Examiner's Verdict: A Rigorous and Balanced Assessment

The October/November 2024 sittings for Computer Science (9618) Papers 12 and 22 offer a balanced yet challenging journey through the fundamental concepts of computer science. With an overall difficulty index of 3.5 out of 5, the series successfully separates candidates who rely on rote memorisation from those with a deep, practical grasp of programmatic logic and hardware interactions.

Where the Marks Are Won and Lost

In Paper 12, high-scoring scripts were characterised by absolute precision in the Assembly trace tables (Q8) and the multi-conditional SQL query design. The examiner report highlights that many candidates lost easy marks in Q9(b) by failing to articulate that the road bridge warning system is a monitoring system because it lacks an actuator feedback loop that directly impacts the inputs. In Paper 22, the bulk of the marks are concentrated in the design of custom procedures: Conceal() (Q2), Timer() (Q4), and Special() (Q6). The ability to successfully implement random index generation using RAND() and logic checks to prevent duplicated values was the primary differentiator for high-achieving students.

Examiner Pitfalls & Misconceptions

Several persistent errors surfaced in this series:

  • Parameter Passing: Many candidates failed to explicitly state when arrays or variables should be passed by reference (BYREF), particularly in Q2(b)(ii).
  • SQL Delimiters: Date handling remains a weak spot. Omitting standard delimiters (such as # or quotes) in the date comparison of the INVOICE table cost candidates precision marks.
  • Local Variable Declaration: In pseudocode questions, students frequently overlooked declaring local variables (like loop counters), which is a strict marking criteria.

Strategy for Future Success

To master Paper 1, students must practice drawing and verifying complex logic circuits and write SQL queries with various aggregates and constraints. For Paper 2, mastery of 1D and 2D array manipulation, combined with file input/output syntax, is essential. Practising trace tables with Indirect (LDI) and Indexed (LDX) addressing modes will guarantee high returns, as these are highly tested components of Processor Fundamentals.