2021 SPS Computing P2

[Turn over NAME CLASS INDEX NO. ST. PATRICK'S SCHOOL PRELIMINARY EXAMINATION 2021 SUBJECT : Computing Paper 2 (7155/02) DATE : 24 August 2021 LEVEL : Secondary 4 Express DURATION : 2 hours 30 minutes ADDITIONAL MATERIALS: Electronic version of ORDERS.xlsx data file Electronic version of DRINK.py file Electronic version of REVERSE.py file Quick Reference Glossary INSTRUCTIONS TO CANDIDATES: Write your Name, Class and Index No. in the spaces at the top of this page. Write in dark blue or back pen. Answer all the questions. All tasks must be done in the computer laboratory. You are not allowed to bring in or take out any pieces of work or materials on paper or electronic media or in any other form. Programs are to be written in Python. Save your work using the file name given in the question as and when necessary. 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 50. INFORMATION FOR CANDIDATES: The allocated marks for each question are indicated in the brackets [ ]. For Examiner’s Use Score /50 This question paper consists of 8 printed pages, including the cover page. Candidates answer on the Question Paper.

2

3 [Turn over

4 Task 1 A food and beverage company uses a spreadsheet software to keep track of its customers’ orders. Open the file ORDERS.xlsx. You will see the following data. Save the file as MYORDERS_<Class>_<Class_Index_Number>_<Your_Name>.xlsx 1 The first character of Order ID denotes the zone of the order. In cells B4 to B15, enter a formula that uses an appropriate function to display the zone of the order. [1] 2 In cells E4 to E15, enter a formula that uses an appropriate function to search for the Price of the respective Bento Set and calculate the total price of each order. [2] 3 A discount of 20% is given for orders whose Total Price is above $40. In cells F4 to F15, enter a formula that uses an appropriate function to calculate the price after discount for each order. [3] 4 In cell F16, enter a formula that uses an appropriate function that calculates the total revenue for the day. [1] 5 In cells B20 to F20, enter a formula that uses an appropriate function that calculates the total quantity of each bento set ordered. [2] 6 In cells F4 to F15, use a formatting tool to change the colour of the cells whose value is at least $50, to green fill. [1]

5 [Turn over Task 2 The following program displays a list of drinks available and asks user to input a drink to search within the list. a_list = ["PowerBoost", "EnergyOne", "RedOx", "VitaJuice", "HydroPlus"] print (a_list) search = input("Enter a drink: ") Open the file DRINK.py Save the file as MYDRINK_<Class>_<Class_Index_Number>_<Your_Name>.py 7 Edit the program