CTSS 2019 P2

[Turn over Name: _____________________________ Register Number: ______ Class: _______ Clementi Town Secondary School Preliminary Examination 2019 Secondary 4 Express Computing 7155/02 28 August 2019 2 hours 30 mins CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL Additional Materials: Electronic version of MEMBERS’S_SAVING.XLSX date file Electronic version of SCORE.PY file Electronic version of BMI.PY file Data Resource Files Quick reference for Python sheet 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 question paper consists of 7 printed pages, including this cover page. For Examiner’s Use 50

2 Clementi Town Secondary School Computing Secondary 4 Express Preliminary Examination 2019 Answer all the questions. Task 1 A bank uses spreadsheet software to record the amount and duration that members save in their fixed deposit account. The bank offers compounded interest to all its savers. You are required to finish setting up the spreadsheet to record the interest they will be getting. Open the file MEMBER’S_Savings. You will see the following data. Save the file as MEMBER’S_Savings _<your_name>_<class>_<index number>. 1 In cell B23 enter a formula to calculate the total amount of savings. [1] 2 In cell B24 enter a formula to count how many members there are. [1] 3 In cell B25 enter a formula to count the longest duration. [1] 4 Use an appropriate function to search for the Rate in the Interest Rates table and use it to complete the Rate column. [2]

Clementi Town Secondary School 3 Preliminary Examination 2019 Secondary 4 Express Computing [Turn over 5 Enter a formula to calculate the interest members will be earning and use it to complete the Interest Earned column. [3]