BVSS 2018 P1

Name: _______________________________ ( ) Class: Sec ______ COMPUTING 7155/01 13 September 2018 PAPER 1 Written 2 hours Candidates answer on the Question Paper. No Additional Materials are required. ------------------------------------------------------------------------------------------------------------------------------------ READ THESE INSTRUCTIONS FIRST Write your Name, Register Number and Class on the top of this page. Write in dark blue or black pen. You may use a soft pencil for any diagrams, graphs 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. You should show all your working. Setter: Mr Low Chee Wah Parent’s signature : ______________ This question paper consists of 16 printed pages. 80 BUKIT VIEW SECONDARY SCHOOL PRELIM EXAMINATION Secondary 4 Express 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 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 SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL

2 1. (a) A company uses spreadsheet software. Draw a line between the description and the correct spreadsheet function. Description Function AND It is one of the logical functions to determine if all conditions in a test are TRUE AVERAGE Returns number rounded up, away from zero, to the nearest multiple of significance CEILING Returns the mean of the given numbers ROUND Search the data in column and use associated data in the same row VLOOKUP [4]

3 2. (a) Convert the binary number 11101001 into a denary number. Show your working. ……………………………………………………………………………… ……………………………………………………………………………… ……………………………………………………………………………[2] (b) Convert the denary number 121 into a hexadecimal number. Show your working. ……………………………………………………………………………… ……………………………………………………………………………… ……………………………………………………………………………[2] (c) Convert the hexadecimal number E4 into a binary number. Show your working. ……………………………………………………………………………… ……………………………………………………………………………… ……………………………………………………………………………[2] (d) Convert the binary number 10011100 into a hexadecimal number. Show your working. ……………………………………………………………………………… ……………………………………………………………………………… ……………………………………………………………………………[2]

4 3. Insert six of the following words about a being safe and responsible computer user in the correct place in the text below. cloud data corruption data loss decoding encoding firewall private public router spyware worm Encryption refers to the process of ……………….. data so that a secret key is needed for …………………. the data. The ………………. is a device or computer program that prevents unauthorised access to or from a ……………… network. A …………………is a hidden program that secretly collects personal information about its users and transmits this information to attackers without the users’ knowledge. …………………….. occurs when computer data is changed or becomes unreadable. [6] 4. An engineer wants to use a computer program to find out which day in May experiences the highest temperature in the factory. The average temperature of each day in May is recorded. There are a total of 30 readings taken for this study. (a) State the inputs, the outputs and the processes required to find the hottest day in May. Inputs ….……………………………………………………………………………… ……….…………………………………………………………………………[2] Outputs …..……………………………………………………………………………… …….……………………………………………………………………………[2]

5 Processes required ………………………………………………………………………………. …………………………………………………………………………………… [2] (b) Is 100 degree Celsius (100oC) a possible extreme data for the input? Explain your answer. ……………………………………………………………………………… ……………………………………………………………………………… . ……………………………………………………………………….…… [2] 5. Name each of the key terms described in the five statements below: Statement Terms (a) Creative works that are the creations of the mind and can exist purely as data with no physical form. (b) The legal right of owners to control the use and distribution of their intellectual property. (c) Official description of activities that are authorised or forbidden by the owner of intellectual property. (d) Software where the legal protections that are typically granted to intellectual property have either expired, been surrendered or are simply inapplicable. (e) Demonstration software that is distributed for free but for a specific evaluation period only. [5]

6 6. When we use programming language, the source code must be translated into machine code before it can be run. (a) What are machine codes? ……………………………………………………………………………… …………………………………………………………………………… [1] (b) Name the 2 translator programs used to perform the translation and describe their functions. (i) …………………………………………………………………… …………………………………………………………………… (ii) …………………………………………………………………… …………………………………………………………………… [2] (c) Explain the computer term “Command Line Interface.” ………………………………………………………………………… ………………………………………………………………………… ………………………………………………………………………… [1]

7 7. A topology describes the physical layout of a network. Understanding the topology is essential to designing a network. (a) Describe one advantage of ring topology over bus topology. ……………………………………………………………………………… ……………………………………………………………………………[1] (b) Which topology would you recommend if the requirement is to isolate fault easily and perform a replacement without affecting the rest of the network? ……………………………………………………………………………… ……………………………………………………………………………[1] (c) Which network topology is the least reliable in the event of a breakdown of a computer in the network? Explain your choice. ……………………………………………………………………………… ……………………………………………………………………………… ……………………………………………………………………………[2] 8. (a) Complete the table for two main differences between RAM and ROM. S/N RAM ROM 1 2 [2]

8 (b) Solid-state hard disk is used as an external storage device in certain circumstances. List one advantage and one disadvantage of this type of storage device over magnetic storage device. (i) Advantage: ..…………………………………………………… …………………………………………………………………… (ii) Disadvantage: .………………………………………………… …………………………………………………………………… [2] (c) Describe the function of each of the following computer components: (i) Central processing unit: .………………………………………. …………………………………………………..………………… (ii) Arithmetic Logic Unit (ALU): …………………………………. …………………………………………………..………………… [2] 9. (a) In ensuring that a program wo