Page Comparison

Northern Territory organisations Schools are required to export and submit Student Age Census to the Northern use the 2020 Student Census spreadsheet to submit details of all currently enrolled students to the Northern Territory Government.

Selection CriteriaInclusion criteria

Organisations have different selection criteria for the Student Age Census based on whether the Attendance module is installed. You can click the link below for more information.

If your organisation does not have the Attendance module:

...

...

...

Field configurations

You can click the link below to view configuration details for each field included in the 2020 Student Census.

To export the Student Age Census file:

1. Ensure you have configured the NTGOVDEMO external system lookup table mapping. See Configuring external system lookup table mapping.
2. Open the Demographic tab of the Import/Export Student Data window. See Import_Export Student Data - Demographic tab.
   The Demographic tab of the Import/Export Student Data window is displayed.
   
   
3. Select the year using the Year field.
4. Select the term using the Term field.
   
   Note: You do not need to select the Campus.
   
   
5. Select the NT using the State field, if not already selected.
6. Select Student Age Census using the Export File drop-down list.
7. Type your school name into the School Name field.
   
   Note: You can pre-populate this field by typing your school name into the Value field of the MCEETYA_SchoolName configuration setting. See MCEETYA_SchoolName configuration setting.
   
8. Select how fields in the report are separated using the Delimiter field.
   
   Tip: We recommend using the Comma delimiter.
   
   
9. Select the date up to which student data will be included in the Student Age Census file using the Process Date field.
   
   Note: Students are excluded if their Entry Date is after this date or their Leaving Date is prior to this date.
   
   
10. Click  to select a location to save the file.
    The Save As window is displayed.
    
11. Navigate to the file location where the Student Age Census file is to be saved.
12. Type a filename into the File name field followed by .txt. For example, 2020 Student Age Census.txt.
    
13. Click .
14. Click .
    The Student Age Census file is exported.
15. Open the 2020 Student Census spreadsheet in Microsoft Excel.
    The 2020 Student Census spreadsheet is displayed.
    
    
16. Select the first cell to be populated with data.
17. Click the Data tab.
    The Data tab is displayed.
18. Click  in the Get External Data area.
    The Import Text File window is displayed.
19. Select the Student Age Census file.
20. Click .
    The Text Import Wizard - Step 1 of 3 window is displayed.
    
    
    
21. Select the My Data has headers field.
22. Click .
    The Text Import Wizard - Step 2 of 3 window is displayed.
    
23. Select the delimiter used for the file using the Delimiters area. For example, Comma.
    The Data preview area is refreshed to display the content in columns.
    
24. Click .
    The Text Import Wizard - Step 3 of 3 window is displayed.
    
25. Select one of the following columns in the Data preview area.
    
    • 
    
    
26. Select the Text field in the Column data format area.
27. Repeat Steps 25 and 26 for the remaining fields.
28. Click .
    The Import Data window is displayed.
    
    
    Tip: You can update the Existing worksheet field to change the row and column insertion point.
    
    
29. Click .
    The Student Age Census is imported.
    
    
30. Review the information for completeness.
    
    Note: You can use the field information below these steps to determine acceptable values and where the values are defined in Synergetic.
    
31. Submit the Student Age Census file.
    Exporting the Student Age Census file is complete.

Student Age Census file fields

...