SST 2022 S4 Computing Prelim P2 QP final

SECONDARY 4 PRELIMINARY EXAMINATION COMPUTING Paper 2 Practical (Lab-based) 7155/02 23 August 2022 (Tuesday) 2 hours 30 minutes CANDIDATE NAME CLASS INDEX NUMBER Additional Materials: Electronic version of BLOSSOM.xlsx data file Electronic version of BUBBLES.py file Electronic version of BUTTERCUP.py file Insert Quick Reference Glossary READ THESE INSTRUCTIONS FIRST Answer all 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. This document consists of 8 printed pages, including this Cover Page. Task 3 Task 4 Total 50 For Examiner’s Use Task 2 Task 1

Page 2 of 8 Task 1 Blossom Fresh Fruits and Vegetables uses spreadsheet software to create a receipt for a customer. The items ordered and their unit prices are listed. You are required to help the shop finish up the spreadsheet. Open the file BLOSSOM.xlsx and you will see the following data. Save your file as MYBLOSSOM_2022_<your class>_<index number>_<your name>.xlsx 1 In cell C15 enter a formula that uses (an) appropriate function(s) to find median unit price of all the types of fruits and vegetables sold. [1] 2 In cell C16 enter a formula that uses (an) appropriate function(s) to find total price of the items with 10 or more units ordered. [1] 3 In cells D3 to D12 enter a formula to calculate the Item Subtotal for each item. The Item Subtotal is the unit price multiplied by the number of units ordered. [1] 4 In cell D13, enter a formula that uses (an) appropriate function(s) to calculate the Total that the customer should pay. [1]

Page 3 of 8 [Turn over 5 Blossom Fresh Fruits and Vegetables has a loyalty point system. For each item bought, every $1 spent will earn the customer 1 point. The number of points earned per item is rounded down to the nearest whole number. In cells E3 to E12 enter a formula that uses (an) appropriate function(s) to calculate the number of Points per Item earned. [1] 6 For certain items, the shop also offers a bonus multiplier on the number of points per item earned. This multiplier can vary between 2 times to 5 times the calculated number in the Points per Item column. The items with the bonus points multiplier and their respective multipliers are shown in the Bonus Points Multiplier table. In cells F3 to F12 enter a formula that uses (an) appropriate function(s) to search for the Bonus Multiplier in the Bonus Points Multiplier table. If the item is not in the table, the cell in the corresponding row should show "1". Otherwise, the cell should show the bonus multiplier for the item. [3] 7 In c