GPA Tracker: Each Class's Running Grade All Semester

GPA Tracker: Watch Each Class's Running Grade During the Semester

GPA tracker guide: find each class's running grade from weighted items, see what the final has to score, then estimate your semester GPA.

By · Editorial policy

Published · 9 min read

GPA Tracker: Watch Each Class's Running Grade During the Semester

It's week 9. Three classes have posted scores, and the portal shows a letter you don't quite trust. Ultimate Student Planner is a Google Sheets and Excel planner by Cosmo Suite (ultimatestudentplanner.site). It's a student planner spreadsheet that holds each class's grades beside its due dates, and the method here works in any sheet.

Your semester GPA isn't set until the term ends. Until then each class is half done: a few scores, a midterm, and a final that hasn't happened yet.

The short answer is to work out each class's running grade from the items already graded, then turn those into a semester GPA estimate. The running grade is the number you can still change.

The Short List

  • A semester GPA is set when the term ends. A class's running grade exists as soon as the first item is graded.
  • Running grade = points earned so far ÷ weight graded so far. Leave ungraded items out.
  • Then use your school's scale and credits once, for a semester GPA estimate.
  • It's an estimate. Your instructor's gradebook and your registrar decide.

What a GPA Tracker Should Show Beyond One Number

A GPA tracker should show where each class stands while the semester is still running, not only one number at the end. Running grade is the percent you're earning on the part of a class that has been marked so far. Tools vary in how much of that they cover. Some tools sold as calculators also follow class grades and the score a final needs, so check what yours asks you to enter.

Other tools are plainer. UF's academic advising office offers one: its GPA calculator takes each course's grade and credits and returns a GPA. That fits once letters exist. In week 9 you may only have items, and turning weighted items into a letter is a step you take first.

This guide writes the arithmetic out, so you can inspect every step in any spreadsheet. First comes a running grade from weighted items, then a semester estimate that follows your school's own policy. If you already have final grades, this walkthrough of the credit-weighted GPA formula covers that step.

GPA Tracker, Class by Class

Give each class its own row with its credits and its running grade, then add the letter from your school's scale. Here's one semester of four fictional classes, each shown by its running grade, not a final one. The scale is an example, not any school's: an A is 90 and up (4.0), a B is 80 to 89 (3.0).

Class Credits Running grade Letter on the example scale Grade points × credits
Statistics 3 80.0 B (3.0) 9
Psychology 3 91 A (4.0) 12
Spanish 4 86 B (3.0) 12
Writing 2 95 A (4.0) 8

That's 12 credits and 41 quality points, and 41 ÷ 12 is 3.4167, so the estimate is 3.42. Quality points are a course's grade points multiplied by its credits, and the next sections use them again.

Look at Statistics. An 80.0 is the lowest B on this scale, so a final even a few points under 80 drops the letter. No score on the final can lift it to an A, as the next section shows.

A semester list with four classes, each in its own colour, shown as an illustrated planner page

How to Work Out a Running Grade From Weighted Items

Divide the points you've earned by the share of the grade that has been marked so far. For the Statistics class, that gives 80.0. The weights below come from an imagined syllabus, and every number is made up.

Item Weight Score so far
Homework 20% 90
Quizzes 20% 80
Midterm 25% 72
Final exam 35% not graded yet
  1. Copy the weights from the syllabus. Check that they add to 100.
  2. Multiply each graded score by its weight. 0.20 × 90 + 0.20 × 80 + 0.25 × 72 = 18 + 16 + 18 = 52 points.
  3. Add up the weight that's been graded. 20 + 20 + 25 = 65%.
  4. Divide. 52 ÷ 0.65 = 80.0. That's the running grade.
  5. Leave the final out. Entering it as 0 would leave you at 52, which isn't where the class stands.

Two official pages show the same idea. Virginia Tech's neuroscience department calculates a current grade from points earned over points possible, using the weights on the syllabus. Virginia Commonwealth University works out a weighted midterm grade by dividing the weighted percentages by the weight completed so far.

