So a nice challenge arose for a monday morning, a teacher wanted a grade level calculating as an average in order to input the data to our MIS system. Using the format of 4a, 4b and 4c for grade levels and a complete fear of excel, the job was taken on by our kind selves.
The first task was to convert alpha-numeric characters into an integer value in order to perform the calculation. After a little Googling the following link gave me exactly what I needed: http://www.ehow.com/how_5349505_use-letter-represent-value-excel.html.
Great! After demonstrating our new found use for Excel, it wasn't quite what was required as it wasn't an integer value that was needed for the average grade but a level (like 4a etc). So now it's time to convert 4a from equalling 5 back to equalling 4a. However this can't be done with the same vlookup function that kindly got us this far. We now need to use the Index and Match functions (explained excellently on this link http://www.mrexcel.com/articles/excel-vlookup-index-match.php so I shaln't reinvent the wheel!)
A little more working on the Spreadsheet and we have what we want, getting an average grade from an alpha-numeric value. Google I salute you!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment