View Single Post
  #1   Report Post  
Old January 19th 06, 01:57 PM posted to microsoft.public.excel.misc
Chris Cred via OfficeKB.com
 
Posts: n/a
Default Can this adjusted GPA formual be accomplised?

I'm trying to write a formula that will calculate an adjusted GPA for college.
I've tried tons of different senarios and still cannot figure it out. I'll
post instructions on how to actually calculate the grade on paper so if
anyone wants to take a crack at it please do.

The poblem I'm having is that when you adjust a GPA you must only use the
quality points and credit hours from the newest grade if greater than the
first grade and not count the first quality points and hours.

Here the instructions...

(with first grade of "D" and the repeat grade being a "B")

Sue made these grades during her first term at KSU:

MATH 1101 = A 3 hours (x) 4 quality points (for A) = 12
POLS 1101 = D 3 hours (x) 1 quality point (for F) = 3

Total Hours = 6 Total quality points = 15

Use the formula: Quality points divided by hours attempted = GPA
15 divided by 6 = 2.50 GPA for the Term
(quality points) (hours attempted) (term grade point average)


------------------------------------------------------------------------------
--
Sue made these grades during her next term at KSU:

ENGL 1101 = C 3 hours (x) 2 quality points (for C) = 6
POLS 1101 = B 3 hours (x) 3 quality point (for B) = 9

Total Hours = 6 Total quality points = 15

Use the formula: Quality points divided by hours attempted = GPA
15 divided by 6 = 2.50 GPA for the Term
(quality points) (hours attempted) (term grade point average)


------------------------------------------------------------------------------
--
First, determine the Cumulative GPA:
Add quality points from both terms
15 + 15 = 30

------------------------------------------------------------------------------
--
Add hours from both terms
6 + 6 = 12

Use the formula: Total quality points divided by hours attempted = GPA
30 divided by 12 = 2.50
(total quality points) (total hours) (Cumulative GPA)

(Note: Both POLS 1101 classes are used in this calculation.)


------------------------------------------------------------------------------
--
Next, recalculate for your Adjusted GPA:
Add quality points from both terms
12 + 15 = 27

(Note: when you add your quality points for both terms, only count the
quality points for the POLS 1101 "B" grade. Do not include the quality points
for the other POLS 1101 "D" grade.)

------------------------------------------------------------------------------
--
Add hours from both terms
3 + 6 = 9


(Note: when you add your hours for both terms, only count the hours for POLS
1101 with the "B" grade as 3 hours. Do not include the 3 hours from the other
POLS 1101 "D" grade.)

Use the formula: Total quality points divided by hours attempted = GPA
27 divided by 9 = 3.00
(total quality points) (total hours) (Adjusted GPA)

(Note: Only one POLS 1101 class was used in this calculation - the one with
the higher grade of "B".)

--
Message posted via http://www.officekb.com