You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.


Hopefully the video covers the main points.  This is a google apps sheet solution for tracking, comparing and sharing data at the indicator-level amongst a grade-level team that has done all the hard-work of creating common assessments and rubrics.   I've included both mutiple-choice and constructed-response examples - so delete what you don't need and duplicate what you need more of. 

If you get stuck: (or comment). 



Multiple choice indicator tracking

Question:  I can see that the long response grades align with specific standards, so if I were a teacher looking to target my interventions with this system I could easily do so.  Awesome!

Wondering if the same standards-level information is tracked for the multiple choice questions.  Knowing a student got 80% then 85% then 75% out of 10 questions on the interims is great, but still isn't giving me longitudinal knowledge at the skills-level.  I see you can put the indicator on the top of each multiple choice question, but I'm not seeing how M.C. indicator data shows up in the "Indicators" tab.  Assuming this was left out for the sake of not over-complicating...

Perhaps you could add another sheet that takes in any student name and for each assessment point performs a LOOKUP on only the multiple choice assessment result for each indicator and returns a 1 or 0 which then gives conditional format to a cell in that row.





Wow! This is a really thoughtful solution

An elegant solution that is well-grounded in the interim assessment work of real schools!  Thanks for sharing.  Would love to hook this up with the per-user servlet that I've been working on (you mentioned it at the end) for Google Sites.  

Simple shared assessment tracker

Problem of practice

There isn't a shortage of assessment & gradebook tools/platforms these days & too often the enterprise systems are complex and too intimidating for teachers to adopt on their own (they also cost money!).


This is an attempt to create a simple tool that a team of teachers could use to track indicator-level data on shared assessments. It's low-stakes, hopefully approachable and can be customized to fit the team's needs.

Cast your vote


Tweet this

Browse other items with similar tags

The Reportlet Script, written in Google Apps Script, serves up easily-templated tabular reports that can include custom data, images, and charts keyed to the logged in user. Power users get a dropdown to allow viewing of any report.
Recommended by 17 educator(s).
Using a script stolen from another project and a student template, this platform will allow a teacher to enter in their classroom roster, hit a button and automatically create goal setting sheets for their class and monitor their students' progress!
Recommended by 9 educator(s).
The formMule (aka "The Mule") is a Google Apps script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms.
Recommended by 64 educator(s).
This is a simple script housed in a google sheet that allows teachers to create handouts for their classroom, shares the student appropriately and organizes the handouts in a collection. It can be used to create sheets as well as docs.
Recommended by 19 educator(s).
This hack shows how to install a Google Apps Script in your Google Site to look up the grades of the currently logged-in student or parent and generate a live bar of progress from your Google spreadsheet!
Recommended by 20 educator(s).
This introductory module provides what you need to start building the modular and lightweight data system of your dreams. The first installment is a "Lateness Zapper" that automates logging, communications, and reporting on student lateness.
Recommended by 23 educator(s).
This tutorial presents the pre-Add-on version of Doctopus. Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects. For tutorials on the new version of Doctopus, see
Recommended by 188 educator(s).