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-communica