Page Comparison

To export raw (Note: These instructiuons are not for producing the data for submission for the Non Government Schools Census via the Schools Hub.  See: Preparing Student Census data for submission (Non-Government Schools))

To export student census data to Excel:

1. Select Module > Students > Student Crystal Reports Available.
   The Synergetic Reports Available window is displayed.
   
2. Locate the report using the Search field.
   
3. Select the Student Census - Australian Non-Government Schools report in the grid area.
4. Click .
   The Student Census - Australian Non-Government Schools window is displayed.
   
5. 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 2019 2020 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.
   
   Image Added
   
   
6. Select the date used to calculate the age of students using the Age at Date field.
   
   Note: This field defaults to the date of the August census.
   
   
7. Select the Raw Data (student details; for export to Excel) mode using the Mode drop-down list to export the raw census data.
8. 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.
   
   
9. Select a campus from the Campus drop-down list to filter reported records by the selected campus.
10. Select the Combine Campuses field if you have multiple campuses and would like to combine the results from all the campuses.
11. Select a sub-school from the Sub School drop-down list to filter reported records by the selected sub-school.
12. Select a year level from the Year Level drop-down list to filter reported records by the selected year level.
13. Click .
    The Student Census - Australian Non-Government Schools report is displayed.
14. Click in the report toolbar.
    The Export window is displayed.
    
15. Select Microsoft Excel 97-2000 - Data only (xls) using the Format drop-down list.
16. 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.
    
    
17. Click .
    The Excel Format window is displayed.
    Image RemovedImage Added
18. Select Custom in the Excel Format area.
19. Select Details using the Column width based on objects in the drop-down list.
20. Select the Export page header and footer field.
21. Select the Simplify page headers field.
22. Click .
    Exporting raw student census data to Excel is complete.