AICT 1 15F‎ > ‎Spreadsheets‎ > ‎

Lesson 7

  1. Create a data set to show the number of students in Grade 1-6 for each of the past five years at John Jacob Jingleheimer Schmidt School.
  2. Use function/s to find the total number of students in each grade for the total of five years. Label the answers appropriately.
  3. Use function/s to find the total number of students in the school for each of the five years. Label the answers appropriately.
  4. Use function/s to find the average number of students in each of the grades over the five years. Label the answers appropriately.
  5. Use function/s to find the average number of students in a grade in each year. Label the answers appropriately.
  6. Create a pie graph with the data with appropriate labels.
  7. Create a bar graph with the data with appropriate labels.
Comments