Student Digital Reading Log Using Google Sheets

Why Google Sheets

Collecting student reading logs can be such a tedious task.  There are many websites out there that allow teachers to monitor student reading. However, I prefer Google Sheets as it is so easy to provide students with feedback using the Commenting Tool. Also, students and teachers may easily share the reading log with parents, administrators or educators simply by using the Share feature. And, the Google Sheet is also collaborative. If students were researching together then they could share references, ideas and summaries with their partners. Finally, Google Sheets automatically saves in the Cloud which makes it easy for students to track books they read at school and at home. It will never get lost!

Google Sheets Template

The following digital book log allows students to set a goal for how many books they wish to read. In the image below, the student set a goal to read 100 books. As the student updates their reading log on a weekly basis the percentage towards that goal is automatically updated. So for example, the student in the image below read one book today and they have a goal of 100 books. Therefore, they have met 1% of their goal!

Click the image and Make a Copy to modify and edit your digital book log. 

Screen Shot 2017-10-17 at 10.00.07 PM

Ways to distribute the digital book log

  • Google Classroom-Make a Copy for every student
  • QR Code Generator– Post a QR Code
  • Gmail- Share the file with students and email it to them
  • Teacher Website- Post a link to the URL on the teacher’s website. Remember to change the URL ending from “edit” to “copy” which will force students to make their own copies

Summary

There are many ways to have students track their reading. But, Google Sheets allows teachers and students to easily monitor progress using the amazing features of Google.

How do your students track their reading?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s