CCEA Level 3 Advanced GCE in Software Systems Development
Official qualification regulated by Ofqual, awarded by CCEA. Classified as a GCE A Level.
Course Syllabus & Study Modules
Complete breakdown of verified curriculum topics and learning objectives.
Data Types, Structures and Algorithms
Algorithms
- Design and implement sorting algorithms (bubble, insertion, merge, quick)
- Design and implement searching algorithms (linear, binary)
- Analyse algorithm efficiency using Big O notation
Data Types, Structures and Algorithms
Data Structures
- Describe and implement stacks, queues, linked lists, trees, graphs
- Perform operations on data structures (push, pop, enqueue, dequeue, insert, delete, traverse)
Data Types, Structures and Algorithms
Data Types
- Define and use primitive data types (integer, real, char, string, Boolean)
- Explain and use composite data types (arrays, records, sets)
Databases and SQL
Database Concepts
- Explain relational database model (tables, tuples, attributes)
- Define primary keys, foreign keys, and indexes
- Normalise data to third normal form (3NF)
Databases and SQL
Database Design and Implementation
- Create entity-relationship diagrams (ERDs)
- Implement a database from a design
Databases and SQL
Relational Database Concepts
- Define tables, tuples, attributes, primary keys, foreign keys
- Normalise data to 3NF
Databases and SQL
SQL
- Write DDL statements (CREATE, ALTER, DROP)
- Write DML statements (SELECT, INSERT, UPDATE, DELETE)
- Use joins, subqueries, aggregate functions
Databases and SQL
Structured Query Language (SQL)
- Write DDL statements (CREATE, ALTER, DROP)
- Write DML statements (SELECT, INSERT, UPDATE, DELETE)
- Use joins (INNER, LEFT, RIGHT) and subqueries
Networking and Web Technologies
Network Fundamentals
- Describe network topologies (star, bus, ring, mesh)
- Explain protocols (TCP/IP, HTTP, FTP, SMTP)
- Understand IP addressing and DNS
Networking and Web Technologies
Web Development
- Create static web pages using HTML and CSS
- Implement client-side scripting with JavaScript
- Understand server-side processing (e.g., PHP, ASP.NET)
Programming Concepts and Paradigms
Event-Driven Programming
- Handle user interface events (click, keypress, timer)
- Implement event listeners and callbacks
Programming Concepts and Paradigms
Object-Oriented Programming
- Define classes and create objects
- Implement inheritance, polymorphism, encapsulation
- Use abstract classes and interfaces
Programming Concepts and Paradigms
Programming Fundamentals
- Use variables, constants, operators, and expressions
- Implement selection (if, case) and iteration (for, while, repeat)
- Define and use procedures and functions with parameters
Programming Concepts and Paradigms
Structured Programming
- Use sequence, selection, iteration constructs
- Design and implement modular programs using functions/procedures
- Apply parameter passing (by value, by reference)
Software Development Process
Design
- Produce structure charts, class diagrams, flowcharts
- Design user interfaces and database schemas
Software Development Process
Maintenance
- Describe corrective, adaptive, perfective maintenance
- Use version control systems (e.g., Git)
Software Development Process
Quality Assurance
- Apply coding standards and best practices
- Conduct code reviews and walkthroughs
- Use version control systems (e.g., Git)
Software Development Process
Requirements Analysis
- Gather and document functional/non-functional requirements
- Create use case diagrams and user stories
Software Development Process
System Development Life Cycle
- Describe phases: analysis, design, implementation, testing, maintenance
- Compare waterfall, iterative, agile methodologies
Software Development Process
Testing
- Plan and execute unit, integration, system, acceptance testing
- Use black-box and white-box testing techniques
Software Development Process
Testing and Debugging
- Design test plans (unit, integration, system, acceptance)
- Use black-box and white-box testing techniques
- Debug using breakpoints, watches, and trace tables
Systems Software and Networking
Computer Networks
- Describe network topologies (star, bus, mesh)
- Explain protocols (TCP/IP, HTTP, FTP, DNS)
- Understand IP addressing and subnetting
Systems Software and Networking
Operating Systems
- Describe functions: process management, memory management, file systems
- Explain scheduling algorithms (FCFS, SJF, round-robin)
Systems Software and Networking
Security
- Identify threats (malware, phishing, DoS)
- Apply security measures (encryption, firewalls, authentication)
Systems Software and Security
Computer Security
- Identify threats (malware, phishing, DoS attacks)
- Implement security measures (encryption, firewalls, authentication)
- Understand ethical and legal issues (Data Protection Act, Computer Misuse Act)
Systems Software and Security
Operating Systems
- Describe functions of an OS (process management, memory management, file management)
- Explain scheduling algorithms (FCFS, SJF, round robin)
- Understand virtual memory and paging
Web Technologies
Client-Side Scripting
- Write JavaScript for form validation, DOM manipulation, event handling
- Use AJAX for asynchronous data loading
Web Technologies
HTML and CSS
- Construct web pages using HTML5 semantic elements (e.g., header, nav, section, article, footer) to define document structure.
- Apply CSS3 selectors (element, class, ID, attribute, pseudo-class) to target and style HTML elements.
- Demonstrate understanding of the CSS box model by controlling dimensions, padding, borders, and margins.
- Implement responsive web design using media queries, fluid grids, and flexible images.
- Evaluate the accessibility of web pages by applying WCAG-compliant practices such as alt text and ARIA roles.
Web Technologies
Server-Side Scripting
- Write server-side code (e.g., PHP, Node.js) to handle form data
- Connect to databases and perform CRUD operations
Regulatory & Verification Details
- Qualification Number (QN)
- 601/8914/9
- Regulated Status
- Available to learners
- Awarding Body
- CCEA
- Qualification Type
- GCE A Level
- Operational Start
- Sept 2016
- Operational End
- Aug 2029