{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AEI Pivot_Databricks","Documentation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AEI Pivot_Databricks","index":0,"n_rows":17,"n_cols":43,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Month","Sep"]
["Nationality","(All)"]
["State","(All)"]
["ProviderType","(All)"]
["New to Australia","(All)"]
["Ends This Year","(All)"]
[]
[null,"Year"]
[null,"Sum of DATA YTD Enrolments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of DATA YTD Commencements"]
["Sector",2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
["Higher Education",174468,181316,187815,196584,219411,236415,236148,224435,223357,240416,262277,294950,338127,384416,428768,411281,360287,347145,421779,483667,531855,69581,70648,75511,83556,95043,95627,90630,83179,88294,100438,107338,120500,137554,151682,165104,128986,102137,134110,194296,199117,200778]
["VET",46512,60391,91492,138401,191784,188806,153346,130460,119637,131406,148372,164577,189365,213154,247087,273406,259185,238633,287664,347955,331402,25055,34085,52503,79064,102004,89978,80979,70216,68523,81134,88693,96199,108865,116578,134114,134107,113379,114136,152355,172967,135302]
["Schools",24197,23213,25288,27526,26794,23212,19799,17618,16800,17243,19471,22094,24462,25758,24667,19858,12943,10993,14913,19024,19768,9468,9830,12112,13380,11881,9844,8180,7500,7813,8472,9972,11200,12203,12099,11077,7693,3299,5103,8740,10341,9103]
["ELICOS",54153,63353,83842,104564,117085,95473,78184,75639,91894,108791,115787,120543,125757,126175,129625,94402,36347,52867,135592,127404,79458,38966,45411,62633,77990,85259,65427,55454,55695,68585,78994,82184,84813,88216,87782,90440,56308,23245,46941,96912,80404,47089]
["Non-award",24877,24708,25837,27959,29477,29677,26783,24106,26819,32839,36381,41727,47555,46877,45043,30752,12688,18703,30118,34196,34135,20717,20586,21536,23095,23483,23170,20698,19450,21696,26664,27819,32454,34603,34067,32556,18842,6413,14403,23892,26207,25638]
["Grand Total",324207,352981,414274,495034,584551,573583,514260,472258,478507,530695,582288,643891,725266,796380,875190,829699,681450,668341,890066,1012246,996618,163787,180560,224295,277085,317670,284046,255941,236040,254911,295702,316006,345166,381441,402208,433291,345936,248473,314693,476195,489036,417910]

{"sheet":"Documentation","index":1,"n_rows":120,"n_cols":1,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
["Switch to the Pivot Table tab"]
[]
["Open the International education Website Statistics Page in web browser"]
[]
[]
["On this page:"]
[]
["What is the international student data?"]
[]
["International student data categories"]
[]
["What is a pivot table?"]
[]
[]
["What is the international education student data?"]
[]
["Where does the international student data come from?"]
[]
["Enrolment data are derived from the Commonwealth Provider Registration and International Student Management System (PRISMS) database. PRISMS includes:"]
[]
["- enrolment data for all education sectors (Higher Education, Vocational Education, Schools and ELICOS);"]
["- enrolments by students on a student visa;"]
["- data based on electronic confirmation of enrolments (eCoE); and"]
["- country of origin based on citizenship rather than permanent home residence."]
[]
["Data is initially uploaded into PRISMS by educational providers when an enrolment is offered to a prospective student before a visa is granted, and again when a student obtains and uses their visa to enter Australia and starts studying. The Department of Home Affairs (DHA) updates PRISMS as students enter or leave Australia or change their visa or residence status. Providers also update PRISMS when students change courses or fail to comply with student visa requirements. PRISMS receives data electronically every night from DHA as student visas are granted or cancelled and as students are recorded on DHA systems as entering Australia. Only enrolments that represent students who have actually started studying in Australia are counted in the international student enrolment data."]
[]
["Enrolments versus students"]
[]
["The international student enrolment data generally does not represent the number of overseas students in Australia or the number of student visas issued in different countries. Instead data counts actual course enrolments. The exception is the data at the beginning of a month which represents a close approximation to the number of students enrolled on that day."]
[]
["How are enrolments counted?"]
[]
["A student attending two different courses in the same reference period (for example ELICOS and Bachelor Degree) will have both enrolments counted. Students will be counted as enrolled in Australia even if they have left Australia temporarily for example during end of year holidays. Students are not recorded as enrolled in Australia if for example they are moving between institutions at the date of reporting and their new course details have yet to be entered by institutions."]
[]
["The international student monthly total of enrolments combine continuing enrolments from the previous month with new enrolments commencing during the month."]
[]
["What is a commencement?"]
[]
["A commencement is an enrolment that commenced at any time within the year it appears in. For an example, a higher education commencement that began in March will continue being reported as a commencement up until December of that same year, but should it continue into the next year, it will only be reported as an enrolment in that next year."]
[]
[]
["How is nationality recorded?"]
[]
["The international student enrolment data allocates a student’s nationality based on citizenship data uploaded into PRISMS from both DHA and educational institutions. This may not coincide with their country of home residence. The 'Other' category caters for refugees, stateless people and errors in data entry."]
[]
["How is sector allocated?"]
[]
["Enrolments are allocated to sectors on the basis of their course level within the Australian Qualifications Framework (AQF). Courses not covered by the AQF are allocated to 'Other'. However, ELICOS enrolments are treated differently. All courses identified as 'English Language' field of study are allocated to the ELICOS sector irrespective of the AQF level of course."]
[]
[]
[]
["What international students does the international student enrolment data include?"]
[]
["The international student enrolment data covers onshore international students studying on student visas only (visa subclasses 570 to 575). It does not include overseas students on Australian funded scholarships or sponsorships or students undertaking study while holding a tourist or other temporary entry visas (or their dependents). New Zealand students are not included in this data as they do not require a student visa to study in Australia."]
[]
["Earlier data"]
[]
["The international student enrolment data, derived from the PRISMS database, is available from 2002, noting early years may not be incorporated in the published data.  Earlier data from other data collections is available but is not strictly comparable with data from 2002. These earlier statistics are derived from the Overseas Student Statistics Collection (OSSC). The overseas student statistics in the OSSC were compiled from visa data supplied by the Department of Home Affairs, and in the case of higher education data, primarily from the Higher Education Statistics Collection (HESC)."]
[]
["Anything else you should know?"]
[]
["Users of the international student enrolment data should be aware that:"]
[]
["- data are extracted on a monthly basis. As PRISMS is constantly updated, there will be slight variations in enrolment data across different extract dates;"]
["- as noted above the data classify providers into government and non-government based on advice from State and Territory Accrediting Authorities;"]
["- enrolment records broken by 14 days or less are joined together where the enrolment is at the same sector, level of study and field of study;"]
["- non-ELICOS students who repeat courses after a break of 12 months from the end of their last enrolment are treated as an additional enrolment;"]
["- any period of study identified as persisting for no longer than 10 percent of the expected course duration is not counted in the data; and"]
["- the data do not include information about whether students passed their course or received their qualification. Enrolments by students who do not complete or withdraw late are included. In each case the actual period of enrolment is reflected in the data."]
[]
["top"]
[]
["International student data categories"]
[]
["The following are descriptions of the data categories in the international student monthly data."]
[]
["YTD Enrolments"]
[]
["The running total of international student enrolments for the calendar year, for example YTD Enrolments to September 2006 is the total of the enrolments for each month from January 2006 to September 2006."]
[]
["YTD Commencements"]
[]
["The running total of international student commencements for the calendar year, for example YTD Commencements to March 2005 is the total of the commencements for each month from January 2005 to March 2005."]
[]
["As at 1st Month"]
[]
["The number of international student enrolments as at the first day of the month."]
[]
["Enrolments for Month"]
[]
["The total number of international student enrolments in the month. This is the sum of enrolments at the first of month plus commencements for the month."]
[]
["Commencements for Month"]
[]
["The number of international student commencements during the month. A commencement is a new enrolment in a particular course at a particular institution."]
[]
["Provider Type"]
["Enrolments and commencements are identified as either Government (commonly referred to as public) or Non Government (commonly referred to as private), in accordance with how the associated education providers are identified on the Commonwealth Register of Institutions and Courses for Overseas Students (CRICOS), which is determined from the funding and governance arrangements of each provider."]
[]
["Broad Field (of Education)"]
["The Australian Standard Classification of Education (ASCED) defines different education courses into specific fields. The highest level (least granular) classification is Broad Field of Education, where for example Society and Culture incorporates much of what is commonly known as Arts and Humanities and Health incorporates Medicine as well as Nursing and Allied Health fields. The department also published tables (in Microsoft Excel format) incorporating more granular Narrow and Detailed Fields of  Education."]
[]
[]
["Level of Study"]
["The Australian Qualifications Framework recognises specific awards and qualifications, which are classified as Levels of Study, for example Bachelor degrees in Higher Education and Certificates in Vocational Education and Training. Note that enrolments in Non-Award and also ELICOS are classified as Non AQF Award."]
[]
[]
["New to Australia"]
["An enrolment or commencement identified as New to Australia (Yes) was generated by a student in that year who had not appeared in any previous year of the data collection. Any such enrolment or commencement that carries over into a subsequent year is reclassified as New to Australia (No)."]
[]
["top"]
[]
["What is a pivot table?"]
[]
["A pivot table is an excel spreadsheet table that allows the international student data to be arranged as tables to enable easier analysis."]
[]
["The pivot table allows fields to be cross-tabulated by dragging and dropping items from the field list to the pivot table.  The pivot table consists of four areas–data, row, column and page.  The data area contains the numbers (those fields prefixed by 'DATA').  The row and column areas allow data to be cross-tabulated in the pivot table.  The page area allows data to be filtered by the selection in the page area."]
[]
["The data in the pivot table can be manipulated by the many functions built into Microsoft Excel.  We recommend that users refer to the Microsoft documentation for a description of all Excel pivot table functions.  We have found the ability to sort, group, display percentage changes and construct graphs from pivot tables have proven to be very useful functions."]