Page Comparison

Northern Territory Schools are required to use the 2020 Student Census spreadsheet to submit details of submit a file to the Nothern Territory Government containing demographic details for all currently enrolled students to the Northern Territory Government. This demographic export is known as the Northern Territory Student Age Census file.

Note: The Nothern Territory Student Age Census is produced from the Demographic tab of the Import/Export Student Data window. See Import_Export Student Data - Demographic tab.

Inclusion criteria

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

Field configurations

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

...

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.
   Image RemovedImage Added
   
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 YYYY Student Census spreadsheet in Microsoft Excel.
    The 2020 YYYY Student Census spreadsheet is displayed.
    Image Added
    
16. Select the first cell to be populated with data.
    
17. Click the Data tab.
    The Data tab is displayed.
18. Click Image Removed in the Get External Data area.
    The Import Text File window is displayed.
19. Select the Student Age Census file.
Click Image Removed.
The Text Import Wizard - Step 1 of 3 window is displayed.
Image Removed

20. Select the My Data has headers field.
21. Click Image Removed.
    The Text Import Wizard - Step 2 of 3 window is displayed.
    Image Removed
22. 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.
    Image Removed
23. Click Image Removed.
    The Text Import Wizard - Step 3 of 3 window is displayed.
    Image Removed
Select one of the following columns in the Data preview area.
• 

24. Select the Text field in the Column data format area.
25. Repeat Steps 25 and 26 for the remaining fields.
26. Click Image Removed.
    The Import Data window is displayed.
    Image Removed
    Tip: You can update the Existing worksheet field to change the row and column insertion point.
    Click Image Removed.Image Added
27. Open the Student Age Census export file.
    Image Added
28. Copy all the data.
29. Paste the data into the 2020 Student Census Spreadsheet.
    Image Added
    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.