ACARA Data Extract (Aus)

ACARA Data Extract (Aus) Overview

ACARA (Australian Curriculum, Assessment and Reporting Authority) is responsible for the collection of school data for publication on the My School website and the ICSEA (Index of Community Socio-Educational Advantage).

This program provides a tool to extract student address, parent occupation and parent education data for submission to ACARA. The data extracted is exported to Excel®.

Click here to view an Administrator Note.

Access to the TASS.web ACARA Data Extract (Aus) program is controlled by 'Student Records' permissions on the 'ACARA Data Extract (Aus)' security point.

To enable this function use TASS.web program System Admin > Users > Security Role Permissions.

Map Genders

Use the 'Map Genders' icon to view or edit the specific TASS genders and codes mapped for this report.

Important!

If your school has defined additional gender types that are not recognised by the report's governing body, you will see the following message:

'Unmapped Genders exist. To run this report you must use the 'Map Genders' icon, and enter a mapping for all genders.'

To run the report, any additional genders in your database must be mapped to those that are accepted for the report by the governing body.

For example, if the governing body were to accept 3 gender types:

Female might map to gender code 'F'.
Male might map to gender code 'M'.
Any additional gender types that your school recognises could map to 'Unknown' (gender code 'U')—if the governing body recognises this gender type and you have defined it (or it is already defined) in TASS.

For more information on 'Gender Setup', refer to Community Plus program Setup Information.

General Tab

Fields from the 'General' tab can be used as selection criteria to filter the data that will be included in the Excel sheet. These tabs are similar to those displayed in Student Admin > Student Records > Student Information > Students.

User Defined Tab

Use the fields on this tab to further filter the students who will be included in the export.

Process Tab

Enter the information and select 'Go' to proceed to create the Excel file.

Sort By	Formatting Options
There are 3 options: Student Code. Surname (the default selection). Year Group.	This report can only be output to Excel (i.e. a spreadsheet).
*School Code
ACARA SML ID	Unique numeric ID allocated to a given school or campus by ACARA. Find out what your school’s ACARA SML ID is by visiting https://asl.acara.edu.au/ and searching for your school. The data entered here will be included in Field 1 of the extract.

ACARA format

Field #	ACARA Field	Max Field Length	Value	TASS Program/Field Name
1	*ACARA SML ID	6	Numeric	Entered when running this program on 'Process' tab
2	*School Name	50	Text	Finance > General Ledger > Setup Information > Company Information. 'Full Name'.
3	*Calendar Year	4	Text	The year to which the data relates. The program will insert the calendar year from your server's clock, e.g. 2023.
4	*Jurisdiction Student ID	12	Alphanumeric.	Student Admin > Student Records > Student Information > Students. 'Student Code'.
5	*Grade of Student Enrolment	2	Text. Year groups -1 & 0 will be translated to 0.	Student Admin > Student Records > Student Information > Students. 'Year Group'.
6	*Date of Birth	8	Text (do not use data type date). Must be in DDMMYYYY format.	Student Admin > Student Records > Student Information > Students. 'Date of Birth'.
7	*Gender	1	Numeric 1 = Male. 2 = Female. 3 = (Option) Another term/Non-binary. 9 = Other/Not stated/Inadequately described.	Student Admin > Student Records > Student Information > Students. 'Gender'.
8	*Aboriginal and/or Torres Strait Islander Status	1	Numeric 1 = Aboriginal. 2 = Torres Strait Islander. 3 = Both Aboriginal & Torres Strait Islander. 4 = Neither Aboriginal nor Torres Strait Islander. 9 = Not stated/Unknown.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Indigenous Status'. This program uses the MCEECDYA codes (1,2,3,4,9).
9	*Student Language other than English spoken at home	4	4 digit numerical ASCL code. Not stated = 0002.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Language other than English at home' (for the Student).
10	*Parent Guardian 1 School Education	1	Numeric. 4 = Year 12 or equivalent. 3 = Year 11 or equivalent. 2 = Year 10 or equivalent. 1 = Year 9 or equivalent or below. 0 = Not stated/Unknown.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'School Education' - Mother.
11	*Parent Guardian 1 Highest Non-School Education	1	Numeric. 7 = Bachelor degree or above. 6 = Advanced diploma/Diploma. 5 = Certificate I to IV (includes a trade certificate). 8 = No non-school education. 0 = Not Stated/Unknown.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Non-School Education' - Mother.
12	*Parent Guardian 1 Occupation Group	1	Numeric. 1 = Senior management in large business organisation, government administration and defence, and qualified professionals. 2 = Other business managers, arts/media/sportspersons and associate professionals. 3 = Tradespeople, 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 or unknown.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Occupation' - Mother.
13	*Parent 1 Language other than English spoken at home	4	4 digit numerical ASCL code. Not stated = 0002.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Languages other than English at home' (for the Mother).
14	*Parent Guardian 2 School Education	1	Numeric. 4 = Year 12 or equivalent. 3 = Year 11 or equivalent. 2 = Year 10 or equivalent. 1 = Year 9 or equivalent or below. 0 = Not stated/Unknown.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'School Education' - Father.
15	*Parent Guardian 2 Highest Non-School Education	1	Numeric. 7 = Bachelor degree or above. 6 = Advanced diploma/Diploma. 5 = Certificate I to IV (includes a trade certificate). 8 = No non-school education. 0 = Not Stated/Unknown.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Non-School Education' - Father.
16	*Parent Guardian 2 Occupation Group	1	Numeric. 1 = Senior management in large business organisation, government administration and defence, and qualified professionals. 2 = Other business managers, arts/media/sportspersons and associate professionals. 3 = Tradespeople, 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 or unknown.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Occupation' - Father.
17	*Parent 2 Language other than English spoken at home	4	4 digit numerical ASCL code. Null = 0002.	Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Languages other than English at home' (for the Father).