School
Exactly what do you need on the final?
You know your homework and midterm; you know the weights. So there is one exact score on the final that gets you the grade you want. Goal Seek runs the formula backwards and hands it to you.
Get this in Google Sheets →The model
Your course grade is a weighted average of homework, midterm, and the final. Goal Seek finds the final score that makes the course grade hit your target.
| Homework average | 90 |
| Midterm score | 88 |
| Weights (HW / Mid / Final) | 30% / 30% / 40% |
| Target course grade | 90 (an A) |
| Final you need | → solved |
What Sortia tells you
Solving the grade formula backwards:
For an A (90)91.5 on the final
For a B (80)66.5 on the final
On track for87 (a B)
Solveexact
You need a 91.5 on the final for an A, or just a 66.5 to lock the B. No more anxious guessing — you know the exact number to aim for. Change the target or your scores and it re-solves instantly. (Its Monte Carlo sibling, What Grade Will You Get?, shows the odds you actually hit it.)
Try it in your own sheet
- Open Sortia in Google Sheets and choose Start from a template.
- Pick What Do You Need on the Final? — the model loads with the inputs filled in.
- Change the assumptions to fit your situation and press Run.