Exporting DfE assessment results via CTF to send to the National Curriculum Assessments Portal or the LA

Once all of the End of Key Stage or Early Years Foundation Stage Profile results have been entered, you can export the results via CTF to send to your LA or to the DfE.

Permissions

You will need the General Admin: Export Data or Student Profile: Admin: Administer All Students permission. If you don't have permission, you'll need to ask your admin team to give you permission using these instructions.

Exporting Assessment Result CTFs

You can use Arbor to export statutory assessment results via a CTF. Please note: it is not possible to export school assessments (like summative or curriculum assessments) via CTF - more on this here.

You can go to one of two places to export your results:

• Students > Assessments > DfE Assessments > Export Results
• School > Data > Export > Assessment Results

From those pages, follow these steps to generate your CTF:

• Click +Add in the Current Assessment Results CTF Exports section 
• Update the slide over with the data you want to export using the drop-downs:
   
  • Export Type - Choose which test you want to export results for. It is important to note that each CTF is titled Partial CTF because these files only contain the assessment results and are therefore not as detailed as a full student CTF.
  • Destination - Here you need to choose whether the CTF will be sent to either the Local Authority or the Testing Agency.
  • Year Group - Leave this blank if you want all the students who took the test to be included. If you want to, for example, export your Year 1 and Year 2 Phonics Screening Check data separately, you would select Year 1 in this field.
  • Include only students enrolled on - This section automatically defaults to today's date; however, you might have a student who has unenrolled since the test was done. Make sure that the date reflects the enrolment date that includes all students who sat the test.
  • Only export the most recent assessment results - If you check this box, Arbor will only export the assessment results with the most recent dates. If it is unchecked, we will export all results for the given export type, for all year groups. 
    
    Leave this unticked. Ticking this is known to leave the CTF stuck on 'Processing', and it overrides the Year Group filter. You will only see this academic year's DfE assessments anyway, so this checkbox is redundant. To separate Year 1 and Year 2 phonics, leave this unticked and use the Year Group filter instead.
     
• When happy with the settings, click the green Export button.

The CTF will then show as processing. You'll receive a notification in the left-hand menu of Arbor when this is ready to download.

If you refresh your page, the CTF will also show as Ready for download in the Current Assessment Results CTF Exports section. 

• Click where it says Ready for download.

• Scroll down to the bottom of the slide over and click Download.

You can locate your file once you have downloaded it by right-clicking the download at the bottom of your page. Do not open the file. In Windows, select the 'View in folder' option.

You'll then need to submit the file.

Which pupils will be included?

You should leave the Year Group field blank to include everyone with a result this academic year on the export.

If you want to export results for a certain cohort, e.g. split exports for Y1 and Y2 Phonics, you will need to select the relevant year group in the Year Group field and ensure you leave the Only export the most recent assessment results box unticked.