Initially, quiz grades go into a personal Google Sheet before eventually going into the district grading program. Here’s a link to a blank template. Let’s take a look at some of the features.
The best part about the sheet is that it’s conditionally formatted to show certain colors for certain grades. We can quickly see what areas a student is excelling in or needs more work in. This helps with many areas including tutoring, knowing what to re-focus on in class, and knowing where to go with the class in the future.
In addition to individual student grades, there is a row at the bottom for the class average for each concept.
After placing the grades in this spreadsheet, it’s time to go over the quiz with the students. We go over the problems in class and analyze where we can improve. Then, once class has ended and the kids have left the room, at some point that day their grades are entered into the district’s online gradebook program. I’m not sure if it’s appropriate to take a screenshot of the program we use, so here’s what it looks like in spreadsheet form.
Our district requires 9 minor grades and 3 major grades each nine weeks (not all of my grades are pictured above). Usually, I have the minimum number of minor grades, but major grades exceed the minimum number because each concept on the concept checklist has it’s own major grade. This does create a bunch of grade entries, but I prefer this method because the kids can see exactly what they need to work on. It’s harder to know where a student is strong or needs more work if the concepts are bundled together. For example, if I bundle Translations, Reflections, Rotations, Dilations, and Compositions all into one major grade for Transformations, then the kids only know that they need to work on Transformations. This is more general than I prefer and makes it harder for them to focus their continued learning.
Also, the actual grade entries are directly based on the SBG ratings in the original Google Sheet at the top. However, instead of entering a 9 in the district gradebook, a 90 is placed. 6.5 converts to 65, 8 converts to 80, etc.
That’s a quick breakdown, but please feel free to ask questions!