NESA Course Mapping Tool

1

Upload Student Attendance Spreadsheet

Go to the Profiles module on Sentral.
Select Exports in the menu on the left.
Match the settings as shown below. Make sure you have selected only the desired year.
Only .xls or .xlsx files are accepted. Do not modify the spreadsheet once downloaded from Sentral.

Select student attendance file (.xls or .xlsx):

Choose File

2

Upload NESA Course Codes

In Schools Online, go to Courses Offered at Your School.
Change the year of study to the one you are working with.
Select Show only courses offered. This will show courses offered at your school and make matching easier.
Click on the download button. Do not make any changes to the file.

Select NESA course codes file (.csv):

Choose File

3

Upload NESA Template

In Schools Online, go to 20XX Enrolments.
Select Load Student Courses from a file.
Make sure the correct year of study is selected.
On the left, click on create entry file to download the file. Do not make any changes to the file.

Select NESA student data file (.csv):

Choose File

4

Map Classes to NESA Courses

Map each unique class code to its corresponding NESA course. Most courses should do this automatically based on the class codes from Sentral and our database. Unmapped classes will retain their original names in the output. You will need to manually map any courses that were not automatically matched, and any Board Endorsed courses by using the textbox on the right of each course. For any classes on the timetable that do not need to be uploaded to Schools Online, click on the delete checkbox to remove it from the relevant students.

Please note that the class codes will attempt to match based on the timetable naming conventions of one school. If your school's naming conventions differ greatly from ours, you may have to manually map a few more codes. See the Help & FAQs for more information.

📅 Select Year Level (for auto-mapping):

Year 10 Year 11

5

Download Output

Columns C, D and E are from the Sentral Attendance spreadsheet and are there for you to double check that the matching was done correctly. It is very important to check students with common or duplicate surnames. To upload this spreadsheet to Schools Online,

Delete any students who do not have a NESA number. If you upload without doing this, Schools Online will get upset.
Delete columns C, D and E.
Do a final check for any courses that are still timetable codes instead of NESA codes.
Make sure the file is still a csv.

📚 NESA Course Mapping Tool