June Vann
Beaufort Elementary School
2/13/02
Subjects included in this Lesson Plan: Math,
Technology
Brief Description:
Collect temperature readings over a period of time, enter the
information into a spreadsheet and choose the appropriate graph to
display the results.
Approximate time required: 30 min.
Standard Course of Study Goals and Objectives:
Math
2.09 Use an organized approach, appropriate strategies, and
technology as needed to solve multi-step problems involving
geometry, spatial visualization, and measurement (length, weight,
time, capacity, temperature, perimeter, area, volume.)
4.01 Interpret and construct line graphs.
4.02 Explain the kinds of decisions that need to be made in
selecting and constructing appropriate graphs including
pictograph, bar, line plot, circle, and line graph.
4.03 Systematically collect, organize, display and interpret data
both orally and in writing using information from a variety of
content areas.
4.04 Compare increasingly complex displays of data, including
multiple sets of data on the same graph, computer applications,
and Venn diagrams
4.05 Determine the mean of a given set of data using a calculator
when appropriate
4.06 Use the range, median, mean and mode to describe a set of
data.
Computer Technology
2.1 Use technology tools to collect, analyze, and display
data.
2.8 Create/modify and use spreadsheets to perform calculations
(+,-,*, /).
3.4 Select the most appropriate graph to display data and state
reason.
Teacher's Lesson Goals/Objectives: The students will be able
to construct a line graph given data about the temperatures taken
the week before, choose the appropriate graph and explain they
reasons behind the type of graph they chose. They also will be able
to show proficiency in entering formulas (+, /) to find the mean.
Students will find the median and mode of their temperatures
readings for the week.
Materials/Resources Needed:
- Computers for each student,
- AppleWorks spreadsheet
- Temperatures from the week before.
Pre Activities:
Students will read and record daily temperatures for a week. They
will review how to read thermometers, study different types of
graphs, and why we use certain ones. We will do a study what mean,
median, and mode are and how/why they are used in the real world.
Activities:
- Have students go to Appleworks
- Select spreadsheets
- Enter data about the temperatures into the spreadsheet
- Highlight and go to options and select line graph.
- Go through the spreadsheet procedure of labeling and
displaying the graph correctly.
- Find the average. (Students are to calculate the average by
entering the formula to add the columns/rows of temperature and
then entering the formula to divide by the number of temperature
entries).
- Students explain why they chose the line graph.
- Students examine the column of numbers to find and enter the
median, and mode on their print out.
- Students explain the reason they chose the graph.
Closure:
Discuss the temperatures from the week. Students interpret the
temperature data and explain what they graph is showing.
Assessment:
The following checklist will be used to assess student work.
Possible 100 pts.
- Student entered their information into the spreadsheet
correctly. 10 pts
- Student where able to create a graph of their information. 10
pts.
- Student chose the correct graph. (line graph) 10 pts
- Student labeled their data correctly. 10pts.
- Student entered the addition and division formulas correctly
to find the mean. 20 pts
- Student identified the median and mode on their printout. 20
pts
- Student interpreted and explained the reason they chose the
graph. 20pts
