Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a students grade & credit hours to current GPA
Can someone please help me figure out on excel how to figure this? I have
students letter grade, credit hours for each class, on our grading scale to calculate the GPA. Thanks. Terri Strickland |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a students grade & credit hours to current GPA
You can convert the letters to number using match =MATCH(F1,{"F","D","C","B","A"},0)-1 Do you have grades using A+ and A- Then use lookup =MATCH(F1,{"F","D","C-","C","C+","B-","B","B+","A-","A","A+";0,.5,1,1.5,1.5,2.0,2.5,2.5,3.0,3.5,3.5, 4.0,4.5})-1 -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149564 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Grade 40 Students relitively On a Normal Distribution. | Excel Worksheet Functions | |||
How to grade 40 students relatively on a normal distribution? | Excel Worksheet Functions | |||
400 students to grade, so little time... | Excel Discussion (Misc queries) | |||
students grades, formulae to calculate what grade is needed based. | Excel Worksheet Functions | |||
I am trying to set a letter grade for my students, HELP | Excel Worksheet Functions |