Data Types, Privacy Principles, and Programming Concepts for Students

What type of data is most suitable to collect during an interview?

Qualitative data

What type of data is commonly collected using sensors?

Health monitoring data

What data type includes integers, floating point, and date/time values?

Numeric data type

What factor affects data quality when survey questions are biased?

Bias

Which Australian Privacy Principle relates to protecting personal information from misuse or loss?

APP 11

What ethical issue occurs when personal data is collected without consent?

Misuse of personal data

Why is APA referencing important?

To acknowledge intellectual property and maintain academic integrity

What does IPO stand for?

Input-Process-Output

What is a structural characteristic of an RDBMS?

Tables and queries

Which spreadsheet function is commonly used for descriptive statistics?

COUNT

What does encapsulation in OOP mean?

Bundling data and methods into a single unit

What is the best data type for storing a phone number?

Text

What do arrays and lists both do?

Store multiple data items

What naming convention is myVariableName?

Camel casing

What validation technique checks if a value is between 0 and 100?

Range check

What is the purpose of internal documentation?

To explain code structure

Which design tool is used for graphical user interfaces?

Mock-up

What is debugging?

Fixing errors in code

What do control structures determine?

The flow of execution in a program

What is a benefit of low-code development platforms?

Applications can be created faster with less coding

What is a Boolean data type?

A data type with only two possible values such as true/false

What is qualitative data?

Non-numerical descriptive data

What is quantitative data?

Numerical data that can be measured

Difference between qualitative and quantitative data?

Qualitative is descriptive, quantitative is numerical

Why are the Australian Privacy Principles important?

They help protect personal information and ensure proper data handling

Example of APP use?

A company securely storing customer details to prevent data leaks

What does the size characteristic of data refer to?

The amount of data being stored or measured

What is accessibility in data?

How easily users can access information

Example of accessibility?

A website that can be used by people with disabilities

What is accuracy in data?

How correct and error-free the data is

Example of accurate data?

A correctly recorded birth date

What is abstraction in OOP?

Hiding unnecessary details and showing only important features

How do naming conventions benefit software projects?

They improve readability and make code easier to maintain

Three tasks completed during testing besides fixing errors?

Check functionality, test user input, and verify outputs

Two legal requirements in software development?

Copyright law and privacy law

Why must software developers consider copyright law?

To avoid illegally copying code or content

Why must software developers consider privacy law?

To protect user data and follow legal requirements

Why would organisations use both surveys and sensors for data collection?

To collect both personal opinions and accurate real-time measurements

Why is data quality important?

Accurate data leads to better decisions and reliable analysis

Why is complete data important?

Missing data can lead to incorrect conclusions

Spreadsheet formula for median?

=MEDIAN(range)

Spreadsheet formula for standard deviation?

=STDEV(range)

What is a primary key in a database?

A unique identifier for each record

What is a foreign key in a database?

A field that links tables together

What is a relationship in an RDBMS?

A connection between tables using keys

Two components of data visualisation?

Titles and labels

Why are data visualisations useful?

They make trends and patterns easier to understand

What is an attribute in OOP?

A variable that stores data about an object

What is a method in OOP?

A function associated with an object

Example of an attribute in a resident health system?

Age or weight

Example of a method in a resident health system?

Calculate BMI

Difference between arrays and records?

Arrays store one type of data, records store multiple related data types

What is a selection control structure?

A decision-making structure such as IF statements

What is an iteration/repetition control structure?

A loop that repeats instructions

Difference between a function and a procedure?

A function returns a value, a procedure does not

One advantage of functions and procedures?

Code can be reused more easily

What is Hungarian notation?

A naming convention that includes data type prefixes

How would Gender be written in Hungarian notation if it is text?

strGender

How would Age be written in Hungarian notation if it is numerical?

intAge

How does internal documentation help future maintenance?

It helps programmers understand and update the code later

What is the purpose of validation?

To ensure data entered is sensible and correct

What does an existence check do?

Checks that data has been entered

What does a type check do?

Checks that the correct data type is entered

What is a breakpoint in debugging?

A pause point used to inspect code while it runs

What error exists in the calculate_average_weight pseudocode?

total_weights should be total_weight

Why use a breakpoint in debugging?

To inspect variable values and identify where errors occur

What is sequence in programming?

Instructions executed in order

What is selection in programming?

Code that makes decisions based on conditions

What is iteration in programming?

Code that repeats using loops

What is a relational database?

A database made of related tables

What is a query in a database?

A request for specific information from a database

What is a field in a database?

A category of data in a table

What is a record in a database?

A complete set of related fields

What is a spreadsheet used for?

Organising, analysing, and calculating data

What is object-oriented programming?

A programming style based on objects and classes

What is a class in OOP?

A blueprint for creating objects

What is an object in OOP?

An instance of a class

Why is testing important in software development?

To ensure software works correctly and reliably

What is a mock-up?

A visual design of a user interface

What is pseudocode?

A simplified way of planning program logic

What is a flowchart?

A diagram showing program steps and decisions

What is a range check?

A validation that checks if data falls within limits

What is a format check?

A validation that checks data follows a pattern

What is an existence check?

A validation that checks a field is not empty

What is a type check?

A validation that checks correct data type input