Computer Science (9-1)

Year 11 Mock Exam

January 2024

Candidates answer on the Question paper.

Other materials required:

• Pencil Duration: 1 hour 30 mins
• Ruler (cm/mm)

Teacher’s Name Ms Tzimouli/Dr Stow Mr Fuller

Candidate name

Candidate number

INSTRUCTIONS TO CANDIDATES
• Write your candidate number in the boxes above and circle your teacher’s name. Please write clearly.
• Use black ink. HB pencil may be used for graphs and diagrams only.
• Answer all the questions unless your teacher tells you otherwise.
• Read each question carefully. Make sure you know what you must do before starting your answer.
• Where space is provided below the question, please write your answer there.
• You may use additional paper, or a specific Answer sheet if one is provided, but you must clearly show your candidate number and question
number(s).

INFORMATION FOR CANDIDATES

• The quality of written communication is assessed in questions marked with an asterisk.
• The number of marks is given in brackets [ ] at the end of each question or part question.
• The total number of marks for this paper is 95.
 Section A

© OCR 2022. You may photocopy this page. Page 2 of 15

1(a). Explain why data is stored in computers in a binary format.

[2]

(b). The following logo is stored as a bitmap image. Each box represents one pixel, with three different colours being used in the image.

State what is meant by the term image resolution.

[1]

(c). Calculate the fewest number of bits that could be used to store the logo as a bitmap image. You must show your working.

[4]

(d). Give two ways that the file size of the image could be reduced.

[2]
2(a). Ali’s tablet computer has an operating system.

Complete the following description of the functions of an operating system by selecting the appropriate missing words from those in the
box.

user drivers directories hardware interface multitasking

output peripherals printers processor RAM utility
ROM running passwords faster volatile virtual

The operating system provides a user .................................................... . This displays the

output to the user and allows the user to interact with the .................................................... .

The operating system controls the movement of data from secondary storage to

.................................................... and vice-versa. This is known as memory management.

The operating system can only perform one process at a time, but by managing the memory

the computer can appear to be completing more than one process at a time. This is known as

© OCR 2022. You may photocopy this page. Page 3 of 15

.................................................... .

An operating system allows device ..................................................... to be installed to allow

an external piece of hardware to interact with the .................................................... .

The operating system provides security through user accounts and

.................................................... . It also creates and maintains a file system to organise files

and .................................................... .

[8]

(b). Ali’s tablet computer has a CPU. Identify two events that take place during the fetch-execute cycle.

[2]
(c). Ali’s tablet computer has a magnetic hard drive disk.
Explain one reason why a secondary storage device is needed in most computer systems.

[2]
(d). Ali runs defragmentation analysis on his magnetic hard disk. Parts of the results are shown.

i. Explain how defragmentation will change how the files and free space are arranged on Ali’s hard disk.

© OCR 2022. You may photocopy this page. Page 4 of 15

 [3]

ii. After defragmentation, Ali’s computer is able to access files faster.

Explain why Ali’s computer can access the files faster after defragmentation.

[2]

iii. Give three additional examples of utility programs.

3
[3]

© OCR 2022. You may photocopy this page. Page 5 of 15

(e). Ali’s computer uses virtual memory. Ali has written two procedures to help himself understand how virtual memory works.

storeData() describes how data is stored in RAM.

accessData() describes how data is read from RAM.

Write the letter of the missing statements from the table in the correct place to complete the algorithms. Not all statements are used,
and some statements might be used more than once.

procedure storeData()

if RAM is ......................... then

move data from RAM to .........................

endif

store data in next free space in .........................

.........................

procedure accessData()

if ......................... (data required is in RAM) then

if RAM is full then

move unneeded data from RAM to HDD

endif

move required data from HD to RAM

endif

read data from .........................

endprocedure

Letter Statement

A Secondary storage

B NOT

C Full

D endfunction

E Empty

F endprocedure

G AND

H RAM

[6]

© OCR 2022. You may photocopy this page. Page 6 of 15

 (f). Ali’s tablet computer also has ROM (read only memory).

Describe the purpose of ROM in Ali’s tablet computer.

[2]

(g). Ali thinks his tablet is an embedded system.

State whether Ali is correct or incorrect, justifying your choice.

Choice

Justification

[3]

