Cambridge AS & A Level Computer Science 9618/12 October/November 2025 (Paper 1 Theory Fundamentals): Question-by-Question Guide
Past Papers

Cambridge AS & A Level Computer Science 9618/12 October/November 2025 (Paper 1 Theory Fundamentals): Question-by-Question Guide

Mahira Kitchil Project Head, Tutopiya
• 10 min read
Updated

Cambridge AS & A Level Computer Science 9618/12 is the October/November 2025 Paper 1 (Theory Fundamentals), variant 2. It is an AS Level component that lasts 1 hour 30 minutes, is worth 75 marks and is sat by every 9618 candidate. It had eleven compulsory questions and no calculator, spread across the AS syllabus, with no question worth more than 13 marks. This guide goes through the paper question by question and shows what the official mark scheme gave marks for. The paper and its mark scheme are free on the Tutopiya Learning Portal.

For the newest series of the same paper, see 9618 Paper 12 May/June 2026: questions and mark scheme.

For an overview of all four 9618 papers from this series, see A Level Computer Science 9618 Oct/Nov 2025 Papers & Marking.

9618/12 at a glance

Paper codes: the code printed on the cover is 9618/12/O/N/25, the question paper file is 9618_w25_qp_12 and the mark scheme file is 9618_w25_ms_12.

QuestionTopicMarksMain command word
1Verification methods: data transfer or data entry2Draw lines
2Copyright, open source, shareware, licences, codes of conduct6Describe
3Relative addressing, registers, addressing modes, clock speed and cache10State, write, explain
4The SHIPPING database: relationship, ALTER TABLE, COUNT query, developer interface10Describe, write
5LANs, star topology, packets, CSMA/CD, security threats13Describe, complete
6Lossy sound compression, binary words, parity, bitmap file size6State, circle, calculate
7Binary addition, Unicode, BCD and hexadecimal4Complete, state, write
8Cloud computing, touchscreens, utility software10Give, explain, identify
9Logic expression from a circuit, truth table errors4Write, identify
10Interpreters and compilers, Free Software, digital signatures7Explain, describe, state
11Automatic doors: monitoring or control3Identify, justify
Total75

Question-by-question walkthrough

Question 1: verification methods (2 marks)

Parity byte check, checksum and parity block check are used during data transfer; a visual check is used during data entry. Two marks for all four lines, one for two or three.

Question 2: ownership and ethics (6 marks)

  • Four terms (4 marks, one per row): copyright gives the holder the legal right of ownership of intellectual property; open source software can be freely copied, distributed or adapted; shareware gives a trial period or limited functionality before payment or sign-up; and a software licence is a legal agreement that sets out the rights and terms of use.
  • Purpose of a code of conduct (2 marks): any two of: a safe, respectable and professional working environment; making sure employees understand what is expected and the consequences of their actions; a clear outline of good practice; clear rules for particular situations; and protecting the organisation’s reputation or public trust.

Question 3: the processor (10 marks)

  • Relative addressing (1 mark): the operand is an offset that is added to a base value to give the address whose contents are loaded.
  • Two special purpose registers (2 marks): any two of the PC, MDR, MAR, CIR and status register. The ACC and IX were excluded by the question.
  • ACC values (3 marks):
    • LDM #98 loads the number itself: 98
    • LDI 101 reads 98 from address 101, then loads the contents of address 98: 8
    • LDX 100 adds the IX value of 2 to make address 102 and loads its contents: 32
  • Faster clock and bigger cache (4 marks, two each): a higher clock speed means more fetch-execute cycles per second, so more instructions can be processed each second; a bigger cache can hold more of the most frequently used instructions, which reduces the need to access slower RAM.

Question 4: the SHIPPING database (10 marks)

