DOWNLOADS ARE AVAILABLE AT THE BOTTOM OF THIS ARTICLE INCLUDING TEMPLATES FOR ISSUE TO SCHOOLS AND SAMPLE GUIDANCE FOR SCHOOLS
Nexus 'Predicted Outcomes' functionality was intended to allow LA and their schools to process predicted outcomes for pupils at EYFS, Phonics, KS1 or KS2 at any point of the year prior to the actual statutory assessment. This allows the school and/or LA to use Nexus reporting functionality to look at the outcomes that would be achieved.
In 2020 and 2021 - due to Covid-19 - the functionality was used to import actual outcomes however this was not the intention of the functionality. You may find reference in some documentation to 2020 & 2021 collections that reflect this difference in status.
Before you begin with the Primary Outcome import you will need to determine how you plan to collect data from your schools, there are 2 options.
Option 1 - Excel (CSV) Import
You can use the spreadsheet that we have attached to the bottom of this article, and you can collect all primary data using this method.
Here are some quick facts about working with this excel spreadsheet.
- If you copy data into the spreadsheet from another source it will remove the validation, increasing the risk of errors when you import into Nexus
- Right click to hide any worksheets you don't want to share with your schools, do not delete worksheets from the spreadsheet.
- If you see the below dialogue in excel, always click end or you will be taken into the macro editing screen.
Let's take a look at each of the sheets in the excel spreadsheet.
You might want to hide this sheet before sharing it with your schools, to do this right click on the sheet and click hide.
The outcomes on this sheet correspond to outcomes that you school will be allowed to enter on the key stage sheets.
You can find a list of these values with some more information here.
You may wish to limit the number of outcomes your schools choose from, you can therefore choose to delete outcomes.
Let's say you don't want to give your school the option of entering HGH and WTS for KS2 reading and maths. Follow the steps in the video below. At the final step - when deleting a value - ensure that you don't leave blanks or accidentally delete the whole row (affecting other assessment results)
Information & Instructions
You'll need to ensure that all spreadsheets returned have a valid school name, 3 digit LA number and 4 digit school number.
Once you have populated the key stage sheets you wish to import into Nexus and the above details are populated, click to export.
EYF, EYF2, PHO, KS1 & KS2
You can hide any sheets you do not want to collect data for but do not delete the sheets as this will affect the CSV creation.
EYF2 is for those using the new EYFSP framework which is statutory from 2021/22. The spreadsheet attached below also includes a hidden sheet named 'EYF' which was for the 'old' framework. That sheet should not be used but can be safely left hidden.
A CSV file will be exported for each of the key stage sheets that has data in cell A2.
The files will be exported to the same folder on your computer as the excel spreadsheet has been saved. For this reason you should ensure that you select a location and save the sheet rather than simply run it from an email (in which case the files would be saved in a temp system folder and be hard to locate)
There is validation on all columns other than forename and surname, here is how they are validated.
UPN - this must be 13 characters long.
DOB - this must be a valid date format of dd/mm/yyyy.
Gender - this is validated based on the values in the reference tab.
NC_Year - this is validated based on the values in the reference tab.
Outcomes - all other columns are outcomes and are validated based on values in the reference tab for that assessment.
Option 2 - XML (CTF) Import (EYFSP only)
If your schools have completed the assessment in their MIS, you can choose to import those CTFs into Nexus.
Here are some facts about the CTF import.
- We won't be validating the file name so it doesn't matter how the CTF is exported from the school MIS.
- We will validate the header inside the file so the year, Local Authority Number and academic year fields in the SourceSchool section must match the importing LA and chosen year.
As with other Nexus assessment imports, you'll be able to view the Primary Outcomes you import via a Keypas grid. In this case it appears in the 'Predicted Outcomes' section of Keypas Grids.
There will only be pupil level grids in Keypas, if you want to view aggregated information then use Insight Tables.
Imported outcomes will be matched with both Census Information and the Pupil Premium Import when available. LA should therefore ensure that the both of these files (Spring census) are imported into Nexus.
While you will be able to update outcomes on the grid, you won't be able to update census information.
Below are the files available for download to support this exercise, including the collection spreadsheet (Nexus Predicted Outcome Import.xls). The Sample Guidance for schools is offered as the start point for LA in documenting for their schools. This document must be customised and localised for your decisions on how to run this process with your schools.
The CLA version of Sample Guidance for schools should only be provided to schools attended by a CLA pupil from your LA who is at a primary statutory assessment point. Again, this document must be customised and localised for your decisions on how to run this process with schools both inside and outside the LA which may be very different to your all pupil collections (if offered)