🎓 A grade tracker with weighted averages

Set up the table

A: Category      B: Weight   C: Your score (%)
Homework         0.20        92
Quizzes          0.15        85
Midterm          0.25        78
Lab              0.15        95
Final exam       0.25        (empty)

Weights come from the syllabus and should add up to 1 (100%).

Weighted average

=SUMPRODUCT(B2:B5, C2:C5) / SUM(B2:B5)

SUMPRODUCT multiplies each weight by each score and adds them. Dividing by the weights so far gives your current grade: (18.4 + 12.75 + 19.5 + 14.25) / 0.75 ≈ 86.5%.

What do I need on the final?

Target grade in F1: 90
=(F1 - SUMPRODUCT(B2:B5, C2:C5)) / B6

Here: (90 − 64.9) / 0.25 ≈ 100.4% — a 90 is out of reach, but an 85 needs only about 80.4% on the final.

Absolute references

When you copy a formula, cell references shift. Put $ in front to lock them: $F$1 always points to F1. Press F4 in Excel (or type the $) to toggle.

Tip

💡 Check the syllabus for dropped lowest quiz or extra credit, and build those into the tracker.

🧠 Quick quiz

Answer all 4 questions correctly to mark this lesson as done.