The tables are CONTAINER(ContainerID, Type, Weight, OwnerName, ShipID) and SHIP(ShipID, Type, Capacity, ShipName).

  • The relationship (2 marks): SHIP to CONTAINER is one-to-many (1), with the primary key ShipID in SHIP linked to the foreign key ShipID in CONTAINER (1).
  • Adding an inspection date field (2 marks): an ALTER TABLE statement (1) that adds a suitably named field with a suitable type (1), for example ALTER TABLE CONTAINER ADD InspectionDate DATE;
  • Counting Caledonia’s containers (4 marks): one mark each for SELECT COUNT, the correct tables, the join and the condition on the name. One version is SELECT COUNT(ContainerID) FROM CONTAINER, SHIP WHERE CONTAINER.ShipID = SHIP.ShipID AND ShipName = “Caledonia”; an INNER JOIN … ON version was also given.
  • The developer interface (2 marks): any two of: creating, modifying or deleting tables; setting up relationships; creating input forms and adding tools such as drop-down boxes and buttons; designing reports; adding menus; and inspecting the contents and metadata by creating and running SQL queries.

Question 5: networks (13 marks)

  • Characteristics of a LAN (2 marks): it covers a small geographical area, is normally privately owned with dedicated infrastructure, and can be wired or wireless.
  • Star topology diagram (2 marks): every computer connected directly to the switch with no other links (1), and the switch connected directly to the server (1).
  • How packets travel in a star (3 marks): the sending device sends packets to the switch; the switch checks the destination address on each packet; and it sends them only to the intended receiver.
  • Collisions on an Ethernet bus (3 marks): any three of: CSMA/CD is used; workstations listen to the channel and send only when it is idle; if a collision is detected, transmission stops and a jamming signal is sent; each workstation waits a random time before trying again; and the wait increases after repeated collisions.
  • A security threat (3 marks): a threat, a matching description and a matching prevention. The scheme’s examples were malware or a virus (code that alters or deletes files; anti-virus, anti-malware or a firewall), spyware (records keystrokes and sends them to a third party; anti-spyware), hacking (unauthorised access to a network or device; authentication or a firewall), phishing (emails pretending to come from reputable companies to trick people into giving personal information; a spam filter or not opening emails from unknown sources) and pharming (redirecting users to a bogus website; a VPN, anti-malware or not opening links).

Question 6: data representation (6 marks)

  • Reducing the sampling rate (1 mark): lossy, because there are fewer samples per second, so data is permanently lost and the original sound cannot be re-created. The mark needs the type and the justification.
  • Decoding three bytes (1 mark): 00111000 is 56, 00111100 is 60 and 00111110 is 62, which gives Science is Amazing!, in that order.
  • Even parity bit (1 mark): 0101110 has four 1s, so the parity bit is 0.
  • Finding the altered bit (1 mark): the second byte, 0111000 with parity 0, has three 1s, so it fails the even check; the fifth column also has an odd total. The circled bit is the fifth bit of the second byte, the 0 where they cross.
  • Bitmap file size (2 marks): one for the working and one for the answer. 1000 × 2000 × 16 = 32 000 000 bits; ÷ 8 = 4 000 000 bytes; ÷ 1 000 000 = 4 megabytes.

Question 7: binary and character sets (4 marks)

  • 10000111 + 00111001 (1 mark): 1100 0000 (135 + 57 = 192).
  • Bits per Unicode character (1 mark): 8, 16, 32 or 64 were all accepted.
  • ‘h’ (denary 104) in BCD (1 mark): 0001 0000 0100, one nibble per denary digit.
  • ‘h’ in hexadecimal (1 mark): 68 (6 × 16 + 8 = 104).

