First Release Version
69.20, 68.48
Contents
| Table of Contents |
|---|
Background (2019)
The changes to NAPLAN submission for 2019 introduced by the NSW Educations Standards Authority (NESA) have resulted in two submission file templates that NESA require different sets of schools to use, one each for:
- schools at which students do NAPLAN with Pen and Paper; and
- schools at which students do NAPLAN Online
Synergetic was advised by NESA that intermediary bodies, such as Diocese may issue their own versions.
For 2019, Synergetic has supplied the ‘Pen and Paper’ version only in our export logic.
Synergetic has been told by the ACT Education Directorate that ACT schools use the NSW templates, so this section is for NSW and ACT schools
Versions
The 2019 NAPLAN file version is available in V.68 and V.69.
Opening the NAPLAN tab
The file continues to be produced in the standard manner:
To open the NAPLAN tab:
...
Field
...
Description
...
School Code
...
Code used to identify the school in Australia.
...
Year Level From / To
...
Range of year levels to export.
...
Process Date
...
Date when the tests were held. The month of May was chosen as the most appropriate time for the national tests. It is early enough in the year for the test results to be used as a diagnostic tool.
...
Gender
...
Gender of students to export. You can select either:
- all
- males only
- females only.
...
File Name
...
Name and location of exported file.
...
Progress
...
Progress of the import.
Buttons
...
Button
...
Description
...
...
Select the file location.
...
...
...
NAPLAN NSW and ACT File Format - 2019
The following table is the template provide by NESA (NSW Education Standards Authority) transposed so columns are rows.
The template is here: NAPLAN_Online_2019_Student_Registration_AIS_Template.xlsx
...
Recommended 2019 Submission Process for Schools
Due to the variety of template formats that exist in 2019 in NSW and ACT, schools may need to manually manipulate the data extracted from Synergetic to conform with the template they must comply with.
To determine your course of action in filling in your particular version of the template, please generate the 2019 Synergetic NAPLAN export file at your school and compare its output to your NESA template form. Use the above table to assist you in this process.
If the file output as generated from Synergetic does not match your particular required spreadsheet template, we recommend the following approach:
Confirm whether your NAPLAN template is based on the ‘Pen and Paper’ Variant or ‘Online’ file variant.
- Populate the template according to your identified file variant:
Note: Please ensure you read the column heading descriptions in your file, to ensure you are populating values appropriately.
For ‘Pen and Paper’:
Create the Synergetic file, open this in Excel and Copy/Paste individual columns from the Synergetic output into the template you have been supplied, and manually enter any extra columns which were not able to be generated by Synergetic.
- Make sure to not copy over any formulas embedded in the spreadsheet.
- Make sure that you paste the Synergetic data into the correct destination column
- Do not copy any un-needed columns
For ‘Online’
Follow the initial column copy steps as per ‘Pen and Paper’ where relevant.
For any columns that were not able to be populated by Synergetic, you will need to populate these manually within the spreadsheet template, using appropriate values for your school and student records. Some columns may have built in lookups and formulas to help you select the appropriate values.This page information is now redundant.
See: