WA Computer Science ATAR Year 11 — Data Management
Designing relational databases and querying them with SQL.
Modules (117)
1
Data and information
2
Text data: character and string
3
Numeric data: integer
4
Numeric data: floating point
5
Date/time data
6
Boolean data
7
Choosing a data type for a value
8
One-dimensional arrays
9
Two-dimensional arrays
10
Records: grouping fields of different data types
11
Choosing a data structure
12
Delimited (CSV) files: structure
13
Plain text (TXT) files: structure
14
XML files: structure
15
Dataset file formats: CSV, XLSX, JSON and XML
16
Reasons for using TXT, CSV and XML data sources
17
Characteristic of data: structure
18
Same data, different representations
19
Why use a database instead of a spreadsheet
20
What is a relational database?
21
Database objects: table, query, form and report
22
Entity
23
Attributes become fields
24
Database field data types
25
Field sizes
26
Primary key
27
Choosing a suitable primary key from a table
28
Composite primary keys
29
Foreign key and table relationships
30
One-to-many relationships between tables
31
One-to-one and many-to-many relationships
32
Referential integrity
33
Entity relationship diagram: entities and relationship lines
34
Crow's foot notation for one and many
35
Drawing an ERD from a scenario
36
Designing a table structure
37
Naming a database and its tables
38
Naming columns, primary keys and foreign keys
39
Data dictionary
40
Writing a data dictionary entry
41
Defining a single-table database from storage requirements
42
The repeated-data problem in one big table
43
Insertion, update and deletion anomalies
44
Functional dependency and determinants
45
First normal form (1NF)
46
Second normal form (2NF)
47
Third normal form (3NF)
48
Normalising a table step by step to 3NF
49
What SQL is
50
SQL column data types and sizes
51
CREATE TABLE and INSERT INTO
52
FOREIGN KEY ... REFERENCES in CREATE TABLE
53
SQL constraints for validation
54
What data validation is and why it matters
55
Validation rules on database fields
56
Importing a CSV file into a database table
57
Running an SQL query in a database tool
58
SQL UPDATE and DELETE
59
SQL SELECT and FROM
60
Field order in the output of a SELECT
61
SQL WHERE conditions
62
WHERE on text, Boolean, character and date fields
63
Boolean operators AND, OR and NOT in a WHERE clause
64
Mixing AND and OR with brackets in a WHERE clause
65
BETWEEN and IN in a WHERE clause
66
SQL LIKE with the % wildcard
67
NULL values and IS NULL
68
SQL ORDER BY
69
How a field's data type changes sorting
70
Clause order in a full SQL query
71
SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX
72
SUM and COUNT with a WHERE condition
73
SQL GROUP BY
74
Why a query over two tables needs a join
75
Writing the ON condition: foreign key equals primary key
76
Table-qualified field names in a join
77
Table aliases in a join
78
A join with WHERE and ORDER BY
79
Joining three tables
80
A join that forgets the ON condition
81
Answering a question with a multi-table query
82
Writing an SQL query from a requirement
83
Describing what a query does in plain English
84
Working out the output of an SQL statement
85
Common mistakes in SQL scripts
86
Completing an SQL script
87
Testing a query against the data
88
Exporting query results for use in a spreadsheet
89
Personal data
90
Sensitive information
91
Privacy Act 1988 (Cwlth)
92
Who must follow the Privacy Act: APP entities
93
The 13 APPs grouped by stage of the data lifecycle
94
Consent when collecting personal data
95
APP 3: collecting only what is reasonably necessary
96
APP 5: notifying people when collecting data
97
Australian Privacy Principle 6
98
APP 8: sending personal data overseas
99
APP 10: quality of personal information
100
Australian Privacy Principle 11
101
APP 12 and 13: access to and correction of personal information
102
The OAIC and making a privacy complaint
103
Risks of collecting and keeping too much data
104
Deleting data that is no longer needed
105
Security measures to protect personal information
106
User permissions: read, write and execute
107
Backup strategies
108
Secure disposal of files and storage media
109
Data breach
110
Privacy Amendment (Notifiable Data Breaches) Act 2017
111
Applying the Notifiable Data Breaches scheme to a scenario
112
Anonymising data
113
Ethical issue: misuse of personal data and information
114
Ethical issue: ownership and control of data
115
Ethical issue: use of inaccurate or incomplete data
116
Respectful data collection and Indigenous data sovereignty
117
Analysing an ethical issue in a data scenario
Smaller journeys, one per content description
The same modules, split up so a class can take just the content description it's working on.
19
Year 11 Computer Science ATAR: Data representation and organisation
Students learn how data becomes information, how it is typed, structured and stored in files, and why databases suit large collections of data.
22
Year 11 Computer Science ATAR: Relational database design
Students learn to design relational databases using entities, attributes, keys, relationships, entity relationship diagrams and data dictionaries.
7
Year 11 Computer Science ATAR: Normalisation to 3NF
Students learn why redundant data causes anomalies and how to remove it by taking tables through first, second and third normal form using functional dependencies.
40
Year 11 Computer Science ATAR: Building and querying a database with SQL
Students create tables with keys and constraints, insert, update and delete data, and write queries using WHERE, ORDER BY, aggregates, GROUP BY and joins.
29
Year 11 Computer Science ATAR: Legal and ethical responsibilities for data
Students learn the privacy law, security practices and ethical principles that govern how personal data is collected, stored, used and protected.
Printables for this journey
Every module above has its own free printable worksheet with an answer key. These crosswords and word searches cover the same terms:
✎
VCE Cyber Security Crossword: Worms to Operating system updates (Modules 31–40)
10 clues · Worms, Ransomware, Denial of service attacks, Improper credential management and more
✎
VCE Cyber Security Crossword: ISM guideline: confidentiality and integrity of wireless traffic and more (Modules 61–74)
10 clues · ISM guideline: confidentiality and integrity of wireless traffic, ISM guideline: wireless network footprint, Privacy Act 1988 (Cwlth), Australian Privacy Principle 1 and more
🔎
VCE Cyber Security Word Search: Local Area Networks (LANs) to Operating system updates (Modules 21–40)
20 words to find · Local Area Networks (LANs), Wide Area Networks (WANs), Wireless Personal Area Networks (WPANs), Global exposure to cyber security threats and more
🔎
VCE Cyber Security Word Search: Software malware updates to Information Privacy Principle 5 (Modules 41–74)
22 words to find · Software malware updates, Staff procedures, Encryption and decryption, Caesar cipher and more
✎
Years 5–6 Data & Information Crossword: Data, information and binary representation (Modules 1–10)
10 clues · Data and information, Types of data: numbers and text, Types of data: images, sound and video, Same data, different representations and more
✎
Years 5–6 Data & Information Crossword: Analysing and visualising data and Digital footprint and privacy (Modules 31–56)
10 clues · Choosing the right chart, Column and bar charts, Line charts, Pie charts and more
🔎
Years 5–6 Data & Information Word Search: Data, information and binary representation and Acquiring and manipulating data (Modules 1–20)
20 words to find · Data and information, Types of data: numbers and text, Types of data: images, sound and video, Same data, different representations and more
🔎
Years 5–6 Data & Information Word Search: Acquiring and manipulating data to Digital footprint and privacy (Modules 21–56)
20 words to find · Cleaning data, Formulas start with =, Arithmetic operators + - * /, The SUM function and more
✎
Years 7–8 Digital Systems Crossword: Data transmission and network security and Account security and cyber threats (Modules 26–74)
10 clues · Comparing wired and wireless networks, Wi-Fi range and interference, HTTPS and the padlock, Securing a Wi-Fi network and more
🔎
Years 7–8 Digital Systems Word Search: Hardware for particular tasks to Account security and cyber threats (Modules 4–74)
20 words to find · CPU clock speed (GHz), CPU cores, HDD vs SSD performance, Storage units: KB, MB, GB, TB and more
✎
Years 9–10 Digital Systems Crossword: Controlling and securing access to data (Modules 13–24)
10 clues · Confidentiality, Integrity, Availability, Authentication vs authorisation and more
🔎
Years 9–10 Digital Systems Word Search: Controlling and securing access to data and Threats and software vulnerabilities (Modules 13–40)
20 words to find · Confidentiality, Integrity, Availability, Authentication vs authorisation and more
✎
VCE Data Analysis Crossword: Types and purposes of data and Data types and data characteristics (Modules 15–24)
10 clues · Open data portals and data licences, Text data: character and string, Numeric data: integer, Numeric data: floating point and more
✎
VCE Data Analysis Crossword: Data types and data characteristics to Privacy and the Australian Privacy Principles (Modules 25–37)
10 clues · Characteristic of data: accessibility, Characteristic of information: clarity, Characteristic of information: context, Data quality: accuracy and more
✎
VCE Data Analysis Crossword: Privacy and the Australian Privacy Principles and Ethics and APA referencing (Modules 38–54)
10 clues · APP 2: anonymity and pseudonymity, Holding information only for its primary purpose, Security measures to protect personal information, Critiquing a system against the Australian Privacy Principles and more
🔎
VCE Data Analysis Word Search: Types and purposes of data and Data types and data characteristics (Modules 3–24)
20 words to find · Quantitative data, Qualitative data, Purposes of qualitative and quantitative data, Interviews to gather perspectives on a topical issue and more
🔎
VCE Data Analysis Word Search: Data types and data characteristics to Ethics and APA referencing (Modules 25–54)
20 words to find · Characteristic of data: accessibility, Characteristic of information: clarity, Characteristic of information: context, Data quality: accuracy and more
✎
VCE Spreadsheets, SQL & Visualisation Crossword: Descriptive statistics and Manipulating, validating and testing spreadsheet data (Modules 21–34)
10 clues · Grouping numbers into bins with COUNTIFS, The STDEV.S function, Interpreting standard deviation, Cleaning text with TRIM, UPPER and PROPER and more
✎
VCE Spreadsheets, SQL & Visualisation Crossword: Manipulating, validating and testing spreadsheet data and Relational database structure (Modules 35–44)
10 clues · Pivot tables, What is a relational database?, What a single-table database is, Database field data types and more
✎
VCE Spreadsheets, SQL & Visualisation Crossword: Relational database structure and Querying data with SQL (Modules 45–54)
10 clues · Importing a CSV file into a database table, Validation rules on database fields, SQL constraints for validation, What a database query is and more
✎
VCE Spreadsheets, SQL & Visualisation Crossword: Querying data with SQL to Purposes and types of data visualisations (Modules 55–70)
10 clues · SQL GROUP BY, SQL JOIN across two tables, SQL UPDATE and DELETE, Testing a query against the data and more
🔎
VCE Spreadsheets, SQL & Visualisation Word Search: Spreadsheet structure, formulas and functions to Manipulating, validating and testing spreadsheet data (Modules 4–34)
20 words to find · Naming worksheets consistently, Header labels for rows and columns, Relative and absolute cell references, The COUNTIF function and more
🔎
VCE Spreadsheets, SQL & Visualisation Word Search: Manipulating, validating and testing spreadsheet data to Querying data with SQL (Modules 35–54)
20 words to find · Pivot tables, What is a relational database?, What a single-table database is, Database field data types and more
🔎
VCE Spreadsheets, SQL & Visualisation Word Search: Querying data with SQL to Visualisation components and design conventions (Modules 55–86)
20 words to find · SQL GROUP BY, SQL JOIN across two tables, SQL UPDATE and DELETE, Testing a query against the data and more
✎
VCE Software Development U3O1 Crossword: Requirements and design tools to Naming conventions and internal documentation (Modules 10–47)
10 clues · Data dictionary, Writing a data dictionary entry, Designing classes with a class diagram, Object descriptions and more
✎
VCE Software Development U3O1 Crossword: Pseudocode to Data structures (Modules 72–96)
10 clues · Turning pseudocode into Python, Changing a global variable with the global keyword, Functions calling other functions, Program structure with a main() function and more
✎
VCE Software Development U3O1 Crossword: Data structures and Data sources and files (Modules 98–113)
10 clues · Records: fields with different data types, Accessing a record's fields by name and by field index, Choosing a data structure, Plain text (TXT) files: structure and more
🔎
VCE Software Development U3O1 Word Search: Requirements and design tools to Pseudocode (Modules 10–71)
21 words to find · Data dictionary, Writing a data dictionary entry, Designing classes with a class diagram, Object descriptions and more
🔎
VCE Software Development U3O1 Word Search: Pseudocode to Data sources and files (Modules 72–113)
21 words to find · Turning pseudocode into Python, Changing a global variable with the global keyword, Functions calling other functions, Program structure with a main() function and more
✎
VCE Software Development U3O2 Crossword: Analytical tools and the software requirements specification and Legal requirements for copyright, ownership and privacy (Modules 52–71)
10 clues · Purpose of a software requirements specification (SRS), SRS content: requirements, constraints and scope, SRS content: user characteristics and technical environment, SRS content: analytical tools depicting existing systems and more
✎
VCE Software Development U3O2 Crossword: Legal requirements for copyright, ownership and privacy to Ideation and evaluating design ideas (Modules 72–85)
10 clues · IPP 10: sensitive information, File naming, shared folders and version history, Version control for software projects, Full backup and more
🔎
VCE Software Development U3O2 Word Search: Analytical tools and the software requirements specification to Ideation and evaluating design ideas (Modules 52–85)
20 words to find · Purpose of a software requirements specification (SRS), SRS content: requirements, constraints and scope, SRS content: user characteristics and technical environment, SRS content: analytical tools depicting existing systems and more
✎
VCE Data Analytics U3O1 Crossword: Data types and relational databases to Sourcing, validating and referencing data (Modules 17–49)
10 clues · Field sizes, SQL column data types and sizes, One-to-many relationships between tables, Boolean operators AND, OR and NOT in a WHERE clause and more
🔎
VCE Data Analytics U3O1 Word Search: Data types and relational databases to Statistical analysis of data (Modules 17–91)
20 words to find · Field sizes, SQL column data types and sizes, One-to-many relationships between tables, Boolean operators AND, OR and NOT in a WHERE clause and more
✎
VCE Data Analytics U3O2 Crossword: Collecting primary and secondary data to Data integrity (Modules 32–75)
10 clues · Searching with keywords and search operators, Searching and filtering a data repository, One-dimensional arrays, Records: grouping fields of different data types and more
✎
VCE Data Analytics U3O2 Crossword: Data integrity to Evaluating designs and design tools (Modules 76–146)
10 clues · Data integrity: reasonableness, Data integrity: timeliness, Participant information statement, Consent form and more
🔎
VCE Data Analytics U3O2 Word Search: Research questions and project planning to Evaluating designs and design tools (Modules 3–146)
21 words to find · What a research question is, Research question feature: clarity, Research question feature: measurability of data requirements, Research question feature: feasibility and more
✎
VCE Data Analytics U4O2 Crossword: Victorian privacy and health records legislation to Emerging trends in cyber security (Modules 115–134)
10 clues · Comparing the three privacy laws, Privacy Amendment (Notifiable Data Breaches) Act 2017, Eligible data breach and serious harm (ss 26WE, 26WF), Assessing a suspected breach (s 26WH) and more
🔎
VCE Data Analytics U4O2 Word Search: Victorian privacy and health records legislation to Ethical issues and case-study analysis (Modules 115–150)
21 words to find · Comparing the three privacy laws, Privacy Amendment (Notifiable Data Breaches) Act 2017, Eligible data breach and serious harm (ss 26WE, 26WF), Assessing a suspected breach (s 26WH) and more
✎
Years 9–10 Data & Information Crossword: Interactive content with emerging tools to Data privacy and the Australian Privacy Principles (Modules 83–132)
10 clues · Emerging digital tools, Selecting a tool for an audience and purpose, Embedding audio and video with HTML, Navigation and hotspots in interactive content and more
🔎
Years 9–10 Data & Information Word Search: Data compression to Data privacy and the Australian Privacy Principles (Modules 6–132)
21 words to find · Redundancy: repeated data that can be shortened, Lossless compression, Lossy compression, Run-length encoding: encoding text and more
✎
IGCSE Computer Science Paper 2 Crossword: 8.3 File Handling and 9 Databases (Modules 500–522)
10 clues · Write, close, then read the data back, Copying a line of text from one file to another, Tracing a file handling program, Common mistakes in file handling pseudocode and more
✎
IGCSE Computer Science Paper 2 Crossword: 9 Databases (Modules 525–538)
10 clues · Field order in the output of a SELECT, WHERE on text, Boolean, character and date fields, Mixing AND and OR with brackets in a WHERE clause, Clause order in a full SQL query and more
✎
IGCSE Computer Science Paper 2 Crossword: 9 Databases and 10 Boolean Logic (Modules 539–551)
10 clues · Common mistakes in SQL scripts, What a logic gate is, Labelling inputs and the output: A, B, C and X, Truth table layout for two inputs and more
🔎
IGCSE Computer Science Paper 2 Word Search: 8.3 File Handling and 9 Databases (Modules 500–538)
20 words to find · Write, close, then read the data back, Copying a line of text from one file to another, Tracing a file handling program, Common mistakes in file handling pseudocode and more
🔎
IGCSE Computer Science Paper 2 Word Search: 9 Databases and 10 Boolean Logic (Modules 539–580)
20 words to find · Common mistakes in SQL scripts, What a logic gate is, Labelling inputs and the output: A, B, C and X, Truth table layout for two inputs and more
✎
ACARA Digital Technologies Years 7–8 Crossword: Analysing and Visualising Data and Structured Data and Queries (Modules 331–360)
10 clues · Describing a trend in a sentence with evidence, Investigating a dataset from question to conclusion, Attributes of an object, Attributes of an event and more
✎
ACARA Digital Technologies Years 7–8 Crossword: Structured Data and Queries and Algorithms, Flowcharts and Pseudocode (Modules 365–411)
10 clues · SQL LIKE with the % wildcard, How a field's data type changes sorting, Describing what a query does in plain English, A loop inside a loop and more
✎
ACARA Digital Technologies Years 7–8 Crossword: Digital Footprints and Data Minimisation (Modules 728–751)
10 clues · Form settings that collect email addresses, Data sharing with third parties, Purpose and user of an existing digital system, Justifying keeping or removing a data item and more
🔎
ACARA Digital Technologies Years 7–8 Word Search: Analysing and Visualising Data to Algorithms, Flowcharts and Pseudocode (Modules 331–411)
21 words to find · Describing a trend in a sentence with evidence, Investigating a dataset from question to conclusion, Attributes of an object, Attributes of an event and more
🔎
ACARA Digital Technologies Years 7–8 Word Search: Networks and Cyber Threats and Digital Footprints and Data Minimisation (Modules 696–770)
22 words to find · Substitution cipher, Transposition cipher, Keeping an encryption key secret, Why a Caesar cipher is weak compared with modern encryption and more
✎
ACARA Digital Technologies Years 9–10 Crossword: Acquiring and Validating Data (Modules 255–329)
10 clues · Validation rules on an online survey form, Choosing a logging interval for sensor readings, Recording sensor readings in a spreadsheet with timestamps, Sensor errors: faults, calibration and noise and more
✎
ACARA Digital Technologies Years 9–10 Crossword: Entities, Relationships and Queries (Modules 433–451)
10 clues · The repeated-data problem in one big table, Entity, Attributes become fields, One-to-one and many-to-many relationships and more
✎
ACARA Digital Technologies Years 9–10 Crossword: Entities, Relationships and Queries (Modules 459–475)
10 clues · Pattern matching with LIKE, % and _, BETWEEN and IN in a WHERE clause, Why a query over two tables needs a join, Writing the ON condition: foreign key equals primary key and more
✎
ACARA Digital Technologies Years 9–10 Crossword: Cyber Security Threats and Vulnerabilities and Privacy Principles and Digital Footprints (Modules 876–944)
10 clues · Brute-forcing a Caesar cipher in Python, Vigenere cipher in Python, The XOR cipher, Base64 is encoding, not encryption and more
🔎
ACARA Digital Technologies Years 9–10 Word Search: Data Compression and Acquiring and Validating Data (Modules 226–329)
20 words to find · Exporting audio at different quality levels in Audacity, How video compression reuses unchanged parts of frames, Streaming media and adjusting bitrate, Common compressed file formats and what they are used for and more
🔎
ACARA Digital Technologies Years 9–10 Word Search: Analysing and Visualising Data and Entities, Relationships and Queries (Modules 413–451)
21 words to find · Connecting one slicer to several pivot charts, Referencing a cell on another worksheet, Named ranges, A drop-down list as a chart selector and more
🔎
ACARA Digital Technologies Years 9–10 Word Search: Entities, Relationships and Queries and Algorithms with Logical Operators (Modules 459–534)
22 words to find · Pattern matching with LIKE, % and _, BETWEEN and IN in a WHERE clause, Why a query over two tables needs a join, Writing the ON condition: foreign key equals primary key and more
🔎
ACARA Digital Technologies Years 9–10 Word Search: Cyber Security Threats and Vulnerabilities and Privacy Principles and Digital Footprints (Modules 860–944)
20 words to find · Frequency analysis, Transposition cipher: rail fence, CODE and CHAR functions in a spreadsheet, The MOD function in a spreadsheet and more
✎
Crossword: Data Management and Cyber Security (Modules 28–122)
10 clues · Composite primary keys, Insertion, update and deletion anomalies, Functional dependency and determinants, First normal form (1NF) and more
🔎
Word Search: Data Management and Cyber Security (Modules 28–266)
20 words to find · Composite primary keys, Insertion, update and deletion anomalies, Functional dependency and determinants, First normal form (1NF) and more
Frequently Asked Questions
Are these worksheets free?
Yes — every worksheet and its answer key is free to view, download, and print, with no account required to access any individual module.
Do I need an account?
No account is needed to view or print a worksheet. A free teacher account adds extras like assigning modules to a class and tracking progress automatically — it takes under three minutes to set up and doesn't need a credit card.
What year level is this for?
This curriculum is aligned to the Australian Curriculum (ACARA) and Victorian Curriculum, spanning roughly Years 3 to 10 — from first sequencing and variables through to object-oriented programming and advanced data structures. Start wherever matches your class's current level; each module builds on the last.
Can I print them?
Yes — every module has a one-click Print Worksheet button that generates a printable page with the practice questions and a full answer key.
Is this aligned to a curriculum?
Yes — the module sequence is mapped to the Australian Curriculum (ACARA) and Victorian Curriculum, and a class's progress is reported back against those curriculum bands (e.g. ACARA Years 5–6 sequencing and iteration, Years 7–8 functions and data structures), not just a generic difficulty scale.
Can students use this without a teacher?
Yes — students can start any module and practice directly, no class or account required. Joining a teacher's class with a class code adds progress tracking, class badges, and live Sprints, but isn't needed to work through the worksheets or modules solo.
Do I need to know WA Computer Science ATAR Unit 2 myself to teach this?
No — every module comes with a full worked answer key, and Cloodit tracks who's stuck automatically, so you don't need to solve each exercise yourself before assigning it or be able to debug a student's work line by line.
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →