“How do you keep track of everything in your standards-based grading system?”
Both the students and I are responsible for tracking scores. Here’s how it works.
My Google Docs Gradebook
I use Google Docs for my SBG gradebook. Since each course I teach has different standards, I have a separate file for each course. Multiple sections of the same course are in the same file. Here’s how the files are set up:
 Each assessment has its own sheet in the gradebook file.
 One column for each standard on the assessment, in order of appearance (question order). This makes transferring scores from quiz paper to gradebook much easier. Even easier if the quiz papers are alphabetized.
 Cells have color-coded formatting rules. I can easily see that everyone rocked standard BF.1, while CV.4 will need reteaching. Student A did well on the whole, while Student Y should come for extra help.
Once the scores for the assessment are recorded, I copy/paste them to the master sheet.
 The master sheet keeps track of the most recent scores for all of the standards.
 The standards are ordered by level. This make determining quarter grades easier. (See my grading policy sheet below.)
 The columns from the most recent assessment (in this case BF Quiz 2), are copied from the assessment sheet and pasted to the master sheet, one-by-one. Most recent scores replace old scores.
The master sheet allows me to see at a glance where everyone currently stands. (You cannot do this with the SnapGrades online gradebook.) I can see the date and assessment name for when each standard was last scored. And since each assessment has its own sheet, I do not lose the prior scores for the standards. The scores for students who reassess on their own time are entered directly into the master sheet and are annotated.
What I cannot do is see, at-a-glance, a student’s progress over time for each standard. This is why I also have…
Student Learning Folders
Each student has a 2- pocket folder with prongs. The prongs hold hole-punched pages. The first page explains my SBG grading policy.
The subsequent pages in the folder are tracking sheets for the learning goals.
When students get a quiz back, they record the name of the assessment, the date, and their scores on the corresponding standards on the tracking sheets. Students can store the quizzes in the pockets, if they wish. With their folder, students can easily see, at-a-glance, their progress on each standard over time. According to Marzano, student gains are higher when students track their progress.
At interims and end-of-quarter time, students fill out a progress report. They take the most recent score for each standard and record it under the corresponding level. This makes it easier for the student to determine their grade for the interim or quarter. Folders and progress report sheets are sent home to parents.
I then meet with students individually to discuss their grade, making sure my Google Docs gradebook reconciles with their progress report sheet.
This system works really well for me. While there are more scores to enter for each assessment, it takes the same amount of time as it would to tally up all the points earned if the quiz was scored traditionally.
Be sure to read “Improving the Way We Grade Science” for more background on standards-based grading. (It’s where I picked up the tip to color-code the scores in the spreadsheet.) You can also check out my SBG bookmarks at http://bit.ly/SBGlinks.
(Note: Feed reader users may need to click through to view embedded documents.)