Generate Code#

Tools use:

  • QT Designer

  • Annotated code

For Units 1 to 4#

In generating code we will need to use the following programming features and operations:

  • Basic Features of Programming

    • Variables

    • Functions

    • Control Structures

    • Data Structures

    • Syntax

    • Libraries

    • Classes

  • Operations

    • Arithmetic operators

    • Assignment operators

    • Comparison operators

    • Logical operators

    • Identity operators

    • Membership operators

For Units 3 to 4#

In addition to the programming features from Unit 1, we will also need to use the following Structured Query Language (SQL) features:

  • Retrieving data

    • WHERE

    • GROUP BY

    • HAVING

    • ORDER BY

    • COUNT

    • MIN

    • MAX

    • AVG

    • IN

    • inner-joins

    • sub-queries

  • Creating tables and modify stored data:

    • CREATE

    • INSERT

    • UPDATE

    • DELETE

We will also need to use the SQLite3 Python package to interface with an SQL database.

Unit 1 subject matter covered:

  • generate user interfaces by investigating and applying useability principles

  • explore the use of a procedural text-based language for writing and modifying code and using existing code blocks or statements

  • explore the use of a procedural text-based language for interpreting programming language rules and syntax

  • explore the use of a procedural text-based language for analysing and critiquing the end result of code statements using input or output evidence, i.e. runtime evidence

  • explore functions and procedures with efficient and maintainable code that includes reuseable coded components

  • explore functions and procedures with efficient and maintainable code that responds to keyboard and mouse events

  • explore functions and procedures with efficient and maintainable code that uses variables, selection structures, counted loops, while loops and single, multi-branch and nested conditional logic/statements

  • explore functions and procedures with efficient and maintainable code that uses operators, including arithmetic (+, –, *, /, integer, modulus, exponent), comparison (<, >, <=, >=, equal, not equal) and logical (AND, OR, NOT)

  • explore the purpose of code statements by writing code and using existing code blocks or statements

  • explore object/event triggers and develop explanations about their effect/s on user interfaces

  • apply the use of arithmetic operators: +, –, *, /, integer, modulus, exponent

  • apply the use of comparison operators: <, >, <=, >=, equal, not equal

  • apply the use of logical operators: AND, OR, NOT

  • output information to the screen in text-based or visual formats

  • generate components of a solution by using existing code or writing new code statements

  • generate modified code in response to new or existing information

  • generate functions/procedures with efficient and maintainable code that includes reuseable code blocks or statements and responses to keyboard and mouse events

  • generate Selection structures, counted loops, while loops, and single, multi-branch and nested conditional logic statements

  • generate local and global variables

  • generate a prototype digital solution in response to a problem [QCAA, 2017]

Unit 2 subject matter covered:

  • generate SQL SELECT statements, including WHERE, GROUP BY, HAVING, ORDER BY, COUNT, MIN, MAX, AVG, IN, inner-joins and sub-queries to retrieve appropriate data from existing databases

  • generate SQL CREATE, INSERT, UPDATE and DELETE statements to create database tables and views, and modify stored data

  • generate a prototype digital solution to access, manipulate and display data in an interactive media that enables data to be inserted, inserted, retrieved and deleted from single and multiple tables

  • generate a prototype digital solution to access, manipulate and display data in an interactive media that validates the data to be entered for reliability to ensure that the data is valid for use and storage

  • generate a prototype digital solution to access, manipulate and display data in an interactive media that includes user interfaces that will enable the insertion, updating and Selection of data from/to a database

  • generate a prototype digital solution to access, manipulate and display data in an interactive media that creates procedural code to control user interaction, data validation, execution of SQL queries, manipulation and display of query results through the user interface [QCAA, 2017]

Unit 3 subject matter covered:

  • explore methods of synthesising user interface, processing and data components to generate a prototype digital solution

  • generate code that creates, reads, writes, opens and closes a file

  • generate program modules that interact with users

  • generate program modules that interact with 2D data sources

  • generate program modules that validate data inputs

  • generate program modules that control the interactions in a digital solution

  • synthesise user interface, processing and data components to generate a prototype digital solution [QCAA, 2017]

Unit 4 subject matter covered:

  • Synthesise information and ideas to determine prototype components of data exchange solutions

  • generate a prototype digital solution that uses appropriate data structures including JSON or XML, to exchange data

  • manipulate data from an external source

  • generate within programmed methods use of data types, error-checking functions and conversions

  • generate within programmed methods use of structures, including one-dimensional collections, e.g. arrays and lists [QCAA, 2017]