Advertisement

Mark to Grade Spreadsheet

If you have the results of a test or exam and you have the grade boundaries you can use the VLOOKUP function in Excel to automatically attribute a grade to each student. This spreadsheet is all setup and working - so use it as an example or add your own data and off you go.

You need to Login or register to download the file shown below. Registration is free and only takes a second.
AttachmentSize
Marks To Grades Spreadsheet.xls21 KB