Remember Me?

#1
January 19th 06, 01:57 PM posted to microsoft.public.excel.misc
 Chris Cred via OfficeKB.com Posts: n/a
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")

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)

------------------------------------------------------------------------------
--

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

------------------------------------------------------------------------------
--
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.)

------------------------------------------------------------------------------
--
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.)

------------------------------------------------------------------------------
--
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

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

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

#2
January 19th 06, 01:59 PM posted to microsoft.public.excel.misc
 Chris Cred via OfficeKB.com Posts: n/a
Can this adjusted GPA formual be accomplised?

for some reason a large portion of my post went under the signature. Just
expand the signature to read the remaining post.

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Bonnie Excel Discussion (Misc queries) 1 October 25th 05 12:55 AM Jan Excel Worksheet Functions 2 June 16th 05 11:30 PM Boydster Excel Discussion (Misc queries) 1 May 19th 05 05:59 PM Fast Eddie Excel Worksheet Functions 3 March 14th 05 01:11 AM elizabeth Excel Discussion (Misc queries) 1 January 12th 05 07:15 PM

All times are GMT +1. The time now is 06:51 AM.