Overview | Content Knowledge | Essential Questions | Connection To Standards | Initiating Activity | Learning Experiences | Culminating Performance | Pre-Requisite Skills | Modifications | Schedule/Time Plan | Technology Use
|
LU Title: Predicting Temperature: An Internet/Excel Learning Experience |
Author(s): Cynthia Langone |
|
Grade Level: 3 |
School : Westmoreland Road Elementary School |
|
Topic/Subject Area: Science |
Address: 8596 Westmoreland Road, Whitesboro, NY 13492 |
|
Email: clango@whitesboro-west. moric.org |
Phone/Fax: 315-168-9780 X4421/ 315-768-9789 |
This learning experience is part of an MST unit called "Gather, Graph and the Weather." We are focusing on temperature comparisons and predictions.
|
Declarative |
Procedural |
|
To understand and apply weather related vocabulary |
Access information using the internet |
|
To understand the goal of forecasting is to make accurate predictions about the weather |
Write a compare/contrast paragraph |
|
To understand the role technology plays in making weather predictions and how technology has improved forecasting making it more reliable |
Read and interpret a bar graph
|
|
Read and interpret a line graph |
How accurately can meteorologists predict temperature?
How do weather predictions effect our lives?
How does the temperature in our locale differ from that of a place around the world?
CONNECTIONS TO NYS LEARNING STANDARDS
MST #2 - Students will access, generate, process, and transfer information using appropriate technologies.
ELA #1 - Students will listen, speak, read, and write for information and understanding.
ELA #3 - Students will listen, speak, read, and write for critical analysis and evaluation.
Use internet to acquire data about the high temperature in our locale and Lima, Peru while working with a partner
In support of our Math Calendar program, students will use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. My class chose Lima, Peru. The students will record this data on a given recording sheet, and keep track of the temperature in these two locations for 10 days.
To correlate with our language arts writing program, the students will write a compare/contrast paragraph about these two places. The learners will use the data on their graphs as well as a study of the location on the map using the atlas.
The students will work in groups to generate a list of myths we have about the weather. For example, cows lying down means rain; red sky in morning, sailors take warning, red sky at night, sailors delight; grandmas knee always hurts before it rains; etc. After we compile one class list a discussion will occur. Are these the methods weather forecasters use? What do you think they do to make weather predictions?
The students gather information using the Internet locating a local news channels site (www.wktv.com). The students are collecting data for each day including that days predicted high temperature and the previous days actual high temperature. Students work in pairs to assist one another, if needed. One student is responsible for each of the tasks. After acquiring the information, they record the data on a given recording sheet.
After the students have collected data for ten days, they begin to make a chart using Microsoft Excel, and use Chart Wizard to create a double-line graph. Students will personalize their graphs by using color.
The students will then interpret their graphs as they participate in a group discussion and answer questions. These questions require students to read their graphs and interpret them for specific information. Also, students will be asked to think of a time when their family has made or cancelled plans due to a weather forecast. Students will discuss why weather predictions are necessary and how they effect make our lives.
In addition, students will be asked how they think meteorologist make weather predictions. We will discuss the role technology plays in this science and the fact that predictions can be more precise and reliable with modern technology.
Literature is incorporated throughout this experience. The following books are read as teacher read aloud and/or independent student reading:
Weather Words and What They Mean by Gail Gibbons
Be Your Own Weather Forecaster by Sharon Cosner
Cloudy With A Chance Of Meatballs by Judi Barrett
Weather and Climate by Seymour Simon
The Cloud Book by Tomie DePoala
Forecast by Malcolm Hall
Weather Forecasting by Gail Gibbons
CULMINATING PERFORMANCE
Predicting Temperatures
Rubric
|
4 |
3 |
2 |
1 |
|
|
Internet |
Student is able to access the internet, locate the site and find the desired information independently. |
Student is able to access the internet, locate the site and find the desired information with minimal assistance from teacher of peers. |
Student is able to access the internet, locate the site and find the desired with some assistance from teacher or peers. |
Student is unable to access the internet, locate the site and/or find the desired information without consistent intervention from teacher or peers. |
|
Excel Spreadsheet (recording data) |
Student is able to open Excel spreadsheet and quickly and efficiently record the data collected in the correct place without assistance. |
Student is able to open the Excel spreadsheet and record the data collected while working alone. |
Student is able to open the Excel worksheet but needs some assistance to accurately record the data. |
Student requires consistent assistance to open the Excel spreadsheet and record the data collected. |
|
Excel Spreadsheet (create graph) |
Student is able to effectively create a colorful bar graph without any assistance. The graph accurately and creatively depicts the information on the students original data record. |
Student is able to create a colorful line graph with some assistance. The graph accurately depicts the information on the students original data record. |
Student is able to create a graph of the information with much assistance. One piece of information is inaccurately displayed. |
Student is not able to create a graph without consistent support from another. The data is incorrectly displayed or the graph is missing data. |
PRE-REQUISITE SKILLS
All IEPs will be followed. Students will work collaboratively with a partner to assist each other as needed.
Two weeks are required to collect data for each activity, therefore, if you choose to do them separately four weeks are needed.
Individual times will vary for students to create their charts and graphs depending upon ability.
Two class periods to write a Compare/Contrast paragraph using the writing process.
Materials and Supplies:
computers
Internet access
Microsoft Excel
recording sheets
Assessment Tools and Techniques:
teacher observation
rubrics (Compare/Contrast rubric from Whitesboro Central School District)
Reflection:
We were already using the Internet to find the high temperature in our area and in Lima, Peru. The students used the Weather Channels website to find the data on these two locales. After the data was collected, the students wrote a compare/contrast paragraph, which is in support of our ELA portfolio requirements.
I felt this was an appropriate time to inject this Excel lesson as we had already begun examining temperature. First, I explained the project and handed out the chart on which the children were to record their data. Next, I modeled the procedure used to access the necessary site (www.wktv.com). Each computer was outfitted with the instructions needed to find both pieces of information so that the students had something to guide them through the process.
The students worked well on this project. The classroom cluster of computers was utilized for this activity. Each day students worked in pairs to find the desired data to complete the chart. One student was responsible for finding the predicted high temperature for that day, while the other found the actual high temperature for the previous day. Working in pairs was quite effective since this was one of their earliest experiences accessing the Internet in school. It was helpful for the students to have a friend close at hand. I found that overall the children worked with very little assistance from me.
After all children had completed the recording chart, it was time to begin making the graph. We made a list of the different types of graphs. I explained that some graphs are better suited to display certain kinds of information than others. Because we are comparing two pieces of information (prediction and actual temp.) and because we can see a trend, I explained that a double line graph would be best.
To create the graph, we used Microsoft Excel. For this activity, I used the schools computer lab. Students had one previous experience using Excel for Charting, therefore, they quickly set up the first spreadsheet in Excel. Also, I found they went through the Chart Wizard fairly quickly. A few children needed one to one assistance throughout the task, however, most worked with little or no assistance. The students favorite part, of course, is customizing their graph by changing fonts and colors.
When all graphs were completed, we spent some time discussing the information the graphs depicted. The students were asked several questions in which they had to interpret the information on the graph, such as: On how many days was the predicted high temperature and the actual high temperature the same? Which days? Which dates show the biggest difference in the prediction and the actual temperature? Which day was the coldest? Hottest? Which days had the biggest gap between what was predicted and the actual temperature? Then, students were to form an opinion as to the accuracy of the local meteorologists. They all were very impressed with their predicting skills. We also discussed the science used to determine accurate predictions. These discussions were quite lively and interesting. I was impressed with their understanding of the importance of weather predictions. They also expressed their frustration when the forecast is wrong. We decided that perhaps we have been spoiled by so many accurate forecasts that an incorrect prediction really bothers us! This is a science that the children can apply to their lives since weather is ever present.