College GPA Calculator | 4.0 Cumulative & Semester GPA
Calculate your semester GPA, cumulative college GPA, and quality points on the standard 4.0 grading scale. Add courses dynamically, assign credit hour weights, and calculate what term GPA you need to secure your target cumulative GPA.
To calculate your GPA, multiply each course's grade points ($g_i$) by its credit hours ($c_i$) to determine quality points, sum all quality points together, and divide by the sum of attempted credits: GPA = Σ(Grade Points × Credits) / Σ(Credits).
| Course Name | Grade | Credits |
|---|
What is a Grade Point Average? (Mathematical Definition)
Unlike a simple arithmetic mean—where every class contributes equally regardless of duration or difficulty—a college Grade Point Average (GPA) is a credit-weighted mean that reflects course volume through credit hours (Carnegie Units).
The formal mathematical formula for Grade Point Average is expressed as:
Where $g_i$ represents the numerical grade points earned in a specific course (such as 4.0 for an A, 3.0 for a B), and $c_i$ represents the course credit hours. The product of $g_i \times c_i$ produces Quality Points. Summing all quality points and dividing by total attempted credits yields your official weighted GPA.
Where College GPAs Are Used
1. Academic Honors & Dean's List Standing
Universities award term distinction based on semester GPA thresholds. Full-time undergraduate students who complete at least 12 graded credit hours with a term GPA of 3.50 or higher qualify for the Dean's List, an honor documented directly on collegiate transcripts.
2. Federal Financial Aid & Satisfactory Academic Progress (SAP)
Under U.S. Federal Regulations (34 CFR § 668.34), maintaining Title IV financial aid (including Pell Grants and Direct Federal Student Loans) requires meeting Satisfactory Academic Progress (SAP). Students must maintain a minimum 2.00 cumulative GPA (C average) and pass at least 67% of attempted credit hours. Falling below this threshold triggers Academic Warning or Probation.
3. Graduate Admissions & Latin Honors
Competitive graduate, medical, and law school programs evaluate cumulative GPA as a primary benchmark. Additionally, undergraduate commencement honors depend on lifetime cumulative standing:
- Cum Laude (With Honor): 3.50 – 3.69 GPA
- Magna Cum Laude (With Great Honor): 3.70 – 3.89 GPA
- Summa Cum Laude (With Highest Honor): 3.90 – 4.00 GPA
Simple Average vs. Weighted GPA: The "Average of Averages" Fallacy
Failing to account for credit hour weighting produces a misleading calculation. Consider a student who takes an intensive 4-credit science lecture with lab alongside a 1-credit orientation seminar:
| Course Title | Letter Grade | Grade Points | Credit Hours | Quality Points Earned |
|---|---|---|---|---|
| Biology 101 with Lab | A | 4.00 | 4.0 | 16.0 (4.0 × 4) |
| Calculus I | B+ | 3.30 | 3.0 | 9.9 (3.3 × 3) |
| English Composition | A- | 3.70 | 3.0 | 11.1 (3.7 × 3) |
| World History 202 | C | 2.00 | 3.0 | 6.0 (2.0 × 3) |
| Totals / Results | Simple Mean: 3.25 GPA | 13.0 Credits | Weighted GPA: 3.31 (43.0 / 13) | |
Notice that the simple unweighted mean (3.25) understates student performance because it under-weights the 4-credit "A" in Biology. Weighting properly yields the accurate university standard of 3.31.
Standard 4.0 College GPA Conversion Scale & Matrix
Under standard North American guidelines (endorsed by the American Association of Collegiate Registrars and Admissions Officers — AACRAO), letter grades convert to numerical quality points:
| Letter Grade | Percentage Range | 4.0 Grade Points | 3-Credit Quality Points | 4-Credit Quality Points |
|---|---|---|---|---|
| A / A+ | 93% – 100% | 4.00 | 12.0 | 16.0 |
| A- | 90% – 92% | 3.70 | 11.1 | 14.8 |
| B+ | 87% – 89% | 3.30 | 9.9 | 13.2 |
| B | 83% – 86% | 3.00 | 9.0 | 12.0 |
| B- | 80% – 82% | 2.70 | 8.1 | 10.8 |
| C+ | 77% – 79% | 2.30 | 6.9 | 9.2 |
| C | 73% – 76% | 2.00 | 6.0 | 8.0 |
| D | 65% – 69% | 1.00 | 3.0 | 4.0 |
| F | < 60% | 0.00 | 0.0 | 0.0 |
How to Calculate GPA in Excel & Google Sheets
Instead of multiplying each grade by its credit hours manually, spreadsheets provide the SUMPRODUCT function to calculate GPA in a single formula:
=SUMPRODUCT(B2:B5, C2:C5) / SUM(C2:C5)
- Range B2:B5: Contains the numerical grade points earned (e.g., 4.0, 3.3, 3.7, 3.0).
- Range C2:C5: Contains the credit hours attempted (e.g., 4, 3, 3, 3).
SUMPRODUCT(): Multiplies each course's grade points by its credit hours to calculate total Quality Points.SUM(): Adds all credit hours together and divides the quality points to produce your official weighted GPA.
Related Educational & Grade Calculators:
- Weighted Average Calculator — Compute syllabus category breakdowns (tests, homework, quizzes) and determine scores required on upcoming final exams.
- Attendance Percentage Calculator — Track mandatory minimum attendance requirements (e.g. 75% rule) to prevent administrative drops.
- Full Average Calculator Hub — Calculate arithmetic mean, median, mode, and range for grouped sample datasets.
- Percentage Calculator Tool — Compute percentage point differences, academic variance, and test curve scaling.
Frequently Asked Questions
What is considered a good college GPA?
In North American universities, a cumulative GPA of 3.00 (a "B" average) is considered good and represents the standard minimum requirement for maintaining scholarships, Greek life standing, and graduate admissions. A GPA of 3.50 or higher qualifies students for the Dean's List and competitive graduate, law, or medical programs.
Do Pass/Fail or Satisfactory/Unsatisfactory classes affect my GPA?
No. Classes completed on a Pass/Fail (or Satisfactory/Unsatisfactory) grading track award credit hours toward degree completion requirements, but they carry no quality points. Because there are no numerical grade points to weight against the credits, they are completely excluded from both semester and cumulative GPA calculations.
How do credit hours impact my GPA?
Credit hours act as mathematical multipliers called weights. An A earned in a 4-credit course provides 16.0 quality points (4.0 × 4), whereas an A earned in a 1-credit seminar provides only 4.0 quality points (4.0 × 1). Consequently, higher-credit courses exert significantly greater mathematical influence on your semester and cumulative averages.
How do I convert quarter credits to semester credits?
To convert quarter credits into semester credit hours, multiply the quarter credits by two-thirds (0.667). For instance, a 4-credit quarter course equals approximately 2.67 semester hours. Conversely, to convert semester credits to quarter credits, multiply by 1.5. Grade point values (e.g., A = 4.0, B = 3.0) remain identical between both systems.
How do repeated courses impact my GPA under grade forgiveness?
Under an institutional grade forgiveness (or course replacement) policy, the new grade replaces the prior grade in your cumulative GPA calculation, removing the earlier quality points while keeping credit hours constant. Without grade forgiveness, colleges average both course attempts into your cumulative transcript, meaning both grades factor into your overall GPA.
Is my grade data saved on a server?
No. All calculations run 100% locally inside your browser's runtime memory using JavaScript. No course grades, school names, or student data are transmitted across an HTTP network or saved in an external database.