Exporting NAPLAN Data

New Schools: How many years of data should you export?

The Explorer and Ledger combines results for current & previous years to show longitudinal progress for students and the school as a whole. This is why we need a few years of NAPLAN reporting to build that view.

As a rule of thumb, we need as many years of history as the school wishes to see in growth. As a minimum we suggest 4 years for a primary school or high school, and 7 years for a K-12. However, we can import data as far back as 2013.

Exporting your data

The Literatu NAPLAN importer relies on exports downloaded from your state/system NAPLAN reporting application. Unfortunately, we can not give you exact instructions for each reporting system as we don't have access to them. However, we do have samples of the file formats we expect in the NAPLAN Import routine.

Your school would have been sent these in your on-boarding Data email as well. Please contact support [ at ] literatu.com if you need another copy of the email.

As a general rule:

• Please do not edit the exported file contents at all (e.g. adding columns, grouping, totals etc). We rely on completely un-edited data.

• Please do not change the filenames, with the exception of prefixing or suffixing to show the domain and year level, if needed (e.g. GP7, SP7 etc).

• Please ensure you export the data for all tested year levels, domains and calendar test years.

Victorian Schools

As of 2021, Victorian NAPLAN data is split across the VCAA NAPLAN data service (outcome and question level data) and the ACARA SSSR extract. The fragmented nature of the data means that you will need to import data from both sources.

From the VCAA data service, please export the student outcome level and student question level data. Additionally, please export each domain and year level from the ACARA SSSR reporting suite.

Exporting data from ACARA SSSR

1. Open the ACARA report suite and navigate to the School Item Report tab.

2. Choose the first Domain and Year Level you will export.

3. Click export. Leave all of the boxes in the popup checked and click Export as CSV.

4. When the file downloads to your computer, add a prefix to the filename it so you can track what you have exported. Otherwise leave the filename as is E.g:

Save SSSR Extract - BEST SCHOOL - SYDNEY CAMPUS (12345) - 2022-08-02.csv as

GP7-SSSR Extract - BEST SCHOOL - SYDNEY CAMPUS (12345) - 2022-08-02.csv … and so on.

5. Choose the next domain for that cohort and continue exporting until all 5 domains are exported. Then, export the data for the next year level.