Why does a missing assignment sometimes leave a student’s grade unchanged while another missing assignment lowers it sharply? The answer is not merely ‘the computer changed the marks’. In a school gradebook, a missing assignment, an excused assignment, an ungraded submission and a recorded zero may have different effects on the grade denominator. Learning what the software counted helps parents, students and teachers respond fairly.
This guide explains how a running grade differs from a final grade, how a zero changes an eligible-points total, how excused work is excluded, and how to audit a surprising percentage without confusing incomplete records with academic ability. It uses transparent numerical examples, current official platform guidance, and realistic school decisions rather than pretending all gradebooks use the same policy.
Start with the 50-second explanation below, then follow the worked examples and the role-specific routes. The point is not to find a trick for raising grades. It is to understand the difference between learning evidence, authorized exceptions and calculation rules so a family can ask the right question when a grade suddenly changes.
The useful answer in about 50 seconds
A grade is a fraction with a numerator (points earned) and a denominator (points currently eligible). A submitted, marked assignment normally contributes to both. An unmarked or blank grade cell may contribute to neither in a running-total display. A recorded zero contributes zero to the numerator but adds the assignment’s possible points to the denominator. An excused assignment is intentionally excluded according to the institution’s policy. Those are four different states, even when the student did not hand in a piece of work.
Start with three checks: what status is recorded, which assignments the current total includes, and whether the screen shows a running grade or an official final grade. If a number seems surprisingly high or low, calculate the included points on paper. Do not automatically change an empty cell to zero or mark it excused. First establish the actual school rule and whether the work was due, submitted, graded, optional, inaccessible, or formally waived.
For example, 24 points earned out of 30 marked possible points is 80%. Add an unsubmitted 10-point assignment as a zero and the figure becomes 24 out of 40, or 60%. Excuse that assignment instead and the figure remains 24 out of 30, or 80%. Leave it ungraded in some running-total configurations and it may also display 80%, although the meaning is entirely different. The difference is the denominator, not a mysterious calculation error.
A parent opens the portal and sees two incompatible stories
Imagine that a Secondary student has an English comprehension task, a Mathematics quiz and a short Science investigation. On Monday the school portal shows a respectable overall result. On Tuesday the result drops despite the student earning no new poor mark. The family asks whether the teacher changed the grade. In fact a previously empty assignment cell may have received a zero after the deadline. A small visible event in an electronic gradebook can change the set of points used to calculate the total.
The opposite can also happen. A learner missed an assignment because a teacher granted an exemption. The parent expects the grade to be reduced. Instead the total stays the same or changes in a less obvious way because the assignment has been excluded. This is not a reward for not working: it is an implementation of a legitimate decision about what evidence counts. The two pupils may have identical-looking blank submissions but opposite grading responsibilities.
A teacher faces a different problem. The markbook is a live operational record, while the report card is an assessment decision. Staff must distinguish a submission event, a grading status, a late-work policy, an exception decision, and an official released grade. When all are compressed into one number, parents can misread a draft calculation as a verdict on learning. Good explanation restores the separate layers and keeps the reasoning visible.
First separate five states that look deceptively similar
Submitted and graded. The teacher has assigned a score, for example seven out of ten. Provided the assessment counts, the total gains seven earned points and ten possible points. The mark may still be hidden until a release date. Hidden does not mean missing; release visibility is another dimension. In a weighted system, the effect on the course result depends on the category.
Not yet graded. The task may be submitted and awaiting marking, or it may not have a score. In some systems the running total omits a scoreless assignment. This does not establish full credit, a penalty or an exemption. A current-grade display can therefore be temporarily optimistic. A student should not infer that the teacher has accepted an ungraded submission as correct.
Missing, without a numerical score. A missing label is a status flag, not necessarily a posted zero. Schools may configure automatic missing-work policies, but the exact behavior varies by platform, due date, assignment type and teacher settings. A red badge is useful evidence of a workflow issue, not enough to reconstruct a grade by itself.
Recorded zero. A score of zero out of ten generally means that ten possible points are in the denominator while the earned points remain unchanged. If the zero is provisional, a resubmission or teacher decision may later change it. This is different from an empty score cell, even when both refer to an absent submission.
Excused or excluded. A formal exception can remove the task from a particular learner’s calculation, often reducing the number of possible points for that learner. It does not necessarily remove the assignment for everyone. Nor does it mean the learner demonstrated the knowledge. It indicates that the specified task is not being used as a scored obligation for that student under the relevant rule.
Build the fraction before interpreting the percentage
Take a clean, simplified example. In Week 1, one learner scores 8/10 for English and 16/20 for Mathematics. The running total is (8 + 16) / (10 + 20) = 24/30 = 80%. Suppose a ten-point Science task is due. The gradebook now presents three possible versions of the same week. If it remains scoreless and omitted from the running total, the display stays 80%. If a zero is recorded, the total is (8 + 16 + 0)/(10 + 20 + 10) = 24/40 = 60%. If the student has a formally excused Science task and it is excluded, the relevant figure remains 24/30 = 80%. These calculations are illustrative, not an assertion about every learning-management system.
The two 80% displays carry different information. One says, ‘There are 30 marked possible points and we do not yet know what will happen to the next ten.’ The other says, ‘The school decided those ten points are not part of this learner’s current eligible assessment.’ The same output value does not prove the same rule or educational situation. A parent who responds only to the percentage will miss that distinction.
Check whether the teacher has weighted subject components. In a weighted arrangement, ten points of weekly homework may not have the same course impact as ten points on a high-stakes test. A common model calculates each category’s earned/possible ratio and then combines category results using prescribed weights. Where that happens, simply summing every point across all tasks is the wrong reconstruction method. Ask which categories are included, what weight each carries and how empty categories are treated.
A staged diagnostic that avoids guessing
Stage 1 — identify the number. Is this a running course score, a projected ‘what-if’ score, the mark on one assignment, a teacher’s private view, or an official report? A 74% in a student-facing preview might not be the final school result. The label and release date matter as much as the digits.
Stage 2 — identify the assignment. Record its task title, maximum points, due date, submission requirement and category. There may be two similarly named tasks, a practice activity that does not count, or a group submission recorded under a separate workflow. Do not replace a real task description with ‘the worksheet’.
Stage 3 — read the cell carefully. Is it blank, zero, EX, marked missing, late, incomplete, reassigned, resubmitted, dropped, or hidden? These statuses can coexist in certain systems and can have different meanings. A due-date flag by itself is not evidence of a posted numerical grade.
Stage 4 — identify the policy. Find the class syllabus, school assessment handbook or assignment instructions. Does missing work become zero immediately, after a grace period, or only after review? When may an absence be excused? Does an approved alternative assessment replace the old task? The software should implement the policy, not invent it.
Stage 5 — reconstruct. Make a table of earned points, eligible points and category weights, separating current scores from ungraded items. Recalculate with the assignment included at zero and excluded as excused. This is a sensitivity check, not a request that staff choose whichever gives the highest percentage.
Stage 6 — ask one precise question. Instead of saying ‘The marks are wrong,’ ask ‘The Science cell is marked missing but currently has no score. Is the running total excluding its ten possible points, and under what condition will a zero be posted?’ Specific questions let staff resolve an issue without turning a learning discussion into a dispute over a dashboard.
Why different systems can show different totals
Electronic gradebooks often distinguish stored submission records from grade calculations. A task can have a due date and a missing label without having a saved numerical mark. A teacher can see a status that a student does not yet see. A course may include draft assignments, unpublished assignments and assignments intentionally excluded from the final total. Some systems support ‘treat ungraded as zero’ as a display choice rather than a final stored grade. The interface needs a careful reader because the screen is a view over rules and records, not the rules themselves.
The University of Minnesota’s Canvas guidance, updated on 12 February 2026, describes a running-total approach in which only scored activities affect the current total. It warns that unscored missing work may inflate a displayed percentage and explains how a recorded zero and an excused EX affect calculations differently. Stanford’s Canvas guidance similarly tells instructors to check missing scores, excused entries and grade visibility before finalizing. Those are concrete vendor-platform instructions, not evidence that all Singapore schools use Canvas or share one assessment policy.
Your school might use another portal, a spreadsheet, a bespoke student information system or a manually reviewed report. An ‘EX’ code is not universal. A teacher might use an approved alternative task rather than exclude the original. Some final report calculations may also cap, normalize or moderate components. If the local policy differs from the examples here, the local policy and official marks govern. The mechanism to understand is the same: a percentage depends on what the software counted.
Two different questions: ‘Was the work done?’ and ‘Should it count?’
There is an ethical as well as a mathematical distinction. ‘Was the work completed?’ is about learning activity and submission evidence. ‘Should this particular item contribute to a reported grade?’ is a policy and professional judgement that may involve illness, access, disability-related arrangements, school-approved absence, replacement tasks, moderation or a documented error. A student can need a learning catch-up even when an assignment is rightly excused. Conversely, a pupil can have handed in good work while a technical handoff prevents it being registered.
That second situation belongs partly to the separate explanation of why submitted homework may still be invisible to the teacher. Our question here starts after the submission status is understood: what is actually included in the calculation? Keeping these questions separate prevents an information-system problem from being mistaken for a weakness in a child’s knowledge.
An excusal should not become an informal method of improving grades. Schools need consistency, authority, dates and a record of why an exception is appropriate. A zero should not be imposed by guesswork where the school’s process first requires checking submission evidence or an approved absence. Both errors are avoidable when an educator treats the gradebook as a transparent ledger and takes student circumstances seriously.
Worked casebook: ten situations worth recognising
Case 1: A student submits two hours before the deadline, but the gradebook is blank. The first check is not the denominator. Establish whether the submission exists and whether the teacher has marked it. A receipt, attachment or platform confirmation can establish the submission state. Only then ask whether its possible points are excluded from the running total. If the task is awaiting marking, a stable percentage is not proof that the work earned full marks. For the pupil, the useful next move is to preserve the receipt and check the assignment status rather than upload repeated versions without instructions.
Case 2: An assignment passes its due date but keeps an empty score. A child may assume an empty cell is a zero. Another may assume it has no consequence. Both inferences can be wrong. The teacher may be allowing a grace period, checking absences, waiting for manual grading or working within a system that separates the missing flag from the numerical penalty. Ask for the policy rather than interpreting a colored badge as the actual calculation. For families, it helps to track the original deadline and any authorized extension separately.
Case 3: The displayed average suddenly drops when staff finalize missing work. This is a classic denominator event. If 24/30 became 24/40 after a zero was entered, the percentage changed even though none of the previously marked work changed. That does not make the zero intrinsically fair; fairness depends on the stated school rule and facts. But it does explain the arithmetic. A useful conversation is: ‘What eligible task did the total add, and was the missing-work process applied correctly?’
Case 4: A student is officially excused from an assignment after an illness. If the approved exception removes a ten-point task, those ten possible points should generally not remain in an ordinary points-based denominator. The class may still offer the learning materials or an equivalent chance to practise. The official status should be documented rather than left as a mysterious blank. The teacher can tell the pupil which knowledge remains important even when the score is waived, so educational expectations are not conflated with a numerical exemption.
Case 5: The parent sees a lower number than the teacher reports. One view may include unreleased marks or make a different choice about ungraded work. Another possibility is a weighted or overridden total. Before alleging that someone changed the record, compare the name and date of the same assignment in each view. Ask whether all grades meant for release have been posted. A percentage without a list of included components is not enough to determine the source of the difference.
Case 6: One Mathematics quiz is optional and another is compulsory. An optional bonus task may be configured not to count unless attempted; the compulsory test may count even when submitted late. A learner should not treat ‘no score yet’ as permission to skip a compulsory task. Equally, teachers should avoid calling a genuine optional activity ‘missing’ when no submission is required. Clear labels are a fairness device because they prevent pupils from making effort decisions against an ambiguous rule.
Case 7: A task is recorded as zero, then a late submission is accepted. The stored score might later become six out of ten, creating both a numerator increase and a status change. If the late policy applies a penalty, the awarded number may differ from raw correctness. When the grade changes, ask which policy was used and whether the same standard applied to peers. The goal is to understand the final evidence rather than celebrate a temporary rise without knowing the rule.
Case 8: A group project is submitted by one leader. A team member may see no personal submission even though the group file exists. The gradebook may be waiting for a group mark, individual score or mapping between group and members. Before imposing zeros, the teacher should reconcile the submission workflow and the actual assessment criteria. Students can retain a brief contribution record, but this article does not own the separate question of whether their individual group work was fairly assessed.
Case 9: A resit or replacement task follows a difficult week. A replacement assessment can supersede, average with or coexist with an original score depending on policy. An apparent extra zero may be the old component waiting to be excluded. Conversely, excluding both could overstate performance. The family should ask which piece of evidence is the official owner of the skill for reporting. A clear replacement map avoids double counting and prevents a learner from preparing for the wrong requirement.
Case 10: A student receives 100% on one tiny homework item. The running total might show 100% if no larger tests have been marked. That is accurate for the scored subset but very weak evidence about the full term. The remedy is not to dismiss the child’s achievement. Congratulate the completed work, then distinguish early progress from a final prediction. Look for the upcoming categories, sample size and different skills that remain unassessed. The gradebook is a snapshot, not a forecast.
Four more cases about fairness, not arithmetic tricks
Case 11: The school approves an alternative assessment. If a child cannot complete one format because of an authorized access arrangement, the replacement may measure the same objective in another way. Do not assume that both the old and new tasks should count. Nor should the family insist they are automatically equivalent. The teacher needs to specify the learning target, the approved substitution and which item the final grade uses. The denominator explanation is only the bookkeeping side of that professional decision.
Case 12: A zero appears after an upload error. Screenshots alone may not tell the entire story, but a timestamped submission receipt, original file and communication log are useful facts. The first issue is determining whether the submission actually reached the teacher; the second is whether the markbook status reflects the resolved fact. A grade inquiry is stronger when it separates evidence of delivery from assertions about grade entitlement. Students should not publicly circulate classmates’ grades while trying to prove a system issue.
Case 13: Two classes use different percentages for comparable work. One may weight examinations more heavily, exclude a particular practice task or release marks at different times. Cross-class comparison without a common denominator is misleading. Ask for each class’s assessment plan before concluding there is unequal treatment. A grade is an output from both performance and scoring design. A course can be rigorous and fair with different task structures, provided criteria and communication are sound.
Case 14: A teacher posts zeros for every ungraded task by mistake. This is not simply a numerical issue; it can send misleading messages and create unnecessary distress. The teacher should distinguish ‘not yet submitted’, ‘received and awaiting marking’ and ‘officially zero’. An audit of recent score changes, pending submissions and approved exclusions protects the student. When an error is found, correct the records through normal school procedures and explain what changed, rather than inventing a vague reassurance about the student’s effort.
Practical learner route: check the work, then the record
Start by opening the assignment itself. Keep a simple private log: date due, whether it was submitted, confirmation received, whether the teacher marked it and what follow-up is required. The log should not become a second bureaucracy bigger than the homework. It exists to prevent ‘I thought I uploaded it’ from becoming the only available information when a disagreement arises. If the record says missing, first check whether a submission exists and whether you met the instructions, including the required file and correct classroom page.
If a score appears unexpected, calculate the fraction only after checking the component values. Try the difference between a blank score, zero and excused assignment on paper. A younger pupil may start with three strips labeled 24/30, 24/40 and 24/30, physically counting the eligible points. Older pupils can use a spreadsheet with separate columns for score, maximum, counted status and assessment category. The exercise teaches a useful general lesson: a percentage is incomplete until we know what its denominator represents.
When contacting the teacher, be factual and respectful. ‘I submitted on Tuesday and have a confirmation screen; the gradebook says missing’ is actionable. ‘Why did you lower my grade?’ assumes a cause that may not have occurred. If you need help learning the missed material, ask for it even if the numeric task was excused. The classroom objective remains broader than the percentage displayed on a portal.
Practical parent route: replace the shock number with an accurate question
Parents can help by refusing to turn a live score into a final judgment about the child. Start with the assignment list, not a comparison with another student or a sudden demand for extra tuition. Identify the changed cell and check whether it became scored, excused, dropped or posted. If you cannot see component details, politely ask for an explanation of the running-total rules. Schools usually have more context than the parent portal can display.
A useful private conversation is: ‘Yesterday the gradebook showed 80%. The ten-point task is now recorded as zero and the total is 60%. Can we check whether that was the expected policy and whether the submission history is correct?’ This wording joins the arithmetic to the governance question without asking for special treatment. If there was illness or a technical barrier, provide the relevant factual record and follow the school’s process. Do not ask staff to mark an assignment excused solely to obtain a higher percentage.
Use the moment to teach long-term habits. Ask the child what work needs doing, what part is understood, and how to check submission completeness next time. A number can alert us to an issue but cannot identify its cause alone. Remember that a lower running grade can reflect an added denominator rather than a new loss of knowledge; the learning diagnosis still requires looking at the actual student work.
Practical teacher route: make calculation status auditable
Teachers can prevent many misunderstandings by publishing a short explanation of the difference between ungraded, missing, zero, exempt, dropped and hidden. State when these states change and who can authorize an exception. For weighted courses, give a simple numerical example. When the portal uses a running total that omits scoreless assignments, warn families that the figure may overestimate the eventual total while work remains ungraded. That warning is both mathematically accurate and humane.
Before finalizing marks, audit ungraded cells, pending submissions, manual zeros, excused entries, category weights and visibility settings. Confirm that assessments not meant to count are configured accordingly. For one or two fictional or anonymized records, reconstruct the published course total independently. The University of Minnesota and Stanford Canvas teaching guides explicitly encourage such checks on missing zeros, excused scores and published marks. The point is not that software always errs; it is that clearly reviewed settings protect the meaning of the reported result.
When a pupil asks about an unexpected grade, explain the status transition. A sentence like ‘The ten-point Science task was empty yesterday and is now recorded as zero under our published late-work rule, so the denominator went from 30 to 40’ teaches more than ‘The computer updated.’ For approved exceptions, document the decision without disclosing sensitive circumstances to classmates. Where serious or disputed matters arise, follow the school’s escalation and assessment procedures, not an ad hoc change made through a public email thread.
Common failure modes and why the usual quick fixes fail
One mistake is to compare percentages without comparing eligible work. A learner with 80% on two minor quizzes is not necessarily performing at the same level as one with 80% on a completed examination. Another mistake is to divide summed earned points by every assigned point when the course uses category weights. A third is to treat the word ‘missing’ as an automatic zero across all software and policy configurations. Each error collapses a state or a weighting rule that matters.
A different failure comes from treating ‘excused’ as a judgement of achievement. It is usually a recorded exception to the assessment obligation, not a mark of mastery. Equally, an actual zero can be the output of a policy rather than proof that the child understands nothing. The teacher still needs evidence of competence from other sources. A child who struggled because instructions were inaccessible needs a different learning and access response from a child who misunderstood fractions.
There is also the automation trap. Teachers may bulk-apply default zeros, or families may use an unofficial grade calculator, without checking how the school treats hidden, resubmitted or excused items. The fastest calculation is not necessarily the correct calculation. When a grade matters for a consequential decision, ask the school for the official reviewed figure. An educational explanation can improve understanding; it cannot replace the institution’s authoritative records.
FAQ: questions families and teachers actually ask
Does a blank grade mean zero? Not necessarily. It can mean ungraded, unsubmitted, not released or a system-specific state. You need the task status and local gradebook rules. Some running totals omit unscored work while a final reporting process later requires an explicit mark or excusal.
Does a missing label always lower the current percentage? No. In systems where a missing flag and numeric score are stored separately, the flag alone may not change the running-total denominator. A missing-work policy may insert a zero automatically, however, and that can change the grade.
Why can an excusal leave the percentage unchanged? If a task was never included in the running calculation, excluding it formally may not change the current ratio. The record still matters: it distinguishes an authorized exception from work awaiting a score or a potential future penalty.
Can an excused task make a percentage rise? Yes, if the system previously counted a low score and a properly authorized exclusion removes those possible and earned points. But whether the school may change the status depends on policy, not on which result is larger.
What if the portal shows 90% but the teacher says work is missing? Both claims can be true. The displayed 90% may reflect only marked work, while the teacher is identifying required unmarked work. Ask which points are currently included and when missing work will be processed.
Should parents ask for all missing assignments to be marked excused? No. Excusal is an educational and administrative decision subject to school criteria. A parent can provide evidence for a legitimate exception or access issue, but should not use EX as a shortcut for inflating a grade.
How can a zero lower a grade if the child earned no new wrong marks? A zero adds potential points to the denominator without adding earned points. That arithmetic lowers the ratio even though previous scored assignments did not change.
What about weighted assessment categories? The school may calculate ratios inside categories and combine them using preset percentages. Recalculate using the published weights and any category-specific drop rules; do not use a single total-points formula unless that is how the course is configured.
Could an assignment be excluded because it was practice, not assessment? Yes. A teacher might set a formative exercise to ‘not count toward final grade’. That is different from excusing one learner from an assignment that ordinarily counts. Each case should have a clear label.
Does a graded but hidden score count? The effect varies by platform and view. Staff and students may see different totals when grades have not been released. The reliable route is to identify which assessment data the displayed number uses and ask when the official marks will be posted.
Who should fix a wrong status? Use the school’s documented channel, typically the responsible teacher or assessment administrator. Students can provide relevant evidence; access or technical support may be needed for upload problems. An outside tutor cannot lawfully change the school’s grade record.
Is an 80% running grade a good forecast for the term? Only to a limited extent. It depends on how much assessment has been marked, the remaining task types, weighting and the stability of performance. A percentage from a narrow early sample should be treated as a partial observation.
What should a student learn even if the grade is excused? Look at the objective. A pupil might still need to understand the science investigation, practise the comprehension strategy or learn a missing algebra method. Exemption from scoring and exemption from learning are not identical.
How can schools prevent disputes? Publish clear status definitions and worked totals, check missing and excused entries before reports, make release rules transparent and offer a respectful correction procedure. A traceable calculation helps families focus on the child’s next learning move.
Evidence, limits and related reading
The primary platform evidence for this specific arithmetic comes from University of Minnesota’s Canvas guide on missing and excused activities and its guide to preparing final grades, both modified 12 February 2026. The Instructure Canvas Instructor Guide on gradebook indicators explains that status colors and score representations are not interchangeable. Stanford University’s Canvas grade-calculation instructions and the University of Iceland guide to finalising grades independently describe the need to address empty scores and excused assignments before official reporting.
For the broader educational distinction between scores, evidence and responses, the OECD’s 2025 discussion of formative assessment and feedback explains why information about learning must lead to useful instructional decisions. The U.S. Institute of Education Sciences’ mathematics problem-solving guide encourages monitoring and reflection rather than relying on answers alone. Neither report is a specification of Canvas, and neither proves that a particular gradebook policy is fair; they supply a wider reason for interpreting assessment evidence carefully.
Within the eduKate library, why a class average can hide individual decline examines aggregation across pupils, while this page owns the denominator of one learner’s grade. Why a blank answer is not the same as a wrong answer addresses classroom diagnosis, not markbook eligibility. The Secondary 1 Mathematics tutorial explainer gives a practical perspective on checking the underlying method rather than merely reacting to a result. Read each only when that different question is genuinely yours.
Final thought: ask what the percentage counted
A markbook is a way to summarize evidence under declared rules. It is not a window directly into a child’s intelligence, effort or future. Before treating a surprising grade as praise, punishment or proof of a technology fault, reconstruct its denominator, identify which assignments are scored or excluded, and check the school’s policy. That single habit makes the number more intelligible and makes the next conversation more useful. The meaningful outcome is not merely a corrected percentage; it is a student, parent and teacher who can agree what the record says and what learning should happen next.