2022 CWSS Prelim 4ENA COMP P1 QP Final

COMMONWEALTH SECONDARY SCHOOL PRELIMINARY EXAMINATION 2022 COMPUTING Paper 1 (Theory) Name: ___________________________________ ( ) Class: ___________ SECONDARY FOUR EXPRESS/NORMAL ACADEMIC Wednesday 31 August 2022 7155/1 1130 – 1330 2 hours READ THESE INSTRUCTIONS FIRST Write your name, index number and class on all the work you hand in. 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. Approved calculators are allowed. Candidates will answer on the question paper. 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. Name of setter: Mr Cheong HS For Examiner’s Use Parent’s Signature: ___________________________ Total 80 This paper consists of 15 printed pages including the cover page.

2 [Turn over 1 A loan company uses a spreadsheet to record their loan database. (a) Identify the most appropriate data type for the data in the following cell references: Cell Data type A3 B6 [2] (b) The cells in the Loan column are highlighted if the loan is above $2000. This is done using a feature found in the spreadsheet. Describe how a feature can be used to perform this operation. .................................................................................................................... .................................................................................................................... .................................................................................................................... [3]

3 (c) The cell F2 is calculated by multiplying the loan with the loan term and the interest rate that is based on the loan plan. Describe the formula that will need to be entered in cell F2. .................................................................................................................... .................................................................................................................... .................................................................................................................... [3] (d) The cell G2 will indicate “Y” in the cell should the interest be more than $200. Identify the function that will need to be entered in cell G2. ..................................................................................................................... [1]

4 2 Nikki sets up a new tele-communication company. As most of the staff is new to the company’s privacy policies, she decides to brief them on intellectual property. freeware piracy authorise domain expire demonstrate share cracks infringe shareware copyright courseware license illegal open (a) Some of the following words need to be used to complete her presentation on intellectual property. The legal right of owners to control the use and distribution of their intellectual property is called ………………………. . They have to apply for a …………….. which is an official description of activities that are authorised or forbidden by the owners. The public ……………… software refers to software where legal protections have expired while the free and open-source software refers to software where users are free to change, copy, study and ……………… the software. Proprietary software refers to commercial software that is ……………….. to copy, modify or distribute. [5] The company’s data is partially lost due to poor authorisation. There are no signs of unauthorised access, and the installed firewall showed no signs of irregularity in terms of the transmission of data. (b) Explain what is meant by authorisation and how it can cause data to be lost. …………….................................................................................................. .................................................................................................................... .................................................................................................................... .................................................................................................................... .................................................................................................................... [4]

5 (c) Nikki wants to explore the feasibility of focusing on communication and healthcare technology in their company by finding out how they can impact on society. Complete the table by describing one economical and social impacts on each area of technology. Area Impact Economical Social Communication ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. Healthcare ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. ………………………………. [4]

6 3 Four parts of the computer architecture are on the left, and five descriptions on the right. Draw one line to link each part to its correct description. Part Description [4] 4 Hossan is asked to set up a network in his base company in Singapore and connect it to the network in his parent company in Japan. (a) The base company comprises 4 workers including Hossan. He is considering setting up a peer to peer network. Explain what is meant by a peer to peer network. …………….................................................................................................. .................................................................................................................... .................................................................................................................... Control unit Used to store data for immediate use in a computer Follows instructions and decides when data should be stored, received or transmitted Bus Way of storing large amounts of data that will not be lost when power supply is interrupted Storage Media Memory Allows users to enter data and instructions into a computer Collection of wires that serves as a highway for data to travel on

7 .................................................................................................................... [4]

8 (b) Hossan’s parent company’s network is formed using a bus topology. It has a server, three computers and a network printer. Show, by drawing a diagram in the box below, how the devices may be connected in the topology. [2] (c) State whether Hossan’s base and parent companies should be a LAN or WAN, and explain why. .................................................................................................................... .................................................................................................................... .................................................................................................................... .................................................................................................................... .................................................................................................................... .................................................................................................................... [3]

9 5 (a) Convert the (i) denary number 63 into a 8-bit binary number. ……………………