Average a course from weighted assignments (points, percents, or letters) and see the score you still need on leftover work. The Final tab solves the grade required on a final exam to finish at a target.
Formula
A course average is the weighted mean of the scores you enter:
average = Σ (score × weight) ÷ Σ weight
All-numeric scores stay percents (one decimal) and pick a letter from the table below. Any letter in the list switches the average onto the GPA column (two decimals) and the nearest letter. Remaining-work planning uses each letter's lower percent:
needed = (goal × 100 − Σ current × weight) ÷ weight remaining
A final exam of weight c percent is the same identity solved for the unknown
exam score:
needed final = (target − current × (1 − c ÷ 100)) ÷ (c ÷ 100)
Two letter grades on the Final tab are averaged on the 4.3 GPA scale. If the exam would need more than an A+ (4.3), the result says even an A+ is not enough. Percent targets still show the numeric score, even when it is above 100.
Letter grades, GPA, and percent ranges
| Letter | GPA | Percentage |
|---|---|---|
| A+ | 4.3 | 97–100% |
| A | 4.0 | 93–96% |
| A− | 3.7 | 90–92% |
| B+ | 3.3 | 87–89% |
| B | 3.0 | 83–86% |
| B− | 2.7 | 80–82% |
| C+ | 2.3 | 77–79% |
| C | 2.0 | 73–76% |
| C− | 1.7 | 70–72% |
| D+ | 1.3 | 67–69% |
| D | 1.0 | 63–66% |
| D− | 0.7 | 60–62% |
| F | 0 | 0–59% |
Examples
Default mixed course
Homework 1 at 90 (5%), Project at B (20%), and Midterm exam at 88 (20%) include a letter, so 90 becomes A− = 3.7 and 88 becomes B+ = 3.3. The weighted GPA is (3.7×5 + 3.0×20 + 3.3×20) ÷ 45 = 3.21, nearest letter B+. Total weight is 45%.
Numeric course plus remaining work
Quiz 95 at 30% and Exam 80 at 40% average to 86.4 (B). Aiming for 90 with 30% left needs (90×100 − 95×30 − 80×40) ÷ 30 = 98.3 on the remaining tasks.
Final exam needed
Current grade 88, course target 85, final worth 40%: needed = (85 − 88 × 0.60) ÷ 0.40 = 80.5. A current 82, target 85, and 30% final needs 92.0.