BLSS 2018 Computing P2

BOON LAY SECONDARY SCHOOL PRELIMINARY EXAMINATION 2018 Name ( ) Class Subject : COMPUTING Paper No : 2 Subject Code : 7155/02 Level : SECONDARY FOUR EXPRESS Date/Day : 28 AUGUST 2018 (TUESDAY) Time : 1130 - 1400 Duration : 2 HOUR 30 MINUTES Additional Materials: Electronic version of CARLOAN.XLSX data file Electronic version of TEXTCHECK.PY file Electronic version of JOB_ERROR.PY file Insert Quick Reference Glossary READ THESE INSTRUCTIONS FIRST Before you start your exam, check that you have received the correct paper and the number of printed pages are correct. Write your name, index number and class in the spaces 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 number of marks for this paper is 50.

2 This document consists of 6 printed pages. Task 1 Century Boon Lay Loan Service provides car loan to new car owners. The manager wants to use a spreadsheet software to record the details of the transactions in the first quarter of 2018. You are required to finish setting up the spreadsheet to record the interest earned. Open the file CARLOAN. 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 the total loan amount. [1] 2 In cell B21 enter a formula to count the number of transactions made. [1] 3 In cell B22 enter a formula to calculate the range of the number of years loaned. [1] 4 Use an appropriate function to search for the Interest Rate per Year in the Rates table and use it to complete the Interest Rate column. [2] 5 Enter a formula to calculate the simple interest payable by car owners and use it to complete the Interest Payable column. Round these values to the nearest whole number. [3]

3 6 Enter a formula, by using conditional statement(s), to identify car owners who have loaned $50,000 or more for over 5 years and put YES in the Free 1st Year Car Insurance column. Otherwise put NO in the Free 1st Year Car Insurance column. [2] Save and close your file. Task 2 The following program accepts five inputs and prints out the length of the longest input and the average length of all the inputs. An input may only contain letters, digits or symbols. longest = 0 total = 0 data = 5 for count in range(data): text = input("Please enter the text: ") if len(text) > longest: longest = len(text) total += len(text) print("The longest input length is ", longest) average_length = total/data print("Avera