When our school closed our campus and became a distance learning institution, I was fortunate to have several blended learning tools that my students were familiar with and able to access. However, since our LMS doesn’t aggregate data from each of those tools and so I needed to create another solution.

I made a tracker (and there is a google sheets template below) where I can open up students’ work, check for completion, and enter a quick value.

I also added in conditional formatting that turns the names yellow or red if a student is having repeated completion difficulties and needs to be contacted. Below is a Google Sheets template for anyone to use if you would also find it useful.