Printed from https://fyi.org.nz/request/10509-list-of-ncea-achievement-and-unit-standards?unfold=1 on November 22, 2024 17:39

List of NCEA Achievement and Unit Standards

N Gyles made this Official Information request to New Zealand Qualifications Authority

The request was successful.

From: N Gyles

Dear New Zealand Qualifications Authority,

I am requesting a list of NCEA Achievement and Unit Standards, in CSV, XLS or another suitable database format under the Official Information Act. I would prefer an electronic response and am a NZ Citizen & Resident for the purposes of the Act.

I would expect the following information from this request for each standard:

* Title
* Standard number
* Type (Unit/Achievement)
* Version number
* Level
* Credits
* Category
* Status (expired / expiring / current)

I understand this information is presented on the NZQA website already (https://www.nzqa.govt.nz/framework/searc...), however, it is not easily processed and there is no clear way to download this information or query against it from external systems. Additionally, this does not show expired standards.

I believe much of this information may be available to people with an educational provider login via the units.txt file.

Please note, as there have been several previous OIA requests for this information in the past (e.g. https://fyi.org.nz/request/2370-list-of-..., https://fyi.org.nz/request/5954-ncea-ach..., https://fyi.org.nz/request/5954-ncea-ach...) this dataset may also be a good candidate for publishing on data.govt.nz

Yours faithfully,

Natalie

Link to this

From: Team Mailbox HelpDesk Call Centre
New Zealand Qualifications Authority

Kia ora Natalie
I have forwarded your email through to our Ministerials team to reply to your query.

Regards
Awhina
Te Mangai Putahi Waea
Call Centre Helpdesk

-----Original Message-----
From: N Gyles <[FOI #10509 email]>
Sent: Monday, 10 June 2019 5:55 PM
To: Team Mailbox HelpDesk Call Centre <[email address]>
Subject: Official Information request - List of NCEA Achievement and Unit Standards

Dear New Zealand Qualifications Authority,

I am requesting a list of NCEA Achievement and Unit Standards, in CSV, XLS or another suitable database format under the Official Information Act. I would prefer an electronic response and am a NZ Citizen & Resident for the purposes of the Act.

I would expect the following information from this request for each standard:

* Title
* Standard number
* Type (Unit/Achievement)
* Version number
* Level
* Credits
* Category
* Status (expired / expiring / current)

I understand this information is presented on the NZQA website already (https://www.nzqa.govt.nz/framework/searc...), however, it is not easily processed and there is no clear way to download this information or query against it from external systems. Additionally, this does not show expired standards.

I believe much of this information may be available to people with an educational provider login via the units.txt file.

Please note, as there have been several previous OIA requests for this information in the past (e.g. https://scanmail.trustwave.com/?c=5051&a... https://scanmail.trustwave.com/?c=5051&a... https://scanmail.trustwave.com/?c=5051&a... this dataset may also be a good candidate for publishing on http://scanmail.trustwave.com/?c=5051&am...

Yours faithfully,

Natalie

-------------------------------------------------------------------

This is an Official Information request made via the FYI website.

Please use this email address for all replies to this request:
[FOI #10509 email]

Is [NZQA request email] the wrong address for Official Information requests to New Zealand Qualifications Authority? If so, please contact us using this form:
https://scanmail.trustwave.com/?c=5051&a...

Disclaimer: This message and any reply that you make will be published on the internet. Our privacy and copyright policies:
https://scanmail.trustwave.com/?c=5051&a...

If you find this service useful as an Official Information officer, please ask your web manager to link to us from your organisation's OIA or LGOIMA page.

-------------------------------------------------------------------

If you have any feedback on our service we would love to hear from you. Please use this link to our customer survey.
https://nzqa.au1.qualtrics.com/jfe/form/...

********************************************************************************
This email may contain legally privileged information and is intended only for the addressee. It is not necessarily the official view or
communication of the New Zealand Qualifications Authority. If you are not the intended recipient you must not use, disclose, copy or distribute this email or
information in it. If you have received this email in error, please contact the sender immediately. NZQA does not accept any liability for changes made to this email or attachments after sending by NZQA.

All emails have been scanned for viruses and content.

NZQA reserves the right to monitor all email communications through its network.

********************************************************************************

hide quoted sections

Link to this

From: Team Mailbox NZQA Ministerials
New Zealand Qualifications Authority

Kia ora Natalie

Thank you for your email below.

NZQA will be able to provide you with the data in the format requested by the end of the week.

Ngā mihi

NZQA Chief Executive and Ministerial Services

-----Original Message-----
From: N Gyles <[FOI #10509 email]>
Sent: Monday, 10 June 2019 5:55 PM
To: Team Mailbox HelpDesk Call Centre <[email address]>
Subject: Official Information request - List of NCEA Achievement and Unit Standards

Dear New Zealand Qualifications Authority,

I am requesting a list of NCEA Achievement and Unit Standards, in CSV, XLS or another suitable database format under the Official Information Act. I would prefer an electronic response and am a NZ Citizen & Resident for the purposes of the Act.

I would expect the following information from this request for each standard:

* Title
* Standard number
* Type (Unit/Achievement)
* Version number
* Level
* Credits
* Category
* Status (expired / expiring / current)

I understand this information is presented on the NZQA website already (https://www.nzqa.govt.nz/framework/searc...), however, it is not easily processed and there is no clear way to download this information or query against it from external systems. Additionally, this does not show expired standards.

I believe much of this information may be available to people with an educational provider login via the units.txt file.

Please note, as there have been several previous OIA requests for this information in the past (e.g. https://scanmail.trustwave.com/?c=5051&a... https://scanmail.trustwave.com/?c=5051&a... https://scanmail.trustwave.com/?c=5051&a... this dataset may also be a good candidate for publishing on http://scanmail.trustwave.com/?c=5051&am...

Yours faithfully,

Natalie

-------------------------------------------------------------------

This is an Official Information request made via the FYI website.

Please use this email address for all replies to this request:
[FOI #10509 email]

Is [NZQA request email] the wrong address for Official Information requests to New Zealand Qualifications Authority? If so, please contact us using this form:
https://scanmail.trustwave.com/?c=5051&a...

Disclaimer: This message and any reply that you make will be published on the internet. Our privacy and copyright policies:
https://scanmail.trustwave.com/?c=5051&a...

If you find this service useful as an Official Information officer, please ask your web manager to link to us from your organisation's OIA or LGOIMA page.

-------------------------------------------------------------------

If you have any feedback on our service we would love to hear from you. Please use this link to our customer survey.
https://nzqa.au1.qualtrics.com/jfe/form/...

********************************************************************************
This email may contain legally privileged information and is intended only for the addressee. It is not necessarily the official view or
communication of the New Zealand Qualifications Authority. If you are not the intended recipient you must not use, disclose, copy or distribute this email or
information in it. If you have received this email in error, please contact the sender immediately. NZQA does not accept any liability for changes made to this email or attachments after sending by NZQA.

All emails have been scanned for viruses and content.

NZQA reserves the right to monitor all email communications through its network.

********************************************************************************

hide quoted sections

Link to this

Christopher K left an annotation ()

Has this request been fulfilled? Many of us would find this information useful.

Additional useful information would be the expiry date for each standard.

Link to this

From: Team Mailbox NZQA Ministerials
New Zealand Qualifications Authority

Attachment PRS 3019 List of Standards.xlsx
4.2M Download View as HTML

Kia ora Natalie

Further to my email below, please find attached a spreadsheet with the information you have requested.

Ngā mihi
NZQA Chief Executive and Ministerial Services

-----Original Message-----
From: Team Mailbox NZQA Ministerials
Sent: Wednesday, 12 June 2019 10:50 AM
To: [FOI #10509 email]
Subject: List of NCEA Achievement and Unit Standards

Kia ora Natalie

Thank you for your email below.

NZQA will be able to provide you with the data in the format requested by the end of the week.

Ngā mihi

NZQA Chief Executive and Ministerial Services

-----Original Message-----
From: N Gyles <[FOI #10509 email]>
Sent: Monday, 10 June 2019 5:55 PM
To: Team Mailbox HelpDesk Call Centre <[email address]>
Subject: Official Information request - List of NCEA Achievement and Unit Standards

Dear New Zealand Qualifications Authority,

I am requesting a list of NCEA Achievement and Unit Standards, in CSV, XLS or another suitable database format under the Official Information Act. I would prefer an electronic response and am a NZ Citizen & Resident for the purposes of the Act.

I would expect the following information from this request for each standard:

* Title
* Standard number
* Type (Unit/Achievement)
* Version number
* Level
* Credits
* Category
* Status (expired / expiring / current)

I understand this information is presented on the NZQA website already (https://www.nzqa.govt.nz/framework/searc...), however, it is not easily processed and there is no clear way to download this information or query against it from external systems. Additionally, this does not show expired standards.

I believe much of this information may be available to people with an educational provider login via the units.txt file.

Please note, as there have been several previous OIA requests for this information in the past (e.g. https://scanmail.trustwave.com/?c=5051&a... https://scanmail.trustwave.com/?c=5051&a... https://scanmail.trustwave.com/?c=5051&a... this dataset may also be a good candidate for publishing on http://scanmail.trustwave.com/?c=5051&am...

Yours faithfully,

Natalie

-------------------------------------------------------------------

This is an Official Information request made via the FYI website.

Please use this email address for all replies to this request:
[FOI #10509 email]

Is [NZQA request email] the wrong address for Official Information requests to New Zealand Qualifications Authority? If so, please contact us using this form:
https://scanmail.trustwave.com/?c=5051&a...

Disclaimer: This message and any reply that you make will be published on the internet. Our privacy and copyright policies:
https://scanmail.trustwave.com/?c=5051&a...

If you find this service useful as an Official Information officer, please ask your web manager to link to us from your organisation's OIA or LGOIMA page.

-------------------------------------------------------------------

If you have any feedback on our service we would love to hear from you. Please use this link to our customer survey.
https://nzqa.au1.qualtrics.com/jfe/form/...

********************************************************************************
This email may contain legally privileged information and is intended only for the addressee. It is not necessarily the official view or
communication of the New Zealand Qualifications Authority. If you are not the intended recipient you must not use, disclose, copy or distribute this email or
information in it. If you have received this email in error, please contact the sender immediately. NZQA does not accept any liability for changes made to this email or attachments after sending by NZQA.

All emails have been scanned for viruses and content.

NZQA reserves the right to monitor all email communications through its network.

********************************************************************************

hide quoted sections

Link to this

From: N Gyles

Dear Team Mailbox NZQA Ministerials,

Thank you for your prompt response, most appreciated. However unfortunately there are a couple of amendments required to meet the original request:
* the .xlsx file attached is unable to be opened in Excel - when I try to open it I am getting the error message "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Replaced Part: /xl/worksheets/sheet2.xml part with XML error. Whitespace expected. Line 2, column 5166109." The workbook then opens with the front sheet displaying correctly but the sheet with data does not have any information. I can only guess this is because it was sent as a .xlsx format but has far too many records for that format (perhaps due to having all the expired standards and all the versions included in the one file). Can you please supply the data in a format that can be opened - perhaps by supplying it as a csv, or sending in the same way as previous OIAs on the same subject, where the expired standards were sent in a separate file?
* There is no indication of which Field a Unit Standard is in - I see the Notes page of your .xlsx states "'Category' has not been included as not found in our system", however I had used the same wording of a previous OIA (linked), where category had been correctly interpreted as needing Domain/Field etc. Would it be possible for you to please include this information in your response, so that the Unit Standards can be filtered appropriately.

I am very grateful for your assistance, thanks once again.

Nga mihi,

N Gyles

Link to this

From: Team Mailbox NZQA Ministerials
New Zealand Qualifications Authority

Attachment PRS 3019 List of Standards Category.zip
2.7M Download

Kia ora Natalie

Please find attached a response to your request below.

Ngā mihi

NZQA Ministerials team

-----Original Message-----
From: N Gyles <[FOI #10509 email]>
Sent: Thursday, 20 June 2019 11:13 PM
To: Team Mailbox NZQA Ministerials <[email address]>
Subject: RE: List of NCEA Achievement and Unit Standards

Dear Team Mailbox NZQA Ministerials,

Thank you for your prompt response, most appreciated. However unfortunately there are a couple of amendments required to meet the original request:
* the .xlsx file attached is unable to be opened in Excel - when I try to open it I am getting the error message "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Replaced Part: /xl/worksheets/sheet2.xml part with XML error. Whitespace expected. Line 2, column 5166109." The workbook then opens with the front sheet displaying correctly but the sheet with data does not have any information. I can only guess this is because it was sent as a .xlsx format but has far too many records for that format (perhaps due to having all the expired standards and all the versions included in the one file). Can you please supply the data in a format that can be opened - perhaps by supplying it as a csv, or sending in the same way as previous OIAs on the same subject, where the expired standards were sent in a separate file?
* There is no indication of which Field a Unit Standard is in - I see the Notes page of your .xlsx states "'Category' has not been included as not found in our system", however I had used the same wording of a previous OIA (linked), where category had been correctly interpreted as needing Domain/Field etc. Would it be possible for you to please include this information in your response, so that the Unit Standards can be filtered appropriately.

I am very grateful for your assistance, thanks once again.

Nga mihi,

N Gyles

-----Original Message-----

Kia ora Natalie

Further to my email below, please find attached a spreadsheet with the information you have requested.

Ngā mihi
NZQA Chief Executive and Ministerial Services

-------------------------------------------------------------------
Please use this email address for all replies to this request:
[FOI #10509 email]

Disclaimer: This message and any reply that you make will be published on the internet. Our privacy and copyright policies:
https://scanmail.trustwave.com/?c=5051&a...

If you find this service useful as an Official Information officer, please ask your web manager to link to us from your organisation's OIA or LGOIMA page.

-------------------------------------------------------------------

If you have any feedback on our service we would love to hear from you. Please use this link to our customer survey.
https://nzqa.au1.qualtrics.com/jfe/form/...

********************************************************************************
This email may contain legally privileged information and is intended only for the addressee. It is not necessarily the official view or
communication of the New Zealand Qualifications Authority. If you are not the intended recipient you must not use, disclose, copy or distribute this email or
information in it. If you have received this email in error, please contact the sender immediately. NZQA does not accept any liability for changes made to this email or attachments after sending by NZQA.

All emails have been scanned for viruses and content.

NZQA reserves the right to monitor all email communications through its network.

********************************************************************************

hide quoted sections

Link to this

From: N Gyles

Dear Team Mailbox NZQA Ministerials,

Thank you, most appreciated.

Yours sincerely,

N Gyles

Link to this

N Gyles left an annotation ()

Pleasingly, NZQA have now made Standards data publicly available on data.gov:
catalogue.data.govt.nz/dataset/list-of-standards-by-category

Link to this

David Hartley left an annotation ()

I have just downloaded the data from data.govt.nz, fantastic resource. The only thing missing for me is whether each standard is/was assessed externally or internally. Is there any way of appending this data?

Link to this

N Gyles left an annotation ()

@David Hartley after a bit of a prod the NZQA team have now published the current version of the Unit Standards data. Peculiarly, it's now under a different URL for 2020 (rather than updating same dataset) but GREAT that it is available! The team tell me that whilst the current version doesn't have internal vs external assessment they will be able to add that field in the coming days. Hopefully they can make publishing this a regular event.
https://catalogue.data.govt.nz/dataset/l...

Link to this

Things to do with this request

Anyone:
New Zealand Qualifications Authority only: