"I love your textbook! I think we'll be using it for our BSN informatics course!!
On another note - I'm pulling my hair out on making a GPA spreadsheet like we used at ___! I'm going gray over this. Could you help me out please? I'll be eternally grateful. :-)"
What she is asking is how to create formulas in Excel to calculate a GPA. Although the formulas may initially look intimidating, they are fairly straightforward. The formulas use If/Then statements. The formulas are based upon the A, B, C, D, F grading scale, where A is worth 4, B is worth 3, C is worth 2, D is worth 1, and F is worth 0 quality points.
My answer is noted below. I will also attach a spreadsheet with the formulas. Note that the formulas below are nested meaning that each one includes several arguments, that is, one for each grade.
A | B | C | D | E | F | |
1 | Course | Name | Credits | Grade | Quality PTs | QP/Credits |
2 | ENG | College Composition I | 3 |
=IF(D2="A",C2,IF(D2="B",C2,IF(D2="C",C2,IF(D2="D",C2,IF(D2="F",C2," ")))))
The formula above in Cell E2 is for quality points. What it says is that if D2 (Grade) is "A", E2 (Quality Points) is the same value as C2 (Credits) - same for "B", "C", "D", and "F".
=IF(D2="A",4*E2,IF(D2="B",3*E2,IF(D2="C",2*E2,IF(D2="D",1*E2,IF(D2="F","0","")))))
The formula above in Cell F2 is if D2 (Grade) is "A", multiply 4 times E2 (Quality Points), - same for "B", "C", "D", and "F" except "B" = 3, "C" = 2, "D" = 1, and "F" =0.
The letter grades are in parenthesis to tell Excel that the letter is a text field.
To download a copy of the spreadsheet, go to http://hercules.gcsu.edu/jsewell/textbook/GPA_spreadsheet.xls
