Cambridge AS & A Level Computer Science 9618/12 October/November 2025 (Paper 1 Theory Fundamentals): Question-by-Question Guide
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.
| Question | Topic | Marks | Main command word |
|---|---|---|---|
| 1 | Verification methods: data transfer or data entry | 2 | Draw lines |
| 2 | Copyright, open source, shareware, licences, codes of conduct | 6 | Describe |
| 3 | Relative addressing, registers, addressing modes, clock speed and cache | 10 | State, write, explain |
| 4 | The SHIPPING database: relationship, ALTER TABLE, COUNT query, developer interface | 10 | Describe, write |
| 5 | LANs, star topology, packets, CSMA/CD, security threats | 13 | Describe, complete |
| 6 | Lossy sound compression, binary words, parity, bitmap file size | 6 | State, circle, calculate |
| 7 | Binary addition, Unicode, BCD and hexadecimal | 4 | Complete, state, write |
| 8 | Cloud computing, touchscreens, utility software | 10 | Give, explain, identify |
| 9 | Logic expression from a circuit, truth table errors | 4 | Write, identify |
| 10 | Interpreters and compilers, Free Software, digital signatures | 7 | Explain, describe, state |
| 11 | Automatic doors: monitoring or control | 3 | Identify, justify |
| Total | 75 |
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
| Topic | Questions | Marks |
|---|---|---|
| Networks, cloud computing and security | 5, 8(a) | 17 |
| Processor fundamentals and assembly language | 3 | 10 |
| Databases and SQL | 4 | 10 |
| Ethics, ownership and licensing | 2, 10(b), 10(c) | 9 |
| Data representation and compression | 6(a), 6(b), 6(d), 7 | 8 |
| Hardware: touchscreens and control systems | 8(b)(i), 11 | 7 |
| System software: utilities and translators | 8(b)(ii), 10(a) | 6 |
| Data integrity: verification and parity | 1, 6(c) | 4 |
| Logic gates | 9 | 4 |
| Total | 75 |
- 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
- 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.
- 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.
- Mark the threat table as a set. In 5(e) the description and prevention must match the threat you named.
- Rework every calculation. The ACC values, the parity bits, the file size and the binary addition all have one right answer.
- Remember the zero-mark identifications. In Question 11, “control” on its own scores nothing; only the justification earns marks.
- 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:
| Block | Marks | Time |
|---|---|---|
| Question 1 | 2 | 2 minutes |
| Question 2 | 6 | 7 minutes |
| Question 3 | 10 | 12 minutes |
| Question 4 | 10 | 12 minutes |
| Question 5 | 13 | 15 minutes |
| Question 6 | 6 | 7 minutes |
| Question 7 | 4 | 4 minutes |
| Question 8 | 10 | 12 minutes |
| Question 9 | 4 | 5 minutes |
| Question 10 | 7 | 8 minutes |
| Question 11 | 3 | 3 minutes |
| Check calculations and SQL | – | 3 minutes |
| Total | 75 | 90 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
- 9618 Paper 22 (Fundamental Problem-solving and Programming Skills)
- 9618 Paper 32 (Advanced Theory)
- 9618 Paper 42 (Practical)
Practise and download
- Download 9618/12 and its mark scheme on the Learning Portal →
- All 9618 October/November 2025 papers: overview and marking patterns
- All 9618 May/June 2026 papers: overview and marking patterns
- Try a free A Level Computer Science quiz
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 TrialWritten 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.
Related Articles
A Level Biology 9700 Oct/Nov 2025 Papers & Mark Schemes
Free 9700 Oct/Nov 2025 Paper 1 and Paper 3 with mark schemes: the topics tested, the practical tasks and how examiners awarded marks on each.
A Level Computer Science 9618 Oct/Nov 2025 Papers & Marking
Free 9618 Oct/Nov 2025 papers and mark schemes, plus a paper-by-paper breakdown of Papers 1 to 4 and how examiners gave marks for code and theory.
A Level Geography 9696 Oct/Nov 2025 Papers: Topics & Mark Scheme
Free 9696 Oct/Nov 2025 papers, inserts and mark schemes, plus a paper-by-paper breakdown of the data questions, options and essays and how they were levelled.
