School report calculator
Model a school report with several subjects across one to four grading periods.
- Export
Choose a common grading scale and one to four periods. Enter subject weights and period averages; an empty cell means a missing grade.
Average:
Was this tool useful?
How does this tool work?
When simulating a school report, you often have subject averages for each term or semester rather than every assignment grade. This tool brings those averages together across one to four periods, applies subject weights and shows their effect on the overall result. It helps compare scenarios on a common grading scale without claiming to reproduce every school, exam or admission rule.
The calculation has two stages. Within each subject, filled-in periods are averaged with equal weight. Subject averages are then weighted by their coefficients to obtain the overall average. A weight of 2 gives a subject average twice the influence of a weight of 1; it does not double the grade itself.
Each period average is calculated separately from the subjects filled in for that period and their weights. If all grades are present, this method and averaging the period results give the same overall value. Missing grades change the denominators: the simple average of period results can then differ from the overall average used here.
A blank cell means a missing grade, not zero. A subject with no grades has no weight in the overall result. All grades must lie between zero and the selected maximum, and weights must be strictly positive. The tool accepts up to twenty subjects, a maximum grade of 1,000 and weights up to 1,000.
Reducing the period count hides the last columns and excludes them from calculations and CSV without deleting their inputs. They reappear if you increase the count again. The draft stays only in this browser. On a shared device, use Reset when finished; download the CSV to keep an independent copy.
How to use this tool
Set up the report
Choose the maximum grade and number of periods. Add or remove subjects to match your report.
Enter averages and weights
Name each subject and enter its positive weight and period averages. Enter 0 for a zero grade and leave missing grades blank.
Compare and export
Review subject, period and overall averages. Adjust a scenario or download the table as CSV.
From period averages to the overall average
Stage one: each subject
Mᵢ = sum of entered grades / number of filled-in periods
Pᵢ contains only the filled-in periods for subject i. A zero grade belongs to this set; a blank cell does not.
Stage two: the overall average
G = Σ(cᵢ × Mᵢ) / Σ(cᵢ)
I contains subjects with at least one grade. Weight cᵢ applies to subject average Mᵢ, without rounding intermediate results.
Use cases
Compare scenarios
Change a subject average to see how it affects the overall report average.
Find influential subjects
Compare coefficients before assuming that gaining one point has the same effect everywhere.
Plan grading periods
Collect term or semester averages without mixing individual assignments with period averages.
Examples
Two complete subjects across two periods
The overall average is (14 × 2 + 12 × 1) / 3 = 40/3. Both periods are complete, so averaging their results gives the same value when using unrounded figures rather than the displayed decimals.
Input
Maximum grade: 20; periods: 2
Subject A: weight 2; grades 12 and 16
Subject B: weight 1; grades 10 and 14Result
Subject A average: 14
Subject B average: 12
Period 1: 11.333
Period 2: 15.333
Overall average: 13.333A missing grade and an actual zero
Only 12 is filled in for Mathematics. In English, zero counts alongside 18, giving 9. The overall average is (12 × 2 + 9 × 1) / 3 = 11. Averaging the two period results would give (8 + 18) / 2 = 13, which uses a different weighting.
Input
Maximum grade: 20; periods: 2
Mathematics: weight 2; grades 12 and blank
English: weight 1; grades 0 and 18Result
Mathematics: 12
English: 9
Period 1: 8
Period 2: 18
Overall average: 11Measure the effect of a subject weight
Subject averages remain 14 and 12. With both weights equal to 2, the overall average becomes (14 × 2 + 12 × 2) / 4 = 13. Increasing the influence of the weaker subject lowers the average here without changing any grade.
Input
Maximum grade: 20; periods: 2
Subject A: weight 2; grades 12 and 16
Subject B: weight 1; grades 10 and 14
Then change B’s weight from 1 to 2Result
Initial overall average: 13.333
After the change: 13Tips and best practices
- Convert grades to one common scale before entering them. Directly mixing grades out of 20 and out of 100 produces a meaningless average.
- Weights apply to subjects. To combine assignments within one subject or find the next grade needed, use the weighted grade average calculator.
- The display shows at most three decimal places; calculations and CSV retain unrounded values. Do not reconstruct a precise result solely from displayed figures.
Sources and references
- Weighted Mean (opens in a new tab), Wolfram MathWorldPage in English
Frequently asked questions
Why can the overall result differ from the average of periods?
Missing grades can change which subjects contribute to each period. This calculator averages each subject first, then applies its coefficient. These are different weighting methods when coverage is incomplete.
Does an empty cell count as zero?
No. It is excluded from the average. Enter 0 explicitly when a zero grade should contribute.
Are these assignment weights?
No. Coefficients weight subjects in the overall average. Aggregate assignments into each period grade first.
How are results rounded?
The display uses at most three decimal places. Further calculations and CSV exports retain unrounded values; your school may follow a different rule.
Are my grades saved?
Yes, only in this browser, so they survive a page reload. Nothing is sent to a server. The Reset button deletes this draft.
Related tools
Keep going with these tools
Tools similar or complementary to this one.
Similar tools
Calculate a weighted average and the next grade needed to reach your target.
Education & examsFeaturedUse this tool
Turn a number of correct answers into a percentage score and count your mistakes, for a multiple-choice test, quiz or exam.
Education & examsNewUse this tool
Calculate a credit-weighted GPA from the grade points of each course, on a 4.0 scale or another scale.
Education & examsNewUse this tool
Read next
GuideBest practicesBeginner
Weighted grade averages: marks, weights and target grades
Calculate a weighted average, distinguish assessment and subject weights, find the mark you need next and work out attendance separately.
25 October 20264 min