2021 SST S4 Computing Prelim P2 QP final

Page 1 of 9 SECONDARY 4 PRELIMINARY EXAMINATION COMPUTING Paper 2 Practical (Lab-based) 7155/02 24 August 2021 (Tuesday) 2 hours 30 minutes CANDIDATE NAME CLASS INDEX NUMBER Additional Materials: Electronic version of CREDITCARD.xlsx data file Electronic version of TEAORDER.py file Electronic version of MORETEA.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 9 printed pages, including this Cover Page. Task 3 Task 4 Total 50 For Examiner’s Use Task 2 Task 1

Page 2 of 9 Task 1 A customer of a credit card company uses spreadsheet software to keep track of his expenditure with his credit card. He lists his spending according to the Transaction ID. You are required to help this customer finish up the spreadsheet. Open the file CREDITCARD.xlsx and you will see the following data. Save your file as MYCREDITCARD_<your class>_<index number>_<your name>.xlsx 1 In cell B14 enter a formula that uses (an) appropriate function(s) to find the total amount charged. [1] 2 In cell B15 enter a formula that uses (an) appropriate function(s) to find the range of the amount charged for the transactions. [1]

Page 3 of 9 [Turn over 3 The credit card company offers a varying percentage of cashback on expenditure, depending on the amount spent in each transaction. In cells C3 to C12 enter a formula that uses (an) appropriate function(s) to search for the Percentage Cashback in the Cashback table. [2] 4 The Transaction ID of each transaction consists of the date of the transaction followed by the shop name. In cells D3 to D12 enter a formula that uses (an) appropriate function(s) to obtain the Shop Name from the Transaction ID. [2] 5 In cells A3 to A12, use a formatting tool to change the colour of the cell to red if it corresponds to an expenditure of more than $50 as reflected in cells B3 to B12. [2] 6 The credit card company also allows their customers to pay their credit card bill in 6 equal monthly payments, with 12% of interest per annum, compounded monthly. In cell B16 enter a formula that uses (an) appropriate function(s) to find the total amount repayable, including interest, if they take this option. [2] Save and close your file. Task 2 begins on the next page.

Page 4 of 9 Task 2 The following program is a point-of-sale (POS) system which reads in a customer's drink order and displays the total bill. menu = ['OOLONG MILK TEA', 'EARL GREY MILK