OCR Nationals - Unit 1 New Spec, Spreadsheet AO5
I have followed the OCR “Unit one” guidance for developing a Spreadsheet for A05,
However, the visiting moderator stated that the Spreadsheet was not “a suitable business Spreadsheet” because the student had used an average function to calculate the average cost of the trip and the MAX and MIN function to show the cheapest and most expensive costs of the trip, this was viewed as “unsuitable as it was not a 15 page Spreadsheet that needed a summary on the first sheet and the student was just showing off their knowledge of functions”.
Therefore the moderator felt that the business Spreadsheet was not appropriate and award the “students produces an appropriate business Spreadsheet” at a Pass. However, all the other criteria for P, M, and D were met and agreed. So the overall grading for AO5 was P, M, D, D, D, D and I awarded this as a Distinction.
I was told this was not correct and the whole AO5 was barley a pass because the Spreadsheet was “not appropriate”.
I am now confused as to how the marking criteria is applied, are some elements weighted more than others?