AS 91902 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, 186 KB]

TKI Digital Technologies assessment resources (external link)

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

This involves:

• iterative improvement throughout the design, development and testing process
• using efficient tools and techniques in the outcome’s production
• presenting the data effectively for the purpose and end-users.

There is no student work currently available at this grade.

The student shows iterative improvement by trialling and testing alternative ways of making components of the database or adding new features. Iterative improvement will involve deliberate cycles and focus on the reliability and functionality of the database, resulting in a substantially improved outcome. For example, the student included trialling and improving the interface, data tables/nodes, queries, input forms and output forms.

The student showed how they used efficient tools and techniques in producing the database. For example:

• they applied version control methods
• their testing was planned and systematic, not trial and error
• the student used “includes” to make efficient use of PHP scripts
• the student created relationship diagrams before implementing the table structure
• the student created queries that use input parameters so that scripts do not have to be duplicated.

The student showed how they have effectively presented the data. For example:

• they ensured that the data was presented in such a way that it was able to be analysed and searched (e.g. drop-down lists and checkboxes where appropriate) and the data is easily understood
• there are very few grammatical or typographical errors
• the layout demonstrates the application of design principles.

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

This involves:

• using information from testing procedures to improve the quality of the outcome
• structuring, organising and querying the data logically.

There is no student work currently available at this grade.

The student has thoroughly tested the database and made significant improvements to the operation of the database as a result. This is more than correcting errors in the database. For example, the student has tested and revised the interface, data nodes, queries, input forms or output forms and improved their functionality and layout.

The student has logically structured, organised and queried the data. For example:

• the database output is displayed in a logical order that is easy to read and understand
• the queries make it easy to find items in the database both for users looking for items and for admins who might want to delete/edit a given item
• the form has been edited so that the input types restrict the input to what is allowable, in order to improve accuracy of the data and efficiency for the user
• the database structure has minimised repeated data (normalised).

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

This involves:

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

There is no student work currently available at this grade.

The student has produced a database plan which includes at least two linked tables, shows the structure of the tables, shows the designs for the input and output interfaces, planned queries and a plan for linking the tables. They have used at least two complex techniques from the list in EN4.

The student has used appropriate tools and 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 which allows users to add data to the database via a website
• allowed different levels of authorised users to add, edit and delete information in the database.

Data integrity and testing has been applied and shows that the database functions as intended, and that the data is relevant for the intended purpose and end-user.

Testing shows that the data in the database is correct, including data being validated before it is added to the database to prevent obviously invalid material from being inserted (e.g., blank records), and that adding material to the database works correctly and that the various queries returned the expected results.

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