Throwback Thursday: Track Student Progress with Google Sheets

This video is one I made last semester on using Sheets to track student progress.  There’s lots of great information in here including:

  • Data Validation
  • Conditional Formatting
  • Sparklines

Check it out….


  1. Hey Shawn, thanks for the info. I was wondering how I can make a graph from the info collected on the attendance form to show parents?


    • You can use the Explore button on Sheets or you can click Insert Graph and choose the data range that you wish to create a graph for.


  2. Hi Shawn,
    Thanks for the videos and all the good stuff you post. I want to automate our detention system so that the teachers can give a detention from a Google form and the grade level administrators AND the parents involved, can receive an email when the detention is issued. I am thinking about using Formmule but wonder if you have a better way to do this. Any help is greatly appreciated.
    Thank you!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s