Before the Activity:
1. The teacher will model how to use the calculator to compute averages.
2. The teacher will provide an example of a spreadsheet format for students to view. An example spreadsheet can be downloaded in the attachments section.
3. Students will predict which state they think will have the most tornadoes in their science journal. They will also predict where they believe their state (Alabama) will be ranked.
During the Activity:
1. Explain to students that tornadoes are possible in all of the 50 states.
2. Students will work in pairs.
3. They will be reviewing information from the following two websites to record the number of tornadoes that have occurred in each state from 2011 - 2015.
4. Students will create a new spreadsheet document following the sample spreadsheet format provided via teacher projector. A link to a spreadsheet template can be accessed using the attached document.
5. Students will enter data collected into the spreadsheet.
6. Students will enter a formula provided by the teacher to calculate the average number of tornadoes for each state into the seventh column of the spreadsheet.
7. Students will sort the spreadsheet from greatest to smallest average.
8. Using the spreadsheet data, students will determine the top ten states with the highest average of tornado occurrences during the time frame.
9. Students will create a bar graph and a picture graph for the top ten states using the poster board, graph paper, colored pencils, pencils, and rulers.
10. Students will select the data for the top ten states and generate a bar graph using the spreadsheet program.
10. Students will print the graphs.
After the Lesson:
1. In their science journals, students will compare the graphs they created with the computer generated graphs. Were the graphs similar? If not, what was the problem?
2. Students will address the following questions in their science journals: a) Did their data match their predictions about the state with the most tornadoes? b)Was their prediction concerning their home state correct? Were they close to their predictions?