3(a). Complete a 3 place right shift on the binary number 11001011.

[1]
(b). Explain the effect of performing a 3 place right shift on the binary number 11001011.

[2]
(c). Add the following binary numbers.

[2]

4. * The use of digital technology in medicine is constantly evolving.

Discuss the impact of digital technology on medicine including:

• diagnosing patients
• treating patients
• storage of records.

© OCR 2022. You may photocopy this page. Page 7 of 15

 [8]

Section B

© OCR 2022. You may photocopy this page. Page 8 of 15

5. The database table Results stores the results for each student in each of their chosen subjects.

StudentName Subject Grade

Alistair English 3

Jaxon Art 5

Alex Art 4

Anna French 7

Ismaael Art 9

Complete the SQL query to return all of the fields for the students who take Art.

SELECT

FROM

WHERE

[3]

© OCR 2022. You may photocopy this page. Page 9 of 15

6.

i. Draw the logic diagram for the logic system P = A AND (B OR C)

[3]

ii. Complete the truth table for the logic system P = NOT (A AND B)

A B P

0 0 1

0 1

1 0

[4]

© OCR 2022. You may photocopy this page. Page 10 of 15

7. A school uses a mobile phone app to allow parents to book appointments for parents’ evenings.

Parents must log in before they can use the system. They then choose to book a new appointment, view all appointments already made or
update their personal details. If parents choose to view their appointments, they can either view them on-screen or print them off.

Each teacher has the assessment grades for each student. These grades are stored in numerical order.

i. The grades for one student are shown:

2 3 4 5 6 7 8

Show the steps that a binary search would take to check whether the student has achieved a grade 7 in any assessment.

Your answer must refer to the grades provided.

[4]

ii. Explain how a binary search would determine that a value does not appear in a given array.

[2]

iii. Give one advantage of a binary search over a linear search.

[1]

8. A car dealership uses a computer system to record details of the cars that it has for sale. Each car has a make, model, age and number
of miles driven.

Each car is given a star rating of 1 to 5, based on the age of the car and the number of miles it has been driven. This rating is recorded in
the computer system.

i. Define the term abstraction.

© OCR 2022. You may photocopy this page. Page 11 of 15

 [1]

ii. Give one example of how abstraction has been used in the design of this star rating system.

[1]

iii. Explain how authentication could be used as part of the defensive design considerations for this computer system.

[2]

© OCR 2022. You may photocopy this page. Page 12 of 15

9. OCR Tech is an online shop that sells electronics such as TVs and game consoles.

Customers can use a discount code to reduce the price of their purchase. Valid discount codes and their value (in pounds) are stored in a
global two-dimensional (2D) array with the identifier discount. The following table shows part of this 2D array.

For example, discount[2,0] holds discount code BGF2 and discount[2,1] holds the discount of 15 pounds.

A function searches through the 2D array and applies the discount to the price. The price and discount code are passed in as parameters.
The algorithm design is not complete.

i. Complete the design for the algorithm.

function checkdiscount(price, code)

newprice = price
size = len(discount) – 1
for x = 0 to ....................
if discount[x,0] == ................ then
newprice = ................ – discount[................]
endif
next x
............................
endfunction

[5]

ii. Identify two variables used in this function design.

[2]

© OCR 2022. You may photocopy this page. Page 13 of 15

iii. Write a program that:

• asks the user for an item price and discount code

uses the checkdiscount() function from part (i) to calculate the price of the item after any discount has been
•
applied
• repeats bullet points 1 and 2 until a price of 0 is entered
• outputs the total cost of all items entered, after any discounts have been applied.

You must use either:

• OCR Exam Reference Language, or

• A high-level programming language that you have studied

[6]

© OCR 2022. You may photocopy this page. Page 14 of 15

10(a).

Tick (✓) one box in each row to identify whether the statement refers to a high-level language or a low-level language.

Statement High-level language Low-level language

Uses English-like keywords such as print and

while

Must be translated before the processor can

execute code

Code written is portable between different

processors

Requires the programmer to understand the

processor’s registers and structure

[4]

(b). A translator is a common tool found in an Integrated Development Environment (IDE).

Describe two other common tools or facilities that an IDE can provide.

[4]

END OF QUESTION PAPER

© OCR 2022. You may photocopy this page. Page 15 of 15