...
- Ensure you have configured the NTGOVDEMO external system lookup table mapping. See Configuring external system lookup table mapping.
- 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. - Select the year using the Year field.
- Select the term using the Term field.
Note: You do not need to select the Campus. - Select the NT using the State field, if not already selected.
- Select Student Age Census using the Export File drop-down list.
- 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. - Select how fields in the report are separated using the Delimiter field.
Tip: We recommend using the Comma delimiter. - 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. - Click to select a location to save the file.
The Save As window is displayed. - Navigate to the file location where the Student Age Census file is to be saved.
- Type a filename into the File name field followed by .txt. For example, 2020 Student Age Census.txt.
- Click .
- Click .
The Student Age Census file is exported. - Open the 2020 Student Census spreadsheet in Microsoft Excel.
The 2020 Student Census spreadsheet is displayed. - Select the first cell to be populated with data.
- Click the Data tab.
The Data tab is displayed. - Click in the Get External Data area.
The Import Text File window is displayed. - Select the Student Age Census file.
- Click .
The Text Import Wizard - Step 1 of 3 window is displayed. - Select the My Data has headers field.
- Click .
The Text Import Wizard - Step 2 of 3 window is displayed. - 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. - Click .
The Text Import Wizard - Step 3 of 3 window is displayed. - Select one of the following columns in the Data preview area.
• StudentsMainSLG
• ParentGuardian1MainSLG
• ParentGuardian2MainSLG.
• - Select the Text field in the Column data format area.
- Repeat Steps 25 and 26 for the remaining fields.
- Click .
The Import Data window is displayed.
Tip: You can update the Existing worksheet field to change the row and column insertion point. - Click .
The Student Age Census is imported. - 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. - Submit the Student Age Census file.
Exporting the Student Age Census file is complete.
Student Age Census file fields
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|