HOw do you create a program in excel that will give the GPA, upon entering a letter grade?

Answer 1

Put this formula in cell B1:

=if(a1="A", 4, if(a1="B", 3, if(a1="C", 2, if(a1="D", 1, 0))))

Copy it down one row for each course you have.

Under the last one, enter this formula: (Assuming you have 6 courses and you are in cell b7)

=sum(b1:b6)/6

(if you had 8 courses and were in cell b9 the "6"s would be "8"s)

Enter your letter grades (in CAPS) in column A.

:-)

Answer 2

Take the user input of the grade, convert each letter to a number. Say, A is 8, B is 7, C 6, D 5, E 4, F 3, G 2, U 1... Store it in an "int grades [10];" array or something. To average them, add the contents of that array, then divide it by the number of grades, and round it to an integer. The average grade is the letter corresponding to this integer ;)

Answer 3

You have to use "IF" function and "logical" expression. Like you will write "A" in column A1. Then, click on column B1 and go to functions. Got to logical and insert IF block. You have to choose "if A1 = A, then B1=4.0". Similarly, you have to add more logical expression in there such that if grade is not "A", it will check for "A-" and put GPA 3.75 or whatever etc. Excel has help file on such.

I just explained the logic behind it. but There is good news. There are templates and help sources available too. Just for you!

http://www.tarleton.edu/~edulab/PD1/PD1_assignments/teacher/Excel/excel_makeit.htm

http://www.themathlab.com/homework/algebrahomework/GPAstart.htm

there are more. Just do google search with "letter grade to GPA, excel".

Those actaully solve your problem.