The NZCER Marking site can upload student data extracted from some student management systems (SMS).

This functionality is currently available for schools using KAMAR, eTAP, MUSAC, Assembly and SchoolMaster. If your SMS software is not listed here and you wish to use this additional functionality, please contact your SMS provider to inquire about their development of this function, it may be available but not yet known to us.

Please note: the file generated in the SMS will only contain students that have a complete NSN record. It is therefore essential to ensure that your SMS records have been through the Get Check NSN process from Enrol, prior to using this functionality.

Brief notes on importing the files from your SMS are as follows:

KAMAR

http://www.kamar.co.nz/104841

eTAP

The NZCER file can be created by anyone able to log into eTAP and view the ‘Admin tools’ menu option. The following link gives clear visual instructions on how to create a file from eTAP that can be used in the NZCER Marking Service.

Import and Export instructions for schools using eTAP

MUSAC – Edge


http://answers.edge.school.nz/edge/knowledge-base/curriculum/assessment/e-asttle-and-nzcer/export-nzcer

MUSAC – Classic

  1. Log on to Classroom Manager – Administrator version
  2. Click on ‘Other Utilities’
  3. Click on asTTle and NZCER Utilities
  4. Click on ‘Export NZCER data’
  5. Choose the ‘Term’
  6. Select where you would like to save your ‘csv’ file
  7. Decide on your selection of students ‘optional – your current filter will apply’
  8. Click ‘Proceed’.

Note: If you receive a message advising some students will not be included, this is because the student does not have an NSN. You may at this point choose to continue (adding the missing students in manually) or return later to your MUSAC program to download the latest NSN identifier’s for the required students. The ‘omitted.csv’ file will be useful for identifying which students require updating.

MUSAC hosted by Edtech

If your school has MUSAC hosted by Edtech you should refer to your manual – MUSAC Classic – which is available in the Cloud Site Manual. You should have a link directly to the manual but if not please email servicedesk@edtech.co.nz for this.

The sections you should refer to are:

Section 3.2 Exporting data from Student Manager to NZCER

Section 4.1 Downloading Exported files

ASSEMBLY

The following link gives clear visual instructions on how to create a file from Assembly that can be used in the NZCER Marking Service.

Import and Export instructions for schools using Assembly

PC SCHOOL

See attached file


LINC-ED

The following link will take you to a web-clip that will show you how to create this file:

Linc-Ed Web-clip


SCHOOLMASTER

At this time it is not possible for you to upload your SchoolMaster file yourself, but the process below allows you to create a file that can be emailed to NZCER to be uploaded on your behalf.


  1. Click on the student records tab
  2. Click on the writer icon
  3. Click on new report
  4. Type in NZCER export in the title and then tab
  5. Type in NZCER in group and tab
  6. Click on the add fields to report button
  7. Double click on
  8. National_Student_Number
  9. Enrolment_Number
  10. LastName
  11. FirstName
  12. Last_PreferredName
  13. User_ID
  14. Room
  15. Year_
  16. Gender
  17. Ethnic_Group
  18. Click OK
  19. Click on Save changes to report
  20. Click on NZCER then NZCER Export and Run report
  21. Click on Select icon and select appropriate year levels (eg; click on choice 1 box for Year_ and highlight 3, 4, 5 and 6 etc and click ok)
  22. Click on Save to File
  23. Save the file onto your desktop or somewhere handy – with an easy to recognize name
  24. Open a blank Excel document
  25. Go to File and OpenChange the File type to all fields, choose the exported file and open
  26. Go through the text import wizard (Next, next and finish).

You will then need to insert a row at the top and type in the headers so it has the same columns as below, as well as inserting columns for Schoolname etc. Use the autofill to fill these in.

The Fields required are:

NSN (National Student Number), SMS (Enrolment Number), surname, first name, full name, School_name, School ID, Roomname (Room), year, term, gender, Ethnicity (Ethnic Group).

Click on File > Save as to a .csv type file.

For any issues, please contact the SchoolMaster Helpdesk on (03) 230-4096.

FILE UPLOAD

Once you have prepared your .csv file, please see Step 2 for instructions on uploading it to NZCER Marking.