Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to calculate GPA in Excel worksheet

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-06-2009
Member
 
Join Date: Feb 2008
Posts: 1,337
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)?

Reply With Quote
  #2  
Old 06-06-2009
Member
 
Join Date: Sep 2005
Posts: 1,306
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.
Reply With Quote
  #3  
Old 06-06-2009
Member
 
Join Date: May 2008
Posts: 979
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)
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.
Reply With Quote
  #4  
Old 06-06-2009
Member
 
Join Date: May 2008
Posts: 4,829
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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 27-01-2012 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 04-12-2011 11:24 AM
Outlook reminders with excel worksheet Avinash Kaur Windows Software 5 17-03-2011 12:40 AM
Excel opens but not the worksheet! Rob Dizzle Windows Software 5 12-01-2010 04:21 PM
How to Add Combo Box to a Worksheet of Excel? Pratim Windows Software 5 06-01-2010 06:07 PM


All times are GMT +5.5. The time now is 12:15 AM.