Variables, constants, inputs, outputs and assignment

A program asks a user to enter a number. Only integer values between 1 and 100 (inclusive) are accepted. The program is tested.

Tick (✓) one or more boxes in each row to identify the type or types of test for each example of test data.

An algorithm is written for the program.

Complete the algorithm for the program.

num = input("Enter a number between 1 and 100")

if num........ AND........ then

print("accepted")

print("not accepted")

endif

Give the identifier of one variable used in the algorithm in part (b)(i).

Give one Boolean operator used in the algorithm in part (b)(i).

OCR Rockfest is a yearly music festival. Visitors buy tickets to attend and watch the music acts.

A computer system is created to sell tickets and store information about visitors and the music acts.

Visitors are asked to choose a password. The password is entered twice and stored in the variables passA and passB

Tick (✓) one box to identify the correct OCR Exam Reference Language statements for the design of this task.

Design an algorithm that:

• checks if the passwords stored in passA and passB are the same

• outputs "passwords match" if they are the same

• outputs "passwords do not match" if they are not the same.

The database table TblMusic stores data about the music acts.

Some of the data in TblMusic is shown:

An SQL statement has been written to show ActID and Stage for all acts playing on Saturday. The SQL statement is incorrect.

SELECT ActID AND Stage FROM TblActs IF Day = Saturday

Refine the SQL statement to correct the errors.

Identify one example of a record from TblMusic

Give the most appropriate data type for each field shown.

Tickets to the festival are £60 each. Visitors can buy multiple tickets. For example, a visitor buying 4 tickets would pay £240.

Write a function, calculatePrice() that:

• takes the number of tickets to be purchased as a parameter

• calculates and returns the total price to pay.

You must use either:

• OCR Exam Reference Language, or

• a high-level programming language that you have studied.

Write an algorithm that:

• uses the function calculatePrice() to find the price for a visitor buying 3 tickets

• stores the result in the variable totalPrice

You must use either:

• OCR Exam Reference Language, or

• a high-level programming language that you have studied.

The number of different music acts on each of the three stages is stored in the array actNumbers.

Each index of the array represents one stage.

This algorithm adds up the total number of acts on all three stages.

01 count = 0

02 for x = 0 to 2

03 count = count + actNumbers[x]

04 next x

05 print(count)

Complete the trace table for the algorithm. You may not need to use all rows in the table.

The array actNumbers is changed to include data for two more stages. The new array is shown:

Index 0 1 2 3 4

The algorithm from part (i) needs refining to work for the new array. The algorithm is repeated here:

01 count = 0

02 for x = 0 to 2

03 count = count + actNumbers[x]

04 next x

05 print(count)

Identify the line number that will need to be changed for the new array and write the updated line of code.

Refine line 05 in the algorithm to output "The total act count is " and then the content of the variable count

For example:

The total act count is 50

There are 500 tickets available for the music festival. The number of tickets currently available is stored in the variable tickets

Complete the algorithm to:

• prompt the user to enter how many tickets they would like and take this value as input

• output "Tickets booked" and reduce the value stored in tickets if there are enough tickets available

• output "Not enough tickets" if there are not enough tickets available

• repeat the steps until there are no tickets left.

You must use either:

• OCR Exam Reference Language, or

• a high-level programming language that you have studied

tickets = 500

The variable message is assigned a value.

message = "abcd1234"

Complete the table to show the output when each statement executes.

The first output has been completed for you.

Write an algorithm in pseudocode to:

• store "Hello" in the variable word1

• store "Everyone" in the variable word2

• concatenate word1 and word2 to store "HelloEveryone" in the variable message

The table contains four statements about programming languages.

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

The variables num1 and num2 store integers.

Write pseudocode to add the integers stored in num1 and num2. Store the result in a variable with the identifier total

Three incomplete pseudocode algorithms are given with a description of the purpose of each algorithm.

Write the missing arithmetic operator for each algorithm.

Outputting 12 to the power of 2.

Working out if a number is odd or even.

number = 53 if number ……………… 2 == 0 then print("Even number") else print("Odd number")

endif

Finding the difference between two measurements.

measurement1 = 300 measurement2 = 100

difference = measurement1 ……………… measurement2

Read the following pseudocode algorithm:

01 start = 3 02 do 03 print(start) 04 start = start - 1 05 until start == -1 06 print("Finished")

Complete the following trace table for the given algorithm.

An insertion sort is one type of sorting algorithm.

A student has written a pseudocode algorithm to perform an insertion sort on a 1D array names

names = ["Kareem", "Sarah", "Zac", "Sundip", "Anika"] for count = 1 to names.length – 1 pos = count while (pos > 0 and names[pos] < names[pos – 1]) temp = names[pos] names[pos] = names[pos – 1] names[pos – 1] = temp pos = pos – 1 endwhile next count

Describe the purpose of the variable temp in the insertion sort pseudocode algorithm.

An insertion sort contains a nested loop; a loop within a loop. In this pseudocode algorithm the outer loop is a count-controlled loop and the inner loop is a condition-controlled loop.

Explain why the inner loop needs to be a condition-controlled loop.

A bubble sort is another type of sorting algorithm.

Describe one difference between an insertion sort and a bubble sort.

Describe two similarities between an insertion sort and a bubble sort.

OCR Security Services is a company that installs intruder alarm systems in commercial buildings.

The systems use a computer that is connected to the door sensors and window sensors.

The following data is stored in the system:

Below is a table showing some variables within the program.

Tick (✓) one box in each row to identify the most appropriate data type for each variable.

The alarm has an algorithm that decides whether to sound the alarm by checking the data that is stored in the following three variables.

• SystemArmed

• DoorSensorActive

• WindowSensorActive

The alarm will only sound when the alarm has been activated and one or both of the door and window sensors are activated. When the system needs to sound the alarm it calls the pre-written procedure SoundAlarm()

Write a program that checks the data in the variables and calls SoundAlarm() when appropriate.

You must use either:

• OCR Exam Reference Language, or

• A high-level programming language that you have studied.

Give the line number where there is concatenation.

Give the identifier of a variable used in the program.

Identify the data type of the data returned by the function CheckSensorCode()

Give the line number that contains a function call.

Identify two programming constructs that have been used in the program.

The alarm system has a log that stores a record each time a sensor is triggered. This is called an event. The record format is given in the table:

The log is stored in a database table called events. The current contents of events is shown:

Write an SQL statement to display the sensor IDs of the door sensors that have been triggered for more than 20 seconds.

A program written in a high-level language is used to access the data from the database. This program has a procedure, SaveLogs(), that stores the data to an external text file.

The procedure SaveLogs():

• takes the string of data to be stored to the text file as a parameter

• takes the filename of the text file as a parameter

• stores the string of data to the text file.

Write the procedure SaveLogs()

You must use either:

• OCR Exam Reference Language, or

• A high-level programming language that you have studied.

OCR Security Services need to identify the total number of seconds the sensors have been activated on a specific date.

The data from the database table events is imported into the program written in a high-level programming language.

The program stores the data in a two-dimensional (2D) string array with the identifier arrayEvents

The data to be stored is shown in the table.

In this table, the value of events[1, 1] contains "MS1".

An array can only store data of one data type. Any non-string data must be converted to a string before storing in the array.

Identify the process that converts integer data to string data.

Write a program that:

• asks the user to input a date

• totals the number of seconds sensors have been activated on the date input

• outputs the calculated total in an appropriate message including the date, for example: Sensors were activated for 40 seconds on 05/02/2023

You must use either:

• OCR Exam Reference Language, or

• A high-level programming language that you have studied.

Tick (✓) one box in each row to identify whether the OCR Reference Language code given is an example of selection or iteration.

Write pseudocode to increment the value held in the variable score by one.

State the name of each of the following computational thinking techniques.

Breaking a complex problem down into smaller problems.

Hiding or removing irrelevant details from a problem to reduce the complexity.