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….

4 thoughts

  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?


    1. 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 )

Google photo

You are commenting using your Google 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