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.

Objective

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.

1 Shares

As a Provo City School District employee, you qualify for a COVID booster shot if you...

There are many options to consider when the district is preparing the school-year calendars As we...

Thank you to all for your wonderful participation in our first virtual training on Oct 19 At this...

RS will be presenting a training for those employees who are within 3 years of retirement Please...

Wellness News Virtual Health Screenings Did you forget your health screening We have you covered We...

Tuesday, October 19 is Professional Development Day  We have organized grade level/subject...

Please remember the following for the upcoming fall break: Turn off all electronics ie, TVs,...

High School students, teachers, parents, school counselorsProvo CAPS Open House6:00PM to...