This guided lesson will teach the basics of Microsoft Excel to emerging-learners in technology. I designed it for fourth graders who have little-to-no previous experience. There are step-by-step instructions for inserting data, highlighting data, creating graphs, changing graph appearances, etc. Each instruction has a screen-shot picture of what the student must do on his or her own computer. I first model the lesson on my projector then have my students complete it on their own. It took us about 3-4 45 minute class periods. This lesson has remedied many of the "panic" questions that students have when they are new to Microsoft. (All screen shots are from Microsoft Excel 2007).
In this project, students will choose a city that they think is interesting. They will study the weather in that city on Weatherspark.com. This is an amazing weather website that has interactive weather graphs. The user can pan and zoom through the entire history of any weather station on earth! Students will insert this data into Microsoft excel as they practice making spreadsheets and creating charts and graphs.