GPA Calculator

Assist students with the GPA Calculator so that they can determine what grades they need in their classes to achieve their target GPA. (This form was developed in Microsoft Excel. If your computer does not have Excel, you will not be able to open this file.)

Instructions for using form

Use these instructions to assist students with calculating their GPAs.

1. Open the GPA Calculator in Excel. The file is set up so that the student can enter information into three sets of formulas.
2. To begin, click cell E6 and enter the student's target cumulative GPA. The numerical value will appear in the cell.
3. Click cell E8 and enter the number of hours the student has attempted at JMU. The numerical value will appear in the cell.
4. Click cell E10 and enter the number of hours remaining toward the student's degree. The numerical value will appear in the cell.
5. Click cell E12 and enter the number of quality points the student has earned. (This information is available on the student's unofficial transcripts on e-campus.) The numerical value appears in the cell.
6. Retrieve the minimum GPA the student will need to earn during his or her remaining academic hours from cell E15. This value adjusts as you and the student enter new information into the preceeding cells.
7. Repeat steps 1-6 with the other two sets of formulas to compile other GPA values.

Notice that the GPA Calculator also lists the GPA scores that result in academic suspensions based on the total hours attempted. Please make students aware of these GPA scores.