Basic FunctionsIntermediate

Weigh a GPA by credit hours instead of by course count

AVERAGE treats every course the same regardless of size — SUMPRODUCT paired with SUM lets a 4-credit lecture course count four times as much as a 1-credit lab.

Task:

You handle transcript calculations in a university registrar's office. A student's fall semester grades are in front of you, and each course carries a different number of credit hours — a 1-credit lab should not pull the GPA as hard as a 4-credit lecture course. Work out the credit-weighted GPA in C6.

Interactive Spreadsheet

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

6 rows × 3 columns1 cell you fill in
ABC
1CourseCredit HoursGrade Points
2Calculus I43.7
3Intro to Psychology34
4Chemistry Lab13.3
5World History33
6Weighted GPA
What this exercise teachesMay contain the answer

SUMPRODUCT(B2:B5,C2:C5) pairs each course's credit hours with its grade points, multiplying and adding in one step, which gives the total quality points the student earned — 14.8 for Calculus, 12 for Psychology, 3.3 for the lab and 9 for History, totaling 39.1. Dividing by SUM(B2:B5), the 11 total credit hours, converts that back into a per-credit figure: 3.5545. A plain AVERAGE of the four grade points would give 3.5, quietly treating the 1-credit lab as if it counted as much as the 4-credit lecture course and understating how much Calculus and Psychology's higher-credit grades should pull the number up.