Cambridge IGCSE · 0478 · Paper 2 · Algorithms, programming & logic
Computer Science 0478/21 Oct/Nov 2025 past paper
Cambridge IGCSE Computer Science (0478) Paper 2 (Algorithms, programming & logic), variant 1, Oct/Nov 2025: the question paper and its official mark scheme, 11 questions worth 75 marks, with the grade thresholds. Free to open, no account needed.
- Questions
- 11
- Marks
- 75
- Grade A from
- 43
File names: 0478_w25_qp_21 · 0478_w25_ms_21
Grade thresholds for 0478/21 Oct/Nov 2025
The minimum raw marks Cambridge set for each grade on this component (out of 75). Thresholds change every session and variant, so always compare your score with the paper you actually sat.
| A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|
| 43 | 33 | 23 | 19 | 15 | 11 | 7 |
Topics in this paper
Which syllabus chapters 0478/21 Oct/Nov 2025 tested, by marks. Each chapter links to every past-paper question on it.
| Chapter | Questions | Marks |
|---|---|---|
| Databases | 5 | 28 |
| Algorithm Design and Problem-Solving | 3 | 17 |
| Scenario Question | 1 | 15 |
| Boolean Logic | 1 | 14 |
| Programming | 1 | 1 |
Questions in 0478/21 Oct/Nov 2025
- Question 1
Four descriptions of structured query language (SQL) keywords and five SQL keywords are given. Draw one line from each description to its matching keyword. Not all SQL keywords will be used. identifies the database table sets the condition sorts the …
- Question 2
Identify three different types of test data that can be used to test a program. …
- Question 3
Tick (✓) one box to identify the operator that returns the quotient of a calculation with the fractional part discarded. …
- Question 4
(a) A restaurant offers a fixed priced menu. A meal for an adult costs $9.99 and a meal for a child costs $6.99. If there are 6 or more people at a table, a 15% discount is applied to the …
- Question 5
A hotel booking system is an example of a computer system that is made up of sub-systems. The booking system: • allows the user to select the room type and the number of nights required • displays the types of …
- Question 6
A check digit is one method to validate a 5-digit number. The check digit for a 5-digit number is calculated as follows: • Each digit is multiplied by its position (the first digit on the left is in position 1). …
- Question 7
The flowchart represents an algorithm. START STOP Count 0 INPUT Number No Yes Value Count * Number IS Value …
- Question 8
A school has set up a database table SchoolTrip to record details of students that will go on a school trip. StudentID StudentName ParentName Permission DateReceived STU147 Amir Mr Akar True 03/03/2025 STU348 Filip Mrs Johnson True 04/03/2025 STU274 Matthew …
- Question 9
A school stores all the students’ attendance data in a file called Attendance.txt Write an algorithm in pseudocode to read a line of text from the file and store this line in the variable StudentAttendance
- Question 10
The variables Seconds and Minutes are used in a program. Seconds holds the number of seconds as a whole number and Minutes holds the number of minutes as a whole number. (a) Write pseudocode statements to declare the variables Seconds …
- Question 11
The scores for each competitor in an archery competition are recorded. The one-dimensional (1D) array CompetitorName[] is used to store the names of the competitors. The maximum number of competitors is 30. There are 10 rounds in the competition with …
Other Computer Science papers from Oct/Nov 2025
- 0478/11 Computer systems
- 0478/12 Computer systems
- 0478/13 Computer systems
- 0478/22 Algorithms, programming & logic
- 0478/23 Algorithms, programming & logic