How to figure GPA
First decide on a grading scale. I have two examples on this web page. Alter the numeric grade ranges to match the grade scale that you use.
Two Grading Scale Examples- Simple
A=94-100; B=86-93; C=77-85; D=70-76; F=below 70
A=90-100; B=80-89; C=70-79; D=60-69; F=below 60
Two Grading Scale Examples- Detailed and Shows Quality Points
Grade Scale 90/80/70/60
| Grading Scale (weight) | |||||
| Letter Grade | Numeric Grade | 1 Credit Quality Points |
0.75 Credit Quality Points |
0.5 Credit Quality Points: |
0.25 Credit Quality Points: |
A |
93-100 |
4.00 |
3.00 |
2.00 |
1.00 |
Grade Scale 94/86/77/70
| Grading Scale (weight) | |||||
| Letter Grade | Numeric Grade | 1 Credit Quality Points |
0.75 Credit Quality Points |
0.5 Credit Quality Points: |
0.25 Credit Quality Points: |
A |
96-100 |
4.00 |
3.00 |
2.00 |
1.00 |
Sample Transcript Entry
| Course Title | 1st Semester | 2nd Semester | Final | Cumulative | |||||
| Grade | Credit | Grade | Credit | Grade | Credit | QP | GPA | Credits | |
|
Geography Algebra English Science Art PE Health |
B C A B A A B |
0.50 0.50 0.50 0.50 0.50 0.25 0.25 |
A B A B A A B |
0.50 0.50 0.50 0.50 0.50 0.25 0.25 |
B+ B A B A A B |
1 1 1 1 1 0.5 0.5 |
3.33 3.00 4.00 3.00 4.00 2.00 2.00 |
(21.33
total QP points divided by 6 credits)
3.5 |
6 |
The Grade and Credit Determine the GPA
For example, Geography will earn 1 credit. The student's final grade is B+. Using the grading scale above, the quality points (QP) for a 1 credit course that earned a grade of B+ is 3.33. PE is a 0.5 credit course. A grade of A earned for a 0.5 credit course gives a GPA of 2.00.
At the end of the year, total the grades and find the quality points for each grade/credit. Add the QP and divide the sum with the number of credits earned.
In the example above, the green column shows the QP's that were earned for each course. The QP's are added and they total 21.33. To get the cumulative GPA, divide the total (21.33 in the example) by the number of credits that were earned (6 in the example). This yields a GPA (grade point average) of 3.5.
XLS GPA Calculator
The GPA Calculator requires a spreadsheet program. The file has the two grade scales shown above on this web page. The grade scales can be altered.
In the calculator (image left) enter subjects, grades, and credits. The calculator will return the GPA, QP, letter grades, and total credits.



On This Page







