OCR GCSE (9–1) Computer Science J276/02 - Computational thinking, algorithms and programming - Paper 2

Sep 5, 2026

GCSE (9–1) Computer Science exam question paper focused on computational thinking, algorithms and programming. The paper tests data representation and database skills using a student conduct system, requiring appropriate data types, SQL queries, and SQL wildcard usage. It also assesses algorithm design by reading records into a zero-based array and outputting whether a letter was sent. Additional tasks evaluate nested loops, output sequencing, and programming constructs, including variables.

LanguageEnglish

CategoryExam

FormatPDF

Pages16

Reading Time40 min

AccessFree to download

Instructions and information

Question 1: Student conduct database and algorithms

(a) Data types for stored items

(b) SQL selection and wildcard usage

Question 2: Nested loops and programming fundamentals

Oxford Cambridge and RSA GCSE (9–1) Computer Science J276/02 Computational thinking, algorithms and programming Thursday 17 May 2018 – Afternoon Time allowed: 1 hour 30 minutes Do not use: • a calculator | First name | | | --- | --- | | Last name | | | --- | --- | INSTRUCTIONS • Use black ink. • Complete the boxes above with your name, centre number and candidate number. • Answer all the questions. • Write your answer to each question in the space provided. If additional space is required, use the lined page(s) at the end of this booklet. The question number(s) must be clearly shown. • Do not write in the barcodes. INFORMATION • The total mark for this paper is 80. • The marks for each question are shown in brackets [ ] . • This document consists of 16 pages. No calculator can be used for this paper © OCR 2018 [601/8355/X] DC (ST/SG) 155699/6 OCR is an exempt Charity Turn over 2 Answer all the questions. 1 OCR High School uses a computer system to store data about students’ conduct. The system records good conduct as a positive number and poor conduct as a negative number. A TRUE or FALSE value is also used to record whether or not a letter has been sent home about each incident. An example of the data held in this system is shown below in Fig. 1: | StudentName | Detail | Points | LetterSent | | --- | --- | --- | --- | | Kirstie | Homework forgotten | −2 | FALSE | | Byron | Good effort in class | 1 | TRUE | | Grahame | 100% in a test | 2 | FALSE | | Marian | Bullying | −3 | TRUE | Fig. 1 (a) State the most appropriate data type used to store each of the following items of data. • StudentName .................................................................................................................... • Points ................................................................................................................................ • LetterSent .......................................................................................................................... [3] (b) The data shown above in Fig. 1 is stored in a database table called Conduct. (i) Write an SQL statement to select the StudentName field for all records that have negative Points. ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [3] (ii) State the wildcard that can be used in SQL to show all fields from a table. ........................................................................................................................................... ...................................................................................................................................... [ 1] © OCR 2018 3 (c) A single record from this database table is read into a program that uses an array with the identifier studentdata. An example of this array is shown below: studentdata = [“Kirstie”, “Homework forgotten”, “-2”, “FALSE”] The array is zero based, so studentdata[0] holds the value “Kirstie”. Write an algorithm that will identify whether the data in the studentdata array shows that a letter has been sent home or not for the student. The algorithm should then output either“sent”(if a letter has been sent) or “not sent”(if a letter has not been sent) . | | | --- | | | | | | | | | | | | | | | | | .............................................................................................................................................. [4] © OCR 2018 Turn over 4 2 A programmer has written an algorithm to output a series of numbers. The algorithm is shown below: 01 for k = 1 to 3 02 for p

FAQs

What is the paper’s total mark and permitted resources?

The total mark for the paper is 80. No calculator can be used, and the paper states the total time allowed is 1 hour 30 minutes.

How does Question 1 define the stored conduct data?

Good conduct is stored as a positive number and poor conduct as a negative number. A TRUE/FALSE value records whether a letter was sent home about each incident.

What is required in Question 1(c) using the studentdata array?

An algorithm must check the array contents to determine whether a letter was sent. It then outputs "sent" if a letter was sent, or "not sent" if it was not.

Sep 5, 2026

Upload by Lucas Vance