Assigning Numeric Values to Letter Grades (& vice versa)
Posted by Gloria Tidwell on April 26, 2001 1:40 PM
I am a college English instructor who's been called on to submit my course grades in spreadsheet form.
For ease of data entry, I would like to be able to enter the letter grades from my gradebook, and have the spreadsheet do the assignment of the numeric value so that the grades can be averaged and then the final grade converted to a letter.
First, I need to know how to do that process.
Secondly, the numeric values change from cell to cell. For instance, an "A" letter grade for a simple essay may be worth 25 points, while an "A" for a more complex work may be worth 75 points. Is there a way to distinguish these on a column by column basis?
Thank you for the help.