JYSS 2019 P2

JUNYUAN SECONDARY SCHOOL PRELIMINARY EXAMINATION 2019 SECONDARY FOUR EXPRESS CANDIDATE NAME CLASS INDEX NUMBER COMPUTING 7155/02 Paper 2 (Practical) 23 Aug 2019 2 hours 30 minutes Additional Materials: 1 x Thumb Drive Electronic version of TASK1.xls file Electronic version of TASK2.py file Electronic version of TASK3.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 6 printed pages and 2 pages of Quick Reference for Python. [Turn over For Examiner’s Use Task 1 10 Task 2 10 Task 3 10 Task 4 20 Total 50

2 Task 1 BSOP Bank uses a spreadsheet for its customer loan records. You are required to finish setting up the spreadsheet to record the monthly repayment data. Open the file TASK1.xls. You will see the following data. Save the file as LOAN_<Class>_<Index>_<Name>.xlsx 1 For the cell range C7:C16, use an appropriate function to extract the last letter of the Customer Code to represent the Loan Type. [1] 2 Use an appropriate function to search for the Interest Rate per Year in the Interest Rate Table given and use it to complete the Interest Rate column. [2] 3 Enter a formula to calculate the simple interest payable by the customers and use it, together with the Loan Amount, to complete the Total Amount of Repayment column. [3] 4 Enter a formula to calculate the monthly amount repayable per customer and use it to complete the Monthly Repayment column. [2] 5 Use a conditional statement, to identify those customers who have undertaken a loan repayment amount of more than $15000 and whose application method was online, and put YES in the Free Power Bank column. Otherwise, put NO in the Free Power Bank column. Save and close your file. [2]

3 4E Computing P2 2019 Prelim [Turn over Task 2 The following program accepts ten positive integers between 0 and 100, both exclusive, and prints out the smallest integer. smallest = 100 counter = 0 while counter < 10: number = int(input("Enter a positive integer: ")) if number < smallest: smallest = number counter += 1 print("The smallest integer is ", smallest) Open the file TASK2.py Save the file as POSITIVE_<Class>_<Index>_<Name>.py 6 Edit the program so that it: (a) Accepts only five positive integers. [1] (b) Prints out the largest integer as well as the smallest integer. [4] (c) Tests if the number is positive, and if not, asks the user for another input. [3] 7 Save your program as VARPOSIT