Grade Level: 7
Subjects:
Reading/Language Arts
Math
Science
Learner Outcomes:
The students will use the book Holes
by Louis Sachar
as background
information for the lesson.
The students will use the Internet to locate the average daily temperatures
for their
hometowns.
The students will use maps to locate an area in Texas where the fictional
Camp Green Lake in the book Holes could
be located.
The students will use the Internet to locate the average
daily temperature for
a Texas town located in the area where they estimated Camp Green Lake is
located.
The students will create a graph using Excel
that will compare the two towns
average daily temperatures.
Duration: Two fifty minute sessions
Materials:
Holes by Louis Sachar
Average Daily Temperature Chart
Rubric for evaluation
Technology Tools:
Microsoft Word
Microsoft Excel
Internet access
Teacher Notes:
Have secured signed Internet policies (AUP)
Schedule computer lab time
Bookmark appropriate Internet sites. A list of sites is included in the
Student
Resource section.
Procedures:
Day 1
Discuss with the students the area of the fictional Camp Green Lake.
Together brainstorm context clues from the story that would help locate
Camp
Green Lake.
Access the Internet to pinpoint an area in Texas that could be where the
Camp is located.
Use the following links Texas
Maps , Eco-Regions
of Texas
For example, the area around Pecos, Texas may fit the criteria.
After selecting a city, the students should go to The Weather Site.
Step 1 is to type in their hometown ZIP Codes. When this page is accessed,
scroll down to locate the Records and Averages Section. Here locate the
Averages Section and have the students record on the Average
Daily
Temperature Chart the Highs and Lows
for a five day period in mid-June.
Step 2 is to repeat the procedure this time locating the average daily
temperature for the Texas town the students selected. These temperatures
should be recorded on the Average Daily Temperature Chart.
Day 2
Students should have the Average Daily Temperature Chart completed for
this lesson in the computer lab.
Open a new Excel
spreadsheet.
Fill in the data. ( Excel Sample Worksheet
)
Select the data needed for the graph.
Click the Chart Wizard and follow the onscreen directions for the type
of
graph wanted and the titles to be used.
Completed graphs can be printed with the data displayed or as a separate
sheet.
Modifications: Comply with IEP guidelines.
Enrichment:
Students could research desert area environments such as, the
temperature changes in Arizona from the rim of the Grand Canyon
to the base.
Evaluation/Assessment: Students will be evaluated using a rubric.
West
Virginia Standards :
Language Arts- 7.19, 7.25, 7.51, 7.57, 7.60, 7.61, 7.62, 7.64, 7.156
Science 7.7, 7.28, 7.79
Math 7.78, 7.79
National
Standards :
Language Arts
Writing 4 Gathers and uses information for research
purposes.
Reading 5 Uses the general skills and strategies of the reading
process
6 Uses reading skills and strategies to understand and intrepret
a variety of
literary texts.
Math 1 Uses a variety of strategies in the problem solving process.
6 Understands and applies basic and advanced concepts of statistics
and data
analysis.
9 Understands the general nature and uses of mathematics.
Science - 6 Understands the relationship among organisms and thier
physical environment.
References:
Teacher Resources
Holes by Louis
Sachar
Rubric
Average Daily Temperature Chart
Excel Tutorial
Student Resources
Maps of Texas
Eco Regions of Texas
50 States
Lake Regions in Texas
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
