How do I export NAPLAN data from Scout (NSW Independent) for import into Analysis
UPDATED: January 2020
1. Access
Scout2. Click login for
NSW Independent Schools (AIS)3. Select
NAPLAN (AIS) 4. Scroll across to
NAPLAN Results5. 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.