If the thread title seems a little opaque, things should be clearer after i explain.
First, let me say that i’m no Excel expert. I barely ever use it. But one thing i do use it for is to make a spreadsheet of my students’ grades. I have the students’ names in one column, then i assign a column for each assignment, and a final column that takes all the assignments and calculates a final grade.
I grade using the letter system (A, B, C, etc.), and when i put the students’ grades into the spreadsheet i do it using the GPA equivalent. So, if the student got an A, i put in 4; if they got a B, i put in 3, etc.
What i was wondering is if there’s a way to assign each letter a numerical value, so i can just input the letter and have Excel automatically assign a numerical value to it for calculation purposes.
My idea is that there would be somewhere i could type something like…
Let A = 4
Let A- = 3.7
Let B+ = 3.3, etc., etc.
…and have the program use that guide when assigning values to letter grades.
Is this even possible, or do i have to stick with inputting numbers?