Question 8: a restaurant (10 marks)

  • Two benefits of cloud storage (2 marks): free for a limited amount; no need for personal storage devices; access from any computer with an internet connection; backup and recovery services included; easier sharing and collaboration; and capacity that can be increased quickly.
  • Two drawbacks of cloud computing (2 marks): it needs an internet connection; reliance on a third party for backups; slow uploads and downloads; downtime or technical problems at the provider; compatibility problems moving the data; limited storage without paying more, which may cost more in the long run; and possible security issues.
  • How a touchscreen turns a touch into a menu choice (4 marks): up to two for how the touch is detected, from resistive (two layers make contact and complete a circuit), capacitive (a touch changes the charge), infrared (beams are broken), optical imaging (a touch creates a shadow) or acoustic pulse (the wave is absorbed); and up to two for the selection: the point of touch gives x and y coordinates, and the menu item at that position is recognised and added to the order.
  • Two utilities to recover corrupted images (2 marks): disk repair (or disk contents analysis) and back-up software.

Question 9: logic (4 marks)

  • Expression from the circuit (2 marks): one mark for NOT (A XOR B) and one for NAND with ((B AND C) OR A), giving X = (NOT (A XOR B)) NAND ((B AND C) OR A). The two halves could be written either way round.
  • Three errors in the truth table (2 marks): rows 2, 4 and 7. In rows 2 and 4, A is 0, so both A NAND B and NOT A OR NOT C are 1, the XOR is 0 and X should be 1. In row 7, A NAND B is 0 and NOT A OR NOT C is 1, so X should be 0. Two marks for all three rows, one for one or two.

Question 10: translators and software licensing (7 marks)

  • Using an interpreter then a compiler (4 marks, up to two each): use the interpreter while writing the program to test and debug it as you go, because errors can be fixed and execution continues from where it stopped, or errors are found one at a time; use the compiler once the program is complete, to create an executable so the source code is not seen, or to test a completed section repeatedly without re-interpreting it.
  • Free Software (2 marks): any two of: it is free of restrictions; it is not necessarily free of charge; the source code comes with it and can be edited; and users can share it with others.
  • Showing the download is authentic (1 mark): a digital signature.

Question 11: automatic doors (3 marks)

It is a control system, but the identification earns no mark. The three marks are for the justification: it uses an actuator to open or close the doors; the output (the opening doors) lets people move, which changes the input to the sensor; and it acts on its own using feedback from a sensor.

Where the marks are on 9618/12

TopicQuestionsMarks
Networks, cloud computing and security5, 8(a)17
Processor fundamentals and assembly language310
Databases and SQL410
Ethics, ownership and licensing2, 10(b), 10(c)9
Data representation and compression6(a), 6(b), 6(d), 78
Hardware: touchscreens and control systems8(b)(i), 117
System software: utilities and translators8(b)(ii), 10(a)6
Data integrity: verification and parity1, 6(c)4
Logic gates94
Total75
  • 19 marks have fixed answers: the verification lines, the ACC values, Questions 6 and 7, and the logic question. These are the marks to bank first.
  • SQL carried 6 marks in 4(b) and 4(c). Both reward exact syntax: ALTER TABLE … ADD, COUNT, and a correct join.
  • Paired answers decide many marks. 3(c), 5(e), 8(b)(i) and 10(a) each need a point and its explanation or match. A name on its own earns only part of the credit.

How to self-mark 9618/12 with the mark scheme

  1. Learn the scheme’s layout. Each bullet is one mark up to the stated maximum, a slash or // separates alternatives for the same point, and ”…” shows a point that builds on the one before.
  2. Check the “max” in each part. 3(c) allows two marks for clock speed and two for cache; 8(b)(i) caps both the detection method and the selection at two; 10(a) caps the interpreter and the compiler at two each.
  3. Mark the threat table as a set. In 5(e) the description and prevention must match the threat you named.
  4. Rework every calculation. The ACC values, the parity bits, the file size and the binary addition all have one right answer.
  5. Remember the zero-mark identifications. In Question 11, “control” on its own scores nothing; only the justification earns marks.
  6. Log each lost mark as missing knowledge, a vague answer or a misread question, and redo those parts a week later.

Sit 9618/12 as a timed mock

The paper allows 90 minutes for 75 marks, about 1 minute 10 seconds per mark. A workable plan:

