# GRAPHING WEATHER

Document Sample

```					                         GRAPHING WEATHER

Discipline/Subject: Science and Math
Unit/Topic: Weather
Time Frame: One month to graph weather, 1 (45 minute) lesson to create a
graph, 1 (1 hour) lesson to create Excel Activity
Lesson Summary: Students will graph the weather for a given month on
the attached calendar. They will choose only one type of weather for each
day. These are listed at the bottom of the calendar. The students will then
graph their results by creating a graph on grid paper. Students will then
transfer results of their weather into an excel program. Information will be
entered on a blank page and a graph created from this program. Students
will compare the computer generated graphs with their own graphs.

Identify and include Applied Standards:
South Dakota Standards

1. Investigate and describe basic types and patterns of weather
2. describe the uses and importance of measuring and recording weather
data

Second Grade Statistics & Probability Standards
1. represent data sets in more than one way
3. form questions about and generate explanations of data given in tables
and graphs

Objectives of the lesson:
Students will learn to:
 Record data
 Create a graph by hand
 Transfer information to the Excel program
 Create a graph on Excel
 Compare data

Assessment:
 See attached assessment worksheet

Technology to be used:
 Computers
   Excel Program
   Printer

Other Materials:
 Calendar to record weather
 Large grid paper for graphs
 Colored pencils or crayons

Prerequisites:
 Students will have their weather calendar completed.
 Students will have prior knowledge of Word including: being
familiar with the keyboard, printing, and inserting clipart .
 Students should know how to create and read a graph.

Procedural Activities:
1. At the beginning of a month have children chart the weather
on the attached calendar. Have students put the date in the
middle of the square to match the days of the month. Each
day the student will choose one type of weather for that day
and write sunny, cloudy, rainy, or snowy in the box. At the
end of the month students should count the number of each
type of weather day and write the information on the sheet.
2. When this activity is completed, a graph will be made by the
students. Use large grid paper to make a bar graph. Have
the students label the type of days at the bottom for the x-
axis and the number of days on the y-axis. Fill in the
information using a different color for each type of day. Have
students compare graphs with their peers.
3. Using the Excel program have students record and graph
this information using the instructions below.
 Open Excel
 Introduce terminology
o Rows
o Columns
o Cells and how to move from cell to cell
 Practice typing in a cell
 Name cells: for example B3
 Make row A wider by moving with arrow
 Make row A longer by moving with arrow
 Insert clip art in cells B1, C1, D1, E1 (one for sunny,
cloudy, rainy, and snowy)
 In cells B2, C2, D2, E2 type the kind of weather to match
pictures above
 In cell A3 type number of days
   In cells B3-E3 type the number of days that it was cloudy,
rainy, sunny or snowy
   Highlight cells B2-E2 and B3-E3
   Click on Autosum – compare days with handmade chart

Graph
 Click on Chart Wizard (looks like books)
 Select type of graph
 Click on next
 Click on Next
 Click Titles
 Title chart: Weather
 X-axis will be type of weather
 Y-axis will be days
 Leave as object in sheet one
 Click on Finish and graph should appear

4. Students should compare their hand-made graph with the one
produced in Excel. Results should be similar.

Suggested modifications for special learners:
 A peer partner will be provided for those that need.

Attachments:
1. Assessment worksheet
2. Calendar
3. Example of data and graph from excel

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 7 posted: 11/23/2011 language: English pages: 3
How are you planning on using Docstoc?