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 4 Developing Software Theory Test
Three weeks of focused notes, flashcards, quizzes, SDC practice, written scenarios and a timed mock theory test.
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.
Unit 4 Study Guide
Programming, networks, and security review.