2022 BVSS 4E Computing Prelim P1

Bukit View Secondary School Secondary 4 Express Preliminary Examination 2022 BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKI T VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECOND ARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VI EW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECON DARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCH OOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL SCHOOL CANDIDATE NAME CLASS INDEX NUMBER COMPUTING 7155/01 Paper 1 15 September 2022 2 hours Candidates answer on the Question Paper. READ THESE INSTRUCTIONS FIRST Write your name, class and index number on 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. Do not use staples, paper clips, glue or correction fluid. Approved calculators are allowed. 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. You should show all your working. The maximum number of marks is 80. For Examiner’s use Marks 80 Setter: Ms Lee Poh Tin Parent's Signature:__________________ This question paper consists of 17 printed pages and 1 blank page.

2

3 1 Four descriptions of spreadsheet functions are on the left, and five spreadsheet functions are on the right. Draw one line to link each description to the correct spreadsheet function. Description Spreadsheet Function FLOOR.MATH() Returns the integer portion of a division. HLOOKUP() Returns the remainder after a number is divided by a divisor. MOD() Rounds a number down to the nearest integer. OR() Looks for a value in the top row of a table or array of values and returns a value in the same column from a row specified. QUOTIENT() [4]

4 2 An organization with 35 employees scan their staff cards at the general office when they report for work. The clerical staff will need to report to the organization director on employees who report late for more than three times in a month and the average minutes late for the days that they reported late. The output should be appropriately formatted. (a) Specify the inputs, stating the requirements for valid inputs. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [1] (b) Specify the outputs, stating the requirements for correct outputs. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [1] (c) Identify the most appropriate data type for storing the 35 input data collectively. Explain the reason for your choice of data type. Choice of Data Type …………………………………………………………… Reason for your choice ………………………………………………………… ……………………………………………………………………..………..……. ……………………………………………………………………..………..……. [2]

5 3 A new bank has been incorporated and a team of engineers has been engaged to configure the computers for the bank employees. (a) The engineers have decided to set up a computer network for the bank employees. (i) Give one advantage of a computer network. …………………………………………………………………………… …………………………………………………………………………… [1] (ii) Give one disadvantage of a computer network. …………………………………………………………………………… …………………………………………………………………………… [1] (b) Identify and describe the function of one network device that could be used in the network. Network Device ………………………………………………………………… Description ……………………………………………………………………... ……………………………………………………………………..………..……. ……………………………………………………………………..………..……. [2]

6 4 (a) Complete the following table for each related term and description of threats to privacy and security. Description of privacy and security threats Term The interception of requests sent from a computer to a legitimate website and redirection to a fake website to steal personal data. Cookie The mass distribution of unwanted messages or advertising to email addresses. [3] (b) Explain two-factor authentication and give an example to illustrate it. Two-factor authentication ……………………………………………………… ……………………………………………………………………..………..……. ……………………………………………………………………..………..……. Example ………………………………………………………………………… ……………………………………………………………………..………..……. ……………………………………………………………………..………..……. [2]

7 5 (a) Identify the type of storage media described in the table below. Description Type of Storage Media Data is stored as very small pits or indentations that can be read or written by a laser. Data is stored in electronic circuits called “flash memory” that have no moving parts. Data is stored on a material that can be read or written by a head. [3] (b) Convert 372 KB of memory to bytes. …………………………………………………………………………………… …………………………………………………………………………………… [1] (c) Convert 5600 MB of memory to GB. …………………………………………………………………………………… …………………………………………………………………………………… [1]

8 6 (a) 20:18:0F:BC:D0:AE is an example of a MAC address with 6 parts of hexadecimals. (i) State what the term MAC represent. …………………………………………………………………………… [1] (ii) State what the first 3 parts of the hexadecimals represent. …………………………………………………………………………… [1] (iii) State what the last 3 parts of the hexadecimals represent. …………………………………………………………………………… [1] (iv) Explain the purpose of using MAC address. …………………………………………………………………………… …………………………………………………………………………… [1] (b) RGB colour codes is another application of the hexadecimal number systems. For example, the hexadecim al colour code #FF0000 represents the colour red at its highest intensity. Give the hexadecimal colour code for blue at its highest intensity. …………………………………………………………………………………… [1] (c) An organisation has the web address https://www.sportshop.com/shoes.html. Explain whether this web site is encrypted. …………………………………………………………………………………… …………………………………………………………………………………… [1]

9 7 (a) Convert the binary number 10100011 into a hexadecimal number. Show your working. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [2] (b) Convert the hexadecimal number C5 into a binary number. Show your working. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [2] (c) Convert the denary number 217 into a hexadecimal number. Show your working. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [2] (d) Explain how the binary number 11100001 is converted into a denary number. …………………………………………………………………………………… …………………………………………………………………