Results 1 to 4 of 4

Thread: How to calculate GPA in Excel worksheet

  1. #1
    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)?

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

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

  4. #4
    Join Date
    May 2008
    Posts
    4,834

    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

Similar Threads

  1. How to fullscreen Excel Worksheet
    By Calverta in forum MS Office Support
    Replies: 5
    Last Post: 27-01-2012, 06:12 PM
  2. Replies: 8
    Last Post: 04-12-2011, 10:24 AM
  3. Outlook reminders with excel worksheet
    By Avinash Kaur in forum Windows Software
    Replies: 5
    Last Post: 16-03-2011, 11:40 PM
  4. Excel opens but not the worksheet!
    By Rob Dizzle in forum Windows Software
    Replies: 5
    Last Post: 12-01-2010, 03:21 PM
  5. How to Add Combo Box to a Worksheet of Excel?
    By Pratim in forum Windows Software
    Replies: 5
    Last Post: 06-01-2010, 05:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •