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 wor