2023

Cambridge IGCSE · 0478 · Paper 2 · Algorithms, programming & logic

Computer Science 0478/22 Oct/Nov 2023 past paper

Cambridge IGCSE Computer Science (0478) Paper 2 (Algorithms, programming & logic), variant 2, Oct/Nov 2023: 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_w23_qp_22 · 0478_w23_ms_22

Grade thresholds for 0478/22 Oct/Nov 2023

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
4434252015117

Topics in this paper

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

ChapterQuestionsMarks
Boolean Logic323
Databases321
Scenario Question115
Algorithm Design and Problem-Solving29
Programming27

Questions in 0478/22 Oct/Nov 2023

  1. Question 1Algorithm Design and Problem-Solving · 1 mark

    Tick (✓) one box to complete the sentence. Verification is used to make sure that a value entered A has not changed during input. B is an integer. C is correct. D is not a string.

  2. Question 2Boolean Logic · 7 marks

    A type of validation check is a length check. Another type of validation check is used to make sure that any date entered is in the dd/mm/yyyy style: dd means day, mm means month and yyyy means year. (a) State …

  3. Question 3Algorithm Design and Problem-Solving · 8 marks

    Four pseudocode statements and five pseudocode uses are shown. (a) Draw one line to link each pseudocode statement to the most appropriate pseudocode use. Not all pseudocode uses will be required. Pseudocode statement CALL Colour(NewColour) Value …

  4. Question 4Databases · 9 marks

    An algorithm has been written in pseudocode to allow the names of 50 cities and their countries to be entered and stored in a two‑dimensional (2D) array. The contents of the array are then output. 01 DECLARE City ARRAY[1:50, 1:2] …

  5. Question 5Programming · 3 marks

    Explain how variables and constants should be used when creating and running a program.

  6. Question 6Databases · 7 marks

    The flowchart represents an algorithm that performs a process on groups of values that are input. The algorithm will fail if the first value of any group is 0. An input of –1 will terminate the algorithm. START STOP Total …

  7. Question 7Databases · 5 marks

    The string operation SUBSTRING(Quote, Start, Number) returns a string from Quote beginning at position Start that is Number characters long. The first character in Quote is in position 1. Write pseudocode statements to: • store the string "Learning Never Exhausts …

  8. Question 8Programming · 4 marks

    Explain why a programmer would use procedures and parameters when writing a program.

  9. Question 9Boolean Logic · 8 marks

    Consider the logic expression: …

  10. Question 10Boolean Logic · 8 marks

    A database table called Horses stores details about the horses kept at a horse sanctuary. Code Breed BreedOrigin Gender Age Arrived H002 Arabian Saudi Arabia …

  11. Question 11Scenario Question · 15 marks

    A wood flooring company stores the names of up to 100 customers in a one‑dimensional (1D) array Customers[]. A two‑dimensional (2D) array Quotations[] stores details of each customer’s quotation: • length of room (one decimal place) • width of room …

Other Computer Science papers from Oct/Nov 2023

Questions students ask

Where can I get the 0478/22 Oct/Nov 2023 mark scheme?
Open the mark scheme above - it is the official Cambridge scheme for this exact paper (0478_w23_ms_22), and on a wide screen it sits beside the question you are reading.
What was the grade threshold for an A in 0478/22 Oct/Nov 2023?
44 marks out of 75, a C needed 25.
Which topics came up in 0478/22 Oct/Nov 2023?
Mostly Boolean Logic, Databases, Scenario Question. The full list is in the table above.
Do I need an account to open 0478/22 Oct/Nov 2023?
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.