Thursday, January 30, 2020

Two Ways to Make Progress Trackers With Google Sheets

In my previous post I mentioned that Google Sheets can be used for all kinds of interesting things. It can also be used for practical things like keeping tally of your progress or that of your students toward a goal. There are two ways that I usually recommend doing this. The simplest way is to use the progress tracker template available at The method that offers more options is to use a pivot table in Google Sheets.

In the video below I demonstrate how to make a progress tracker using the template from Flippity.

In the following video I demonstrate to use pivot tables to make a progress tracker in Google Sheets.

How to Make Timelines With Google Sheets

There was a time when I didn't like working with Google Sheets. That changed about ten years ago after a chat with Kern Kelley who showed me some of the things that he had created with Google Sheets. Since then I've used Google Sheets for all kinds of things from self-grading assessments to data visualizations. But as a history teacher my favorite thing to do with Google Sheets has been making multimedia timelines with the help of templates from Flippity and Timeline JS.

With the Timeline JS template you can make a multimedia timeline that includes pictures, videos, audio, maps, and text. Watch my video below to see how it works.

Flippity's timeline template doesn't have as many options as the Timeline JS template, but it's still a good option for making a timeline. The upside to Flippity's template is that it is a little easier for first-time users to follow than the Timeline JS template. My video embedded below demonstrates how to use Flippity's timeline template.