2018 SRSS P1

This question paper consists of 12 printed pages. Name__________________________________ ( ) Class: Sec _________ SERANGOON SECONDARY SCHOOL PRELIMINARY EXAMINATION 2018 SECONDARY 4 EXPRESS COMPUTING 7155/01 PAPER 1 24 Aug 2018 Name of Setter: 2 hours READ THESE INSTRUCTIONS FIRST Do not open the question papers until you are told to do so. Write in dark blue or black pen in the spaces provided on the Question Paper. You may use a soft pencil for any diagrams, graphs, music or rough working. Do not use staples, paper clips, highlighters, glue or correction fluid. Answer all questions. No marks will be awarded for using brand names of software packages or hardware. 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. FOR EXAMINER’S USE 80

2 1 Draw a line between the description and the correct spreadsheet function. Description Function [3] 2 (a) Convert the binary number 10110101 into a denary number. Show your workings. ………………………………………………………………………………………………… …………………………………………………………………………………….................. …………………………………………………………………………………………….. [2] (b) Convert the hexadecimal number F8 into a binary number. Show your workings. ………………………………………………………………………………………………… …………………………………………………………………………………….................. …………………………………………………………………………………………….. [2] (c) Convert the denary number 250 into a hexadecimal number. Show your workings. ………………………………………………………………………………………………… …………………………………………………………………………………….................. …………………………………………………………………………………………….. [2] Returns number rounded up to a given multiple MODE SMALL ROUND Returns the most repeated number in a set of numbers Use to retrieve the nth lowest number from a set of numbers CEILING

3 3 (a) A bank needs to keep its customers’ data safe and secure. Unauthorised access can happen due to poor authentication, access control and privacy policy. For each cause of unauthorised access, give: (i) a description of the cause (ii) how it can be prevented (iii) explain how the cause can affect the integrity of data Authentication (i) Description: ……………………………………………………………………………... …………………………………………………………………………………………………. (ii) Prevention: ……………………………………………………………………………… …………………………………………………………………………………………………. (iii) Integrity of data: ………………………………………………………………………... …………………………………………………………………………………………………. Access control (i) Description: ……………………………………………………………………………... …………………………………………………………………………………………………. (ii) Prevention: ……………………………………………………………………………… …………………………………………………………………………………………………. (iii) Integrity of data: ………………………………………………………………………... …………………………………………………………………………………………………. Privacy policy (i) Description: ……………………………………………………………………………... …………………………………………………………………………………………………. (ii) Prevention: ……………………………………………………………………………… …………………………………