2022 CWSS 4E4NA COMP P1 MS Final (updated)

COMMONWEALTH SECONDARY SCHOOL PRELIMINARY EXAMINATION 2022 COMPUTING Paper 1 (Theory) Mark Scheme 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 Date B6 Text [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. Conditional formatting [1]. Formats the cell to fill a certain colour [1] if the ........................................................................................................................ content in the cells is greater than 2000 [1]. ........................................................................................................................ ........................................................................................................................ [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. vlookup is used [1] to find the interest rate based on the plan and multiplied ........................................................................................................................ to the product of D2 (loan) and E2 (term) [2] ........................................................................................................................ ........................................................................................................................ [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. IF ......................................................................................................................... [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 ……copyright………. . They have to apply for a …license………….. which is an official description of activities that are authorised or forbidden by the owners. The public …domain… 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 …share…………… the software. Proprietary software refers to commercial software that is …illegal…….. 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 authorisation and how it can cause data to be lost. Authorisation is a user’s ability to control the access of data and resources ……………...................................................................................................... once he/she has been authenticated [1]. It is also known as access control ........................................................................................................................ [1]. Data can be lost due to misuse of permissions [1] set by the ........................................................................................................................ administrator who has the rights to perform tasks related to authentication ........................................................................................................................ and authorisation. [1] [4]

5 (c) Nikki wants to explore the feasibility of focusing on communication and healthcare technology by finding out how they can impact on society in their company. Complete the table by describing one economical and social impacts on each area of technology. Area Impact Economical Social Communi- cation (Any one) ● Rise of smart phones increase focus in mobile devices and applications ● Rise of social media increases use of social media for marketing purposes ● Improvement in communication technology reduces business costs (Accept only if related to telecommunication) ● Diverse cultures can interact and share ideas with each other ● Social networking sites allow users to remain connected ● AI make it possible to automatically subscribe and translate speech ● Use of internet to reinforce existing opinions or spread rumours or misinformation

6 Healthcare (Any one) ● New areas of growth such as provision of telemedicine solutions to businesses (Cannot accept below, not related to telecommunication) ● Increase focus in automating healthcare processes through use of robots ● Rise of 3-D printing lead to opportunities in creating and customising prosthetic limbs, hearing aids and dental fixtures ● Telemedicine gives patients who live in remote places or have limited mobility better access to healthcare ● Misuse of information from internet can lead to dangerous decisions based on incorrect diagnosis ● May feel uncomfortable with the collection of data to improve AI (Cannot accept below, not related to telecommunication) ● AI can identify warning signs of possible health problems and provide doctors with accurate diagnosis ● Use of robots impersonal and untrustworthy [4] 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 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 Allows users to enter data and instructions into a computer Memory

7 [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. Peer to peer network is a type of network where all computers are considered as equals and the load is distributed among all computers [1]. Each computer can act as both a client and a server, communicating directly with other computers [1]. Users are able to share files and resources located on t