Obtaining a 2.1 result in your degree is a typical prerequisite for many offers in the milkround. This calculator allows you to estimate your result from each module and then transfer this into an overall result.
Firstly enter the number of modules you are studying and it will generate the appropriate number of input cells. Then enter the module name, credit and score and let excel work its magic.
Note: My lack of experience with other colleges’ grading scores (e.g. GPA) is the reason for their absence but I hope to include one down the line for this and other grading systems.
Nerd Corner
The calculator itself is a relatively simple excel spreadsheet (it can be downloaded clicking on the excel logo at the bottom of the calculator) using the following core functions;
- the “key” table are all inputs and never change;
- the “no. of modules” cell drives drives conditional formatting rules to colour in a certain number of rows (matching the number of modules) to highlgiht to the user the number of things to input; and
- the weighted average score is then caluclated using a SUMPRODUCT formula and finally we can find the appropriate result, given our score, from the “key” table using the INDEX & MATCH forumlae.