AS 91892 Annotated exemplars

This annotated exemplar is intended for teacher use only. Annotated exemplars are extracts of student evidence, with commentary, that explain key parts of a standard. These help teachers make assessment judgements at the grade boundaries.

Download all exemplars and commentary [PDF, 202 KB]

TKI Digital Technologies assessment resources (external link)

For Excellence, the student needs to use advanced techniques to develop a refined database.

This involves:

• iterative improvement throughout the design, development and testing process
• presenting the data effectively for the purpose and end-users.

Full samples of student evidence are available in our online Learning Management System, Pūtake.

The student has shown iterative improvement by trialling and testing alternative ways of making database components or adding new features. Iterative improvement involves employing deliberate cycles and focusing on the reliability and functionality of the database, resulting in its substantial improvement. For instance, the student included trialling and improving of the interface, data tables, queries, and input and output forms.

The student has effectively presented their data. For example:

• there are no grammatical/typographical errors
• the layout demonstrates effective application of design principles
• the selection/sorting features of the database are obvious
• there are customised presentation displays for various queries, to better display the data.

For Merit, the student needs to use advanced techniques to develop an informed database.

This involves:

• using information from testing procedures to improve the quality of the database
• structuring, organising and querying the data logically
• addressing relevant implications.

Full samples of student evidence are available in our online Learning Management System, Pūtake.

The student has thoroughly tested the database and made significant improvements to its operation as a result.

This extends beyond correcting errors in the database, as the student has tested and revised the interface, tables, queries, input/output forms, and has improved functionality and layout.

The student has logically structured, organised and queried the data. For instance,
the database is easy to use, the output display is in a logical, easy-to-read order, and it includes queries to make it easy to filter and extract required data.

The student has shown how their database addresses at least two relevant implications. This could include how they have addressed privacy concerns and met end-user considerations.

For Achieved, the student needs to use advanced techniques to develop a database.

This involves:

• designing the structure of the data
• using appropriate tools and advanced techniques to organise, query and present data for a purpose and end-users
• applying appropriate data integrity and testing procedures
• explaining relevant implications.

Full samples of student evidence are available in our online Learning Management System, Pūtake.

The student has a provided a database plan which includes the data structure (e.g. tables that will be used and how the data in these tables will be linked), planned queries, datatypes and formatting. They have used at least two advanced techniques from the list in Explanatory Note 4.

The student has used appropriate tools and advanced techniques to organise, query and present data for a purpose and end-users. For example, they have:

• used appropriate data types and data formatting
• written a custom query to filter and/or sort data
• created a form that allows users to add to the database
• used mathematical and/or wildcard operators.

Data integrity and testing shows that the database functions as intended, and that the data are relevant for the intended purpose and end-users. Evidence includes testing to show that data in the database are correct. For instance, validating data before they are added to the database (therefore avoiding obviously invalid material, e.g. blank records), and testing to show that adding material works correctly (e.g. that various queries return expected results).

The student explained at least two identified relevant implications for their database, e.g. privacy concerns and intellectual property requirements. They have explained what the relevant implication is, why it is relevant to their database, and how they might address the implication in the database.