Cambridge IGCSE · 0478 · Paper 2 · Algorithms, programming & logic
Computer Science 0478/23 Oct/Nov 2024 past paper
Cambridge IGCSE Computer Science (0478) Paper 2 (Algorithms, programming & logic), variant 3, Oct/Nov 2024: the question paper and its official mark scheme, 12 questions worth 76 marks, with the grade thresholds. Free to open, no account needed.
- Questions
- 12
- Marks
- 75
- Grade A from
- 44
File names: 0478_w24_qp_23 · 0478_w24_ms_23
Grade thresholds for 0478/23 Oct/Nov 2024
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 |
|---|---|---|---|---|---|---|
| 44 | 33 | 23 | 19 | 16 | 12 | 8 |
Topics in this paper
Which syllabus chapters 0478/23 Oct/Nov 2024 tested, by marks. Each chapter links to every past-paper question on it.
| Chapter | Questions | Marks |
|---|---|---|
| Databases | 4 | 32 |
| Algorithm Design and Problem-Solving | 5 | 21 |
| Scenario Question | 1 | 15 |
| Boolean Logic | 2 | 8 |
Questions in 0478/23 Oct/Nov 2024
- Question 1
Tick (✓) one box to show which of the following is used to validate data on input. A checksum B double entry check C type check D visual check
- Question 2
Tick (✓) one box to show a method used to construct a solution to a problem. A abstraction B structure diagram C test data D variable
- Question 3
Four logic gates and five logic gate symbols are shown. Draw one line to link each logic gate to its correct symbol. Not all logic gate symbols will be used. XOR NAND NOR AND Logic gate Logic gate symbol
- Question 4
Complete the paragraph about databases. Use terms from the list. You may need to use a term more than once. Some of the terms in the list will not be used. fields comments columns constant key table primary key program …
- Question 5
One stage of the program development life cycle is the analysis stage. Identify and describe two other stages of the program development life cycle. Stage Description Stage Description
- Question 6
An incomplete algorithm has been written in pseudocode to count the number of values stored in an array and to find their average. Values have been stored in the array starting at A All the values to be counted are …
- Question 7
A programmer is testing a program that requires a positive value between 1 and 100 inclusive to be entered. The range check in the program is to be tested. Identify three different types of test data to be used. For …
- Question 8
A logic circuit is to be built to control the automatic opening of a window. The window W opens if the temperature T is too high, the heater H is off, and the air conditioning A is off. air conditioning …
- Question 9
A flowchart checks that values stored in three variables are identical. If they are different, the highest value is stored in all three variables. START STOP Is …
- Question 10
An algorithm has been written in pseudocode to check that a password meets a set of rules. 01 OUTPUT "Please enter password " 02 INPUT Password 03 Accept TRUE 04 IF LENGTH(Password) < 8 OR LENGTH(Password) …
- Question 11
Building materials are sold in bags. A new database table called BuildStock has been set up to store details about the materials for sale. Part of this table is given. MtNo Name InStock WeightKg PricePerBag NumberBags MT01 Builders sand Yes …
- Question 12
Members of a litter picking group complete a litter pick every month. Members’ names are stored in one-dimensional (1D) array PickerName[] Each member stores the weight of the litter they have picked in another one-dimensional (1D) array PickedWeight[] The weights …
Other Computer Science papers from Oct/Nov 2024
- 0478/11 Computer systems
- 0478/12 Computer systems
- 0478/13 Computer systems
- 0478/21 Algorithms, programming & logic
- 0478/22 Algorithms, programming & logic