Using Google Drive for a Class Reading Log

Like many elementary teachers, I assign independent reading as part of my students’ daily homework routine. We keep this simple — no summaries, no book reports — just choose a book, read for at least 20 minutes, and record the title and author. Ideally, this log of books serves as a launching pad for conversations about different stories, genres, and authors. In practice, however, it’s difficult to find time during class each week to go over the reading logs and check in with each student individually. When it happens, if it happens, it’s often rushed.

To counter these problems, my students have moved their reading logs to the cloud with Google Drive. Now that my class has started with Google Apps, I was able to set up a class reading log in less than 10 minutes. Here’s a quick tutorial I put together to show the steps:

YouTube Preview Image

As soon as your students enter a few books, it will look like this:

Screen Shot 2014-01-15 at 6.43.36 AMTo add comments or questions about your students’ books, select a cell and click the comment button in the upper right side (or select Insert –> Comment).

Screen Shot 2014-01-15 at 6.35.26 AM

So far I’ve kept my comments and questions simple — I don’t think a spreadsheet is the place for deep conversations — but I’ve been able to communicate with my students about their book choices with more regularity than before. Students are also able to make comments to each other. I haven’t promoted this feature yet, but it’s already happening.

There are other options for children to share what they are reading. Some classes at my school are into BiblioNasium, which is like Goodreads for kids. I can see advantages to a website like this, but right now, Google Drive is the simplest choice for my class.

3 Comments

  1. Rebekah Madrid

    I think this is a great way to keep track. In many ways its like the COETAIL spreadsheet…a place to start conversations, I guess. Again, thanks for sharing.

  2. Cool….we did this at ISBangkok for elementary students but also added that it added up their monthly reading time and then instantly graphed it for them. For 3rd and 4th graders they loved seeing the time spent reading in a graph and look at their time reading from month to month. Come conference time it made for a good conversation in student-let conferences with parents.

    Just an idea as you think of moving this to the next level. 🙂

    Love the commenting directly on the sheet…that’s a great idea.

    • Jeff Lewis

      That’s a fantastic idea, Jeff. I’ll have my students start tracking their minutes on Monday. It might also be fun to show the students how to create the graphs on their own. With third graders, I haven’t taught anything beyond the basics of spreadsheets, but I think they are capable.

      I’ll let them gather data for a few weeks and let you know how it goes.

Leave a Reply

Your email address will not be published. Required fields are marked *