Level 3 programming assessment 2026

• A summative assessment is used to determine your grade for an achievement standard.
• After you submit, your work will be marked, moderated, and grades will be uploaded to KAMAR.
• It is held under real assessment conditions — any violations result in an instant Kāore i whīwhī/Not Achieved grade

• 🗓️ You have five (5) spells in which to complete your task.
  • 🏫 You may work on this assignment at home.
  • 🕰️ Due to being able to work on this at home, no Extra Time will apply.
• 💬 You may not communicate with anybody other than your kaiako
  • 🚻 If you need to use the bathroom, let your kaiako know
  • 🚾 You will not be allocated extra time to compensate for your absence
• 🌎 You may consult the web, API documentation, etc.
  • You may also consult:
    • the resources posted to this website
    • the cheat sheet
    • your previous code from this and last year
    • you can use offline documentation from Zeal (Windows, Linux) or Dash (macOS)
      • on the school computers, you must use the portable version of Zeal
      • on your own devices, you can use the Zeal installer
• 📖 You must not submit code that you did not 100% write as your own. This includes:
  • code copied from your neighbours
  • code you get help with from outside sources (whānau, friends)
  • code generated by a large language model (Copilot, ChatGPT, etc.)

Failure to adhere to these conditions will result in an instant Kāore i whīwhī/Not Achieved grade. You will then need to reassess as part of project management.

Use complex programming techniques to develop a computer program involves:

• writing code for a program that performs a specified task
• using complex techniques in a suitable programming language
• setting out the program code clearly and documenting the program with comments
• testing and debugging the program to ensure that it works on a sample of expected cases

A complex computer program:

• uses variables storing at least two types of data (e.g. numeric, text, Boolean)
• uses sequence, selection and iteration control structures
• takes input from a user, sensors, or other external source
• produces output
• uses two or more complex programming techniques

• programming or writing code for a graphical user interface (GUI)
• reading from, or writing to, files or other persistent storage
• object-oriented programming using class(es) and objects defined by the student
• using types defined by the student
• using third party or non-core API, library or framework
• using complex data structures (e.g. stacks, queues, trees)

Use complex programming techniques to develop an informed computer program involves:

• documenting the program with appropriate names and comments that describe code function and behaviour
• following common conventions for the chosen programming language
• testing and debugging the program effectively to ensure that it works on a sample of both expected cases and relevant boundary cases

Use complex programming techniques to develop a refined computer program involves:

• ensuring that the program is a well-structured, logical response to the specified task
• making the program flexible and robust
• comprehensively testing and debugging the program

Use complex techniques to develop a database involves:

• designing the structure of the data
• using appropriate tools and appropriate techniques to organise, query and present data for a purpose and end users
• applying appropriate data integrity and testing procedures
• addressing relevant implications (you will get this for free)

Use complex techniques to develop an informed database involves:

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

Use complex techniques to develop a refined database 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

Complex techniques will include a selection from:

• structuring the data using multiple tables or nodes
• creating queries which insert, update or delete to modify data
• creating customised data displays from multiple tables or nodes (e.g. reports, PDFs, web pages, dashboards, program interfaces)
• dynamically linking data between the database and a front-end display
• applying data access permissions as appropriate to the outcome

The program must allow the user to:

• add new items
• register borrowers/users
• lend or issue an item
• return an item
• view available and unavailable items
• search items or borrowers
• edit item or borrower records
• delete records where appropriate

• Each item that can be loaned must have at least THREE (3) data points and some way to identify it (in case of items with the same name). You will also need to store information about the borrowers and their loans.
• Your program must use a combination of at least TWO (2) complex techniques:
  • OOP + Database: Structs + database-backed lending system
  • OOP + functional programming: Structs + in-memory (hard-coded) borrowing system with map, filter, and reduce
  • Database + functional programming: Database-backed system using structs/functions and map, filter, and reduce
• The program must remain complete and functional even if one of the three approaches is not used.
• Students may partially use a third technique (i.e. those doing OOP + Database can also make use of map, filter, or reduce), but only TWO (2) are required for Paetae/A.

You should test at least the following parts of the program, regardless of which complex programming techniques you use:

For those attempting AS91902, you will need to also record evidence of errors occurring purely within your database. You can use the SQLite editor to test:

Before you submit, make sure that you have:

1. Committed and pushed/synced/published your code to GitHub.
2. Downloaded a copy of your completed code from your GitHub repository (Code -> Local tab -> Download ZIP), and attached this to your Google Classroom assignment.
   • If you only submit main.swift or SwiftPlayground.swift, I will not mark your work.
3. Filled in the testing table with at least TWENTY (20) lines of testing.
4. Turned in your Google Classroom assignment.

If you don’t publish/sync your branch and there is a problem with your submitted Google Classroom assignment, do not beg for an extension. You will be laughed out of the room.

• Cheat sheet
• GRDB Setup
• Swift programming language documentation
• Swift standard library documentation