Preparing Student Census data for submission (Non-Government Schools)
Use the following topic to prepare student census data for the Australian Non-Government Schools Census data by:
- exporting the census data from Synergetic
- copying the census data in the Census Upload Tool spreadsheet.
Field configurations
Click the link below to view the configuration details for each field included in the 2022 Non-Government Schools Census.
Note: You should check for errors by running the Summary and Detailed reports before exporting the census data. See Running the Student Census - Australian Non-Government Schools report.
Note: Synergetic is not providing an HR solution. For additional information about the Census Upload Tool including instructional videos, see 2022 Non-Government Schools Census.
To prepare the student census data for submission:
- Select Reports > Available Reports.
The Available Reports window is displayed.
Tip: You can also select Students > Student Reports Available. - Locate the report using the Search field.
- Select the Student Census - Australian Non-Government Schools report in the grid area.
The Student Census - Australian Non-Government Schools window is displayed. - Select the official census date using the Census Date field.
Note: You can check the official census date on the Department of Education and Training website. See 2022 Non-Government Schools Census.
Important: This field is used to determine whether students are included or excluded from the report. For example, students with a Leaving Date before this date are excluded from the report. - Select the date used to calculate the age of students using the Age at Date field.
- Select Data for Government Submission using the Mode drop-down list.
- Select one or more fields in the Reference Period for Inclusion Selections area to define criteria for including students in the census.
You can select:
• Select the Attendance for File Type field to include students from a particular file type, such as Academic.
• Select the Absence Events Daily Calc field to include students provided they have at least one day in the reference period where their absence factor <1.0.
Important: Do not change the Reference Period Days field unless the Department of Education defines a new reference period. Currently, the census reference period consists of twenty school days (excluding school holidays) leading up to and including the census day. - Select a campus from the Campus drop-down list to filter reported records by the selected campus.
- Select the Combine Campuses field if you have multiple campuses and would like to combine the results from all the campuses.
- Select a sub-school from the Sub School drop-down list to filter reported records by the selected sub-school.
- Select a year level from the Year Level drop-down list to filter reported records by the selected year level.
- Select Summary in all the If using per section fields.
- Click .
The Student Census - Australian Non-Government Schools report is displayed. - Click in the report toolbar.
The Export window is displayed. - Select Microsoft Excel 97-2000 - Data only (xls) using the Format drop-down list.
- Select the export location using the Destination drop-down list. You can select:
• Application to open the data in Excel
• Disk file to save the file to your hard drive. - Click .
The Excel Format window is displayed. - Select Custom in the Excel Format area.
- Select Details using the Column width based on objects in the drop-down list.
- Select the Export page header and footer field.
- Select the Simplify page headers field.
- Click .
- Open the census data file in Microsoft Excel.
- Resize the columns so you can see the data.
- Select all cells populated with data except the header cells.
Important: You must only select the cells populated with data (excluding headers). The Census Upload Tool spreadsheet does not allow content to be pasted when the size of the copied data does not match the size of the paste area. - Copy the cells.
- Open the Census Upload Tool spreadsheet.
Note: You can download the latest Census Upload Tool spreadsheet from the Schools Hub website.
Important: The following steps provide instructions for adding student data to the Census Upload Tool spreadsheet. These steps are current at the time of writing, but may change. You can check the Schools Hub website for the latest instructions. See 2022 Non-Government Schools Census.
- Click the Enter Student Data tab.
The Enter Student Data tab is displayed.
Note: Synergetic is not providing an HR solution for the Enter Staff Data tab. - Paste the copied rows into the spreadsheet.
- Click .
- Either:
• No errors are identified.
• Errors are identified and cells with errors are highlighted in red. Resolve any errors and repeat steps 1 through 17.
Tip: You can right-click cells with errors to view error descriptions.
Preparing the student census data for submission is complete.