Beth Holland

Food for thought…

Google Spreadsheets + Screenchomp = Dynamic Reading Records


As teachers begin to organize themselves for the upcoming school year, just a suggestion for those looking to track Guided Reading. A few years ago, I encouraged our first grade teachers to use a Google Spreadsheet for tracking Guided Reading rather than a standard Word Document. This way, all of the data could live in one location, and both teachers could access and edit the same file simultaneously. An unintended consequence, however, was that at the end of the year, they simply shared the document with the 2nd grade teachers to that the process could continue.

This sample spreadsheet shows the progression of students over two years with their reading. (NOTE: all of the names have been changed.)

However, for a teacher inheriting this information, the notes may not be enough. That’s where the Screenchomp app for iPad comes in. Imagine this:

  • Either import a PDF, or take a picture, of what the student is about to read out loud.
  • Allow the student to read from their paper copy.
  • Hit the record button in Screenchomp and capture your student’s fluency along with your annotations in real time!
  • Add the Screenchomp link as a comment in the spreadsheet with your notes

Now, either as a teacher inheriting a student, or even reflecting back on student progress during the course of the year, you have your notes plus an authentic recording of the student reading all in one place! You could certainly do this process with other screen recording apps. I just happen to like Screenchomp for this because it is FREE, scrolls to the full length of a page, and generates its own link to add to the spreadsheet.

NOTE: No iPad? No problem! A web-based screencasting tool such as or could also work.

Author: brholland

Researcher, Writer, and Speaker

8 thoughts on “Google Spreadsheets + Screenchomp = Dynamic Reading Records

  1. Pingback: Weekly Resources, New Articles, & ETT Projects | Leading Change in Changing Times

  2. I’ve used Evernote for an audio record of students reading but I had not tied the information to a Google spreadsheet, great idea. Thank you.

  3. Pingback: Google Spreadsheets + Screenchomp = Dynamic Rea...

  4. Hi Bret.
    If you do running reading records, Screenchomp could be interesting to try as you could record the student’s fluency as well as your notes. Similarly, if you are keeping student portfolios in Evernote, you could do the running record and then email it to the Evernote notebook. What could also be interesting is to have the student do a new recording as an audio note to accompany the screencast. Lots of possibilities!

  5. Pingback: DIY Reading Records | Beth Holland

  6. Pingback: KISS – Keeping It Shockingly Simple | Beth Holland

  7. Hi there would you mind letting me know which web host you’re utilizing?
    I’ve loaded your blog in 3 completely different internet browsers
    and I must say this blog loads a lot faster then most. Can you recommend a
    good web hosting provider at a honest price? Kudos, I appreciate it!

  8. Hi. This site is actually just hosted through I’ve had it for years and it’s been great! Free, too!

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s