Tree view is one of the older parts of Nexus and shows the datasets, imports, data cleaning reports and exports that are available once data has been imported into the system. This article covers only the navigation of the Keypas Tree View; other articles explain what to so with the data next.
Who this is for
Nexus administrators and members of school - and other - data teams involved in processing annual EYFSP and Phonics results, along with those who may need to support with other types of imports into the system.
Before you start
Keypas access requires the 'Can Access Keypas' permission in user privileges. Once access is provided, log in to Nexus and click Keypas on the main toolbar. If you don’t see this option, please speak to your administrator or refer to the Nexus Users & Permissions guide.
What Tree View is for
Most reporting in Nexus is through the Nova and Insight modules. Keypas Tree View is used for working with the data that has been imported into the system, whether you want to process and clean it, export files out to work with or investigate imported data
Navigating Tree View
To begin viewing data and reports click Tree View from the Keypas menu bar. The page below will be displayed.
The tree view page is split into two sections; the collapsible side-menu on the left of the screen with the + and - alongside each option will allow you to select which assessment stage or option you are viewing. The second section is the main body of the page, which contains the data or reports depending upon which option you choose.
You also need to use the Result Year drop-down to select the year you want to work on.
Note that it is better to first select the year and allow the screen to refresh before selecting any other options as not every option is available for every year, (leaving you to wait for the screen to refresh and then re-select your options to make a change).
Because Nexus also allows a Local Authority to import optional collections (KS1 and Multiplication Table Check) you will see options in the list that are no longer current statutory collections. It also includes options around contextual data loading (census, pupil premium, weekly attendance etc).
Use the + and - icons alongside each assessment Key Stage and side-menu option to view the specific options, the expanded assessment/contextual stage is shown below (not every option is shown for every assessment stage):
What the options offer
- Data Cleaning - Options within here allow you to run data cleaning checks on imported data through a two step process - the first to identify and the second step to fix those errors or queries
- Exports - Views data from Keypas that can be exported into either a .csv or .xls file. Some of this will be at the pupil level while other data will be aggregated to school or LA level.
- Imported Data - Allows you to view any assessment or contextual data you have imported. Importantly this is post-processing by the system. It is not the actual file that was imported, but instead what Nexus has retained and stored (and in some cases combined with other available data)
- Reports - Displays a list of available reports such as Import Logs, Audit Logs and Cohort differences. (Remember that Nova and Insight are the main reporting mechanisms for Nexus)
In addition to the assessment stage options shown above, the following items are also displayed in the same side-menu.
- Pupil Premium - Currently displays imported pupil premium data that applies across Key Stages.
- Maintenance - Displays first names / sex and ethnicity codes used within Keypas, and details of reports by Key Stage held within Keypas. You should not normally need to make any changes in this section but can be useful information if you need to extract data from the system to work with externally (in the case of ethnicities).
- CLA (SSDA903) - Displays the data for the CLA reporting (the SSDA903) broken down by Key Stage assessment (where the user has CLA permissions).
- Current CLA Cohort - Displays data imported by the LA to update the Current CLA cohort (after the SSDA903 import) (where the user has CLA permissions)
- CIN - Displays data for CIN (Children in Need) reporting
- SEN2 - Displays data for SEN2 (Special Educational Needs census) imports and exports
- Census - Displays imported school census data, broken down by the term of the census. Within each term there is an option to view the imported data or access LA or school summary data.
- Census Attendance - This option displays imported attendance data (taken from school census files) at the pupil level or LA or school summaries. This is available for the Autumn term, the Autumn and Spring term or the Full Academic Year.
- Exclusions - This option displays imported exclusions data (taken from school census files) at the pupil level or LA or school summaries. This is available for the Autumn term, the Autumn and Spring term or the Full Academic Year.
- Weekly Attendance - weekly absence data published by DfE on View Your Education Data that can be imported into Nexus by the LA
- Weekly Attendance Social Care Cohort - for LA's that import weekly attendance data, they can also create a simple file indicating which children are subject to a Child Protection Plan, CIN Status or are Children Looked After.
Upon further expanding and selecting any of the nested options, the main body of the Tree View will display the data or report. When viewing imported data in this view, the data is displayed in a tabular grid.
More detail - Imported Data
The Imported Data section has sub-options which determine the data that is displayed in the viewer. Please note, not all options are available for all Key Stages.
- Audit Log - Displays pupil records that have been modified since import – the type of change, date of change are recorded along with details of the amended field including the new and old values.
- Expected Cohort sizes - Displays the DfE Number of the Setting/School along with the expected cohort size for the assessment stage – used with the Cohort Differences report to check for possible missing pupils.
- Pupils / Requests / CIN etc (names may vary) - Displays all imported pupil assessment records including all matched data such as the school census, pupil premium and user defined fields. Names vary by dataset as - for example - children imported under a social care import are not 'pupils'
- Schools - displays a list of schools for which data has been returned (KS2 TA only)
More detail - Exported Data
Exports in the Tree View have been superseded by NOVA reporting and Insight and therefore some options below are legacy options for preceding years when those older years are selected from the Result Year dropdown
- LA - summarises assessment information at the LA level
- School - summarises information at the school level
- Pupils - pupil /child level file of data (again, names may vary by the dataset involved)
- Region - summarises results at the regional level based on the LA and DFE region of the logged in user
- National - summarises results at the national level
Last reviewed / owner
Last reviewed: July 2026 / Owner: Technical Support Director