What does it look like in the gradebook?

Standards-Based Grading

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.

Grades Google Sheet

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.

Class Average

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.

Skyward Example

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!


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s