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. …...................................................................................................... …...................................................................................................... …...................................................................................................... …...................................................................................................... …...................................................................................................... (ii) Convert the binary number 10111110 into a hexadecimal number. Show your working. …...................................................................................................... …...................................................................................................... …...................................................................................................... …...................................................................................................... …...................................................................................................... (iii) Convert the hexadecimal number CD into a denary number. Show your working. …...................................................................................................... …...................................................................................................... …...................................................................................................... …...................................................................................................... …...................................................................................................... (b) State and explain the ideal manner for memory dumps to be represented. …................................................................................................................. …................................................................................................................. …................................................................................................................. [2] [2] [2] [2]

4 3 Integers are input into the flowchart below. START GrpA = [] GrpB = [] INPUT X Count = X - 1 Is Check = 0 ? Append X to GrpB Check = X MOD Count Is Count = 1 ? Append X to GrpA Is X = 0 ? Count = Count - 1 OUTPUT GrpB END Is X = 1 ? OUTPUT GrpA Yes Yes No No Yes No Yes No

5 (a) Complete the trace table for the following set of data. 2, 3, 4, 5, 6, 7, 8, 0 Trace table GrpA GrpB X Count Check Output [6]

6 (b) State the purpose of the algorithm. …................................................................................................................. …................................................................................................................. [2] 4 The following diagram shows five network terms and six descriptions. Draw a line between the term and the correct description. [5] Term Description Ethernet Media Access Control (MAC) Router Wireless access point (WAP) Internet Protocol (IP) A device responsible for modulation and demodulation. A device that forwards packets between separate networks. The most commonly used wired network protocol for local and metropolitan are networks. A device that provides connection between wireless devices up to 100 metres away and can connect to wired networks. Sequence of bytes that is used to identify a computer or device on the internet. Sequence of bytes (usually permanent in nature) that is used to identify a particular network interface card.

7 5 Insert five of the following words/phrases about data flow in the correct place in the text below. fixed iteration procedural repeating selection sequence Flowcharts obey certain rules. The …………………...….. construct is for …………………...….. instructions while a particular condition is true. The construct for choosing between two or more branches based on a particular condition is called the …………………...….. construct. The …………………...….. construct is used to perform multiple instructions in a …………………...….. order. [5] 6 The processor is usually a complex circuit made of many components that are compressed into a square or rectangular package. (a) State the purpose of the Arithmetic Logic Unit (ALU). …................................................................................................................. …..............................................................................................................