CCEA A-Level · Analysis & Prediction

2024 CCEA A-Level Software Systems Development CL4 Past Paper: Analysis & Answers

The CCEA GCE A2 1 Software Systems Development (ADV11) 2024 paper provides comprehensive coverage of database management and systems analysis methodologies based on the Total Cleaning Services (TCS) case study. Key areas tested include advanced SQL queries involving multiple joins and date manipulation (25%), Systems Methodologies featuring Agile vs Traditional models and UML sequence diagrams (22%), full-stage Database Normalisation up to 3NF (13%), and comprehensive Software Testing techniques (12%).

Updated: 31 Aug 2026

Analysis Sample paper

Difficulty 3.4/5

Total marks

100

Duration

120 mins

Most tested

Structured Query Language (SQL) and Database Design

Paper breakdown

Unit A2 1: Systems Approaches and Database Concepts: 100 marks · 120 mins

Top chapters

Structured Query Language (SQL) · 25 marksSystems Methodologies · 22 marksNormalisation · 13 marksTesting · 12 marksReasons for Systems Development · 12 marks

Executive Summary & Exam Overview

The 2024 CCEA GCE A2 Unit 1 paper assesses candidates across core theoretical and practical facets of systems development and relational database design. Grounded in the Total Cleaning Services (TCS) scenario, the paper is well-balanced with a standard total of 100 marks across 8 structured questions to be completed in 2 hours.

Where the Marks Are Distributed

Marks are heavily weighted toward practical technical implementation and methodology analysis:

Structured Query Language (SQL) (25 marks): Dominates the second half of the examination, covering DML (INSERT, UPDATE), DDL (ALTER TABLE with default constraints), and an extensive multi-table aggregation query involving INNER JOIN, DATEDIFF/DATEADD, COUNT(DISTINCT), and GROUP BY.
Systems Methodologies & UML (22 marks): Evaluates Agile manifesto principles, comparative methodology essays (Agile vs Waterfall), and rigorous sequence diagram reading and interpretation.
Database Concepts & Normalisation (23 marks): Spans foundational architectural knowledge (cloze paragraph) and a systematic normalisation exercise spanning 1NF, 2NF, and 3NF tabular schemas.
Testing & Project Management (18 marks): Centres on test table completion, test data categorisation (extreme, erroneous, null), and Iron Triangle resource-constraint tradeoffs.
Systems Initiation (12 marks): Examines Feasibility Studies, Terms of Reference (ToR), and stakeholder identification.

Examiner Pitfalls & High-Frequency Errors

Candidate performance typically hinges on four key areas:

SQL Query Syntax: Missing table aliases, failing to qualify columns in multi-table joins, omitting DISTINCT in staff counts, and using non-standard date calculation logic.
Normalisation Schema Notation: Omitting primary key (*) or foreign key annotations when decomposing tables, or improperly identifying transitive functional dependencies in 2NF to 3NF.
QWC in Methodologies & Iron Triangle: Providing generic textbook answers without contextualising points to the specific TCS cleaning agency scenario (e.g., matching cleaners to clients, managing overtime pay).
Test Data Precision: Confusing boundary/extreme values with purely invalid or erroneous test inputs.

Revision Strategy & Future Focus

Students preparing for upcoming series must master end-to-end database design: practice writing SQL by hand without an IDE, ensure fluent comprehension of UML notation (Sequence, Class, and Use Case diagrams), and develop structured essay templates for methodology comparison anchored to given scenario constraints.

Ready to test yourself?

Turn these notes into exam-style practice. Get unlimited AI questions on this topic with instant marking and explanations.

Practise This Topic

Charts

Marks by chapter

See where the marks were concentrated so revision time goes to the highest-value topics.

Question type mix

Compare the mark share of each paper section and question type.

Code Writing / SQL Scripting24 marks · 4 questions
Extended Response / Essay (QWC)26 marks · 4 questions
Schema / Normalisation Transformation10 marks · 3 questions
Cloze / Fill-in-the-Blank10 marks · 1 questions
Short Answer / Structured21 marks · 6 questions
Matching / Table Completion9 marks · 2 questions

Mark accessibility

