Computing+in+the+NZ+Curriculum

The [|NZQA copyright notice] states that "Non-commercial educational use of NZQA material within New Zealand is permitted subject to the General Conditions and Specific Conditions set out below." and later "An "educational use" is a use that is only for an organisation's internal purposes by its staff and learners (for example assessing learners, preparing programmes of activities, or as reference materials for teachers)." The purpose here is to provide reference materials and support for NZ teachers who want to target these standards.

=Objective=

The goal here is to provide information that can be shared and re-used in an open way. When we provide links in sub-pages, they can be to both open and commercial resources. We do our best to always provide at least one free / open source alternative. But we see the issue as secondary. Educators are expert in Pedagogical Content. What should be open, in education, is the content. To impose the additional constraint that only open software should be used to edit that content might hinder rather than support the sharing effort. We believe in freedom of choice in that respect.

We cover both basic and advanced skills, considering Computer Programming as key Digital Literacy skill for the 21st century. In the 21st century, where learners can access a huge range of quality resources over the internet, it is perfectly okay for students to go beyond the skills and knowledge of a teacher. To quote the school of webcraft "Younger students often have nowhere to turn if they want to learn web design or development. Serious training often isn’t available until the post-secondary level. Despite the fact that many talented developers [started] early. Matt Mullenweg, for example, created WordPress.com before he could legally drink." To have students engage in activities that a teacher doesn't master himself is not necessarily a problem in the context of Internal Assessment when the criterion for qualification in NZ is achieved / not achieved.

We also try and reflect as much as possible what is being done in the industry rather than what is traditionally taught at school. Rather than provide tutorials on “the use of tables to position text and graphics”, we try and put the NZ standards as they are currently worded in the context of real world practices.

=NZ Standards= Aggregation of data about NZ standards from different sources
 * Source 1 [|Alignments matrics] on the TKI website.
 * Source 3 Data obtained from the csv file on the NCQA page with the [|National Qualifications Framework statistics 2007] (NV).

Fields

 * objective. This information was not provided in any official data. However, it was apparent that each standard was worded with the [|revised bloom taxonomy] (pdf) as a reference.
 * NCEA_Unit captured in the Template:NCEA_Unit, standard Id with link to the NZQA website, standard, area, level, credits, Internal or External
 * achieved-NV2007. This provides some measure of popularity, it captures the NV-achieved data provided in source 3.
 * status. A status of "expiring" indicates that the standard has been marked as so in either source 1 or 3. This can mean that the standard received a new idea between 3 (2007) and 1 (2010) or this can mean that the standard will be removed forever. Double check.
 * source: A source value of "1--" indicates that this unit or achievement standard was found in source 1 but not in source 3.

