Employee Support Website

About this course

In this course, you will learn about tools, tips, and tricks in Google Sheets to make your life as an educator easier. This course includes ways to average grades, view trends in student data, visualize student progress with charts and graphs, and quickly join or separate names in student rosters and Google Forms responses.


By the end of this course, the learner will be able to:

  1. Use SUM and SUMIF to calculate campus attendance and field trip information,
  2. Use AVERAGE and AVERAGEIF to find the averages of class test scores,
  3. Use SPARKLINE to generate quick graphs of student progress over time,
  4. Use CONCATENATE to join student first and last names on a class roster,
  5. Use the “Split Names” Add-On to separate student names on a class roster,
  6. Use filters and filter views to only view student data from specific class periods,
  7. Protect sheets and ranges to prevent accidental editing by administrators and co-teachers,
  8. Create alternating row colors to make student data easier to read,
  9. Apply conditional formatting to visualize student achievement on assessments,
  10. Use the “Explore” feature to spot trends in data and generate charts and graphs of student achievement.

If you need help logging onto Kyte, please contact renaed@provo.edu. Click on the link below to view this course.


We have a workshop that requires 15 educators to help us with new cluster development for grades...

The 2021 Utah Office of Outdoor Recreation grant cycle is officially open! We can't wait to see...

UtSTA (Utah Science Teacher Association) is still hosting virtual PD courses online Join UtSTA...

Reimbursement forms are still available for completing Science Endorsement programs You may view...

A wonderful resource has been shared with our district and added to our Curriculum Notebook...

Did you know that not all pharmacies have the same price for medications Prescription prices can...

Join Utah Valley University on January 13th for a virtual event celebrating Martin Luther King Jr...