Additional Programming Techniques (OCR GCSE Computer Science)

Customers at a hotel can stay between 1 and 5 (inclusive) nights and can choose between a basic room or a premium room.

A typical booking record is shown in the table:

Booking records are stored in a database table called TblBookings

The following SQL statement is written to display all customer bookings that stay more than one night.

SELECT ALL

FROM TblBookings

IF Nights < 1

The SQL statement is incorrect.

Rewrite the SQL statement so that it is correct.

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

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

Data for one week (Monday to Friday) is stored in a 2D array with the identifier minsPlayed.

The following table shows part of this array, containing 4 students.

The teacher wants to output the number of minutes Dan (column index 3) played computer games on Wednesday (row index 2). The following code is written:

print(minsPlayed[3,2])

Write a line of code to output the number of minutes that Stuart played computer games on Friday.

You must use either:

• OCR Exam Reference Language, or

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

A program is being created to convert the data capacity of a storage device into a different measure.

The function, calculate(), takes the measurement (e.g. gigabytes) and the number (e.g. 2) as two parameters.

It then returns the value in bits.

The function returns –1 if an invalid measurement was entered.

Complete the function calculate

function calculate(.......................,number) 

if measurement == "gigabytes" then 

    value = number * 1024 * 1024 * 1024 * 8 

elseif measurement == "....................." then 

    value = number * 1024 * 1024 * 8 

elseif measurement = = "....................." then 

    value = number * 1024 * 8 

elseif measure = = "bytes" then 

    value = number.................. 

else

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

endif 

return ........................... 

endfunction

OCRBlocks is a game played on a 5 × 5 grid. Players take it in turns to place blocks on the board. The board is stored as a two-dimensional (2D) array with the identifier gamegrid

Fig. 6.1 shows that players A and B have placed three blocks each so far.

The function checkblock() checks whether a square on the board has been filled. When checkblock(4,2) is called, the value "A" is returned.

function checkblock(r,c) 

    if gamegrid[r,c] == "A" or gamegrid[r,c] == "B" then 

       outcome = gamegrid[r,c] 

     else 

       outcome = "FREE" 

     endif 

     return outcome 

endfunction

Give the returned value when the following statements are called

A vending machine stores the quantity of items available in a database table called ITEMS. The current contents of ITEMS is shown:

Complete the following SQL statement to display the item code for all items that have fewer than 10 in stock.

An example of the data held in a system is shown below in Fig. 1:

Fig. 1

The data shown above in Fig. 1 is stored in a database table called Conduct.

Write an SQL statement to select the StudentName field for all records that have negative Points.

State the wildcard that can be used in SQL to show all fields from a table.

Functions and procedures are both examples of sub programs.

Describe one difference between a function and a procedure.

Describe two benefits to a programmer of using sub programs.

A Basic room costs £60 each night. A Premium room costs £80 each night.

Create a function, newPrice(), that takes the number of nights and the type of room as parameters, calculates and returns the price to pay.

You do not have to validate these parameters.

You must use either:

• OCR Exam Reference Language, or

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

Write program code, that uses newPrice(), to output the price of staying in a Premium room for 5 nights.

You must use either:

• OCR Exam Reference Language, or

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

A program is created to convert hours and minutes into a total number of minutes.

The teacher wants to create a sub program to perform the calculation.

The program has been started but is not complete.

Complete the design for the program.

hours = input("Please enter number of hours played") 

minutes = input("Please enter number of minutes played") 

finalTotal = ……………………………………………………………….. 

print(finalTotal) 



function ………………………………………………………………………………………………………………

         ………………………………………………………………………………………………………………

         ………………………………………………………………………………………………………………

         ………………………………………………………………………………………………………………

         ………………………………………………………………………………………………………………

endfunction

A programmer declares the following variables.

first = "Computer Science"

second = "is great"

State the output from the following line of program code.

print(first.length)

State the output from the following line of program code.

print(second.length DIV 3)

State the output from the following line of program code.

print(3 ^ 2)

A programmer declares the following variables.

first = "Computer Science"

second = "is great"

Strings can be concatenated (joined together) using the + operator.

For example, print("Maths " + second) will output Maths is great

Use string manipulation with the variables first and/or second to produce the following output.

great

Use string manipulation with the variables first and/or second to produce the following output.

Computer

Use string manipulation with the variables first and/or second to produce the following output.

Science is great

The number of goals scored in each football match is held in an array called goals. An example of this array is shown.

goals = [0, 1, 3, 0, 4, 5, 2, 0, 2, 1]

Elliott wants to count how many matches end with 0 goals.

Complete the following pseudocode for an algorithm to count up how many matches with 0 goals are stored in the array and then print out this value.

01 nogoalscount = 0 

02 for count = 0 to (goals.length-1) 

03     if goals[…………………………] == 0 then 

04         nogoalscount …………………………………………………… 

05     endif 

06 next count 

07 print(……………………………………………)

OCR Land is a theme park aimed at children and adults. Entrance tickets are sold online. An adult ticket to OCR Land costs £19.99, with a child ticket costing £8.99. A booking fee of £2.50 is added to all orders.

A function, ticketprice(), takes the number of adult tickets and the number of child tickets as parameters. It calculates and returns the total price to be paid.

Use pseudocode to create an algorithm for the function ticketprice().

Tick (✓) one box to identify the data type of the value returned from the function ticketprice(), justifying your choice.

A library gives each book a code made from the first three letters of the book title in upper case, followed by the last two digits of the year the book was published.

For example, “Poetry from the War”, published in 2012 would be given the code POE12.

Complete the following pseudocode for a function definition that will take in the book title and year as parameters and return the book code.

01 function librarycode(title, ………………………………………………)

02     parta = title.subString(0, ………………………………………………)

03     partb = year.subString(2, 2)

04     ……………………………………………… parta.upper + partb

05 endfunction

Use pseudocode to write an algorithm that does the following :

• Inputs the title and year of a book from the user.

• Uses the librarycode function above to work out the book code

• Permanently stores the new book code to the text file bookcodes.txt