Year 12 Computer Science General
Units 3 & 4 course materials for The King's College students. Explore systems analysis, programming, databases, and networking.
Next Unit 4 focus
Task 7 Programming Practical and Task 8 Network Design
Practical programming readiness followed by a high value domestic UniFi network design project with study notes, quizzes, guides and submission documents.
Course Overview
Unit 3
Terms 1 & 2 (20 weeks)
Systems Analysis & Development
SDLC, project management, context diagrams
Managing Data
Spreadsheets, databases, data validation
Unit 4
Term 3 (10 weeks)
Developing Software
SDC, programming concepts, algorithms
Networks & Communications
Topologies, protocols, security
Assessment Schedule
View All →Task 1
Systems Analysis Test
Week 6
Task 2
System Analysis Project
Weeks 7-9
Task 5
Externally Set Task
Week 13
Task 3
Database Practical
Week 16
Task 4
Developing Software Theory Test
Term 3 Week 3
Task 6
Study Session Helper Program
Term 3 Weeks 4-8
Task 7
Programming Practical Test
Term 3 Week 9
Task 8
Network Design Project
Term 3 Week 10
Quick Links
Glossary
Key terms and command words used in assessments.
Unit 3 Study Guide
Core knowledge summary and practice prompts.
Unit 3 EST Prep
Highlighted 2026 EST content with flashcards, quizzes, scenarios, and a timed mock.
Task 2 System Analysis Project
Case study, context diagram requirements, spreadsheet budget checklist, rubric, and weekly project sequence.
Task 3 Database Practical
Microsoft Lists guides, weekly lesson overviews, query/report practice, and documentation support.
Task 4 Software Theory Prep
Software types, licensing, SDC stages, user needs, interface factors, flashcards, quizzes and a timed mock test.
Task 6 Study Session Helper
Supplied programming project with guides, weekly build steps, templates, testing support and submission files.
Task 7 Programming Practical
Scenario reading, data types, variables, control structures, trace tables, debugging, quizzes and timed practical prep.
Task 8 Network Design Project
Real estate floorplan selection, UniFi Design Center guidance, topology support, network theory, justification prompts and submission files.
Unit 4 Study Guide
Programming, networks, and security review.