PrepWithTee owl logo PrepWithTee
2022

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

Computer Science 0478/22 Oct/Nov 2022 past paper

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

Questions
7
Marks
50
Grade A from
30
Open the question paperMark scheme

File names: 0478_w22_qp_22 · 0478_w22_ms_22

Grade thresholds for 0478/22 Oct/Nov 2022

The minimum raw marks Cambridge set for each grade on this component (out of 50). Thresholds change every session and variant, so always compare your score with the paper you actually sat.

ABCDEFG
302214121086

Topics in this paper

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

ChapterQuestionsMarks
Databases424
Scenario Question120
Algorithm Design and Problem-Solving26

Questions in 0478/22 Oct/Nov 2022

  1. Question 1Scenario Question · 20 marks

    All variables, constants and other identifiers must have meaningful names. (a) (i) Identify one constant you could have used for Task 1 and state its value. Constant Value (ii) Identify one array you could have used in Task 1 and …

  2. Question 2Algorithm Design and Problem-Solving · 4 marks

    Draw a line to connect each programming concept to the most appropriate description. counting repetition selection sequence totalling carrying out an action multiple times within a loop structure adding together the numbers in a list of numbers tracking the number …

  3. Question 3Databases · 3 marks

    Describe the use of verification on input of data when entering a list of items in stock into a database. Explain why verification is necessary.

  4. Question 4Algorithm Design and Problem-Solving · 2 marks

    Describe one type of test data that must be used to test if a program accepts valid input data.

  5. Question 5Databases · 8 marks

    This pseudocode should allow 500 marks to be entered into the algorithm. If the mark is 80 or greater it is stored in an array for higher marks. If the mark is less than 80, but greater than or equal …

  6. Question 6Databases · 5 marks

    This flowchart represents an algorithm to divide three-digit numbers into hundreds, tens and units. The pre-defined function DIV gives the value of the result of integer division, for example …

  7. Question 7Databases · 8 marks

    A school uses a database table, ASSESS, to keep a record of the internal assessments and the number of candidates for each of the subjects in its curriculum. SubjectCode SubjectName Exams Practicals Candidates COMP Computer Science …

Other Computer Science papers from Oct/Nov 2022

Questions students ask

Where can I get the 0478/22 Oct/Nov 2022 mark scheme?
Open the mark scheme above - it is the official Cambridge scheme for this exact paper (0478_w22_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 2022?
30 marks out of 50, a C needed 14.
Which topics came up in 0478/22 Oct/Nov 2022?
Mostly Databases, Scenario Question, Algorithm Design and Problem-Solving. The full list is in the table above.
Do I need an account to open 0478/22 Oct/Nov 2022?
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.