For those who use a reading log in class, a Google Sheet is a great way to keep track of this. Each student can share their own reading log with the teacher, to be filed in a folder specific to the class and section, or if your class size is small, you could create one sheet, in which everyone has editing access. Each student having with their own sheet, for easy entry.
Another great way to use Sheets is by creating an assignment tracker. Create a Google Sheet in which all assignments are listed, along with student names, and set up conditional formatting to highlight a cell in green, yellow, or red when the assignment is missing, incomplete, or turned in. Give parents access to view the sheet so that they can easily check their student’s progress, and touch base with you in case they have any concerns. If you would like students to access the sheet, the same can be done–give each one viewing access–or you can publish the sheet on a password protected Google Site.
I love, love, love using Google Drive in my day-to-day, and with students. Interested in learning more about these great tools? I’m now offering this mini-course on G Suite. Check it out!
Amanda M. Orozco 