Analysis FAQs


See all (13)

How do I export NAPLAN data from Scout (NSW Independent) for import into Analysis

UPDATED: January 2020

1. Access Scout
2. Click login for NSW Independent Schools (AIS)
3. Select NAPLAN (AIS)
4. Scroll across to NAPLAN Results
5. Select Cohort Assessment Year
6. Select the Bands tab (bottom left of screen)
7. Untick all options in both sidebars
8. Click on the Menu icon (...) top right of results table
9. Select Export data
10. Select ‘Summarized Data’
11. Select File format: '.csv'
12. Click 'Export' to download.


To verify that you have downloaded the valid format, please ensure the output of your CSV contains the following headers:

School Name, Assessment Year, Assessment, Student Name, Domain, Participation Type, Scaled Score, Proficiency Level

12. Navigate to the Analysis module in Sentral

13. Go to Setup Analysis (top right)

14. Select 'Import'

15. Select 'Test Type: National Assessment Program - Literacy and Numeracy (NSW Scout)'

16. Drag-and-drop your exported .csv file onto the screen and wait for the upload to complete

17. Click the green 'Upload Test Data' button (top right)

18. Navigate to Imported Files screen to monitor progress of the data being matched and imported into the Analysis module.


For Schools who do not use SRN IDs within Sentral

Where your students are identified by an external ID provided by your admin system (eg. Maze, SAS, etc.) that do not use the SRN to identify your students, 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 process 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 the same as specified in Step 11. above.