This is a dynamic and configurable Excel spreadsheet that lets teachers enter grades for their assignments. It’s not meant to take the place of a school’s grade tracking system; it’s specifically for individual teachers to get a handle on their own assignments.
I made it during my student teaching to illustrate to my teachers how the students were progressing during my lessons. I've tweaked it to work on a wider range of disciplines.
It offers a relatively simple way to track the students and classes during an assignment. The spreadsheet automatically creates graphs to visually indicate how the assignment is working and what points need more attention. For example my narrative writing assignment in an 8th grade class focused on 3 main points: narrative components, grammar, and length. I entered the maximum points available straight off of my rubric and let the spreadsheet show me what classes and which students were meeting/not meeting the requirements. I sent the final spreadsheet to my teacher so she could enter the grades into the school’s system.
I hope you find it useful for your class(es).