Instructions: Using the spreadheet data below, choose one column of data and create a representational tool in Microsoft Excel that appropriately displays the data in the spreadsheet.

***First, you need to to click on the export to Excel icon on the Tool Bar, and save the spreadsheet either on your computer or on a floppy disk as an Excel file. Do this first in order to ensure that the data that you input in the spreadsheet is saved. If you do not save first and you leave this page (e.g., by clicking the "Back to Home Page" or the "Go to Instructions for the Student"), you will lose all of the information that has been put in the spreadsheet.

Highlight the columns of data that will be included in the representational tool.

To use this Web page interactively, you must have Microsoft® Internet Explorer 4.01 or later and the Microsoft Office Web Components.  See the Microsoft Office Web site for more information.


Choose a chart type (e.g., histogram, line graph, pie chart, etc.):

Then click on the Chart Wizard icon and follow the directions in the Chart Wizard to create your own representational tool. Give your chart a title, and label the x and y axes. And create your chart as a new sheet, not as an object in the current spreadsheet.


Example of highlighting data:

Example of chart created from highlighted data:





Back to Kellie's Home Page

Go to Learning Data Analysis

Go to Instructions for the Student

Go to Assessment


These pages were made through TeacherTECH, the teacher professional development component of GirlTECH, which is sponsored by the Center for Excellence and Equity in Education (CEEE) with support from the National Science Foundation through EOT-PACI, RGK Foundation, the Verizon Foundation, Rice University, and HiPerSoft.

Copyright © June 2002 by Kellie Butler.