Standards-based grading without a second spreadsheet
The idea is sound and the bookkeeping is what kills it. This is about the bookkeeping: what it actually takes, and which parts a gradebook should be doing for you.
Written by a practising Ontario teacher · Last reviewed: October 2026
What it actually changes
Traditional grading answers "how much work did this student complete, and how well?" Standards-based grading answers a different question: what can this student do?
The practical consequence is that a mark stops being an average of everything and starts being a current best estimate. A student who could not factor in September and can in December is a student who can factor — and an average that still carries September says otherwise.
You do not have to adopt the whole philosophy to get the useful half. Even a traditional percentage gradebook benefits from knowing which standards you have actually assessed.
The bookkeeping cost nobody mentions
Every account of standards-based grading describes the pedagogy. Almost none describes the admin, which is where it fails in practice. Three things get expensive:
- Double entry. Marks go in the gradebook; standards go in the grid. Two places, same information, and the grid loses.
- Standards you did not plan for. A task you wrote on Tuesday assesses something you had scheduled for March. If retagging is awkward, you do not do it.
- Reporting back. Your school still wants a percentage. If your standards data cannot produce one, you keep a second gradebook anyway.
A tool worth using has an answer to all three. Most have an answer to the first.
What to look for in a gradebook
Four questions, in the order they will bite you:
- Does coverage come from the marks? If you enter coverage separately, it will go stale. There is no version of this where discipline wins.
- Can one assessment carry several standards? Real tasks do. A tool that allows one standard per assignment forces you to lie about your own teaching.
- Is the standards list scoped to your grade? A dropdown containing every standard K–12 is a dropdown nobody uses twice.
- Does a percentage still come out the other end? Because your school will ask.
Level Up Classroom answers yes to all four, which is less a boast than a description of why it was built — the first three were the reasons the author's own spreadsheet kept dying.
A smaller way to start
You do not have to convert a whole course. Pick one unit. Tag the three or four assessments in it with the standards they assess, mark them as normal, and look at the coverage map at the end.
If the map tells you something you did not already know — and it usually does, generally a strand you have been assessing twice and another not at all — extend it. If it does not, you have lost a unit's worth of tagging rather than a term.
Frequently asked questions
Is standards-based grading the same as mastery grading?
Can I do this and still report a percentage?
How many standards should one assessment carry?
Does this work for a single teacher, or do I need my school to adopt it?
Related
- A gradebook with Common Core built in
- What-if grade calculator — free, no account
- Best gradebook apps for teachers (2026)
The part that usually gets dropped
Standards tracking only survives if it is a by-product of marking.
Every teacher who has kept a standards spreadsheet has abandoned one. It fails for the same reason every time: it is a second place to enter the same information, so it goes stale in week three and then it lies to you.
Level Up Classroom derives coverage from the marks you already entered. You tag an assessment with the standards it assesses once, and the gaps appear on their own — per strand, per student, from the gradebook you were going to fill in anyway.
A gradebook that does this for you
Level Up Classroom tracks achievement and learning skills together, and drafts report card comments from the marks you have already entered. Free to start.
Try it free