2023

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

Computer Science 0478/23 Oct/Nov 2023 past paper

Cambridge IGCSE Computer Science (0478) Paper 2 (Algorithms, programming & logic), variant 3, Oct/Nov 2023: the question paper and its official mark scheme, 10 questions worth 75 marks, with the grade thresholds. Free to open, no account needed.

Questions
10
Marks
75
Grade A from
44

File names: 0478_w23_qp_23 ยท 0478_w23_ms_23

Grade thresholds for 0478/23 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/23 Oct/Nov 2023 tested, by marks. Each chapter links to every past-paper question on it.

ChapterQuestionsMarks
Databases325
Algorithm Design and Problem-Solving319
Scenario Question115
Boolean Logic111
Programming25

Questions in 0478/23 Oct/Nov 2023

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

    Tick (3) one box to show which term is an example of a verification check. A Double entry check B Format check C Length check D Presence check

  2. Question 2Programming ยท 1 mark

    Tick (3) one box to show which library routine returns the remainder of a division. A DIV B MOD C RANDOM D ROUND

  3. Question 3Databases ยท 6 marks

    (a) Four pseudocode descriptions and five pseudocode keywords are shown. Draw one line to link each pseudocode description to the most appropriate pseudocode keyword. Not all pseudocode keywords will be used. Pseudocode description Pseudocode keyword (b) Give two reasons for โ€ฆ

  4. Question 4Algorithm Design and Problem-Solving ยท 9 marks

    A programmer is writing a data entry program for booking theatre seats. The programmer needs the program to accept only whole numbers that are greater than or equal to one and less than or equal to six. (a) Give the โ€ฆ

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

    An algorithm has been written in pseudocode to check if a new password is in a list of previously used passwords OldList[] If the password is not found, the new password will be stored at the end of the list โ€ฆ

  6. Question 6Boolean Logic ยท 11 marks

    There are three descriptions of logic gates. Each logic gate has two inputs A and B with one output X. Identify each logic gate. Complete a truth table for each logic gate. (a) The only time the output is 1 โ€ฆ

  7. Question 7Programming ยท 4 marks

    A program uses both local variables and global variables. Describe two differences between local variables and global variables. Difference 1 Difference 2

  8. Question 8Databases ยท 8 marks

    This is an algorithm to find if a batch of parts has been manufactured successfully. Accept INPUT PartOK IS PartOK = 'Y'? IS Accept โ€ฆ

  9. Question 9Databases ยท 11 marks

    A sanctuary for pheasants has set up a new database table called PheasantList to store details of the different species of bird at the sanctuary. Part of this table is given, showing: species, description, number of birds at the sanctuary, โ€ฆ

  10. Question 10Scenario Question ยท 15 marks

    A weather station takes temperature readings once an hour for a week. These temperatures are stored in a two-dimensional (2D) array Temperatures[] Each column contains 24 readings for a single day. The first temperature is recorded at 00:00 and the โ€ฆ

Other Computer Science papers from Oct/Nov 2023

Questions students ask

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