How to calculate GPA in Excel worksheet

**Lambard** · 06-06-2009

I have a small database of students maintained in Excel. I want to calculate their Grade Point Average. But this is very time consuming for 1500+ students. Is there any possibility to achieve this with either some simple formula or some calculator available for calculating the Grade Point Average (GPA)?

**kattman** · 06-06-2009

I don't know how to calculate GPA in Excel but here is an online calculator: http://www.usu.edu/advising/gpa/File...or%20Excel.htm. You just need to enter data in the white boxes. The calculator which will do the operations and give you the result. The best part is that you can even print this result.

**Gunilla** · 06-06-2009

You can calculate the GPA in Excel and it is quiet simple. The formula for this is:

Code:

=SUM(Grade*Credit_Hrs)/SUM(Credit_Hrs)

This formula will automatically calculate the grade point average and give you the result. This formula is very helpful if you have a larger number of records (which is what in your case) and have less time or want to achieve it very faster.

**Macarenas** · 06-06-2009

The basic idea for calculating the grade point is: (Grade in Class) x (Credits in class)

Now, to calculate the grade point average, add all your grade points and then divide this value by the number of credits you took.

For example, if the Class A is having 4 credits and got 5.5 grade, then the grade point is 4 x 5.5 = 22. If the Class B is having 6 credits and got 3 grade, then the grade point is 6 x 3 = 18. Now the GPA would be (18+22)/(4+6)=4