## 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

2. open the file
4. in the while cells, enter subjects, credits, and scores (grades)
5. 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.

The GPA depends on three things-

2. The letter grade earned for each class
3. 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.

 QP Table - Standard 4.0 Scale Grade Scale Letter Grade 1 CreditQuality Points 0.75 CreditQuality Points 0.5 Credit Quality Points 0.25 Credit Quality Points 90-100 80-89.9 70-79.9 60-69.9 Below 60 A B C D F 4.00 3.00 2.00 1.00 0.00 3.00 2.25 1.50 0.75 0.00 2.00 1.50 1.00 0.50 0.00 1.00 0.75 0.50 0.25 0.00

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

A detailed QP table that includes +/- letter grades
 QP Table - Standard 4.0 Scale Grade Scale Ltr Gr 1CreditQuality Points 0.75CreditQuality Points 0.5Credit Quality Points 0.25Credit Quality Points 94-100 91.3-93.9 88.7-91.2 86-88.6 83.3-85.9 80.7-83.2 78-80.6 75.3-77.9 72.7-75.2 70-72.6 67.3-69.9 Below 67.3 A A- B+ B B- C+ C C- D+ D D- F 4.00 3.67 3.33 3.00 2.67 2.33 2.00 1.67 1.33 1.00 0.67 0.00 3.00 2.75 2.50 2.25 2.00 1.75 1.50 1.25 1.00 0.75 0.50 0.00 2.00 1.84 1.67 1.50 1.34 1.17 1.00 0.84 0.67 0.50 0.34 0.00 1.00 0.92 0.83 0.75 0.67 0.58 0.50 0.42 0.33 0.25 0.17 0.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:

2. Add the QP (quality points)
3. Divide the QP total by the credits total
4. The answer will be the GPA.
Edited by Donna Young, April 18, 2013
 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.

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