Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Progress Bar of Objectives Template

Progress Bar Template

Progress Bar of Objectives Template

Progress Bar Template

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).
Objective Tracker progress bar


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.
Progress bar marking with xs


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.
send menu

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.


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

Google Slides: Frayer Model

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

4 thoughts on “Progress Bar of Objectives Template

  1. Extremely cool and I can see all kinds of uses for this. Thanks for posting it.
    PS. There is a good chance I will be teaching in Mainland China next year and of course, nothing Google works there. Will this template run in Excel or OpenOffice? I am going to try it now but thought I would ask.

  2. Can you tell me if there is a way to get this chart with the template tab already installed? When I copied and pasted it into a template tab sheet I lost a lot of the formatting.


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.