Question 1

What is NCEA AS 91633 about?

Accepted Answer

This standard asks you to build a working relational database that's connected to another application (like a spreadsheet or website) and meets a set of specifications you've agreed on beforehand. You'll need to design the database structure, write queries to pull and change data, create forms for entering data, and make sure the data stays accurate and secure throughout.

Question 2

What do students need to do for AS 91633?

Accepted Answer

1. Design and build a database with multiple related tables that are properly structured and organized 2. Create queries that pull data from more than one table and that can insert, update, or delete information 3. Set up a system so data can be entered or changed from another application (spreadsheet, web form, or custom program) 4. Build customized input forms and data displays (reports, PDFs, or web pages) that look professional and work correctly 5. Test and verify that your data is accurate, valid, and meets the original specifications, with appropriate access controls in place

Question 3

What's the difference between Achieved, Merit, and Excellence for AS 91633?

Accepted Answer

Achieved: You build a working relational database that meets the agreed specifications, with multiple tables, working queries, links to another application, and proper data integrity checks. Merit: Your database design is accurate and well-organized; your queries and forms work reliably; and you make independent decisions about how to structure and present the data without needing constant guidance. Excellence: Your database is efficiently designed to eliminate wasted space and repetition; you use shortcuts like macros and buttons to streamline data entry; and the overall system minimizes unnecessary work while staying fully functional.

Question 4

What mistakes do students typically make in AS 91633?

Accepted Answer

1. Students create a database that doesn't actually connect to or communicate with another application (like a spreadsheet or web form), missing this core requirement 2. Table structures contain redundant or duplicated data that should have been split into separate related tables 3. Queries are either missing, incomplete, or don't actually combine data from multiple tables as required

Relational database · AS 91633

Documents (9)

The standard itself

Bundles

More in this subject

Other Technology - Digital Technologies and Hangarau Matihiko standards · Level 3 · Year 13

Foundations — Technology - Digital Technologies and Hangarau Matihiko Level 2 · Year 12

Related standards