I am trying to create a spreadsheet that will work ot the average grades for a students test score. Students are graded with a level, followed by a subgrade i.e. 4a, 5c, 6b etc. The possible grades that a student can achieve range from 3c (the lowest) to 8a (the highest). Each level 3 – 8 each has a subgrade a, b and c. Is it possible to do this?
By: Gary Newton