Data are sorted by level and then learning objective. The information published here can become out of date. Always check an official and turstworthy source of information. Under stdId, a link is provided to a query for this id on the NZQA website. Right click to open the link in a new browser window. Ctl-Click to open in a new tab.


 * objective || domain || focus || NCEA Unit || Achieved-NV2007 || status || source ||
 * apply || apps ||  || 5946|Use computer technology to create and deliver a presentation from given content|Computing|1|3|Internal || 4111 ||   || 1-3 ||
 * apply || web ||  || 18758|Find information using the Internet|Computing|1|2|Internal || 3135 ||   || 1-3 ||
 * create || apps || code || 18739|Create and use simple command sequences in a computer language|Computing|1|2|Internal || 1182 ||  || 1-3 ||
 * create || apps || data || 18743|Produce a spreadsheet from instructions using supplied data|Computing|1|2|Internal || 6182 ||  || 1-3 ||
 * create || web || design || 25659|Create a web page using a mark-up language with a text editor|Computing|1|2|Internal || -1 ||  || 1-- ||
 * create || web || design || 18734|Create a web page using a template|Computing|1|2|Internal || 2537 ||  || 1-3 ||
 * create || apps ||  || 2792|Produce simple desktop published documents using templates|Computing|1|2|Internal || 3528 ||   || 1-3 ||
 * remember || tech ||  || 2798|Demonstrate knowledge of the application and impact of computer technology in an organisation|Computing|2|2|Internal || 185 || expiring || 1-3 ||
 * understand || apps || media || 5960|Demonstrate an understanding of digitising sound for multimedia computer applications|Computing|2|3|Internal || 172 || expiring || 1-3 ||
 * understand || apps || media || 5961|Demonstrate an understanding of digitising still images for multimedia computer applications|Computing|2|3|Internal || 457 || expiring || 1-3 ||
 * understand || apps || media || 5959|Demonstrate an understanding of digitising video for multimedia computer applications|Computing|2|3|Internal || 334 || expiring || 1-3 ||
 * apply || web ||  || 15168|Enhance pages on a website|Computing|2|4|Internal || 970 ||   || 1-3 ||
 * apply || tech || data || 2781|Manage and protect data in a personal computer system|Computing|2|3|Internal || 7101 ||  || 1-3 ||
 * apply || comm ||  || 5942|Exchange information with an online computer service|Computing|2|3|Internal || 188 || expiring || 1-3 ||
 * apply || web ||  || 15168|Enhance pages on a website|Computing|2|4|Internal || 970 ||   || 1-3 ||
 * create || web || code || 15167|Create individual web pages as a basis of a website|Computing|2|2|Internal || 1576 ||  || 1-3 ||
 * create || web || code || 15169|Develop and publish an operational website|Computing|2|3|Internal || 298 || expiring || 1-3 ||
 * create || apps || code || 18740|Create a simple computer program to meet a set brief|Computing|2|3|Internal || 1003 ||   || 1-3 ||
 * create || apps || data || 2791|Integrate spreadsheet and database data into a word processed document to meet a set brief|Computing|2|3|Internal || 2385 ||  || 1-3 ||
 * create || apps || data || 2786|Create and use a computer database to solve a problem|Computing|2|3|Internal || 5278 ||  || 1-3 ||
 * create || apps || data || 2784|Create and use a computer spreadsheet to solve a problem|Computing|2|3|Internal || 7294 ||  || 1-3 ||
 * create || apps || design || 5958|Produce a simple design illustration using a computer application|Computing|2|3|Internal || 999 || expiring || 1-3 ||
 * create || apps || design || 5939|Produce computer graphics using base functions|Computing|2|3|Internal || 4450 || expiring || 1-3 ||
 * create || apps || design || 2788|Produce desktop published documents to meet a set brief|Computing|2|5|Internal || 6163 ||  || 1-3 ||
 * create || web || design || 18735|Create a simple website to meet the specifications of a given brief|Computing|2|3|Internal || 3087 || expiring || 1-3 ||
 * create || web || design || 18736|Create a simple website using a text editor to meet the specifications of a given brief|Computing|2|4|Internal || 1740 || expiring || 1-3 ||
 * create || web || design || 25655|Create a website using a dedicated web-authoring tool to meet a set brief|Computing|2|3|Internal || -1 ||  || 1-- ||
 * create || web || design || 25656|Create a website using a mark-up language to meet a set brief|Computing|2|3|Internal || -1 ||  || 1-- ||
 * create || apps ||  || 5940|Produce a presentation using a desktop presentation computer application|Computing|2|3|Internal || 3541 ||   || 1-3 ||
 * create || apps ||  || 5957|Produce schematic diagrams using a computer application|Computing|2|2|Internal || 460 ||   || 1-3 ||
 * remember || tech ||  || 18746|Demonstrate knowledge of contemporary information technologies|Computing|3|3|Internal || 44 || expiring || 1-3 ||
 * understand || apps || support || 5955|Demonstrate an understanding of documentation for computer applications|Computing|3|5|Internal || 11 ||  || 1-3 ||
 * apply || apps || data || 18756|Use and maintain a computer database for business reporting and decision making|Computing|3|4|Internal || 20 ||  || 1-3 ||
 * apply || apps ||  || 5947|Use computer technology to solve a specified problem|Computing|3|3|Internal || 1214 ||   || 1-3 ||
 * apply || apps ||  || 5965|Work cooperatively using workgroup computer software|Computing|3|3|Internal || 24 || expiring || 1-3 ||
 * create || apps || code || 5954|Automate processes in a computer application using a scripting language|Computing|3|5|Internal || 304 ||  || 1-3 ||
 * create || apps || code || 18741|Create a computer program to provide a solution|Computing|3|6|Internal || 464 ||  || 1-3 ||
 * create || device || code || 5967|Create a computer controlled robot using a kit set|Computing|3|5|Internal || 322 || expiring || 1-3 ||
 * create || device || code || 25660|Create a computer-controlled project|Computing|3|5|Internal || -1 ||  || 1-- ||
 * create || apps || data || 2785|Create a computer spreadsheet to provide a solution for organisation use|Computing|3|5|Internal || 2958 ||  || 1-3 ||
 * create || apps || data || 2787|Create and use a computer database to provide a solution for organisation use|Computing|3|6|Internal || 2435 ||  || 1-3 ||
 * create || apps || design || 18749|Create a simple graphical user interface (GUI) for a computer application|Computing|3|5|Internal || 130 || expiring || 1-3 ||
 * create || apps || design || 18750|Produce a learner focused electronic training package for organisation use|Computing|3|5|Internal || 22 ||  || 1-3 ||
 * create || apps || design || 2789|Produce desktop published documents for organisation use|Computing|3|6|Internal || 2836 ||  || 1-3 ||
 * create || web || design || 25658|Create a website for a stakeholder using a dedicated web-authoring tool|Computing|3|5|Internal || -1 ||  || 1-- ||
 * create || web || design || 25657|Create a website for a stakeholder using a mark-up language|Computing|3|6|Internal || -1 ||  || 1-- ||
 * create || web || design || 18737|Create a website for organisation use|Computing|3|5|Internal || 2313 || expiring || 1-3 ||
 * create || apps || media || 5956|Create images using a computer|Computing|3|3|Internal || 1919 || expiring || 1-3 ||
 * create || apps || media || 5963|Design and assemble a multimedia computer application without scripting|Computing|3|3|Internal || 796 || expiring || 1-3 ||
 * create || apps || media || 25661|Design and assemble an interactive media product without scripting|Computing|3|3|Internal || -1 ||  || 1-- ||
 * create || apps || support || 18751|Produce a computer manual or technical document for organisation use|Computing|3|5|Internal || 4 || expiring || 1-3 ||
 * create || apps ||  || 5953|Create and monitor a project plan using a computer application|Computing|3|3|Internal || 143 ||   || 1-3 ||
 * remember || tech || code || 2796|Demonstrate knowledge of the principles of electronic logic gates in computing|Computing|4|9|Internal || 28 ||  || 1-3 ||
 * understand || apps || media || 5964|Demonstrate an understanding of creating multimedia computer applications with scripting|Computing|4|6|Internal || 4 || expiring || 1-3 ||
 * apply || apps ||  || 5948|Use computer technology to research and present a topic|Computing|4|3|Internal || 51 ||   || 1-3 ||
 * create || web ||  || 18738|Create and operate an interactive website to provide a solution for an organisation|Computing|4|15|Internal || 281 || expiring || 1-3 ||
 * create || apps || data || 18742|Produce a relational database solution for organisational use|Computing|4|8|Internal || 41 ||  || 1-3 ||
 * create || apps || support || 18757|Develop a simple online help system to provide a solution for an organisation|Computing|4|15|Internal || -1 || expiring || 1-- ||
 * create || apps ||  || 2795|Create and operate a computer program to provide a solution for an organisation|Computing|4|15|Internal || 12 ||   || 1-3 ||
 * create || web ||  || 18738|Create and operate an interactive website to provide a solution for an organisation|Computing|4|15|Internal || 281 || expiring || 1-3 ||

Topics

 * Create a simple computer program, s18740
 * Create a (complex) computer program, s18741
 * Create a user interface (GUI), s18749
 * Create a simple website
 * Create a (complex) website
 * Create (static) multimedia content
 * Create interactive multimedia content
 * Robots, Controllers and Sensors
 * Data Storage and Manipulation

Possible course structures
National Certificate in Computing
 * [|relevant pages @ NZQA]

Use Google. For instance, a search with [|"Year 12 Computing"] will return results like:
 * [|Year 12 Computing Technology 2010 Topic Plan @ Rosehill College]
 * [|Year 12 computing @Katikati College Community* [|Level 2 computing @ Eastern Institute of Technology]

Environments

 * Mobile: Developing Content_for Mobile Devices
 * Virtual Worlds: [|Sloodle] (Second Life + Moodle)

Related WikiEducator Pages

 * [|Knowledge of a Personal Computer System]
 * [|Secondary Education Certificate - Information Technology]
 * [|1DIG (Level 1 Digital Technologies) at Albany High]
 * [|1DIG (Level 2 Digital Technologies) at Albany High]
 * [|1DIG (Level 3 Digital Technologies) at Albany High]
 * [Computing|Open Computing]
 * [|Computing Terms Glossary]
 * []
 * []