Illuminations: Collecting, Representing, and Interpreting Data Using Spreadsheets and Graphing Software

Collecting, Representing, and Interpreting Data Using Spreadsheets and Graphing Software


Spreadsheets and graphing software are tools for organizing, representing, and comparing data. This activity illustrates how weather data can be collected and examined using these tools. In the first part, Collecting and Examining Weather Data, students organize and then examine data that have been collected over a period of time in a spreadsheet. In the second part, Representing and Interpreting Data, students use the graphing functions of a spreadsheet to help them interpret data. Working on activities like these, students learn to set up a simple spreadsheet and use it in posing and solving problems, examining data, and investigating patterns, as described in the Representation Standard.


Individual Lessons

Lesson 1 - Collecting and Examining Weather Data

In this lesson, Collecting and Examining Weather Data, students organize and then examine data that have been collected over a period of time in a spreadsheet.

Lesson 2 - Representing and Interpreting Data

In this lesson, Representing and Interpreting Data, students use the graphing functions of a spreadsheet to help them interpret data.

NCTM Resources

Principles and Standards for School Mathematics

National Council of Teachers of Mathematics Thinkfinity
© 2000 National Council of Teachers of Mathematics
Use of this Web site constitutes acceptance of the Terms of Use