School
What grade will you get — and what do you need on the final?
Homework and the midterm are locked in; the final is the unknown. This template runs the final as a range through your weighted grade, so you see the spread of grades you might land — and exactly what you need on the final to reach the next letter.
Get this in Google Sheets →The model
Your course grade is a weighted average of homework, midterm, and the final. The final score is the uncertain input.
| Homework average | 90 |
| Midterm score | 88 |
| Final exam score | 68 – 85 – 98 (uncertain) |
| Weights (HW / Mid / Final) | 30% / 30% / 40% |
| Course grade | → simulated |
What Sortia tells you
Course grade across the range of possible finals:
Most likely87
Range P5–P9583–91
Locked-in B100%
Shot at an A11%
P5 · 83median · 87P95 · 91
You are a lock for a B — every scenario clears 80. An A (90+) needs about a 91 on the final, which happens in roughly 1 in 9 of your likely outcomes. Instead of anxiously guessing, you now know the exact target to aim for. Swap in your own scores and weights — a teacher can run a whole roster the same way.
Try it in your own sheet
- Open Sortia in Google Sheets and choose Start from a template.
- Pick What Grade Will You Get? — the model loads with the inputs filled in.
- Change the assumptions to fit your situation and press Run.