Excel is a Microsoft Office tool that can be used to create a variety of record keeping documents as well as a tool for teaching and learning! I created this fourth grade lesson on weather utilizing Excel, Word, and the internet.
It will take the students approximately 5 days
¢ Science Standard
o Strand 6: Earth and Space Science
o Concept 3: Changes in Earth and Sky
o
¢ Social Studies Standard
o Essentials Grades 4-8
o Climate: 6SC-E8. Describe and model large-scale and local weather systems
¢ Technology Standard
o Essentials Grades 4-8
o 3T-E2. Use a variety of technology tools for data collection and analysis
o
o
o
o Strand 2: Writing Elements
o Concept 2: Organization
o
o Concept 4: Word Choice
o
o
o
o
o Concept 6: Conventions
o
¢ Go outside and have all students write down an educated guess for the high and low for that day then look it up on the internet.
¢ The students will research data needed on the internet, learn how to take the average, minimum, maximum of a set of data, and write a poem of a type of weather.
¢ Computer with internet, Excel, and Word
¢ Students will have the opportunity to pick partners and then they will pick a city and state out of a bowl.
¢ Students will research the weather for any month in the last year for their city and state and record it.
¢ Students will make an Excel spreadsheet for their recorded data
¢ Take the average, minimum, and maximum for their recorded data
¢ Students will create a graph in Excel from their data
¢ Students will compose a poem about the main source of weather in their city and state
¢ Students will present their poem, Excel spreadsheet, and graph
¢ I will show the class my example of my poem, Excel spreadsheet, and graph, so they will have a model.
¢ Students will compose a poem for homework about the main source of weather for their city and state.
¢ Group discussion about their different cities and different weather
Graphic from Microsoft Clipart Online