SST 2019 Prelim P2

SECONDARY 4 PRELIM EXAMINATION COMPUTING Paper 2 Practical (Lab-based) 7155/02 27 August 2019 (Tuesday) 2 hour 30 minutes CANDIDATE NAME CLASS INDEX NUMBER Additional Materials: Electronic version of BANK.XLSX data file Electronic version of SHOPPING.PY file Electronic version of NUMBERS.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 7 printed pages.

Page 2 of 7 Task 1 The Bank of Singapore (BOS) uses a spreadsheet software to record the money deposited and how many months the money will be in the bank. You are required to finish setting up the spreadsheet to record the interest that will be paid. For consistency, you are also required to display all results as positive numbers. Open the file BANK.xlsx. You will see the following data. Save your file as BANK_<your name>_<index number>. (a) In cell C23, enter a formula to calculate the standard deviation of the amount deposited. [1] (b) In cell C24, enter a formula to count how many deposits are more than $3000. [1] (c) Use an appropriate function to search for the Interest Rate per year in the RATES table and use it to complete the Interest Rate column. [2] (d) Enter a formula to calculate the simple interest payable for account holders and use it to complete the Interest Payable. [2]

Page 3 of 7 [Turn over (e) Use a conditional statement to identify those savers who have deposited more than $3000 over 24 months and put YES in the Gift Voucher column. Otherwise put NO in the Gift Voucher Column. [2] (f) The bank manager wants to do some scenario planning, where each account holder deposits his/her money for 48 months with a compounded interest rate of 2.00% per annum. The amount of money in the account after 48 months is then recorded in the What-If column. Complete the column for all the bank accounts. [2] Save and close your file.

Page 4 of 7 Task 2 The following program simulates a shopping cart. It accepts 3 different items and the quantity of each item, and places them in a list. After processing, it prints out the item with the largest quantity, as well as its respective quantity. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 #input items