DOWNLOADS ARE AVAILABLE AT THE BOTTOM OF THIS ARTICLE INCLUDING TEMPLATES FOR ISSUE TO SCHOOLS AND SAMPLE GUIDANCE FOR SCHOOLS
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 imported into Nexus
- Right click to hide any worksheets you don't want to share with your schools (i.e. assessments you do not wish to collect), 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. (Note: 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. The precise spelling and formatting of the school name does not matter as long as the LA number and school number are correct.
If you have limited numbers of schools participating you may opt to populate this for each school and this ensure it is correct before issuing.
The Click to Export button will be used by the school to generate the export files once they have populated the key stage sheets they wish to submit results for and you will need to import into Nexus. The export process also requires the aforementioned LA and School numbers to be correctly populated in order to format the exports correctly for import into Nexus.
(Note: Alternatively you may ask your school to send the spreadsheet back to you and you can export for them, but this guide assumes the school has exported the files themselves.)
EYF, EYF2, PHO, KS1 & KS2
You can hide any sheets you do not want to collect data for but do not delete the sheets from the workbook as this will affect the export CSV creation. (Your schools can also opt not to populate a sheet if they do not want to submit data for every assessment - this will not cause any issues)
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 unless you are going back to predicted outcomes for 2020 or 2021 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. (Be aware that if a school 'fudges' the process by using a prior year CTF export process then the resulting import would not not match the year you will try to import to)
All imports using either option are facilitated through the Keypas > Imports wizard.
As with other Nexus assessment imports, you are 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. If you have opted to offer Predicted Outcomes prior to these being available for that year then it will not be possible to match to contextual data which is a consideration in timing.
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.