MFSS 2019 P1

Name: ______________________________ ( ) Class: _______ MONTFORT SECONDARY SCHOOL PRELIMINARY EXAMINATION 2019 Secondary 4 Express COMPUTING Paper 1 Written 11.00 am 7155/01 18 Sep 2019 (Wed) 2 hours 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. You may use an HB pencil for any diagrams, graphs or rough working. Approved calculators are allowed. Answer all questions. At the end of the examination, fasten all your work securely together. The number of marks is given in brackets [ ] at the end of each question or part question. You should show all your working. The total marks for this paper is 80. For Examiner’s Use Total 80 This document consists of 13 printed pages and 1 blank page. Setter: Mr Ricky Tan

2 1 John bought the latest computer with a loan of $3,000. The loan is to be repaid over 4 years. The interest rate is 5% per year and he has a spreadsheet to keep track of the repayments and the amount he owes. (a) State the type of data that is held in each of the following cells. A1................................................................................................................ B1................................................................................................................ B2................................................................................................................ (b) (i) The cell C8 shows the monthly payment amount. Identify the most appropriate function to use in cell C8, if the interest rate and monthly payment amount remain the same. …...................................................................................................... (ii) The cell G1 shows the total principal payment made to date. Identify the most appropriate function to use in cell G1. The payments are entered in cells C8 to E11. …...................................................................................................... (iii) The cell G3 shows the total number of payments made. Identify the most appropriate function to use in cell G3. The payments are entered in cells C8 to E11. …...................................................................................................... [3] [1] [1] [1] A B C D E F G 1Initial Loan $3,000 -$227.77 2Interest 5% -$48.58 3Loan Length (months) 48 4 4Monthly Payment -$69.09 5Total to Pay -$3,662.69 6 7Installment Date PaymentPrincipalInterest 8 1 1-Jan-19 -$69.09 -$56.59 -$12.50 9 2 1-Feb-19 -$69.09 -$56.82 -$12.26 10 31-Mar-19 -$69.09 -$57.06 -$12.03 11 4 1-Apr-19 -$69.09 -$57.30 -$11.79 Principal paid to date Interest paid to date Number of payments made

3 2 (a) (i) Convert the denary number 155 into a binary number. Show your working. …..................