SQSS 2018 P1

2 SQSS 4E Prelim 2018 Computing 7155/01 [Turn Over COMPUTING Paper 1 Written 7155/01 17 Sep 2018 2 hours Candidates answer on the Question Paper. No Additional Materials are required. READ THESE INSTRUCTIONS FIRST Write your name, index number in the spaces at the top of this page. Write in dark blue or black pen. You may use an HB pencil for any diagrams or graphs. Do not use staples, paper clips, glue or correction fluid. DO NOT WRITE IN ANY BARCODES. Approved calculators are allowed. Answer all questions. 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 number of marks for this paper is 80. For Examiner’s Use Total 80 SHUQUN SECONDARY SCHOOL 2018 Preliminary Examination Secondary 4 Express Candidate Name: Candidate Index Number: Class: This question paper consists of 13 printed pages including the cover page.

2 SQSS 4E Prelim 2018 Computing 7155/01 [Turn Over 1 Spreadsheet software is used in many company to keep track of accounts. Draw a line between the description and the correct spreadsheet function. Description Function Returns the number of non-empty cells in the given range references ● ● COUNT ● HLOOKUP Looks for data in row and use associated data in the same row ● ● COUNTA ● CEILING Returns number rounded up to an exact multiple of significance ● ● VLOOKUP ● FLOOR [3] 2 (a) Convert the binary number 10011001 into a denary number. Show your working. ………………………………………………………………………………………………….. ………………………………………………………………………………………………….. ………………………………………………………………………………………………..[2] (b) Convert the hexadecimal number C7 into a binary number. Show your working. ………………………………………………………………………………………………….. ………………………………………………………………………………………………….. ………………………………………………………………………………………………..[2] (c) Convert the denary number 189 into a hexadecimal number. Show your working. ………………………………………………………………………………………………….. ………………………………………………………………………………………………….. ………………………………………………………………………………………………..[2]

3 SQSS 4E Prelim 2018 Computing 7155/01 [Turn Over 3 With the advancement of technology and increasing use of online platforms, internet security is becoming more and more important to protect users from becoming victims of online crimes. (a) Pharming and phishing are examples of potential internet security issues. Explain what is meant by each of these terms. Pharming………………………………………...................................................... ……...………………………………………………………………………………….. …………………………………………………………………...…………………….. Phishing………………………………………...................................................... ……...………………………………………………………………………………….. …………………………………………………………………...………………….[4] (b) Two-factor authentication is one of the safety measures that more websites are adopting these days. Explain what is meant by Two-factor