Skip to content

How to export NAPLAN data and Import into Analysis - NSW Independent schools

UPDATED: August 2024

Overview

Use the following steps to export 2024 NAPLAN data from Scout and import into Sentral Analysis.

Prerequisites

Access to Scout.

NSW Independent school.

Administration level access to Analysis Setup.

Instructions

To export Naplan data from Scout:

  1. Choose Student Class and reports.

  2. Select Class report and then Student results table.

  3. Choose your school from the School list.

  4. Select the Assessment year of 2024 from the list.

  5. Choose All in the Domains list.

  6. Select the More options icon and choose Export Data.

  7. Select Summarized Data.

  8. Select CSV as the file format.

  9. Select Export to download.

Use this NSW Department of education link to view report explanations, videos and supporting resources for NAPLAN Scout reports.


The valid output of the CSV export requires the following headers.

  • Student name - SRN

  • Assessment

  • Domain

  • Participation type

  • Scaled score

  • School name

  • Proficiency level


To Import the NAPLAN data into Sentral Analysis:

  1. From Sentral Dashboard, under Insights select Analysis.

  2. Select Setup and then Analysis Setup.

  3. Select Import.

  4. From the test type select National Assessment Program – Literacy and Numeracy (NSW Scout).

  5. Select the Calendar Year of 2024.

  6. In Drop files here or click to upload space, drag, and drop the exported CSV file.

  7. When the upload is complete, select Upload Test data (top right).

  8. Navigate to Imported Files (Left menu) and locate the NAPLAN import.

  9. Select Set options and choose the School year.

  10. Select the Link icon to confirm the students are matched.

  11. For students with the No Student Match Found in the Matched Student column, click on the No Student Match Found link then search for the student name and select.

  12. Select Import for Matched Students.

     

Use the following information if you school is not using SRN IDs within Sentral.

Where your students are identified by an external ID provided by your admin system (e.g. Maze, SAS, etc.), for automated student-matching following import, you can do the following.

  1. Export your Admin System's External IDs for students into a CSV/spreadsheet format.

  2. Download the NAPLAN data from Scout using the steps above.

  3. Open the NAPLAN data export file in Excel or Google Sheets.

  4. Using the VLOOKUP function, replace the SRN column data with the admin system external IDs.

  5. Save.

  6. Upload the modified NAPLAN data file into Analysis, ensuring that the ordering of the columns (from left-to-right) are as specified above.

Additional information

Visit NSW Department of Education website for information on Naplan Scout reports.

Resources: To help you navigate Sentral, watch video tutorials or view step by step guides

 

Feedback and Knowledge Base