Pivot tables are a built-in interactive function of Microsoft Excel. They enable users to quickly construct cross-tabulations of choice from predefined data sets.
You can rotate columns or rows to see different summaries of the source data and apply filters. A number of Excel spreadsheets are available for downloading in compressed zip files. They provide for cross-tabulations of a number of socio-demographic and course variables to provide information on total enrolments, load, completions, students and staff. Information from recent years is available.
For help with pivot tables, phone David on (08) 8201 2404.
Still Confused? Register your interest in a Pivot Table and University Statistics training workshop.
|Statistic Type||Description||Current 2013
|Enrolments||Since any student/s may be enrolled in more than one course, tables with enrolment figures will count a student more than once if they are enrolled in more than one course.||View current 2013||View trends|
|Student Load||Two variables indicating load are available. This includes the Equivalent Full-time Student Load (EFTSL) measure and the Weighted Equivalent Full-time Student Load (WEFTSL). Full-time load at Flinders is enrolment in 36 units.||View current 2013||View trends|
|Student Load: Extensive Data Set||Same figures as the above Student Load tables. This Extensive Data Set version includes additional fields for more specific queries.||View current 2013||View trends|
|Past Course Completions||Information is provided for each student who completed the academic requirements of an award course in the year prior to the Collection/Census Year.||View trends|
|Students||Students are persons admitted to a course at the University and this is current at the corresponding census, ie the person has not withdrawn from or deferred their studies. Students are counted only once even if they have been enrolled in more than one course.||View current 2013||View trends|
|FT/FFT Staff FTE||Full-Time Equivalent (FTE) Information is provided on recent years FT/FFT staff file as at the 31 March||View trends|
|FT/FFT Staff Numbers||Staff Member numbers are provided on recent years FT/FFT staff file as at the 31 March||View trends|
|Trends in Casual Staff||Information is provided on recent years Casual staff file as at the 31 December in the year previous to submission||View trends|