Math Forum | Urban Systemic Initiative

Main Page || Participants || Outreach

The following activity was designed for the classroom where there is only one computer connected to a projection system. This lesson can be used in grades K-8.

California Mathematics Strand: Statistics, Data, Probability

Lesson Objectives:Data collection and display.Materials required:

- two yardsticks (or metersticks)
- tape
- one computer with data display and ClarisWorks Spreadsheet (or other spreadsheet program)

Description:Students will work in pairs to measure their height and enter the data on the spreadsheet. The teacher will create the graph on the computer as the students model the graph by standing in a row. Displaying the graph in these two ways will allow the students to make connections between their physical height and the heights of the bars on the graph.Procedure:Plan Ahead:Before the class tape the two yardsticks end-to-end vertically to the wall, one above the other. Set up the computer and data display and open a new spreadsheet in ClarisWorks. In cell A1 enter the words "Student Name" and in Cell B2 enter the word "Height."

Class Begins:Working in pairs, students go to the yardsticks and measure their heights. A student or aide could monitor the students as they take their readings. Students then enter their names in the "A" column and their heights in the "B" column of the spreadsheet.

To make a graph, teachers should complete the following steps and display the results for the students to see:

- Select all of your entries in Columns A and B.
- Go to the
Options menu, and selectMake Chart. A window will appear with the different types of graphs.- Select
Barand consider the different options at the bottom of the window.

Try the different options and see which ones enhance your graph. Remember that you are displaying data to present information! Your graph should be clear.

- Go to
Labelsand type in "Height Chart for My Class" for yourTitle.

- Go to
Axesand notice thaty-axisis selected. Type "Heights" for the y-axis.

- Select
x-axisand type "Students" for the x-axis.

- You are ready to make your graph. Select
OK.

- To arrange the bars in order from smallest to largest, select all the entries in columns A and B. From the
Calculate menuchooseSORT. Sort the data in order from smallest to largest beginning in cell "B2".

To finish the activity, have students line up as their names appear on the ordered graph. If they have taken their measurements accurately, your line of students will match the graph. You might take a picture of the students and display it with the graph.

Related LinksSee Suzanne Alejandre's Spreadsheet Lessons for more information on creating graphs and charts.Extensions:Students could first enter their estimated height on the spreadsheet, then measure their height and enter both into the computer. The graph would then include two bars for each student.

[**Privacy Policy**]
[**Terms of Use**]

Home || The Math Library || Quick Reference || Search || Help

http://mathforum.org/

The Math Forum is a research and educational enterprise of the Drexel University School of Education.