Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

First Release Version

69.20, 68.48

...

Contents

Table of Contents

Background (2019)

...

Import/Export Student Data -  tab key fields and buttons

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

Image Modified

Select the file location.

Image Modified

Create the file

Image Modified

Cancel and Exit


NAPLAN NSW and ACT File Format - 2019

...

The template is here:     NAPLAN_Online_2019_Student_Registration_AIS_Template.xlsx


ColumnMandatory (?)Description
School NameMandatory fieldSchool name

Max length = 255 characters
ASL School IDMandatory fieldACARA Australian Schools List school identifier

Max length = 10 characters
Student Registration Number (SRN)Optional fieldThis number is allocated by DoE

If SRN is known please populate this field, otherwise leave blank.

Max length = 9 characters
Local Student ID (School)Mandatory fieldThe student id assigned by and used by local school administrative system.

Max length = 36 characters
Family NameMandatory fieldFamily Name / Surname

Max length = 40 characters
Middle nameOptional fieldMiddle name

Max length = 40 characters
Given nameMandatory fieldGiven name / first name

Max length = 40 characters
Year levelMandatory field3,5,7,9
SexMandatory field1 = Male
2 = Female
3 = Intersex or indeterminate
9 = Not Stated/Inadequately Described
Date of BirthMandatory fielddd/mm/yyyy

Max length = 10 characters
Country of birthMandatory field4 digit code

See "1269.0 Countries" Worksheet

0003 = Not Stated
0004 = Unknown
0005 = Unidentified
Indigenous statusMandatory field1 - Aboriginal but not Torres Strait Islander Origin
2 - Torres Strait Islander but not Aboriginal Origin
3 - Both Aboriginal and Torres Strait Islander Origin
4 - Neither Aboriginal nor Torres Strait Islander Origin
9 - Not Stated/Unknown
Student Main Language Other than English Spoken at HomeMandatory field4 digit code

See "1267.0 Languages" Worksheet

0000 = Inadequately Described
0001 = Non Verbal, so described
0002 = Not Stated
Parent 1 School Education
The highest level of school education completed by Parent 1.
Mandatory field1 - Year 9 or equivalent or below
2 - Year 10 or equivalent
3 - Year 11 or equivalent
4 - Year 12 or equivalent
0 - Not stated/Unknown
Parent 1 Non-school Education
This reflects the level of Parent 1's Non-School Education.
Mandatory field5 - Certificate I to IV (including trade certificate)
6 - Advanced diploma/Diploma
7 - Bachelor degree or above
8 - No non-school qualification
0 - Not stated/Unknown
Parent 1 Occupation
Code that defines employment type of Parent 1
Mandatory field1 - Senior management in large business organization, government administration and defence, and qualified professionals
2 - Other business managers, arts/media/sportspersons and associate professionals
3 - Tradesmen/women, clerks and skilled office, sales and service staff
4 - Machine operators, hospitality staff, assistants, labourers and related workers
8 - Not in paid work in last 12 months
9 - Not stated/Unknown
Parent 1 Main language spoken by Parent 1 at home, other than English.Mandatory field4 digit code

See "1267.0 Languages" Worksheet

0000 = Inadequately Described
0001 = Non Verbal, so described
0002 = Not Stated
Parent 2 School Education
The highest level of school education completed by Parent 2
Optional field1 - Year 9 or equivalent or below
2 - Year 10 or equivalent
3 - Year 11 or equivalent
4 - Year 12 or equivalent
0 - Not stated/Unknown
Parent 2 Non-school Education
This reflects the level of Parent 2's Non-School Education.
Optional field5 - Certificate I to IV (including trade certificate)
6 - Advanced diploma/Diploma
7 - Bachelor degree or above
8 - No non-school qualification
0 - Not stated/Unknown
Parent 2 Occupation
Code that defines employment type of Parent 2
Optional field1 - Senior management in large business organization, government administration and defence, and qualified professionals
2 - Other business managers, arts/media/sportspersons and associate professionals
3 - Tradesmen/women, clerks and skilled office, sales and service staff
4 - Machine operators, hospitality staff, assistants, labourers and related workers
8 - Not in paid work in last 12 months
9 - Not stated/Unknown
Parent 2 Main language spoken by Parent 2 at home, other than English.Optional field4 digit code

See "1267.0 Languages" Worksheet

0000 = Inadequately Described
0001 = Non Verbal, so described
0002 = Not Stated
Enrolled Full-fee Paying Overseas Student (FFPOS) StatusMandatory field1 = FFPOS
2 = Non-FFPOS
9 = Not Stated/Unknown
Class GroupOptional fieldMax length: 255


Recommended 2019 Submission Process for Schools 

...