Integrated Math

Name____________________

Spreadsheet Worksheet

Date ____________________

  1. Create a new spreadsheet using the following headings: Hair Color, Number of Students, Percentage of Students, and Number of Degrees
  2. Using your data, from your database, count the number of people that have each hair color.
  3. Enter the different hair colors under the heading "hair color" and the number of students for each hair color.
  4. Enter formulas for the totals of each column and the percentage of students and number of degrees.
  5. What should your total number of students be?
  6. What should the total of the percentage column be?
  7. What should the total number of degrees be?
  8. Does your spreadsheet have these totals?
  9. Print your spreadsheet.
  10. At the end of class, you should turn in the spreadsheet.