Instructions: Building on the knowledge gained from the previous chart exercise, create a chart or graph using the data below.


Data: Voting and Registration Data, reported by Race, Hispanic Origin, Sex, and Age, for the United States: November 2000

***First, you need to open Windows Excel to create your own spreadsheet using the data from the Voting and Registration Data spreadsheet.

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.

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.



  1. What do you gain from presenting data in chart or graph form that you do not gain in spreadsheet format?
  2. Are there other alternative representational forms in which you could present the data other than the form you chose?
  3. Should you label your x and y axes? Why or why not?
  4. Why is it important to label what unit of measure is used in your chart or graph?
  5. Are legends important? Why or why not?
  6. Why is it important to include information regarding the source where you obtained the data?

Also complete the Graphs Graphs Graphs Funbrain Quiz. Please go to and click on "Take Your Teacher's Quiz" under the Take a Quiz heading. Then login under Student login. Type mathbrain72 for the Secret Word and type yourname for the User ID.







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.