Creating a Class Water Usage Spreadsheet in ClarisWorks

Open ClarisWorks and choose Spreadsheet

  1. In Column A list the names of the students in your class.
  2. In Column B list each student's total 24 hour water use.
  3. Create a line graph of the water use of students in your class. Save your graph for your lab report.
  4. Use formula patterns to calculate a Class Total for 24 Hours, Class Average Individual Use for 24 Hours, and the Total Use by the class for one week, one month, and one year. Make sure to clearly label your data. Formulas you will need:

Return to Personal Usage Lab