## GPA

This page describes how to calculate grade point average and included are charts, an example, and an XLS GPS Calculator file (requires a spreadsheet program.)

## XLS GPA Calculator

The GPA Calculator requires a spreadsheet program.

The file has place for two different grade scales and both may be edited to match your grade scale.

**To use the calculator**

- download the file
- open the file
- edit the grade scale to match your grade scale
- in the while cells, enter subjects, credits, and scores (grades)
- The calculator will return the GPA, QP, letter grades, and total credits.

## How to Calculate GPA

Worksheet that may be used to calculate GPA using the 4.0 Scale. Each file is the same, only the format is different - PDF, DOC, and DOCX.

PDF- Calculate GPA | DOC- Calculate GPA | DOCX- Calculate GPA

The GPA depends on three things-

- Your grade scale (this plus the class scores will determine the letter grades)
- The letter grade earned for each class
- The credit earned for each class

Below are two quality point tables. The tables are set up for two particular grade scales and shown for an example only. With the tables you can determine the quality points to enter for each class. *Both tables are based on the standard 4.0 GPA scale.*

### Two Quality Point Tables

Below are two tables each one shows the quality points earned for each credit value and grade.

### Grade Scale 90/80/70/60

without +/- letter gradesQP Table - Standard 4.0 Scale |
|||||

Grade Scale |
Letter Grade |
1 CreditQuality Points |
0.75 CreditQuality Points |
0.5 CreditQuality Points |
0.25 CreditQuality Points |

90-100 |
A |
4.00 |
3.00 |
2.00 |
1.00 |

### Grade Scale 94/86/78/70

The next table is detailed in that it includes the +/- grades.

A detailed QP table that includes +/- letter gradesQP Table - Standard 4.0 Scale |
|||||

Grade Scale |
Letter Grade |
1 CreditQuality Points |
0.75 CreditQuality Points |
0.5 CreditQuality Points |
0.25 CreditQuality Points |

94-100 |
A |
4.00 |
3.00 |
2.00 |
1.00 |

### Sample Transcript Entry

Below is a sample transcript entry. The green part is the part of interest; it is the part that contains the information that allows one to compute GPA.

The Steps:

- Add the credits
- Add the QP (quality points)
- Divide the QP total by the credits total
- The answer will be the GPA.

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 letter 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. The letter grade of A earned for a 0.5 credit course gives a
GPA of 2.00.

At the end of the year add the credits earned. Find the quality points (QP) 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.

### Some Grade Scales

Grade scales vary and below are three examples. Notice the score range of the letter grade D; it is in the 60's in two of the grades scales and in the 70's in one of the grade scales.

A: 94-100 B: 86-93 C: 78-85 D: 70-77 F: 0-69

A: 90-100 B: 80-89 C: 70-79 D: 60-69 F: 0-59

A: 93-100 B: 82-92 C: 71-81 D: 60-70 F: 0-59