MFSS 2020 P2

Name: ______________________________ ( ) Class: _______ MONTFORT SECONDARY SCHOOL PRELIMINARY EXAMINATION 2020 Secondary 4 Express COMPUTING Paper 2 Practical (Lab-based) 1.00 pm 7155/02 1 Sep 2020 (Tue) 2 hours 30 minutes Additional Materials: Electronic version of LOANS.xlxs data file Electronic version of NUMBER.py file Electronic version of NAPFA.py file Insert Quick Reference Glossary attached as ANNEX A 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. Write in dark blue or black pen. 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 marks for this paper is 50. Parent’s Signature: _______________________ For Examiner’s Use Total 50 This document consists of 8 printed page. Setter: Mr Ricky Tan

2 Task 1 A loan broker keeps track of his clients’ housing loans using a spreadsheet. The rates of three banks are compared and the best (lowest) rate is used to calculate each client’s Monthly Payment. You are required to finish setting up the spreadsheet. Open the file LOANS.xlsx. You will see the following data. Save the file as MYLOANS_<your name>_<your class>_<index number>.xlsx 1 In cells F2 to F13 enter a formula that uses an appropriate function to search for the rate offered by Bank C for each given principal. The rates offered by each bank is given in the Rates table. [2] 2 In cells G2 to G13 enter a formula to determine the Best Rate among the rates offered by the three banks. The best rate is the lowest of Rate A, Rate B, and Rate C [2] 3 In cells H2 to H13 enter a formula to calculate the Monthly Payment of a loan based on the Best Rate. [2]

3 4 In cells I2 to I13 enter a formula to calculate the Total Payment made of a loan based on the Best Rate. The Total Payment made is the sum of all monthly payments for the duration of the loan. [2] 5 In cells J2 to J13 enter a formula to calculate the Total Interest paid of a loan based on the Best Rate. The Total Interest paid is amount of interest that was paid to the bank for the duration of the loan. [2] Task 2 begins on the next page.

4 Task 2 The following program is a number guessing game that allows the user to guess a randomly generated number between 1 and 10 inclusive. The program does the following: • Generates a random number between 1 and 10 inclusive; • Allows the user to repeatedly guess the randomly generated number by entering a number; • Informs the user that his guess is correct if his guess matc