Spreadsheet Lesson - Weather Analysis
Our school is a weather watch school for one of our local TV stations and we have a weather station located on the school that takes weather information and live video.
In this lesson students will log, graph, and create a video news report. To do this students will predict the weekly weather for a month and record their predictions on the spreadsheet, along with logging the actual weather for a month. They will then create comparison graphs that show trends. As a conclusion, they will create a video weather report of their research findings.
This lesson is best done as a jigsaw where a group of 5 students will switch tasks for a total of 4 weeks. (Prediction data, Actual weather data collection, graphing, video report)
Teachers - To download the Lesson Plan and Instruction Sheet Click below.
You may also click here for the lesson plan or Click here for the Student Instruction Sheet.
| weather_lesson.docx |
| weather_lesson_plan_instruction_sheet.docx |
Student Materials and Links - Listed below are the files, questions, and links you will need for this weather analysis project.
Teams rotate every week in this order:
Prediction Team
Weather Station Team
Graphing Team
Video Team
File
| weather_lesson_plan_instruction_sheet.docx |
Questions
Questions to answer in your weather journals as you are collecting data:
1. How is today’s weather/temperature/precipitation like yesterday?
2. How is today’s weather/temperature/precipitation different from yesterday?
3. What relationships between the weather factors do you notice?
4. What can you tell me about weather patterns?
5. What is the date? This is very important for compiling weather data!
Links
WeatherBug Camera
WeatherBug Weather Site
Weather Underground
Prediction Spreadsheet
Actual Weather Spreadsheet
Temperature Graph
Precipitation Graph
Video Script
Video Recording
Questions to answer in your weather journals as you are collecting data:
1. How is today’s weather/temperature/precipitation like yesterday?
2. How is today’s weather/temperature/precipitation different from yesterday?
3. What relationships between the weather factors do you notice?
4. What can you tell me about weather patterns?
5. What is the date? This is very important for compiling weather data!
Links
WeatherBug Camera
WeatherBug Weather Site
Weather Underground
Prediction Spreadsheet
Actual Weather Spreadsheet
Temperature Graph
Precipitation Graph
Video Script
Video Recording
