 OTAN, Outreach and Technical Assistance Network. Okay everybody, hi. Good afternoon. Thank you for coming. I think actually the very first thing I want to do even before I get into the presentation is just sort of ask how many of you were at the first session of, or the first of this series a couple of weeks ago just by, and if you would answer that in the chat. So far we have two nos, three nos, and one yes. And we have two Melinda Holtz. Well yeah, because I answered twice. Responding, yes. Okay, but I know you were here. Okay, so actually quite a good number people were not here and that's okay because you know this the bill, even though it builds on some of those ideas it's the emphasis on some slightly different projects. Okay, so that's good and you can, we'll be doing a repeat of the series sometime in March or April. So if you did miss the first one we'll be doing getting the whole series again anyway. Okay, so let me go ahead and share my screen and we'll get started with the the basics of the presentation. So this is and I'm not sophisticated enough with Zoom to you know only share this particular thing at the moment and so you're going to see my whole darn desktop and that's just a little bit easier for me and I hope that it's okay with you. So this is easy projects with Microsoft Office part two and the focus is projects working in PowerPoint and Excel. My name is Barry Bukin. I am what's called an instructional technology teacher advisor in our division of Los Angeles Unified School District which means that it's an out of classroom position even though I have about 30 years of in classroom experience as well and the main tasks that I do is assist teachers with implementing technology into instruction which also does include online developing online strategies and so I've been incredibly busy of late even though I will say that it has died down a little bit as teachers have acquired the necessary skills over the last six or seven months for online instruction. I'm also what OTAN calls this subject matter expert and so I have been doing webinars and face-to-face trainings for OTAN for more than 10 years since way back and speaking of OTAN I'm sure that most of you are aware that OTAN does quite a bit of things and they're really a great resource for working in adult education and trying to work with technology. So for today hopefully those of you who have joined us after the webinar is over you'll be able to demonstrate to your ESL, ABE and academic subjects several separate projects using Microsoft PowerPoint and Excel for the purposes of practicing grammar, vocabulary, or just mastery of content and while the specific examples are PowerPoint and Excel for those of you who use other platforms like Google Docs or spreadsheets and things, all of these things are transferable to those platforms as well. So before we get started though I will say obviously that most of these ideas did originate in face-to-face environments and so now we do have the extra complexity of trying to deliver these projects online and so it's incumbent upon all of us to perhaps adapt what might have been, you know, go to a computer in a computer lab and do your project and print it out to a new online format and that can take various paths. So for example, you know, you may be using a particular learning management system so our district uses Schoology, others obviously have many, many different options or some may not be using any at all so you have to think about what your district is doing and so first see if these things can be done maybe within the confines of your LMS. So for example a basic profile or a, I'm sorry, like a paragraph that formally you may have printed out as a Word document a little introduction of yourself or of the students, you know, maybe that now you can do that within your LMS as a profile picture and a few words or you could do it as a discussion and so those things are things that each individual teacher has to consider for themselves and so, you know, again, whatever it is that you're using or if all of your students have access to like a Google account maybe there are features within Google that might make it easier for you to do this project so if I'm demonstrating it as a PowerPoint then maybe your students can more easily complete it instead of learning about PowerPoint maybe learning about Google slides. So those are just things that everybody has to consider on their own. Okay, so let's move on and of course it's not just the projects that you have to think about, it's also how are you going to introduce the projects, how are you going to communicate with your students if you're in a completely online environment, how to do these things. So you know is it a matter of, you know, are you using Zoom, are you using some other type of synchronous platform are you going to email instructions, you know do you use Remind, so all of these things are, you know, I can't really touch on because I don't know the specifics of each of your own teaching situations but there are things to consider you know whether or not you want to create a packet of instructions or whether or not you want to create little videos on how to do these things or you know just depend on live sharing in a Zoom session. So anyway, this is the first project I really like. It's adaptable to many types of situations because we're focusing on PowerPoint as opposed to Word, I'm going to show you the PowerPoint or slide version of this and basically it's I call it speech balloons. Very, very adaptable to all levels because as part of your instructions you tell your students what it is and in addition to their own creativity you can tell them and instruct them you know what I want you to include this specific grammar point that we've been studying or some content that you've been addressing or a special vocabulary and it doesn't have to be 100% but you can say you know I want you to drop in your presentation one example of using passive voice, see whereas for a lower level class it may just be please include one example of simple past tense and so very, very adaptable, very flexible and at the same time it does unleash students' creativity because they can choose the pictures that they're most interested in or that resonate with them and they can choose the actual text so let me go ahead and show one student version of this. Now the there's four slides in this particular conversation this is sort of like a snapshot of the four slides this does have student voices in it but when they recorded it the recording volume was very, very low so hopefully you'll be able to hear it but if not as part of the next step where I demonstrate how to actually do it you'll see how it works and hopefully you'll get the idea that way okay so I'm gonna go ahead and play it hopefully you'll be able to hear it I will say that the third slide doesn't have any sound so that one for sure you're not gonna hear let's hopefully this will work let me go up here and we'll just play it from this slide did everybody get a chance to were you able to hear that first of all it was very faint Barry but we were able to read the captions okay well I think at some point I'm gonna have to see if I can because I really like that particular student sample but I'm gonna have to see if I can amp up the volume but the point is what the students are doing is recreating a conversation as a PowerPoint slide show and they're choosing the image and then they're placing in the text and it's a great way to demonstrate their knowledge or their awareness of certain grammar points so what I'm gonna do now is I'm going to get out of that presentation and just gonna start a new PowerPoint presentation and demonstrate the basic steps so I'm just gonna go ahead and start a new blank presentation okay and again this is all very doable using Google Slides and so for this particular one instead of this layout and for those of you who have never ever used PowerPoint basically you have three main areas on the left side you see a list of your slides and here is a work area and then sometimes on the right side you'll have another panel where you take care of other activities you have some choices of different layouts here very easy to demonstrate to students you can start out with a completely blank slate sometimes you can have things that are pre-formatted for example text would go up here and then you could insert maybe a picture, a table, other items but we're gonna go ahead and we're gonna start with a blank slate so the first skill that you wanna make sure students know is how to insert a picture there are different ways to do that I'm not gonna go through all of them you can insert directly from a from the internet you can insert from pictures that you may already have on your computer and again this may be where if you feel like with certain levels of students you have to exercise more control you could provide some already vetted images that you know are appropriate or that work well with this particular project in this particular case I'm going to insert a picture okay insert a picture and I already have a folder where I have some pictures I set up for the webinar okay so I'm gonna pick one that I know will work okay and there it is and so by just selecting the picture it automatically places the area and then I have to think well will people see the speech balloon so I may wanna make this a little bit smaller and put it in the center okay and of course with these presentation slides they tend to be very horizontal and so horizontal pictures work a little bit better even though they don't necessarily have to be you wanna have a variety of you know people or you know animals if necessary you know or other things that you can use as the source of the speech and so a little tip that I like to do is once I have the picture decided and where I wanted on the frame I'm gonna jump around as I progress from slide to slide so what I'm gonna do is I'm going to back from the home tab okay I'm going to make several slides that are exact duplicates so under new slide there's an item that says duplicate selected slide so I've already selected slide number one and I'm thinking well I'm gonna have maybe four four different conversations so I'm just gonna just do that four times and so I know that the conversation is gonna take place over four slides and as I go through this presentation I know this picture is not gonna jump around okay all right so so PowerPoint has a feature that works very well insert shapes and so I'm gonna select the shape and the type of shape I'm going to use is called the call out and what's nice about these is quite a few different little varieties here but I'm pre-formatted and all you do after you select your shape is you can click on the screen and it appears and you can drag it around and enlarge the size and then it's got this little shape over here a little yellow tab it's got the arrow that sort of points to who is doing the speaking and what's nice about these is you can type right away so for example I might say start typing okay please click on the new card button okay and that represents what the digital is saying but it does this is the default every time you start a new one you may get this default but you do have different colors different options so you can change the color fairly easily and then you can just by changing the size of the text see to fill up the screen and as you do that you can adjust it okay so in any case it's very very easy to do that but what I see that what I did is I was working on the fourth slide instead of the first slide no problem you can just click the slide okay so that is going to be my my first slide so before I go on if you have any questions so far about this one basic process of inserting this the speech balloon into your slide and I'll take a quick look over here at the chat and see if there's anybody who has a question I'm going to do it another few times here anyway so you'll see it a few repeated times so if you do have any further questions about that let me know okay so now I click on the second slide okay and I go back to insert and again a shape this time I might do a different so it's a circle this time and this time we want this participant in this workshop to be saying something see and see it's quite easy to move these around and then you type and is this the correct button to click on again I'll make it a little bit larger so it's easier to see okay and again very easy to manipulate the colors or change the colors you know when you click on the figure itself you get your options you know an infinite number of colors you can change the text etc etc okay so we'll just do a third one for the person responding notice of course you have some recently used shapes up here so you could also make use of those so this time we want her to respond and she'll say yes that's the right one okay and again I'll select it to make it a little bit larger so it's nice and visible I'll make sure the arrow is pointing to her so now we've got you know please click on the new card button is this the correct button to click on and she says yes that's the right one and then finally in the last one again insert a shape this time I'm going to insert what we as a convention call okay well let's see let's pick a slightly different color here and we'll say I am so lost and this is a nice time or a good opportunity to talk with or to have a discussion with your students about the difference between what people sometimes say and what you know people sometimes think it may not necessarily be the same thing you get a lot of great cultural ideas here very creative ideas from students you know when they start to work with this so anyway basically here we have this four slides you can click on play the slide show from the beginning and you just click through it and there you're done with the the textual and the photo but let's talk about the narrations because that's really where it can be a lot of fun for your students and also good for you you can get a sense of their pronunciation if you're working with ESL students okay and also very very simple under the slide show tab this is record slide show and you have some options but basically if you're you know if you're students of practice one of the first options is they will just speak every slide and advance the slides and then PowerPoint saves all of that so when you click the record slide show you have two options start recording from beginning or start recording from the current slide well right now I'm on slide number four so what I really want to do is start recording from the beginning and then I just start talking and notice we want to start the recording and so hopefully what's going to happen is it's going to start up at the first one record the slide and animation timings the narrations ink and laser pointer see so you know there's a lot of features you know that some people may produce an entire presentation but we do want to do the slide and animation timings and we also want to get the sound so I'm going to say start recording please click on the new card button is this the correct button to click on yes that's the right one I am so lost now I forgot to mention that to do the timings I was clicking on the mouse okay so that it only it would advance when I was ready for it to advance so hopefully I'm going to try now to play this okay and so we've got play narrations use the timings show the controls I wanted to start from the beginning if the webinar gods have been good to me it will play and you will hear my voice please click on the new card button is this the correct button to click on yes that's the right one I am so lost okay so let me get some feedback I just want to volunteer that you heard it and of course hopefully the volume was good because I double checked ahead of time to make sure that the microphone volume was fine so any questions is there anything about what I just did that I should repeat before I go on to editing some of those features okay so I do see there's one question you hold the click button down while recording no in this case no it's once you click it the first time the recording automatically stops automatically starts then when you and it doesn't stop until the end of the complete slide show all I did was I did use the mouse to click through when I was finished speaking to click through to the next slide now here's you know obviously you know I did a near perfect narration the first time through but it may not be the case and there are some limited editing capabilities that I wanted to run through so for example let's say that you messed up on the second slide is this the correct button to click on well you do have the first option is you just tell your students well just start all over again you start recording from the beginning and then you run through the whole slide again the whole slide show again the other option though is maybe just fix one slide okay so let's see how would you do so let's say slide number two is the one that we want to fix so I select slide number two under record slide show I now have the other option start recording from the current slide okay so I'm going to do that so what I'll see is I'll see this slide and again I'll get everything ready start my recording so I click that once is this the correct button to click on oh my gosh what happened oh I have to do the rest of the slide right so oh my gosh oh yes that's the right one I am so lost oh so I really messed up there because it didn't tell me that I how to stop for that slide and that's a weird little thing stop recording only for this slide so what happened is it expects you to go from here and then continue all the way through okay and so that's a little off-putting but there is a fairly easy solution to it let me just check to make sure if I do undo if it went all the way back to the original recording let's just play it from beginning please click on the new card button is this the correct button to click on yes that's the right one I am so lost okay so the undo work there all of the four slides are recovered but let's say again this one is really a problem and I don't want it but I don't want to record the other ones after it so what you do two steps again under record slide show we're going to clear the narration on that slide not on all slides on that slide but now what we're going to do is we're going to drag that slide that we want to fix down to the bottom okay we're going to trick the recording because it will stop at the end of the slide show so now if I record this particular slide again it will stop at the end of it because it's the last slide so I'm going to say start recording from current slide and then Barry before you do that if someone doesn't see the record slide or the record button on their word or their PowerPoint why would that be would it be because it might be on the web app or they're not the updated version or I would suggest that they make an appointment to visit the OTAN office hours and get advice from all of the experts at OTAN because I have no idea good idea thank you that's what I would do but all of those things that you mentioned you know maybe things but I don't know about them so that's what I would do I would probably the first thing I would do is I would call Melinda Holt at OTAN or Marjorie Olavides or you know Anthony Burek any of those people okay so anyway let's now do this we'll do the start recording and this time it will end after this slide only is this the correct button to click on and now let's see if that worked we'll listen to it from the current slide is this the correct button to click on and then what do I do I just drag it back up to the location that I want it and now when I play from the beginning it's fine please click on the new card button is this the correct button to click on yes that's the right one I am so lost okay so there we go before I move on how do you feel about this type of project is this something that you think your students may enjoy may feel like it's a challenge may like to try any can I get some comments some feedback in the chat when is recording there is a pause button on the recording can you pause it there and then it just when you click it again when you're ready to keep going so yes you can pause so Beverly says you make it look so easy that's partially a function of I've been doing this for a long time but it's also partially a function of it is easy I suggest that if you were not trying this yourself you know while I was demonstrating that you do it and you can see it's really easy you know basically you insert the picture you know duplicate a few slides insert the text boxes and then the narrations and recording the voice and recording the voices a little you know those out of a certain amount of complexity fairly confident that most levels of ESL students who are working you know with a computer or a laptop will be able to do this truthfully I'm not so sure if your students are you know working from phones if they would you know find this as easy to do but it's certainly something that's available okay so let's go ahead I'm gonna go back I'm gonna close this and we'll go back to the main power point and look at another project so the next project is really exactly the same as the last project but more specific specifically you're asking your students to really practice or demonstrate a vocabulary point or a grammar because all the techniques are the same because basically they're gonna create a slideshow okay with whatever grammar point multiple examples of whatever grammar point or vocabulary point that you would like them to practice so in this particular project the students were working on modals and so you know the idea was just insert text and perhaps you want to you know for example if you can see there where it says the modal of ability when I was young I could swim and so you know you could introduce some other features of the you know change the color of the text or put it in underline it and then you know you can tell them you know do 10 of them do all of them do as many as you can do different modals of ability so in this case obviously they the student was running through different types of modals but you know it's just a variety of variation you know you can have them type this all out as a word document you know if that's what works in your particular setting but if you want to introduce a little bit of variety and give them some skills in using power point or Google slides you know this is just another way to deliver that project and it might be a little bit more interesting for them okay so I'm not going to show how to do that because basically all the techniques are exactly the same so now let's take a look at an Excel project basically and that can then be used to incorporate it into a power point so I used to do this with you know ESL students daily activities project and basically they learn about Excel some very basic functions of Excel and how to work with tables okay I want to take a look at an actual student project here so let me flip over for a moment there we go and we'll just play this slide show from the beginning this one doesn't have sound but it could and I'll click on the next slide and they have their their writing on the last slide and of course they could also you know writing selection into multiple slides okay a very very basic power point but the power point is also dependent on the second slide of the chart so let me go into Excel and we'll see what that chart looks like so this is the actual chart that the student created again all of these things you know working Google Slides but basically all we're talking about are two columns of data okay and when I start from a blank screen a blank worksheet we'll talk a little bit about that hopefully you have some experience with Excel but if you don't again you know Excel has extreme levels of capability but they also have very very basic levels that you can work that even ESL students can learn to use and manipulate so basically you're looking at two columns of information the first column is your categories and then the second column would be the hours you know how many hours out of 24 hours in a day do they do that activity so you're asking the student you know make a list of the different things you do and then have a list of how many hours and they should add up to 24 and in this particular case you could teach if you want to the formula notice that there's a formula here for adding up how many hours and you could just remind them make sure that you don't have more than 24 hours in a day okay it's a very very simple device and I'll show it to you when we start with the blank the blank worksheet and then basically you insert a table it's all done automatically and the students really don't have to do too much but they can manipulate the table in different ways so I'd like to show you that next okay so let's start from a basic worksheet I already went ahead and I pre filled in a few activities okay sleeping working driving cooking eating meals watching TV doing homework and I added up some things and the truth is I'm not even sure if this is 24 hours you can do the auto some it's very basic you just click on the first cell that you want to be added and you highlight all of them with all the numbers okay and then there's a menu item called automatic some and so I can see oh look at that I was just doing this in my head I have more hours than the day so maybe here working instead of 10 hours even though it's let me put 8 instead as soon as I click off okay so now I'm not at 23.5 okay so maybe we'll say cooking we can just change that and we'll make it 1.5 I hit the enter key so now I'm at my 24 hours okay some you notice I this column a little bit wider the default you know they're all the same size all you have to do is just move your cursor between the two letters of the column and you can drag it out and you know students can pick up on these things as well okay so that's the first part all they need to do is put in their list of activities and then their hours now they want to move on which is inserting a table and again it's all automatic you show them the insert button or the insert tab okay and it shows them different possible charts so in this case you know you could go you could show them what it looks like you know you hover your mouse over it and you get a column chart you know all various different charts this seems to work best as a pie chart okay so what are we going to do we're going to highlight all of the cells that have titles and move to the right and highlight the the hours not the total just the hours so now that area is highlighted I'm going to go right over here to the insert a pie chart and they give you some samples and notice as you roll over the sample you actually get to see what happens to the sample so I like this one the 3d pie chart and I'm going to select it now notice that it automatically inserts the labels for the different colors and you can you know enlarge it if you want just by dragging on the handles okay but also notice it's got a title so you can show the students you know you just click on the title and they can change the name so instead of a chart title we'll say daily activities okay but you know it doesn't have the numbers and so do that in a couple of ways if you look up at the top notice there are some options of the design see so that's the first option notice it moved the labels from the bottom to the actual areas which could be nice this one oh look it's got the numbers which are automatically converted to a percent and the labels are on the right side and so that's one way that you could you know you could tell students you know pick the one you want or pick the one that has the information you need okay that's one way to do it okay also over on the right side you have some items here this one says add or remove change elements so for example this one does not have the data labels see but if you click on it it would drop the data labels in there also so these are very simple commands that you can you know show your students how to manipulate them see now notice you see because I checked off the hours when I go back to this one now it shows the labels and the hours in the same way see so it's not really up to you whichever method you want to do to you know have the information displayed okay so here you have it here and here and you can say where do you want it to happen so there's all sorts of little variations then the point is once they've decided you know they could either save it like this and turn that in but you want to get it into your PowerPoint so basically all you're really doing clicking on the chart and then just copying the chart copy the chart you go to a PowerPoint I'll just use this the same one we'll just add a new a new slide and then it's just pasting it really doesn't you know get much simpler than that for your students and so it's a really great activity they get to learn a little bit about certainly the functions of PowerPoint but they're also learning a little bit about Excel and how that works any questions on that because we're getting down to the to the end I think right no well we actually have quite a bit of time right we started at one yeah never mind I was thinking we started at 1230 I start my regular trainings my own school at 1230 so that was the clock I was on so we have quite a bit of time is there anything about this that you would like me to review or repeat hopefully some of you are trying this on your own computers we have a request for the repeat that you just offered in the Q&A okay and we can do that very easily right from the beginning okay so I'm just going to say a new workbook alright so we're really starting from scratch here because we do have quite a bit of time I'm going to expand that first column and again this is the 24-hour the daily activity so you know those that would be the topics but again it could be you know you could be making any type of chart but let's let's do this one so let's see I do know that sleeping is a large part of my day okay computer work alright I do like eating so all you're doing your students are just typing the categories okay alright daydreaming now big part of my day okay checking Twitter do any of you guys check Twitter and see what's happening you know in the world is that a popular thing or is it just me they call that also doom scrolling have you heard that term you just keep looking at Twitter without stopping okay what else do we have planning for class getting dressed not too much time don't need anything else give me some other categories of things you're doing let's see one thing I do a lot sitting on the porch not very much commuting nowadays I don't really have to do that at all exercising okay yeah okay so I've got all of my categories now I can go ahead and start to put in some numbers seven and in fact you know remember what we said about the auto some we can start that right away even though the numbers aren't there so I'm going to highlight all of the rows we have columns and rows in Excel and then cells so I'm going to highlight all of the rows in that column and click on auto some okay you know what I did I clicked in the wrong place let me undo that because we wanted to go down below there we go and now we'll do the auto some and see now it's in the you have to highlight past the last row so that's seven so let's see computer work quite a bit of that let's say oh my gosh eating not so much maybe one and a half okay notice what it's doing it's it's giving me a running total day dreaming I've been really good only a half only a half an hour of that every day checking Twitter of course some of these things occur simultaneously but let's say an hour okay doom scrolling that's almost the same as checking Twitter planning for class I don't really have any classes anymore but I do work with teachers so we'll say that's two hours getting dressed okay we'll give it another half hour sitting on the porch okay give that a good two hours and then I can oh look I only need another half hour okay so far with me everything's good okay we've got the basic data again we want to highlight select all of the rows and all of the times and you just leave it selected then you move over a tab to insert and we have insert a chart and there's all different types of charts you can you know see what would happen so that wouldn't work two series of data how about that I don't even get that one but that's okay we're not going to use it we're going to undo it and we're going to we'll go ahead and just stick with the pie chart because that's the one I know best okay so this is the not 3D version okay I can enlarge it I just click right on the chart title to change the chart title berries daily activities I can select one of the different formats that are pre-formatted that doesn't look very good but we don't have to choose that one well that looks really nice and notice it automatically created the percentages okay I like that alright I do I think I do want to include the actual hours so again we're going to add the legend let's see what we want we want the maybe it's this one here the values we got to get the names constantly we want to get the numbers the actual numbers maybe that's one of the other styles there we go okay so no that's the percentage which one had the numbers let's go back to the elements data labels chart title was there legend options that shows where it is I'm lost for maybe it's under the select data that doesn't seem to be right to well we're going to have to figure that one out another time unless one of you can remind me how to get the actual data in while I'm doing it here chart title we want data labels we want legend we want see that doesn't that seems to not be the label options category name value maybe that's it well I'm getting lost in the weeds here but in any case what I did want to show you was the other thing is you see all of these labels are a little bit too crowded so drag them around and that may be something you want to show your your students and you see this one here it automatically included a line if you get too far away so in any case that's a repeat hopefully it was sufficient to get you started and then to get it into the powerpoint you could leave it like this but to get it into the powerpoint you just click on the whole table it selects it and then you can copy it and paste it into the into the powerpoint you could copy and paste it into a word document you could copy and paste it into a discussion on the LMS you know you could there are many many ways for the students to get this data to you and then also one of the nice things about it it's very dynamic so if they change it here it gets changed here as well which is pretty cool because if they you know if they find a mistake for example if they paste this into the powerpoint or into your LMS and as the teacher you notice the mistake as long as they haven't gotten rid of their original file if they save the file it's not that difficult for them to go back to the original and do spelling corrections but again you know this is the type of activity that not just for ESL but you know perhaps students in academic classes may find this type of you know ability to work with Excel a good introduction to using Excel so I think that's enough for this particular project I would like to move on to the last project unless there are any further questions let's get rid of that and minimize that okay I don't see any questions popping up alright so that's called the daily activities project which is a nice introduction to using Excel and builds on the powerpoints the final project that I want to talk about today is a combination project and this wouldn't be the first project you try with your students but after they've done multiple projects after they've done multiple powerpoints after they've done Excel this is a great culmination project for a semester because it involves quite a bit of things whether it's years or it involves having students actually design a research project where they actually have to collect data from other members of the class when I used to do this I always tried to make sure that the data was something that they actually had to initiate a conversation about so for example what color people pants were was not really suitable in the classroom because in the classroom you could just look at what color people's pants were first they had to submit their project ideas to me and then I would okay them so it had to involve some sort of conversation now of course in an online environment where maybe they're collecting the data by texting or emailing or in a discussion group then languages is likely involved but let me go ahead and show some actual student projects so notice actually this was a I used to do this with other teachers and the reason we did that was some of the students were intermediate low and then the other class was a different level so it really was a nice effort in cooperation between students of different levels so this is the research project and I'm just clicking through the slides here and then I have any questions so let me talk a little bit about that we would actually bring all of the students into one classroom and then the the students giving the presentation would ask this of the whole class and then get some responses and they'd have to respond to the questions and then the final slide of your PowerPoint was always a thank you one real quickly so you can get some ideas here and all of this stuff with the backgrounds and the letter the types of letters that is not teacher generated this is all students going crazy and you can see they found out how to choose different table types and work with different variations etc etc so a lot of that they did on their own let's take a look at another one and then this one I selected this one as a sample because they actually were looking at multiple ways to display the multiple data sets not just at one restaurant but at three different restaurants and then of course these were restaurants where they actually worked at so it's a really great topic because they're doing research about something you know has meaning to them and then we've got one more that I want to show you and I wanted to bring up this one because you know students are very very creative and you can actually manipulate when you make the chart they don't have to be just boring old colors you can actually insert photos and so this is a really nice example of that where the student represented each column with the actual an actual photo of the type of cake that was pretty cool and then finally let me go back you see this is just an example of the what it might look like in the classroom so the student standing is speaking the student at the laptop is her partner in this particular project and is controlling the slides and then this is a really really great project for introducing students to the idea of speaking in front of a group giving a presentation at ESL levels this is frightening for students they were all used to confess how nervous they were and how much they would practice but it's a good idea to let them in on some teacher techniques do you face the screen the entire time do you face the students the entire time I used to give them a laser pointer so that they could really practice giving a presentation and then interestingly enough what would happen though when I first started doing it with my lowest level students I did find that they were able to create the presentation, do the research, create the presentations and ask for questions but I found that at the lowest levels they had a really difficult time asking questions about what they just saw and that was when it occurred to me maybe I can bring in higher level classes to be the audience so that was another reason for pairing up classes and sometimes I wouldn't pair up a class to do the research but my students I would just bring in the other class to be the audience because level 2 students, beginning level students they could create the presentation they could answer questions but formulating a question about what they saw was a little bit too difficult so I would bring in level 5 and level 6 classes to be the audience and believe me again it was one level of anxiety when students learned that they were going to present to their own class it was an entirely different level of anxiety when they learned that they would be presenting to a visiting class so again this was a wonderful end of the year project and I think students really got a lot of value out of it let me go now to looking at some actual student created charts for this same project and we'll just we have a little bit of time we can see how this project would work out I just copied a bunch of student presentations into a slide show just so you can see the types of research that was taken place by students isn't that a great research project how many M&M's of each color and what I like about this one is that again the students do research about things that have meaning to them so this was the average monthly production of women's clothing by size at the factory where she worked and so she had that data available to her anyway that's just a few examples so many different types of things okay so let's go to this is the actual worksheet again if they've done the daily activities project already they're already familiar with the basic concept if they haven't it's not that difficult to introduce to your students again you're just looking at two columns so in this case favorite car company so column A has a bunch of different cars and then column B has how many students said Honda was their favorite car how many students said Toyota was their favorite car so that's all the same again all you're doing is highlighting the two columns and then picking the chart so in this case instead of a pie chart a bar graph or a bar chart column chart was really the best option okay but what I wanted to show you the thing that's new was changing the color of the columns into not just a color colors or a photo so I can do that with this one the way it works again remember you can just click on the whole chart and make it a little bit larger so it's easier to work with and then you just select the columns the first time you click on a single column all of the columns are highlighted okay and so then you could right click and you pick a different color but notice the entire series changes okay alright so that provides a little bit of variety the second time you click on a column notice only that column has changed so then you can just change the color of that column if they're doing favorite colors they can just change each column to a different color and these are fairly simple techniques that the students picked up pretty easily but then let's say you do want to use the photo idea so obviously you're not going to change all of the photos at once so again you click twice the first time it selects the entire series the second time it selects just the one column and this time when you right click and you select format the data point meaning the column you get the typical types of options so we're going to select fill and you also have some other options all different types of things different patterns you can change it to different patterns gradients see how it's sort of like a gradient now but this one here says picture or texture okay and so you're given the option of inserting a picture from file a clipboard or online so I did go ahead and I prepared for this particular workshop by finding a picture for Honda okay and so I'm going to select file and go to my folder and see and there's a picture of a Honda okay so I'm going to insert it see do the same thing for Toyota a picture okay and then we'll find the Toyota picture and then for Ford I just did a few I didn't do all of them but I did find a picture of a very classic Ford okay and so you get that but then of course what happens is you get a little bit of distortion and things like that so one of the things that there's some other things that you can work with now so what did I did then was I clicked off of it and I clicked back on because now again the whole series each column is highlighted but you get a little new you get a new menu option okay and this says gap with so the gap is the space between the pictures so if I make the gap wider then that means the picture will be smaller but I can make the gap smaller watch what happens so that actually works better for these columns because there's a little bit more height than for the Ford but I think let's go back up a little bit maybe we'll find a nice happy medium and now it's a little bit more distinguishable or you can actually make it no gap and that works too actually the Ford picture isn't so bad so I'm going to leave it at that but again you know you can click on a single one choose fill picture okay this time did I do the wrong I don't know if that looks like the same photo so what we want to do is maybe we'll go online this time and let's search for Nissan and see if we can find a good picture from Nissan okay so we want to get that nice logo the Nissan logo there we go that looks good and we'll say Nissan so there you go and that's very easy and students can get the hang of that very very quickly so that is actually the last project that I'll be talking about so let me just go back to my original slide show and yeah that's it that was the last one so let's take some time and do you have any questions specifically about the project or maybe this new wrinkle of inserting the photos into the Excel charts anything that you want to bring up they're all playing I hope they're trying this out again it's not the type of project you want to do at the beginning of the semester but if you've been working with your students and they're getting familiar with using some of these tools to practice language remember if it's an ESL class or other type of class the language is the important part this is the vehicle for getting them to stand up in front of the class and speak or getting them to talk to your student to other students in the class and it doesn't have to be students it could be people at their work or it could be their friends but it's a chance to get them to speak and to communicate using the language and we're sort of tricking them by making them do a project that's one of the things about project-based learning is they forget they're learning a language and they're actually just doing something Mary we have a question in the Q&A are you doing this now with long distance school are you doing these projects I cannot say that I personally am because my position now is out of the classroom and I work more with teachers getting them to do these types of things in general I would say these last six months I'm still getting teachers to use our learning management system how to even put materials in the learning management system some of our teachers could probably do this and run with it and I do introduce some of these ideas along the way but I don't actually get a chance to do these things with my own students now for quite some time that's why some of the dates on the projects are a little bit old but I'm highly confident that seeing what other teachers are doing with their students that these are still very very doable in our division we have CTE teachers who are really going very very strongly with having their students complete projects and turning the projects in with photos with videos and so I'm fairly confident that these types of projects are very very workable just as an example of that are I know for a fact and I've seen some really nice examples one of the cosmetology teachers has students take photos of each step in the process of for example preparing somebody's nails in an environment that they've learned the competency so they're taking photos using PowerPoint and they're dropping the photos into the PowerPoint slides and explaining each step of a process in order for them to move on to the next competency so I do know that it works I can't say that I've done it with my own students yet well I think we're doing really good on time there's one last question here Barry this could be I guess in relation or related to distance learning or in the classroom how do you aid students in minimizing their anxiety about presenting in front of others okay well you know I guess the first part was we also give them time to practice so if it was in the face-to-face classroom before they did their official presentation like with the other class I would give them time permitting the possibility of doing it just with the members of their class or even in small groups so for example maybe like in that one picture I showed you you know she was more comfortable with standing in front of the class and presenting and he was more comfortable with working on the computer and that was acceptable because it was a team project okay I think do we agree that's about it I think it is I'll turn it over to Melinda for the wrapping up I want my last slide I just want to review the objectives that I posited at the beginning hopefully what happened was that now you are able to have your students work on or present they have a soft PowerPoint in Excel and by doing so they will be able to practice or demonstrate vocabulary, grammar, or the content that you are covering in class so that was the goal I hope that I met those objectives I want to thank you for being here today