Google Sheets Template for Monitoring Progress

When looking at skills, objectives, and goals it is not always a one and done that we can check off. I like to say that the English standards are more habits of practice than something you can check off. So how do we monitor students doing something repeatedly over time towards a goal?

Google Sheets

Remember, the answer is always a spreadsheet 🙂 I created a Google Sheets template to allow you to list standard, goals, soft skills, behaviors, or whatever you want. Set a target, how many times would you like to see this demonstrated to be able to check it off? Put that number into the Goal column (C).

Template

Click here to make a copy of the template.

Mark it Off

To the right of each standard/objective, you can mark off how many times you observe the standard or behavior. Place an x (or anything) into the cells starting in column E. You may weight an observation with multiple “x”s.

Send

I have coded a menu to send the current tab via email to someone. Click on the Send menu next to the Help menu and choose “send.” You will be prompted for an email address. Note: You will need to authorize the script. You might get a screen of doom from Google with a big back to safety button. Google is just telling you that no one at Google as reviewed my code. You need to click on “Advanced” and “Unsafe” (it’s safe) to authorize.

Install TemplateTab

TemplateTab will make a copy of a graphic organizer (like this one) for each student on your roster. You can use the same one spreadsheet for all of your students. You can go to alicekeeler.com/templatetab to make a copy of the TemplateTab template or (and I recommend) join my beta testers group and install TemplateTab permanently.

alicekeeler.com/betatester

Use the Add-on menu to “Setup sheet.” This will insert a sheet for you to paste your roster. Come back and “Run TemplateTab.”

Google Slides: Frayer Model