WA Computer Science ATAR Unit 2

WA Computer Science ATAR Unit 2 is the second Year 11 unit of the Western Australian (SCSA) Computer Science ATAR course: data management with relational databases, and cyber security.

The two topic journeys below are built mostly from Cloodit's existing ACARA, VCE, IGCSE and Years 9–10 modules, so this page lists the 25 modules written just for this course: composite primary keys, anomalies, functional dependency and normalising a table step by step to 1NF, 2NF and 3NF, and NULL values; and integrity, availability, exploits, threat actors, attack surfaces and incidents, viruses and physical social engineering, penetration testing — phases, black, grey and white box testing, scope, authorisation and reporting — Australian computer offences law, responsible disclosure and professional codes of ethics. Each module includes real practice questions and a full answer key.

Each topic has its own journey below, split into smaller journeys, so teachers can assign a whole topic or one part of it, with progress tracking, class sprints and badges.

Add this whole curriculum to your class, or just the modules your unit needs — Cloodit tracks who's stuck automatically.

Add to class →

Data Management (8 modules)

Composite primary keys A composite primary key: two or more fields together identify each record uniquely. Each field can repeat alone, but the pair cannot. Used in junction tables.

Insertion, update and deletion anomalies A problem caused by redundant data in one table: adding, changing or deleting a record leads to missing data, inconsistent copies or accidental loss of other facts.

Functional dependency and determinants A field is functionally dependent on another when the other field's value determines it. The determinant fixes the value: studentId determines studentName.

First normal form (1NF) A table is in 1NF when every field holds one atomic value, there are no repeating groups, and each record is identified by a key.

Second normal form (2NF) A table in 1NF where no non-key field depends on only part of a composite key. Remove any partial dependency by splitting those fields into a new table.

Third normal form (3NF) A table in 2NF where no non-key field depends on another non-key field. Every field depends on the key, the whole key and nothing but the key.

Normalising a table step by step to 3NF Take a table through 1NF, 2NF, then 3NF by removing repeating groups, then partial dependencies, then transitive dependencies, giving each new table its own key.

NULL values and IS NULL NULL marks a missing value. Test for it with IS NULL or IS NOT NULL, because = NULL never matches. NULL is not a blank or 0, and aggregates ignore it.

Just this content description: the Data Management journey · Add Data Management to a class →

Cyber Security (17 modules)

121

Integrity Data stays accurate, complete and unaltered unless an authorised person changes it. Tampering breaks integrity by altering data without permission.

122

Availability Authorised users can reach data and systems when they need them. Attacks like DDoS and hardware failure reduce it.

125

Exploit A method or piece of code that takes advantage of a vulnerability (the weakness) to attack a system. The vulnerability is the flaw; the exploit is the tool that uses it.

126

Threat actor A person or group that carries out a cyber attack, described by their motive (money, cause, grievance, spying) and skill, such as cybercriminals, hacktivists, insiders and nation-state groups.

127

Attack surface All the points where an attacker could try to get into a system or take data out, such as open ports, running services and user accounts. A smaller surface means fewer ways in.

129

Cyber security incident An event that actually or potentially compromises the confidentiality, integrity or availability of data or systems, such as a data breach or a malware infection.

150

Viruses Malware that attaches to a host file and spreads by replicating itself when a user runs the infected file

161

Physical social engineering: tailgating and baiting Physical social engineering: tailgating follows an authorised person through a secure door, while baiting leaves an infected USB drive for someone to plug in.

257

What penetration testing is An authorised, simulated attack on a system by an ethical (white-hat) hacker to find vulnerabilities before real attackers (black-hat) do, so the weaknesses can be fixed.

259

Vulnerability scanning versus penetration testing A vulnerability scan is an automated check that lists known weaknesses, some false positives. A penetration test is manual: testers try to exploit them to prove the real impact.

260

Penetration test phases The ordered stages of a penetration test: planning, reconnaissance, scanning, gaining access, maintaining access, then reporting, with clean-up of any changes made.

261

Black, grey and white box testing Test approaches defined by what the tester knows beforehand: black box knows nothing (outsider view), grey box knows some (insider view), white box knows everything (full knowledge).

262

Scope and written authorisation for a penetration test Written permission from the system owner that sets the scope: which systems, methods and time window a tester may use. Testing outside it is illegal.

263

Penetration test report and remediation A confidential document listing each finding with its risk rating, evidence and recommended fix, so the client can remediate the problems and then retest to confirm they are fixed.

264

Australian computer offences law A crime under the Cybercrime Act 2001 (Cwlth) and the WA Criminal Code: accessing, changing or impairing computer data or systems without authorisation. Authorisation is a defence.

265

Responsible disclosure of vulnerabilities Privately reporting a vulnerability you found to its owner and giving them time to fix it before telling the public, so attackers can't exploit it.

266

Professional codes of ethics for developers and testers A set of rules for professional conduct, such as the ACS Code of Ethics: be honest, keep client data confidential, avoid harm, declare conflicts of interest and act in the public interest.

Just this content description: the Cyber Security journey · Add Cyber Security to a class →

Printable WA Computer Science ATAR Unit 2 Crosswords & Word Searches

Built from the key terms of each block of modules, every one with a full answer key. All free printables →

✎

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

✎

Crossword: Cyber Security (Modules 125–266) 10 clues · Exploit, Threat actor, Attack surface, Cyber security incident 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

Journeys using these modules

WA Computer Science ATAR Year 11 — Data Management, WA Computer Science ATAR Year 11 — Cyber Security

Or build your own Journey from any of these modules →

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.

Cloodit turns curriculum-aligned coding content into journeys students work through one biome at a time.

Students earn collectable badges

Over 100 of them, across seven natural biomes.

Study Buddy

Students build a real study resource

Turns their work into revision material ready for Flash Cards and Exam study.

Diamond Dash — one of Cloodit's live, competitive Sprint games

Students lock in with Sprints

Live, competitive practice for the start of the lesson or a teacher-led lesson finisher.

A Cloodit certificate of achievement, ready to personalise and print

Custom printable certificates

Honour your top performers, or encourage a student who's trying hard — ready to print in seconds.

Add to class →

For Teachers

Set this curriculum for your class and see who needs help, automatically.

Create a free teacher account →

No credit card. No setup fee. Make a class and invite students in under three minutes.

For Students

Practice this topic interactively, track progress, and unlock badges.

Start Learning Free →

Have a class code?