BlockMarksTime
Question 122 minutes
Question 267 minutes
Question 31012 minutes
Question 41012 minutes
Question 51315 minutes
Question 667 minutes
Question 744 minutes
Question 81012 minutes
Question 945 minutes
Question 1078 minutes
Question 1133 minutes
Check calculations and SQL–3 minutes
Total7590 minutes

There is no calculator, so set out the file size calculation step by step and check each binary value by converting it back to denary.

9618/12 in other series

The May/June 2026 Paper 12 also tested SQL with a COUNT and a join, BCD and hexadecimal conversions, the developer interface of a DBMS, the benefits and drawbacks of cloud storage, translators, and whether a system is monitoring or control (a health monitor there, automatic doors here). This paper put more weight on networks and assembly language addressing modes, while 2026 spent more marks on images, sound and the operating system.

Other October/November 2025 9618 papers

Practise and download

Need help with a 9618 topic? Book a free trial lesson with an A Level Computer Science tutor →

Frequently asked questions

What topics were on 9618 Paper 12 October/November 2025? +

Eleven questions: verification methods; copyright, licences and codes of conduct; registers, addressing modes, clock speed and cache; a SHIPPING database with SQL; LANs, star and bus networks and security threats; sound compression, parity and bitmap file size; binary addition, Unicode and ASCII; cloud computing, touchscreens and utilities; logic circuits and truth tables; interpreters, compilers and Free Software; and a control system for automatic doors.

How many marks is 9618/12 and how long is it? +

It is out of 75 marks and lasts 1 hour 30 minutes, with no calculator allowed. Question 5, on networks, is the biggest at 13 marks.

What were the ACC values in 9618/12 Question 3(b)? +

LDM #98 puts 98 in the ACC. LDI 101 finds 98 at address 101, then loads the contents of address 98, which is 8. LDX 100 adds the index register value 2 to make address 102 and loads 32.

What was the bitmap file size answer on 9618/12 Oct/Nov 2025? +

1000 × 2000 pixels × 16 bits = 32 000 000 bits, divided by 8 to give 4 000 000 bytes, which is 4 megabytes. One mark for the working and one for the answer.

Which rows were wrong in the 9618/12 truth table in Question 9(b)? +

Rows 2, 4 and 7. For X = NOT ((A NAND B) XOR (NOT A OR NOT C)), rows 2 and 4 should output 1 and row 7 should output 0. Two marks for all three rows and one mark for one or two.

Where can I download 9618/12 October/November 2025 and its mark scheme? +

Both are free to download and print on the Tutopiya Learning Portal, on the Cambridge AS & A Level Computer Science 9618 past papers page.

What is 9618_w25_qp_12? +

9618_w25_qp_12 is the file name of the question paper for Cambridge AS & A Level Computer Science 9618 Paper 12 (Paper 1 Theory Fundamentals, variant 2), October/November 2025. Its mark scheme is 9618_w25_ms_12, and the code printed on the cover is 9618/12/O/N/25. In these file names, w25 means the October/November 2025 series, qp means question paper and ms means mark scheme.

Ready to Excel in Your Studies?

Get personalised help from Tutopiya's expert tutors. Whether it's IGCSE, IB, A-Levels, or any other curriculum — we match you with the perfect tutor and your first session is free.

Book Your Free Trial
M

Written by

Mahira Kitchil

Connect on LinkedIn →

Project Head, Tutopiya

Mahira Kitchil is a Project Head at Tutopiya, where she works with Cambridge IGCSE and Edexcel A-Level teachers in more than 20 countries on how exams are set and marked. She writes practical guides that help students find the right past papers and use the mark scheme the way examiners do, so every practice paper counts.

Mahira Kitchil on LinkedIn

Get Started

Courses

Company

Subjects & Curriculums

Resources

Book a Tutor

Struggling with this topic?

Practise A Level Computer Science with free topic quizzes