Skip to main content
JuniperLogo

KS3/4: Preparing KS2 Fine Levels for 2020 and earlier cohorts (Admin)

  • Updated

If you are setting up a historical KS4 cohort which has been awarded KS2 NC Fine Levels, this article can be used to help prepare these for uploading into Analytics. 

Find Students' Fine Point Scores

First, open the relevant spreadsheet below based on the cohort you’re working with.

Please note, the spreadsheets above were created by a third party outside of Sisra (via Herts Learning Grid) and therefore we cannot guarantee their accuracy.

 

After opening the spreadsheet, click the REVIEW tab > Unprotect Sheet, then enter the password 'herts'.

mceclip0.png

Then, enter your students’ details, including their raw KS2 test marks in the appropriate subject columns. For example, in our screenshot we’re using 19/20 Leavers as an example. As these students were reported on for English Reading and Maths, we have added these marks to these columns. This will then calculate your students’ fine point scores for these subjects.

mceclip1.png

Note - If there are any students awarded a level 6, you would need to replace this with their
mark/level from their level 3-5 KS2 test instead, as per DfE guidance

 

Convert Fine Point Scores to Fine Levels

Once you have calculated the fine point scores, you can convert these to fine levels and round these to the appropriate number of decimal places. To do this, highlight the student IDs, student names, and fine point scores for the appropriate subjects, right click and select ‘Copy’. In a new Excel spreadsheet, right click and select ‘Paste as Values’.

Next, create an extra column for each core subject (e.g. Reading and Maths). Then, enter the formula shown below, where ‘CELL’ refers to the cell reference of where the associated level appears:

mceclip8.png

=ROUND(CELL/6,5)

This will divide the score by six to calculate the fine level, then round this to five decimal places.

mceclip7.png

The formula can then be dragged across to the Maths column, and dragged down for each student to calculate their fine levels in both subjects. Then, highlight the new columns and paste these as values to the right. This will remove the formula and allow you to run the data through the add-in, so it can be uploaded into Analytics. 

mceclip11.png

You would need to upload individual levels for Reading and Maths, rather than an
average, as Analytics will calculate the average based on your ‘Core’ selections.

Next, run your file through the Excel Add-In using the ‘Prepare from Broadsheet’ option, ensuring to select the appropriate fine level columns. For example, from the above screenshot we would select row 1 as the row with the qualification title, column H as the first qualification, and column I as the last qualification.

For more information on preparing data using the Excel Add-In, see the following article: KS3/4 - Preparing & Uploading KS2 Core Baselines (Admin)

This should format your file into a 4 column
list, which you can save as a CSV (MS DOS) file, ready to upload into Analytics.		 mceclip6.png

You're now ready to upload and set up KS2 Baselines, explained in the article linked above.

Thanks for reading!

Related articles