September 12, 2011

Using Google Sheets to Track Class Data

Google Sheets is a great tool for inputting and tracking any type of classroom data you can imagine. If you want to track something and then analyze the data afterwards then Google Sheets is your tool. Everything from class attendance, to assignments, and grade tracking can be done easily in this cloud based tool. I've embedded below an example of having collected data from a class over the course of 5 tests. The graph represents the relationship of average scores for the entire class from test 6 to test 10. What the graph reveals is that as a class the scores increased over time.


1 comment:

  1. You took a little different attack on this project, not exactly as per the instructions. However, I appreciate this point of view ... so stick with it.
    You don't have as much data to work with on this strategy, but I'd like a little deeper reflection on what the graph is actually telling. Eg, was it a steady increase, or gaps in some places, etc. And if there were gaps, what might be the reason for this? Just pretend you are a teacher digging deeper.

    ReplyDelete