Skip to main content

NAG2A Tasks — Summary, Data Check, Exclusions and Export

Last updated

The NAG2A tasks help Year 1–8 schools review and report their National Standards Overall Teacher Judgement (OTJ) data: an on-screen summary, a detailed data check, a list of excluded students with reasons, and the export file for the Ministry of Education. These tasks must be enabled for your school — contact support if you don't see the NAG2A menu.

The NAG2A tasks help Year 1–8 schools review and report their National Standards Overall Teacher Judgement (OTJ) data: an on-screen summary, a detailed data check, a list of excluded students with reasons, and the export file for the Ministry of Education. These tasks must be enabled for your school — contact support if you don't see the NAG2A menu.

Where to find it

The NAG2A menu contains four items: Summary, Data Check, Exclusions and Export Report. All four require the Manage Assessment permission.

Every NAG2A page has a year selector at the top. Years from 2012 onwards are available; the page defaults to the current year (or the previous year if it's before 1 March, since the reporting window runs from 1 March).

Summary

NAG2A > Summary shows an aggregated table of OTJ results broken down by ethnicity and gender (Male / Female / Total), with columns for Well Below, Below, At, Above, Total and Excluded (No OTJ).

  1. Choose the OTJ Type (curriculum area — Reading, Writing or Maths).
  2. Choose the OTJ Year — a specific year level, or All Years (1-8).
  3. Review the counts. Cells with no results display "-". Note that the Total column does not include excluded students; they are counted separately in Excluded (No OTJ).

Screenshot: NAG2A Summary table with the OTJ Type and OTJ Year dropdowns

Data Check

NAG2A > Data Check produces a detailed reconciliation report to verify your data before exporting.

  1. Select the year.
  2. Click Generate Detail Report (Excel). The workbook downloads to your browser.

The report lists each expected student with their actual OTJ marks that feed the aggregated export, plus the excluded students who require a reason (name, NSN and the recorded reason) — use it to confirm every student is accounted for before submission.

Exclusions

NAG2A > Exclusions lists students who are enrolled for the reporting year but are missing an OTJ in one or more subjects, so you can record why.

The table shows Name, NSN, Gender, Ethnicity, OTJ Year, Reading, Writing, Math and Reason For Exclusion. An X in a subject column means that subject's OTJ is missing. Expanding a row shows who created the record, the referring staff member and any notes.

  1. Select the year.
  2. For each student whose reason field is editable, type the Reason For Exclusion. Students excluded for enrolment-date reasons (starting late or leaving before the 1 November enrolment cut-off) show an automatic explanation and don't need a manual reason — rows needing a reason are listed first.
  3. Click Save. A status message confirms the reasons were saved.

Screenshot: Exclusions table with X markers for missing OTJs and editable reason fields

Students on the exclusions list are removed from the counts in the Summary and the export file.

Export Report

NAG2A > Export Report generates the submission file and supporting outputs. The page keeps a history of previously generated files with download links.

Current NAG2A CSV Export

  1. Select the year and click Generate Export File (CSV).
  2. Download the file and upload it to the Ministry via the Leadspace portal — edge generates the file but does not transmit it.

The CSV contains aggregated counts only (no per-student rows): one row per combination of curriculum area (READ/WRIT/MATH), year level, gender, ethnicity and OTJ result, following the SMS specification for National Standards data submission. The filename includes your school number, a timestamp and the reporting year.

NAG2A PDF

Click Generate PDF to produce a PDF you can use to check the CSV data before submission. It is a checking aid, not a Ministry submission file.

2013 NAG2A Export Page

A legacy Generate Export File (Excel) option exists for 2013-era reporting. The page notes this file "is for 2013 and should not be sent to the ministry"; its worksheets are locked (password = your MoE school number).

Screenshot: Export Report page showing the CSV, PDF and legacy Excel sections with previously generated files

How the data is calculated

  • Only each student's final OTJ for the reporting window (1 March to end of February) is counted.
  • The enrolment cut-off is 1 November — students who started after it or left before it are excluded automatically.
  • Ethnicity is reported at Level 1 using Ministry codes (NZ European/Other European, Māori, Pacific Peoples, Asian).

Suggested workflow

  1. Run the Data Check and fix any missing or incorrect OTJs.
  2. Record reasons on the Exclusions page for any student who needs one.
  3. Review the Summary figures.
  4. Generate the PDF to double-check, then generate the CSV and upload it via Leadspace.