ACARA Data Extract (Aus)
Overview
The ACARA Data Extra program provides a tool to extract student address, parent occupation and parent education data for submission to ACARA and the Student background data collection for independent schools. The data extracted is exported to Excel®.
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). ACARA collects student background data (SBD) for all Australian schools to calculate Socio-Educational Advantage (SEA) and Disadvantaged Language Background other than English (DLBOTE).
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 TASS.web Community > 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 TASS.web 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:
| This report can only be output to Excel® (i.e. a spreadsheet). |
* School Code | |
ACARA SML ID | Enter the 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 | TASS.web 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. | TASS.web Student Admin > Student Records > Student Information > Students. 'Student Code'. |
5 | Grade of Student Enrolment | 2 | Text. | TASS.web Student Admin > Student Records > Student Information > Students. 'Year Group'. |
6 | Date of Birth | 8 | Text (do not use data type date). | TASS.web Student Admin > Student Records > Student Information > Students. 'Date of Birth'. |
7 | Gender | 1 | Numeric 1 = Male. | TASS.web Student Admin > Student Records > Student Information > Students. 'Gender'. |
8 | Aboriginal and/or Torres Strait Islander Status | 1 | Numeric 1 = 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 | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Indigenous Status'. |
9 | Student Language other than English spoken at home | 4 | 4 digit numerical ASCL code. Not stated = 0002. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web 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. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, Or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'School Education' - Parent 1. |
11 | Parent Guardian 1 Highest Non-School Education | 1 | Numeric. 7 = Bachelor degree or above. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Non-School Education' - Parent 1. |
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. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Occupation' - Parent 1. |
13 | Parent 1 Language other than English spoken at home | 4 | 4 digit numerical ASCL code. Not stated = 0002. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web 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. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'School Education' - Parent 2. |
15 | Parent Guardian 2 Highest Non-School Education | 1 | Numeric. 7 = Bachelor degree or above. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Non-School Education' - Parent 2. |
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. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Occupation' - Parent 2. |
17 | Parent 2 Language other than English spoken at home | 4 | 4 digit numerical ASCL code. Null = 0002. | TASS.web Student Admin > Student Records > Student Information > Students on the 'MCEECDYA' tab, or TASS.web Student Admin > Student Records > Government Returns > MCEECDYA Grid (Aus). 'Languages other than English at home' (for the Father). |