TitleIII Technology Literacy Challenge Grant

Learning Unit

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

OVERVIEW

 This learning experience is part of an MST unit called "Gather, Graph and the Weather." We are focusing on temperature comparisons and predictions.

CONTENT KNOWLEDGE

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

ESSENTIAL QUESTIONS

 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.

INITIATING ACTIVITY

 

LEARNING EXPERIENCES

 

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; grandma’s 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 channel’s site (www.wktv.com). The students are collecting data for each day including that day’s predicted high temperature and the previous day’s 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 student’s original data record.

Student is able to create a colorful line graph with some assistance. The graph accurately depicts the information on the student’s 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

 

 

MODIFICATIONS

  All IEP’s will be followed. Students will work collaboratively with a partner to assist each other as needed.

UNIT SCHEDULE/TIME PLAN

 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.

 

 

TECHNOLOGY USE

 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 Channel’s 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 school’s 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 student’s 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.