

 Thread Tools  Search this Thread 
#1
 
 
How to calculate GPA in Excel worksheet
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)? 
#2
 
 
Re: How to calculate GPA in Excel worksheet
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. 
#3
 
 
Re: How to calculate GPA in Excel worksheet
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) 
#4
 
 
Re: How to calculate GPA in Excel worksheet
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 

Tags: calculate, excel, gpa 
Thread Tools  Search this Thread 

Similar Threads for: "How to calculate GPA in Excel worksheet"  
Thread  Thread Starter  Forum  Replies  Last Post 
How to fullscreen Excel Worksheet  Calverta  MS Office Support  5  27012012 07:12 PM 
Clicking on Worksheet on multiple Worksheets in the single Excel file not allow viewing the worksheet in Microsoft Excel 2010  Dipanwita  Windows Software  8  04122011 11:24 AM 
Outlook reminders with excel worksheet  Avinash Kaur  Windows Software  5  17032011 12:40 AM 
Excel opens but not the worksheet!  Rob Dizzle  Windows Software  5  12012010 04:21 PM 
How to Add Combo Box to a Worksheet of Excel?  Pratim  Windows Software  5  06012010 06:07 PM 