Lesson Plan: Chart It

Grade level: Four
 

Outcomes


Curriculum:
Mathematics
Students will:

read and interpret bar graphs, line graphs, pictographs and stem-and-leaf-plots - F3

construct bar graphs, pictographs and stem-and-leaf-plots - F5

interpolate data from a display - F6

Technology:
Students will:

understand the structure of a simple spreadsheet D4
• understand the terms spreadsheet file, cell, cell address, row and column D4.1

create a spreadsheet as one strategy for collecting and organizing information D6

create charts and graphs to display data D7
• select different types of charts D7.1


Created by: Acknowledgments

Last Updated: June 24, 2003

Activity

 

General Curriculum Outcome F of the Mathematics APEF curriculum states that students will solve problems involving the collection, display, and analysis of data. AppleWorks Spreadsheet is an excellent tool for students and teachers to use to organize and display their data. Once data is organized in a spreadsheet, it is very easy to use AppleWorks to create a pictorial representation of this information in the form of a graph. In Grade 4 math, students can use the AppleWorks Spreadsheet tool to create bar and line graphs. While the curriculum introduces other kinds of graphs at this level, the bar and line graph are the only two that AppleWorks can create. This lesson is an introductory lesson to spreadsheets so students need no prior experience with them.

 

Resources

AppleWorks spreadsheets

Instructions

Suggestions for other activities