ACSBR 2019 P2

Anglo-Chinese School (Barker Road) Prelim Examination 2019 1 Secondary 4 Express Computing 7155/02 Name: Class: 4S3 Index Number: PRELIMINARY EXAMINATION 2019 SECONDARY FOUR EXPRESS COMPUTING PAPER 2 7155/02 2 HOUR 30 MINUTES INSTRUCTIONS TO CANDIDATES Additional Materials: Electronic version of LOANS.XLSX data file Electronic version of FACTORS.PY Python file Electronic version of CHECKCODE.PY Python file Insert Quick Reference Glossary 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 6 printed pages, inclusive of the cover page Anglo-Chinese S chool (Barker Road)

Anglo-Chinese School (Barker Road) Prelim Examination 2019 2 Secondary 4 Express Computing 7155/02 Task 1 A company uses a spreadsheet to record the loans from customers. You are required to finish setting up the spreadsheet to calculate the monthly instalment for each of the account number. Open the file LOANS. You will see the following data. Save the file as MYLOANS_<your name>_<index number> 1 Use a function to extract the type of loans from account number and use it to complete the Loan Type column. The type of loans is the letters from the account number. [2] 2 Use an appropriate function to search for the Interest rate per annum in the Rates table and use it to complete the Interest rate per annum column. [2] 3 Use an appropriate function to search for the Processing Fee in the Rates table and use it to complete the Processing Fee ($) column. The processing fee is a percentage from the loan amount. [2] 4 Use an appropriate function to calculate the monthly instalment amount and use it to complete the Monthly Instalment column. [2] 5 Use an appropriate function to find out the number of Car, Cash and Study in the Loan Types table. [2] Save and close your file.

Anglo-Chinese School (Barker Road) Prelim Examination 2019 3 Secondary 4 Express Computing 7155/02 Task 2 The following program accepts positive integer numbers and prints out the factors for the numbers. for i in range(2): factor_count = 0 number = int(input("Enter a number:")) for i in range(1,number+1): if number%i==0: factor_count += 1 Open the file FACTORS.py Save the file as MYFACTORS_<your name>_<index number> 6 Edit the program so that it: (a) Accept input for 5 numbers. [1] (b) Prints out the factors for each of the number in a list. [4] (c) Tests if the input is a positive number, and if not, asks the user for input agai