2018

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

Computer Science 0478/22 Oct/Nov 2018 past paper

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

Questions
6
Marks
50
Grade A from
34

File names: 0478_w18_qp_22 ยท 0478_w18_ms_22

Grade thresholds for 0478/22 Oct/Nov 2018

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
342619151173

Topics in this paper

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

ChapterQuestionsMarks
Programming330
Databases211
Algorithm Design and Problem-Solving19

Questions in 0478/22 Oct/Nov 2018

  1. Question 1Programming ยท 20 marks

    (a) All variables, arrays, constants and other identifiers should have meaningful names. (i) State the name of one variable you have used for Task 3. Give the data type for the variable. State what it is used for. Variable name โ€ฆ

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

    (a) Write an algorithm, using pseudocode, to input three different numbers, multiply the two larger numbers together and output the result. Use the variables: Number1, Number2 and Number3 for your numbers and Answer for your result. (b) Give two sets โ€ฆ

  3. Question 3Programming ยท 3 marks

    Four programming concepts and four descriptions are shown. Draw a line to connect each programming concept to the most appropriate description. Function Procedure Structure diagram Library routine A subroutine that does not have to return a value. A standard subroutine โ€ฆ

  4. Question 4Databases ยท 4 marks

    A programmer wants to test that the readings from 2000 electricity meters are greater than 400 units and less than 900 units. The programmer uses selection and repetition statements as part of the program. Explain, using programming statements, how selection โ€ฆ

  5. Question 5Programming ยท 7 marks

    The flowchart checks the level of chlorine and the depth of water compared to the height of the swimming pool. Error messages are output if a problem is found. No No No No Yes Yes Yes Yes Yes No OUTPUT โ€ฆ

  6. Question 6Databases ยท 7 marks

    A database table, PORTRAIT, is used to keep a record of the portraits available from a photographic studio. Each portrait has a unique reference number PICnnn, where n is a single digit, for example PIC123. The studio keeps a record โ€ฆ

Other Computer Science papers from Oct/Nov 2018

Questions students ask

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