Open weight is the share of the final grade that hasn't been marked yet. Here 65% is graded and 35% is open, and the running grade is how you're doing on the marked part. It also works as a projection: if the open part scores like the marked part, Statistics ends at 80.0.

A horizontal bar split into a larger graded part and a smaller empty part still open for the final

The same numbers tell you what the final has to do. This is your own arithmetic from the syllabus weights, not something a file works out for you. Subtract your points from the grade you want, then divide by the final's weight:

  • To finish at 85: (85 − 52) ÷ 0.35 = 33 ÷ 0.35 = 94.3 on the final.
  • To finish at 80: (80 − 52) ÷ 0.35 = 28 ÷ 0.35 = 80.0 on the final.
  • To finish at 90: (90 − 52) ÷ 0.35 = 38 ÷ 0.35 = 108.6, which is out of reach.

Run it the other way and you get the whole range. Every point on the final moves the class by 0.35, so a 100 ends at 87.0, a 90 at 83.5, an 80 at 80.0 and a 70 at 76.5. With no extra credit, 87.0 is the ceiling, so Statistics can keep its B or slip to a C but can't reach an A.

Treat the result as a range, because extra credit and drop-the-lowest rules change the math. Your syllabus sets the rule.

From Running Grades to a Semester GPA

Turn each running grade into a letter and grade points on your school's scale, multiply by credits, and divide by total credits. That's the whole step, and the table above did it: 41 ÷ 12 = 3.42.

The scale there is made up, and schools publish their own. The University of Maryland registrar separates semester GPA from cumulative GPA, gives the quality points for each grade, and divides quality points by attempted credits. It leaves out marks such as I, P, S, W and NGR. UC Berkeley's registrar lists its own grade points and doesn't count marks such as P, NP, S and U.

So use your own school's scale, and take the percent cut-off for each letter from your syllabus. A GPA built on running grades is a moving estimate, and the transcript has the final say.

How the Ultimate Student Planner Handles This

We make the Ultimate Student Planner, so weigh this section accordingly. It has a Grades tab for this. In the planner's own words: "For each class, list the graded items with their weights and the grade you got. They add up to a running grade for the class, and the semester GPA uses the grading scale you set in Start Here."

It's a Google Sheets and Excel planner with a Grades tab that keeps a running grade for each class, among 9 connected tabs. It comes as a Google Sheets file and an Excel file, each as a sample copy with a filled-in semester and a clean copy. It holds up to 10 classes, with a colour per class, and the Assignments tab also has a grade weight field. A new semester starts from the clean copy.

It's built around a college semester, works for high school classes too, and doesn't sync with school portals. The "what do I need on the final" math and the choice to leave ungraded items out are steps you take yourself. You type in the scores, and the tab does the adding.

Where to Spend Your Next Study Hour

A letter in a 4-credit class moves the GPA twice as far as one in a 2-credit class. Here is the same fictional semester, one letter at a time.

Class Credits Running grade If it drops one letter If it rises one letter
Statistics 3 80.0 3.17 out of reach (needs 108.6)
Psychology 3 91 3.17 already an A
Spanish 4 86 3.08 3.75
Writing 2 95 3.25 already an A

One letter on the example scale means A (4.0) to B (3.0), or B (3.0) to C (2.0), and the starting estimate is 3.42. Each figure is the semester GPA after that one change: for Spanish, (41 − 4) ÷ 12 = 3.08.

Three rules fall out of it:

  1. Protect the class on an edge. Statistics and Psychology each cost 0.25 if the letter slips, and Psychology sits only 1 point above the A line. A class with little open weight can't move much either way.
  2. Push where the swing is biggest. Spanish has the most credits and is 4 points from an A. If 35% were still open, it would need 97.4 on the rest, and with half the grade open, 94.0 would do. Those open shares are hypothetical, so use your own.
  3. Let go of an out-of-reach target. If the answer tops 100, move the hour to a class where the target can be met.

