2024

Cambridge IGCSE ยท 0478 ยท Paper 2 ยท Algorithms, programming & logic

Computer Science 0478/21 Oct/Nov 2024 past paper

Cambridge IGCSE Computer Science (0478) Paper 2 (Algorithms, programming & logic), variant 1, Oct/Nov 2024: 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
44

File names: 0478_w24_qp_21 ยท 0478_w24_ms_21

Grade thresholds for 0478/21 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.

ABCDEFG
4435262117127

Topics in this paper

Which syllabus chapters 0478/21 Oct/Nov 2024 tested, by marks. Each chapter links to every past-paper question on it.

ChapterQuestionsMarks
Databases426
Algorithm Design and Problem-Solving318
Boolean Logic316
Scenario Question115

Questions in 0478/21 Oct/Nov 2024

  1. Question 1Algorithm Design and Problem-Solving ยท 1 mark

    Tick (โœ“) one box to show which check is used for verification when data is input. A length check B range check C type check D visual check

  2. Question 2Boolean Logic ยท 1 mark

    Tick (โœ“) one box to identify which option is used to show the inputs and output of a Boolean expression. A flowchart B trace table C truth table D variable

  3. Question 3Databases ยท 4 marks

    Four operators and three types of operator are shown. Draw one or more lines from each operator to its correct operator type. >= AND DIV + Operator Boolean Arithmetic Logical Operator type

  4. Question 4Databases ยท 3 marks

    Identify three stages of the program development life cycle from the following list of words. analysis decomposition design input pseudocode testing variable โ€ฆ

  5. Question 5Algorithm Design and Problem-Solving ยท 6 marks

    Describe three methods that are used to design and construct a solution to a problem. Method 1 Method 2 Method 3

  6. Question 6Databases ยท 9 marks

    An incomplete algorithm has been written in pseudocode to count the number of zeros stored in an array and total the non-zero values. 01 DECLARE A[1:50] : INTEGER 02 DECLARE C : INTEGER 03 DECLARE I : INTEGER 04 DECLARE โ€ฆ

  7. Question 7Boolean Logic ยท 7 marks
  8. Question 8Algorithm Design and Problem-Solving ยท 11 marks

    A programmer is designing a program to check the length of a password and to check if the password input is the same as the stored password. The program requirements are: โ€ข input the password, Password โ€ข check if there โ€ฆ

  9. Question 9Boolean Logic ยท 8 marks

    An algorithm has been written in pseudocode to check if a temperature is in a given range. The temperature values used in the algorithm are correct. 01 REPEAT 02 OUTPUT "Please enter temperature " 03 INPUT Temp 04 IF Temperature โ€ฆ

  10. Question 10Databases ยท 10 marks

    A shop that sells cheese has set up a new database table called CheeseStock to store details of the cheeses available for sale. Part of this table is given. ChNo Name InStock SupplierCode PricePerKg WeightKg CH01 American Yes XYZ 4.50 โ€ฆ

  11. Question 11Scenario Question ยท 15 marks

    A running club has 200 members who compete in a 1-kilometre running competition every month. Membersโ€™ names are stored in the one-dimensional (1D) array MemberName[] Each memberโ€™s time, in seconds, for the 1-kilometre run will be stored in another one-dimensional โ€ฆ

Other Computer Science papers from Oct/Nov 2024

Questions students ask

Where can I get the 0478/21 Oct/Nov 2024 mark scheme?
Open the mark scheme above - it is the official Cambridge scheme for this exact paper (0478_w24_ms_21), and on a wide screen it sits beside the question you are reading.
What was the grade threshold for an A in 0478/21 Oct/Nov 2024?
44 marks out of 75, a C needed 26.
Which topics came up in 0478/21 Oct/Nov 2024?
Mostly Databases, Algorithm Design and Problem-Solving, Boolean Logic. The full list is in the table above.
Do I need an account to open 0478/21 Oct/Nov 2024?
No. Every paper opens for free without signing in. A free account also saves your pen marks and records your score against the grade thresholds.