SFSS 4EX_Computing_Prelim_QP1_2022

[Turn Over SPRINGFIELD SECONDARY SCHOOL Preliminary Examination 2022 Secondary 4 Express/ 5 Normal Academic STUDENT NAME CLASS REGISTER NUMBER COMPUTING 7155/01 Paper 1 Written 12 September 2022 2 hours Candidates answer on the Question Paper. No Additional Materials are required. READ THESE INSTRUCTIONS FIRST Write your class, index number and name in the spaces at the top of this page. Write in dark blue or black pen. You may use an HB pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, glue or correction fluid. Approved calculators are allowed. 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. For Examiner’s Use Total /80 Do not turn over this question paper until you are told to do so. ______________________________________________________________________________________________________ This question paper consists of 13 printed pages.

2 1 An administrator of a finance company uses a spreadsheet to record the loans it has given out to car buyers. It records:  loan amount taken  loan period in terms of number of years  interest rate charged per annum  monthly instalment payable  loan amount that is above $50000 or have a loan period of more than 5 years (a) Identify the most appropriate data type for the data in the following cell references: Cell Data type A2 B3 D7 [3] (b) The cell F10 will calculate the total loan amount given out. Identify the function that will need to be entered into F10. ……………………………………………………………………………….…….. [1] (c) The cell F11 will calculate the number of loans that is more than $50000 or has a loan period of more than 5 years. Identify the function that will need to be entered into F11. ……………………………………………………………………………….…….. [1]

3 [Turn Over (d) The cell F7 will indicate “Yes” when the loan that is more than $50000 or has a loan period of more than 5 years, The cell should be blank if otherwise. Describe the formula that will need to be entered in cell F7. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. ……………………………………………………………………………….…….. [3] 2 (a) Complete the following statements on computer architecture. Most computer parts can be organised into the following roles: The processor consists of the ……………………………………. that processes data by performing basic mathematical logical operation s, and the ……………………………………. follows instructions and decides when data should be stored, received, or transmitted. The ……………………………………. stores data that can be volatile or invol