How to average letters and numbers.

Hi

 

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?

 

Thanks

 

Gary 

By: Gary Newton

Leave a Reply

Your email address will not be published. Required fields are marked *