Standards-Based Grading Without the Spreadsheet
If you’ve moved to standards-based grading, you already know the promise: instead of a single averaged percentage, you get a clear picture of which skills each student has actually learned. The problem is almost never the philosophy. It’s the bookkeeping.
Most teachers end up maintaining a giant color-coded spreadsheet — one tab per class, one column per standard, conditional formatting everywhere. It works, until it doesn’t: the formulas break, a column gets dragged out of place, and answering “who still needs to retake standard 3?” takes twenty minutes of squinting.
Here’s a workflow for doing standards-based grading well without living inside a spreadsheet.
1. Score the standard, not the assignment
The first mental shift is to stop thinking in assignments and start thinking in standards. A quiz might assess three different standards; a lab might assess one. When you record a score, attach it to the standard it measures, on a simple scale (most teachers use 0–4). Over a unit, each student accumulates several scores per standard — and that history is where the real signal lives.
2. Decide what “mastered” means — before you grade
“Proficient” should mean something specific and consistent. A common, defensible rule:
- Proficient = scored 3 or higher on a standard multiple times in a row.
- Advanced = a streak of top scores (or two 4s).
Writing the rule down ahead of time keeps you honest. It also means a single great test day doesn’t get mistaken for durable learning — and one rough day doesn’t erase weeks of evidence.
3. Read the data as reteach groups, not rows
This is the part spreadsheets are worst at. The question you actually care about isn’t “what’s Jordan’s average?” — it’s “which five students are stuck on the same standard, so I can pull them together tomorrow?” When your student mastery data is organized by standard, those reteach groups fall out almost automatically: anyone currently below proficient on standard X is your group for standard X.
4. Keep the support flags in view
Standards data is most useful when you can see it alongside the students it describes. If you have IEP, 504, or multilingual-learner students, those flags should travel with the scores — not live in a separate document you forget to check.
Where a tool helps
You can do all of this by hand. But the repetitive parts — applying your mastery rule to every student and standard, surfacing who’s slipping, and grouping students for reteaching — are exactly the parts a computer is good at.
That’s the gap Mastery Monitor is built to fill: import your gradebook, define your mastery rule once, and let the standards mastery tracker do the counting so you can spend your time teaching. It runs on your own computer, so your student data never leaves the building.
It’s currently in beta — if this is the workflow you’ve been trying to build in a spreadsheet, join the waitlist and help shape it.