KS4 Ready Reckoner

[safcgac]

Hi

 

I have downloaded the 2018 KS4 Ready Reckoner spreadsheet from the DFE website that lets you enter KS2 fine scores to get the point score. Does anyone know of a bulk tool that will do this? At the moment we have to enter each student score one by one to get the point scores.

 

Any help is much appreciated.

 

GC

[Cache]

If you use SIMS, they provide a KS2 calculator however last year there were various rounding errors in it that meant it wasn't 100% accurate and Capita wern't that interested in correcting it.

 

I think last year I built a very simple spreadsheet that calculated it and made some manual adjustments for missing grades/absentee's based on the information in the Accountability Measures guidance. If you look on the ready reconer and unhide the tabs you'll be able to get the lookup values that make the calculations which you'll be able to adapt into a spreadsheet to do a vlookup and then add the 2 values together and divide by 2.