BVSS 2018 P2

Name: _____________________________ ( ) Class: _____ Thumb Drive : _____ COMPUTING 7155/2 Paper 2 Practical (Lab-based) 29 Aug 2018 2 hour 30 minutes Additional Materials: Electronic version of CREDITLOAN.XLSX data file Electronic version of ITEMCATEGORIES.PY file Electronic version of ISBNCHECKDIGIT.PY file Insert Quick Reference Glossary READ THESE INSTRUCTIONS FIRST Do not open this booklet until you are told to do so. Write your name, index number, and class in the spaces provided at the top of this page. 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. Answer all questions BUKIT VIEW SECONDARY SCHOOL PRELIMINARY EXAMINATION 2018 Secondary 4 Express BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL 50 O-Level Candidate Index No : ____________

2 Task 1 Horizon Credit Pte Ltd uses spreadsheet software to record the amount of money loaned and how many months the money will be loaned. The borrowers will repay the loan in a lump sum at the end of the loan period. Interest is compounded monthly. You are required to finish setting up the spreadsheet to record the lump sum amount that will be paid by the borrowers. Open the file CREDITLOAN. You will see the following data. Save the file as LOAN_<your name>_<centre number>_<index number> 1 In cell B20, enter a formula to calculate