What to Check Each Time You Add a Grade

Five quick checks keep a running grade honest:

  1. The weights add to 100, or you know why they don't.
  2. An ungraded item is left out of both totals, not entered as 0.
  3. Your school's scale is in use, not the example's.
  4. Drop-lowest or extra-credit rules are applied the way the syllabus says.
  5. "Running" means an estimate, and the instructor's gradebook decides.

Forgot to enter a few scores? Add the missing items with their weights and read the running grade again. Do the check before finals week, while the open weight is still large. A finals plan that starts three weeks out pairs well with it. For the rest of the term, this student planner spreadsheet guide shows where grades fit beside classes and due dates.

A single class card with a row of small checkmarks beside a coloured bar, an illustration of a checklist for each new grade

Calculation methodology: every class, credit count, weight and score in this guide is fictional, made up to show the arithmetic, and none comes from a real student, school or syllabus. Each running grade is the sum of score × weight for the graded items, divided by the graded weight. The semester estimate is quality points divided by credits, rounded to two decimals. The sources back the method and say nothing about these numbers. Our editorial policy says how posts are written and checked. Read about the team behind this site, and if a number looks wrong, contact us with a correction.

Sources checked 17 Nov 2026: University of Maryland Registrar (GPA Calculation), UC Berkeley Registrar (Grade Definitions), UF Academic Advising (GPA Calculator), Virginia Tech Neuroscience (Calculating GPA), Virginia Commonwealth University (How to Calculate Midterm and Final Grades).

Frequently asked questions

Does a GPA tracker work for high school?

Yes. The running-grade method works for any class that weights homework, quizzes and tests. The GPA step is different, because high schools set their own scales and some add points for honors courses. Use your school handbook for that part. The planner is built around a college semester and works for high school classes too.

How do I track my GPA during the semester?

Track each class first, then combine them. For every class, list the graded items with their syllabus weights and work out the running grade. Then convert each running grade to grade points on your school's scale, multiply by credits, and divide by total credits. Redo it whenever a new score arrives.

How is a GPA tracker different from a GPA calculator?

It depends on the tool, because the labels overlap. A basic calculator takes a letter grade and credits for each course and returns one GPA. A tracker follows each class while items are still being graded. Some tools do both, so check what yours asks you to enter.

Should an ungraded assignment count as zero?

No. A zero says you earned nothing on work that hasn't been marked. Leave it out of the points and out of the weight total, then add it when the score arrives. Only count a zero if your instructor has actually recorded one.

What do I need on the final to reach a certain grade?

Subtract the points you've earned from the grade you want, then divide by the final's weight. In the example, a final worth 35% needs 94.3 for an 85 and 80.0 for an 80. A final above 80 keeps the B, and if the answer tops 100, that target is out of reach.

Is a running grade my official grade?

No. It's your own estimate from the scores you've entered. Your instructor's gradebook decides the class grade, and your registrar decides the transcript. Drop-lowest rules, extra credit and rounding can all move the official number, so check the syllabus before you rely on it.

Can the planner pull my grades from the school portal?

No. You type each graded item and its weight into the Grades tab yourself. There's no sync or import from school portals or school websites, and no reminders. You enter the scores, then the Grades tab calculates the running grades.

Sources

  1. University of Maryland Registrar, GPA Calculation
  2. UC Berkeley Registrar, Grade Definitions
  3. UF Academic Advising, GPA Calculator
  4. Virginia Tech Neuroscience, Calculating GPA
  5. Virginia Commonwealth University, How to Calculate Midterm and Final Grades

Ultimate Student Planner

Ready for the Ultimate Student Planner?

Your classes, assignments and due dates in one file. Google Sheets + Excel, your own file, pay once.

Get instant access
Ultimate Student Planner