You are a student in the American diploma, or the parent of one, and you want to know where your GPA stands: each year from 9 to 12, what it becomes once Honors and AP courses are counted, and what you need next term to reach your target. The free American diploma GPA calculator answers those questions from one record you type: the courses. The template and its page are in Arabic.
The problem it solves
Calculating GPA looks simple until the details arrive: a full-credit course next to a half-credit one, letter grades that become points, and Honors and AP courses that in some schools get an addition. You end up with a calculator and numbers you rewrite whenever a grade changes. A number per year plus a cumulative one doubles the work, and since the conversion table differs between schools, you cannot be sure your figure matches your school's.
How it works, step by step
- Open Settings and review the table that turns letter grades into points and the Honors and AP additions. The values written there are examples, so replace them with your school's table.
- In Courses write each course as one row: year (9 to 12), name, credit, type (regular, Honors or AP) and letter grade. The type and grade come from lists fed by Settings.
- Leave the grade empty for a course in progress; it stays out of the calculation and shows "no grade".
- The sheet writes each row's points and status, and colors a faulty row red.
- Open Summary to see unweighted and weighted GPA for each year and cumulative.
- At the bottom of the summary, type a target weighted GPA and the credit you plan to take, and the sheet shows the average points needed.
What each sheet does
- Settings: the student's name, the letter-grade table (A+ to F), the course-type table with its additions, and the point level above which the addition applies. Each table is titled "editable to match your school".
- Courses: the main record, with each row's unweighted points, addition, weighted points, quality (credit times points) and status.
- Summary: years 9 to 12 and the cumulative line with courses, credit, both GPAs and the number of Honors and AP courses, then courses in progress and errors, then the target calculator.
Why it matters
GPA is a number worth watching as it moves, before the year ends rather than after. The gap between weighted and unweighted shows why your figure differs from a friend who chose other courses. The method is visible: every point comes from the Settings table and every figure traces back to the course row that produced it.
Because conversion tables and additions differ between schools, we did not present a table as a general rule. The two tables in Settings are examples that you edit yourself.
A quick walk-through with the sample sheet
The numbers below come from the sample sheet, not from real statistics. It holds 22 courses: 18 with a grade, three in year 12 without one yet, and a fourth graded P. Year 9 shows an unweighted GPA of 3.64 and a weighted one of 3.73, because it has a Biology course of type Honors with a B+. Year 10 shows 3.27 and 3.45, and year 11 shows 3.09 and 3.64 with two AP and two Honors courses. The cumulative result is 3.33 unweighted and 3.61 weighted over 16.5 credits.
In year 12 the three ungraded courses show "no grade", and the course graded P, which is not in the table, shows "grade not found" in red. For the target calculator we typed a weighted target of 3.8 and six planned credits. It shows a needed average of 4.33 weighted points, above a regular course's 4.0 in the example, so it is possible on paper only with Honors or AP courses.
The online version
The same calculator works online: it opens on the ready example, you change any cell and see the result at once, add a course from a form, and import or export an .xlsx file. Your data stays in your browser. Try it from the template page.
Who it suits
- A student in the American diploma who wants to follow GPA each term.
- A parent who wants to understand a child's number.
- An adviser preparing first figures with a student.
The sheet is a calculation tool that relies on the table you enter, not an official reference. The number your school uses is the one in its records, and its rounding may differ. For tracking marks inside one subject there is the student grades sheet, and for revision the study planner.