1 Computers store data in binary form. (a) State the difference between a tebibyte and a terabyte. [1] (b) Convert the signed denary value -100 into an 8-bit two's complement binary integer. Working … Answer … [1] (c) Convert the denary number 251 into hexadecimal. Show your working. Working … Answer … [2] (d) Add the following unsigned binary integers. 0 1 0 1 0 0 0 0 + 0 0 1 1 1 1 1 0 [1]
Cambridge A Level
A Level Computer Science 9618: questions by topic
You’re practising 2021–2022 papers. The 2023–2026 papers, including 2026, need a plan.
Unlock from $6/mo1 (a) Draw one line from each image representation term to its correct definition. Term (left column): Pixel; Bit depth; Image resolution; File header. Definition (right column): The number of pixels wide by the number of pixels high; The smallest identifiable component of an image; Stores data about the image file, e.g. file format, number of bits per pixel, file size; The number of bits used to represent each colour. [3] (b) The following section of a bitmap image is 10 pixels wide and 5 pixels high. In this example, each colour is represented by a letter, e.g. B is blue. Row 1: B | B | B | B | B | B | B | B | B | B; Row 2: Y | Y | P | Y | Y | Y | P | Y | Y | Y; Row 3: R | R | M | R | P | K | T | T | R | R; Row 4: B | O | P | Y | Y | Y | P | G | P | P; Row 5: R | O | R | P | P | P | R | R | R | R. The complete image can have up to 256 colours. (i) Identify the smallest number of bits that can be used to represent each colour in the complete bitmap image. [1] (ii) Calculate an estimate for the file size of the section of the bitmap image shown, giving your answer in bytes. Use your answer from part (b)(i). Show your working. Working … Answer … bytes [2] (c) Describe how changing the colour depth of an image affects its file size. [2] (d) The first row of pixels in the image from part (b) is shown: B | B | B | B | B | B | B | B | B | B. Explain how this row of pixels can be compressed using lossless compression. [2]
1 Text and numbers are examples of data stored in a computer. (a) A character set is used to represent characters in a computer. (i) Describe what is meant by a character set. [2] (ii) Identify two character sets and state one difference between them. Character set 1 ... Character set 2 ... Difference ... [3] (iii) Describe how lossless compression can be used to reduce the file size of a text file. [2] (iv) Explain why lossy compression should not be used on a text file. [2] (b) A computer can represent numerical data in different forms. Complete the table by writing the answer to each statement. Statement | Answer The hexadecimal value 11 represented in denary | '' The smallest denary number that can be represented by an unsigned 8-bit binary integer | '' The denary number 87 represented in Binary Coded Decimal (BCD) | '' The denary number 240 represented in hexadecimal | '' The denary number -20 represented in 8-bit two's complement binary | '' [5] Working space
1 (a) (i) Convert the unsigned binary integer into denary. 00100111 Answer ... [1] (ii) Convert the Binary Coded Decimal (BCD) into denary. 00100111 Answer ... [1] (iii) Convert the 8-bit two's complement binary integer into denary. 11100111 Answer ... [1] (b) Perform the following binary subtraction. Show your working. [Two rows aligned: 1 0 1 1 0 0 1 1 then minus 0 1 1 1 0 1 0 1 with a line beneath] [2] (c) Give one similarity and two differences between the ASCII and Unicode character sets. Similarity ... Difference 1 ... Difference 2 ... [3] (d) Sound samples are recorded and saved in a file. (i) State what is meant by sampling rate. [1] (ii) Explain the effect of increasing the sampling resolution on the sound file. [2]
1 (a) Draw one line from each utility software to its most appropriate purpose. Utility software | Purpose. [Left boxes: virus checker; disk formatter; backup; disk repair; defragmentation. Right boxes: to reorganise files so they are contiguous; to scan for malicious program code; to decrease the file size; to initialise a disk; to create copies of files in case the original is lost; to check for and fix inconsistencies on a disk.] [5] (b) Compilers and interpreters translate programs written in a high-level language into a low-level language. (i) State two drawbacks of using a compiler compared to an interpreter during program development. 1 ... 2 ... [2] (ii) Explain why high-level language programs might be partially compiled and partially interpreted. [2]
1 A digital audio message needs to be recorded. (a) Tick (✓) one box in each row to identify the effect of each action on the accuracy of the recording. Action | Accuracy increases | Accuracy decreases | Accuracy does not change Change the sampling rate from 40 kHz to 60 kHz. | '' | '' | '' Change the duration of the recording from 20 minutes to 40 minutes. | '' | '' | '' Change the sampling resolution from 24 bits to 16 bits. | '' | '' | '' [2] (b) The audio message is recorded with a sampling rate of 50 kHz and a sampling resolution of 16 bits. The recording is 20 minutes in length. Calculate the file size of the recording. Give your answer in megabytes and show your working. Working … Answer … megabytes [2] (c) A computer uses a buffer when playing the audio message. Explain the purpose of a buffer in a computer system using one other example. [3]
2 A computer has hardware and software. (a) The hardware includes different types of memory. (i) Complete the description of computer memory. Random Access Memory (RAM) and Read Only Memory (ROM) are both examples of … memory. One item that is stored in RAM is … . One item that is stored in ROM is … . RAM can be either Static RAM (SRAM) or Dynamic RAM (DRAM). SRAM uses transistors arranged as … . DRAM uses transistors and … . [5] (ii) Explain the difference between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) and Electrically Erasable Programmable ROM (EEPROM). [3] (b) A magnetic hard disk is used to store data on the computer. Describe the principal operations of a magnetic hard disk. [5] (c) Computers consist of logic gates. (i) Complete the table by writing one set of values (input 1 and input 2) for each gate that will give the output 1. Gate | Input 1 | Input 2 | Output; AND | '' | '' | 1; NAND | '' | '' | 1; XOR | '' | '' | 1; NOR | '' | '' | 1 [4] (ii) Write the logic expression for the given logic circuit. [Logic circuit: inputs A and B go into a NAND gate; input B also branches down to an XOR gate whose other input is C; the output of the NAND gate and the output of the XOR gate both feed an OR gate whose output is X.] [3]
2 A car has several features. (a) One feature is a lane detection system. This system monitors the lines on either side of the lane. If the car gets too close to one line, the system automatically moves the car away from the line. Explain why the lane detection system is an example of an embedded system. [2] (b) Two other features: record the number of miles travelled in the current journey, from when the engine is turned on to when it is turned off; record the total number of miles the car has travelled since it was built. Identify the data that will be stored in the primary and secondary storage of the car for these two features. Primary … Secondary … [2] (c) The car has a resistive touchscreen for the user to select options. Tick one box in each row to show whether each statement about a resistive touchscreen is true or false. Statement | True | False; The screen always has five different layers | '' | ''; A processor determines the horizontal and vertical coordinates of the point of contact | '' | ''; The touchscreen will work if any object touches the screen | '' | '' [1]
2 (a) The Fetch-Execute (F-E) cycle is represented in register transfer notation. Describe each of the given steps. Step | Description PC <- [PC] + 1 | '' MDR <- [[MAR]] | '' MAR <- [PC] | '' [3] (b) Explain how interrupts are handled during the F-E cycle. [5]
2 Draw one line from each security feature to its most appropriate description. Security feature | Description. [Left boxes: firewall; pharming; anti-virus software; encryption. Right boxes: converts data to an alternative form; redirects a user to a fake website; verifies the authenticity of data; scans files on the hard drive for malicious software; accepts or rejects incoming and outgoing packets based on criteria.] [4]
2 (a) (i) Convert the two's complement binary integer into denary. 10010110 Answer ... [1] (ii) Convert the unsigned binary integer into hexadecimal. 10010110 Answer ... [1] (iii) Convert the unsigned binary integer into Binary Coded Decimal (BCD). Show your working. 10010101 Working ... Answer ... [2] (b) Perform the following binary addition. [Two rows aligned: 1 0 0 0 1 1 0 0 then plus 0 1 0 0 0 1 1 0 with a line beneath] [1]
2 The relational database ASTRONOMY is used to store data about telescopes, the companies that own the telescopes and the photographs taken by the telescopes. The database has these three tables: COMPANY(TelephoneNumber, CompanyID, CompanyName) PHOTOGRAPH(PhotoID, TelescopeID, DateTaken, TimeTaken, Elevation) TELESCOPE(TelescopeID, CompanyID, SerialNumber) (a) Complete the following table by writing the correct answer for each item. Item | Answer a suitable field for the primary key in COMPANY | '' a candidate key in TELESCOPE | '' the degree of relationship between TELESCOPE and PHOTOGRAPH | '' [3] (b) A Database Management System (DBMS) has several features. Identify the feature that describes the relationship between data and its structure. [1] (c) Complete the SQL script to return the total number of telescopes owned by the company whose ID begins with HW. SELECT … ( … ) FROM TELESCOPE WHERE … LIKE … ; [4] (d) Write the SQL script to add one field to the table PHOTOGRAPH to store the resolution of the photograph, e.g. 1920 × 1068. [2] (e) The photographs are stored as bitmap images. Complete the statements about bitmap images by writing the missing words. The … of a bitmap image is the number of bits that are used to store each pixel. Metadata about the image is stored in the … of the file. [2] (f) Describe the purpose of a query processor in a DBMS. [2]
3 A teacher is writing examination papers on a laptop computer. The computer is connected to the internet. The teacher is concerned about the security and privacy of the papers. (a) State the difference between the security of data and the privacy of data. [1] (b) Identify and describe two threats to the data. Identify one security measure to protect against each threat. Each security measure must be different. Threat 1 ... Description ... Security measure ... Threat 2 ... Description ... Security measure ... [6]
3 The table shows part of the instruction set for a processor. The processor has one general purpose register, the Accumulator (ACC). Instruction (Opcode | Operand) | Explanation; AND | #n | Bitwise AND operation of the contents of ACC with the operand; AND | <address> | Bitwise AND operation of the contents of ACC with the contents of <address>; XOR | #n | Bitwise XOR operation of the contents of ACC with the operand; XOR | <address> | Bitwise XOR operation of the contents of ACC with the contents of <address>; OR | #n | Bitwise OR operation of the contents of ACC with the operand; OR | <address> | Bitwise OR operation of the contents of ACC with the contents of <address>. <address> can be an absolute or a symbolic address. # denotes a denary number, e.g. #123 (a) The ACC currently contains the following positive binary integer: 0 1 1 0 0 1 0 1 Write the bit manipulation instruction that would change the binary integer in ACC to: 1 1 1 1 1 1 1 1 Opcode … Operand … [2] (b) The ACC currently contains the following positive binary integer: 0 1 1 0 0 1 0 1 Write the bit manipulation instruction that would change the binary integer in ACC to: 1 0 0 1 1 0 1 0 Opcode … Operand … [2] (c) Convert the following positive binary integer into hexadecimal. 0 1 1 1 1 1 1 0 [1] (d) A three-place logical shift to the left is performed on the following positive binary integer. Show the result of this logical shift. 0 1 1 1 1 1 1 0 [1] (e) Convert the denary numbers 127 and 12 to 8-bit binary and then perform the subtraction 12 - 127 in binary. Show your working. 127 in binary … 12 in binary … 12 - 127 in binary … [3]
3 (a) The table shows part of the instruction set for a processor. The processor has one general purpose register, the Accumulator (ACC). Instruction Opcode | Operand | Explanation LDM | #n | Immediate addressing. Load the number n to ACC LDD | <address> | Direct addressing. Load the contents of the location at the given address to ACC LDI | <address> | Indirect addressing. The address to be used is at the given address. Load the contents of this second address to ACC <address> can be an absolute or symbolic address. # denotes a denary number, e.g. #123 The current contents of main memory are: Address 100 | 101 Address 101 | 67 Address 102 | 104 Address 103 | 100 Address 104 | 68 Complete the table by writing the value stored in the accumulator after the execution of each instruction. Instruction | Accumulator LDM #103 | '' LDD 102 | '' LDI 103 | '' [3] (b) The instructions in part (a) are examples of the data movement group. Describe two other instruction groups. 1 ... 2 ... [4] (c) The table shows part of the instruction set for a processor. The processor has one general purpose register, the Accumulator (ACC). Instruction Opcode | Operand | Explanation AND | Bn | Bitwise AND operation of the contents of ACC with the operand XOR | Bn | Bitwise XOR operation of the contents of ACC with the operand OR | Bn | Bitwise OR operation of the contents of ACC with the operand B denotes a binary number, e.g. B01001010 The binary value 00111101 is stored in the memory address 200. Each instruction in the diagram is performed on the data in memory address 200. Draw one line from each instruction to its correct result. [Left column boxes: XOR B11110000; OR B01010101; AND B11111111. Right column boxes: 01111101; 00111101; 11111111; 11000010; 11001101.] [3]
3 (a) Draw a logic circuit for the logic expression: X = NOT ((NOT A AND NOT B) OR (NOT B AND NOT C)) [Empty box with inputs A, B, C on the left and output X on the right] [2] (b) Complete the truth table for the logic expression: X = NOT ((NOT A AND NOT B) OR (NOT B AND NOT C)) A | B | C | Working space | X. Rows: 0 | 0 | 0 | '' | ''; 0 | 0 | 1 | '' | ''; 0 | 1 | 0 | '' | ''; 0 | 1 | 1 | '' | ''; 1 | 0 | 0 | '' | ''; 1 | 0 | 1 | '' | ''; 1 | 1 | 0 | '' | ''; 1 | 1 | 1 | '' | '' [2]
3 (a) A greenhouse has an automatic window. The window (X) operates according to the following criteria: Parameter | Description of parameter | Binary value | Condition. T | Temperature | 1 | Too high; T | Temperature | 0 | Acceptable; W | Wind speed | 1 | Too high; W | Wind speed | 0 | Acceptable; R | Rain | 1 | Detected; R | Rain | 0 | Not detected; M | Manual override | 1 | On; M | Manual override | 0 | Off. The window opens (X = 1) if: the temperature is too high and the wind speed is acceptable and rain is not detected, or the manual override is off. Draw a logic circuit to represent the operation of the window. [Empty box with inputs T, W, R, M on the left and output X on the right] [3] (b) Complete the truth table for the logic expression: X = NOT (A OR B OR C) AND (B NOR C) A | B | C | Working space | X. Eight rows 0 0 0 to 1 1 1 with empty working space and X cells [2] (c) Embedded systems contain Read Only Memory (ROM) and Random Access Memory (RAM). Explain the reasons why ROM is used in an embedded system. [2]
3 Draw one line from each Operating System (OS) management task to its most appropriate description. OS Management task: hardware management; security management; memory management; process management Description: dynamically allocates memory to processes; marks unallocated file storage for availability; installs programs for devices connected to external ports; validates user and process authenticity; allows processes to transfer data to and from each other [4]
4 A teacher uses a relational database, MARKS, to store data about students and their test marks. The database has the following structure: STUDENT(StudentID, FirstName, LastName) TEST(TestID, Description, TotalMarks) STUDENT_TEST(StudentID, TestID, Mark) [primary keys underlined: StudentID in STUDENT; TestID in TEST; StudentID and TestID in STUDENT_TEST] (a) Describe the advantages of using a relational database compared to a file-based approach. [4] (b) Give the highest level of Normal Form (NF) the database MARKS is in and justify your choice. Normal Form … Justification … [3] (c) (i) Sample data to be stored in the table STUDENT_TEST is shown. StudentID | TestID | Mark; 12 | A1 | 50; 12 | P10 | 100; 13 | A1 | 75; 14 | P10 | 60. Write a Structured Query Language (SQL) script to create the table STUDENT_TEST. [5] (ii) Write a Structured Query Language (SQL) script to find the average mark of students in test A7. [3] (d) The mark a student is awarded in a test will be entered into the database. This mark needs to be a whole number between 0 and the maximum number of marks for that test (inclusive). Explain how data validation and data verification can be used when a mark is entered. [4]
4 A school stores personal data about its staff and students on its computer system. (a) Explain why the school needs to keep both its data and its computer system secure from unauthorised access. Data … Computer system … [2] (b) Complete the table by identifying two security threats to the data on a computer. Describe each threat. Give a different prevention method for each threat. Threat | Description | Prevention method; '' | '' | ''; '' | '' | '' [6] (c) Data is encrypted when it is transmitted within the school network, or externally such as over the internet. Describe what is meant by encryption and explain why it is used. [2]
Revision method
How to use the Computer Science 9618 question bank
Practise 750 authentic past-paper questions from 85 archived papers (2021-2026). These are past-paper questions, not AI-generated exam-style substitutes. Start with a topic, then switch to mixed or timed practice.
- Choose a topic. Focus your practice on a real past-paper topic rather than a generated exam-style substitute.
- Work through the available questions and answers. Use the matching mark scheme to check your reasoning and identify a precise gap.
- Export when eligible. Guests can view up to 20 matching free questions; a free account can access the remaining free selection. PDF export is subject to eligible bank access and the account’s download allowance.
Computer Science 9618: quick facts
How many questions are in the A Level Computer Science 9618 question bank?
The A Level Computer Science 9618 question bank has 750 past-paper questions from 85 papers, sat 2021-2026, sorted into 20 topics.
Which topics come up most in A Level Computer Science 9618?
The most-tagged A Level Computer Science 9618 topics are Programming (146), Data Types and Structures (114) and Software Development (79), out of 750 questions. These are archive counts, not a prediction, and a question can carry more than one topic.
Is the A Level Computer Science 9618 question bank free?
Partly. A Level Computer Science 9618 questions from 2021–2022 are free with a free account. Questions from other years and PDF worksheets need a plan, from $6 a month.
Do the A Level Computer Science 9618 questions have answers?
Yes. Each A Level Computer Science 9618 question shows the official mark scheme answer.