MFSS 2020 P1

Name: ______________________________ ( ) Class: _______ MONTFORT SECONDARY SCHOOL PRELIMINARY EXAMINATION 2020 Secondary 4 Express COMPUTING Paper 1 Written 8.15 am 7155/01 16 Sep 2020 (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

2 Parent’s Signature: _______________________ This document consists of 13 printed pages and 1 blank page. Setter: Mr Wong Teck Piaw 1 Amanda has a taken a $100,000 study loan from the bank. The loan is to be repaid over 5 years. The interest rate is 6% per year. She has a spreadsheet to keep track of the repayments and the amount she owes. (a) State the type of data that is held in each of the following cells. A1................................................................................................................ A8................................................................................................................ B1................................................................................................................ (b) (i) The cell B4 shows the monthly payment amount. Identify the most appropriate function to use in cell B4, if the interest rate and monthly payment amount remain the same. …...................................................................................................... (ii) The cell E1 shows the total amount that Amanda has paid to date. The payments are entered in cells B8 to B68. Identify the most efficient function to use in cell E1. …...................................................................................................... [3] [1] [1]

3 (iii) The formula in cell E3 calculates the number of payments made. Identify the most appropriate function to use in cell E3. …...................................................................................................... (iv) Cell E2 shows the amount owed to the nearest whole number. Identify the most appropriate function used in cell E2 to convert the value to the nearest dollar. …...................................................................................................... [1] [1] 2 (a) (i) Convert the denary number 232 into a hexadecimal number. Show your working. …...................................................................................................... …...................................................................................................... …...................................................................................................... (ii) Convert the binary number 10100110 into a denary number. Show your working. …...................................................................................................... …...................................................................................................... …...................................................................................................... (iii) Convert the hexadecimal number 9F into a binary number. Show your working. …...................................................................................................... …...................................................................................................... …...................................................................................................... [2] [2] [2]

4 (b) Network addresses are one example of where hexadecimal is used to represent binary. State two other examples where hexadecimal is used to represent binary. 1 ................................................................................................................. 2 ................................................................................................................. [2]

5 3 Integers are input into the flowchart below. START END INPUT a, b, c, d y = 1 y = a a = b OUTPUT a, b, c, d is a > b? b = y x = 1 x = 0 y = b b = c is b > c? c = y x = 1 y = c c = d is c > d? d = y x = 1 Yes No Yes No No Yes is x = 1? Yes No

6 (a) Complete the trace table for the following set of data. a = 3, b = 4, c = 2, d = 1 Trace table a b c d x y Output [7]

7 (b) State the purpose of the algorithm. …................................................................................................................. …................................................................................................................. (c) State the purpose of the following variables in the flowchart. x ................................................................................................................. y ................................................................................................................. [1] [2] 4 The following diagram shows five network terms and six descriptions. Draw a line from each network term to its best description.

8 [5] 5 Insert five of the following words/phrases in the correct place in the text below. ROM register external storage solid-state magnetic RAM The type of computer memory used depends on how the data is meant to be used. The extremely fast …………………...….. is located inside the processor. Where data are stored temporarily for the processor to access, …………………...….. is used. The …………………...….. is used for data that starts up computers or data that rarely needs to be changed. The …………………...….. is where large Term Description Wide Area Network (WAN) Transmission medium Wired network Wireless access point (WAP) bandwidth The average number of bits of data that can be transmitted from a source to a destination over the network Network of devices connected by a physical medium such as cables Network of devices covering multiple large-scale geographical locations Network of computing devices typically spanning across two or more buildings within the same town or city A means of connecting computers together, such as using copper cables, radio wave or light pulses A device that provides connection between wireless devices up to 100 metres away and can connect to wired networks.

9 amounts of data are stored, and …………………...….. storage is a popular option due to its small size and resistance to drops and mechanical shock. [5] 6 Technology is used in various areas of entertainment and finance. (a) Give two social impacts to people using technology in entertainment. 1................................................................................................................... …................................................................................................................. 2................................................................................................................... …................................................................................................................. (b) Give two economic impacts to people using technology in entertainment. 1............