How to Check If Your Gradebook Math Is Wrong
Most of the time, the math is not “broken.” The setup is. A missing zero, the wrong weighting method, an excused assignment, Quick Grade or a points-versus-percentage mix-up can make a grade look wrong even when the system is doing exactly what it was told to do. That shows up often in Canvas, Google Classroom, and PowerSchool support docs and user reports.
Quick answer
To check if your gradebook math is wrong, start with these 6 checks:
- Look for missing or ungraded assignments.
- Make sure you know whether you are seeing a current grade or a total grade.
- Check whether grades were entered as points or percentages.
- Review category weights and make sure they match your syllabus.
- Confirm that the assignment is actually included in the final grade.
- Recalculate one student by hand using the same rules as the gradebook.
Why gradebook math looks wrong
A gradebook can look wrong for simple reasons:
- an assignment was left blank instead of scored as zero
- weights do not match the course policy
- one tool shows only graded work, while another shows all work
- the teacher entered points, but the system expected percentages
- an assignment was marked excused
- a grade was hidden or not posted yet
- the LMS and SIS are using different calculation rules
Step 1: Check for blanks, dashes, and missing work
This is one of the biggest causes of bad-looking grades.
In Canvas, ungraded cells can make the total look better than it really is because missing work may be ignored unless the system is set to count it. Canvas support pages explain that students can see a higher grade when missing work still shows as a dash instead of a zero.
Google Classroom also removes assignments marked Excused from the grade calculation, which can change the average in ways people do not expect.
Quick tip:
If the student did not turn something in, check whether the gradebook shows:
- blank
- dash
- zero
- excused
Those four do not mean the same thing.You can also read: Easy Grader for Points, Percentages, and Letters
Step 2: Check whether you are looking at the current grade or total grade
This is a huge source of confusion in Canvas.
Canvas calculates two grades:
- current grade = based on graded assignments only
- total grade = based on all assignments, including ungraded ones
If the “calculate based only on graded assignments” option is selected, the grade can look much higher than the true course total. That is not bad math. It is a different view.
Simple rule:
If a student says, “Canvas says I have an A,” but several assignments are still missing, check whether they are looking at the current grade and not the total grade.
Step 3: Make sure points were not entered as percentages
This one causes wild grade swings.
A recent Canvas troubleshooting thread showed a real case where grades looked wrong because of a points-versus-percentage setup problem. In the same thread, the teacher later found a test was set to out of 0 points instead of 100.
This happens when:
- a 125-point exam is treated like a percentage
- a column is set up with the wrong point value
- the assignment total is wrong from the start
What to check:
- total points possible
- points earned
- grading type for that assignment
- whether the assignment says 100 points, 10 points, or even 0 by mistake
Step 4: Recheck your weighting method
Not every system calculates grades the same way.
Google Classroom lets teachers choose Total points or Weighted by category. In weighted grading, it first finds the average for each category, then multiplies each category average by its weight, then adds those results for the final grade.
PowerSchool supports several methods too, including:
- total points
- term weighting
- standards weighting
- category weighting
So if your syllabus says:
- Homework = 20%
- Tests = 40%
- Project = 40%
but your gradebook is running on total points, the final grade will not match your policy. That is not a math error. That is a setup mismatch.
Step 5: Make sure the category weights really add up the way you expect
A lot of grade issues come from weighting confusion.
In Google Classroom, weighted categories are calculated category by category. In PowerSchool, category weighting uses rounded category percentages before applying weights. PowerSchool’s documentation also notes that decimals are rounded in category weighting calculations.
That means your hand math can differ slightly if:
- you rounded too early
- the platform rounds by category
- the platform rounds only at the end
Quick tip:
Do one full sample by hand using exact values first. Only round at the end unless your platform says otherwise.
Step 6: Check whether the assignment is included in the final grade
In PowerSchool, an assignment may exist in the gradebook and still not count toward the final grade if it is not set up correctly. PowerSchool community guidance specifically tells teachers to check whether the assignment is marked to include in Traditional Final Grade and whether the assignment is tied to the categories used in the grade calculation setup.
So if a teacher says, “I entered the score but the total did not move,” this is one of the first places to look.
Step 7: Check for hidden or unposted grades
Another reason totals can look wrong is that students may not be seeing all the grades that exist.
Canvas support guidance says grades that have not been posted yet may not be factored into the final grade students see. Hidden assignments can also make the visible course total look off from the teacher’s view.
Simple check:
Compare:
- teacher view
- student view
- posted vs unposted grades
If those do not match, the totals may not match either.
Step 8: Watch for LMS vs SIS mismatch
Sometimes the math is fine in one system and different in another.
PowerSchool community guidance notes that if two systems are both calculating grades, students can end up seeing two different current or final grades. That is common when one tool is the LMS and the other is the official SIS.
This matters because a teacher might be checking:
- Canvas
while the school reports: - PowerSchool
Or a teacher might use Google Classroom categories, but Google’s own help page notes that Classroom grade categories do not transfer to the SIS through SIS grade export.
So ask one simple question:
Which system is the official source of record?
Step 9: Recalculate one student by hand
This is the fastest way to find the problem.
Pick one student and one grading period. Then write down:
- each assignment score
- total points possible
- assignment category
- whether it is counted, excused, missing, or hidden
- the course weighting rule
Then do the same math the gradebook is supposed to do.
Example: total points method
Student earned:
- Quiz 1: 8/10
- Quiz 2: 9/10
- Test: 42/50
Total earned = 59
Total possible = 70
59 ÷ 70 × 100 = 84.29%
If the gradebook shows 84.29%, great.
If not, check whether:
- an item was excused
- one item was not included
- the assignment total was entered wrong
- the class is actually using category weighting instead of total points
Example: weighted category method
Homework average = 90, weight 20%
Tests average = 80, weight 40%
Project average = 95, weight 40%
Final grade:
- 90 × .20 = 18
- 80 × .40 = 32
- 95 × .40 = 38
Total = 88%
If the system shows something very different, the issue is usually in the category setup, not the arithmetic. Google Classroom’s help docs outline this same weighted approach.
Step 10: Check standards, terms, and special grade scales
Some gradebooks are not using plain percentages at all.
PowerSchool can calculate grades using term weighting or standards weighting, and the final grade may depend on a grade scale cutoff instead of raw percent alone.
So if you are comparing:
- quarter grades
- semester grades
- standards scores
- letter cutoffs
make sure you are not mixing different grading systems.
Best quick checklist for teachers
Before you assume the gradebook is wrong, check:
- Are there any blanks or dashes?
- Are missing assignments counting as zero?
- Are excused assignments removed?
- Am I looking at current grade or total grade?
- Are points and percentages entered correctly?
- Do the category weights match the syllabus?
- Is the assignment included in the final grade?
- Are grades posted and visible?
- Is the LMS using the same rules as the SIS?
Easy mistakes that fool people
Here are the mistakes that trick people most often:
Leaving missing work blank
A blank can look very different from a zero. Canvas is especially known for this issue.
Using the wrong grading model
Total points and weighted categories do not give the same result.
Trusting one screen too quickly
A student view, teacher view, and SIS export may all show different numbers depending on settings and posting status.
Rounding too soon
If the platform rounds differently than you do, your hand total may be close but not exact.
FAQ
Why does my gradebook total look too high?
Often because missing work is still blank, excused, or excluded from the current-grade view. Canvas and Google Classroom both have settings that can change this.
Why is Canvas showing one grade and my teacher another?
Canvas can show a current grade based only on graded work and a total grade based on all work. Hidden or unposted grades can also create differences.
Why does my hand math not match PowerSchool?
PowerSchool may be using total points, term weighting, standards weighting, or category weighting, and category weighting includes rounding rules.
Do Google Classroom categories transfer to the SIS?
Google says Classroom grade categories do not transfer to the SIS through SIS grade export.
What is the fastest way to find the error?
Recalculate one student by hand using the exact same grading method the course is supposed to use. Then compare item by item until the numbers stop matching.
Final thought
If your gradebook math looks wrong, the best move is not guessing. It is auditing the setup.
Start with missing work, then check current vs total grade, then look at points, weights, and category rules. In most cases, the gradebook is following its instructions. The real problem is that the instructions do not match the grading policy.