Estimate which marks were basic, mid-level, or high-difficulty.

74%within easy or medium reach

easy: 28 marksmedium: 46 markshard: 26 marks

Difficulty trend

Compare difficulty across recent years.

Command word frequency

Spot common command words so answers match the expected response style.

Skill weighting

Shows the skill mix this paper tested most heavily.

Study ROI

Bigger bubbles recur more often; higher bubbles carry more marks, helping you rank revision priorities.

SQL DML & Complex DQL Queries

25 marks · Difficulty 3.8 · recurrence 5%

Normalisation (1NF, 2NF, 3NF)

13 marks · Difficulty 3.2 · recurrence 5%

Agile vs Traditional Methodologies

11 marks · Difficulty 2.7 · recurrence 5%

Test Data Design & Strategy

12 marks · Difficulty 2.5 · recurrence 5%

UML Sequence & Architecture Diagrams

11 marks · Difficulty 3 · recurrence 4%

Time vs marks

Compare marks with suggested time allocation to plan exam pacing.

marksmins

Next-year prediction

Topics worth watching next year, with the reason shown directly below each bar.

SQL Aggregate & Nested Subqueries5%

SQL constitutes 20-25% of every A2 1 paper; expect subqueries, HAVING clauses, or complex multi-table UPDATE/DELETE commands.

Entity Relationship (ER) Diagramming & Cardinality5%

The 2024 paper featured ER concepts only via cloze text (Q6) rather than requiring candidates to draw or interpret a full Entity Relationship diagram. An ER diagram question is highly likely in the subsequent series.

Project Management Techniques (Gantt & PERT / Critical Path)5%

Project management was assessed via a 6-mark theoretical Iron Triangle question. Calculating float, earliest/latest event times, or drawing critical paths on PERT/Gantt charts is due for heavy testing.

Cumulative marks ladder

The line is your running mark total question by question; dashed lines are the estimated grade cut-offs. See which question the line crosses your target grade at, so you know how far you must answer cleanly and which questions decide a band.

Topic-year heatmap

Compare topic weight by year to spot recurring and returning areas.

Jun 2023

Jun 2024

Structured Query Language (SQL)

Systems Methodologies

Database Concepts

Managing Projects

Testing

Normalisation

Reasons for Systems Development

Examiner insights

Official report

Common pitfalls

Writing purely theoretical responses to QWC questions (such as Agile vs Waterfall or Feasibility) without explicit linking to the pre-release case study context.
Failing to correctly identify and note primary keys (underlined or asterisked) and foreign keys during each step of the normalisation progression.
Omitting necessary join tables when writing multi-table SQL queries, or failing to use COUNT(DISTINCT ...) where multiple matching rows would produce duplicates.
Conflating extreme test data (boundary values that are valid) with erroneous test data (values of wrong type or outside range).

Misconceptions

Assuming adding a column with a DEFAULT constraint automatically backfills existing table rows retroactively rather than leaving existing rows as NULL.
Believing 3NF tables must always require extra splits even when the 2NF schema already has no transitive dependencies between non-key attributes.
Treating UML alternative frames (alt) as simple loops rather than conditional branch (if-else) structures.

Where marks are lost

Loss of QWC marks due to lack of specialist technical vocabulary and poor logical coherence in extended answers.
Syntactical inaccuracies in SQL statements, particularly around DATEDIFF / DATEADD argument ordering and GROUP BY clause requirements.
Incomplete test tables that omit specific boundary edge test data criteria stated in business rule tables.

Estimated grade boundary

Updated: 31 Aug 2026

Source: CCEA

Grade	Mark	Percentage
A*	—	90%
A	—	80%
B	—	70%
C	—	60%
D	—	50%
E	—	40%

Official grade boundaries published by CCEA.

Know what the examiners want. Now go get those marks

thinka is an AI practice app used by 100,000+ students to drill questions and get instant feedback on every answer. You already know the high-frequency topics and where marks are lost. Now practise those specifically on thinka and turn this analysis into actual marks.

Start Practising Free See pricing

Know what's tested? Drill those topics on thinka. AI questions, instant marking.

Start Practising Free