Keeping track of student work

I normally keep track of students' work using Google Sheets and make the sheet available online. I have found this useful in three ways:

1. I can easily, visually identify students who are falling behind.
2. Students can check if they are up to date.
3. Parents can check if their children are up to date.

To streamline the process, I have created a blank student work submission template. All you need to do it add student names and task names. 

You can record students submitting work by entering the following numbers in the appropriate cells, the cells will automatically change colour.

• Enter 0 for work not submitted, turns the cell red
• Enter 1 for work submitted, but with problems, turns the cell amber
• Enter 2 for work submitted, turns the cell green

To get a copy, sign-in to your Google Account, open the template, and then choose File > Make a copy.

The video below shows you how to delete the instruction box.