SRSS Sec 4 COMP PRELIM 2022 PAPER 1

This question paper consists of 14 printed pages including the cover page. [Turn over SERANGOON SECONDARY SCHOOL PRELIMINARY EXAMINATION SECONDARY 4 EXPRESS CANDIDATE NAME CLASS CENTRE NUMBER S INDEX NUMBER COMPUTING 7155/01 Paper 1 25 August 2022 2 hours Setter(s): Mr Adrial Tan READ THESE INSTRUCTIONS FIRST Write you Centre number, 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 80

2 1 Anthony uses a spreadsheet to record his expenses. He records: • the date of purchase and the amount spent on each item • the mode of payment of each item purchased (cash or credit card) A B C D E 1 Date Item Amount ($) Payment mode (cash/credit card) 2 01/07/2022 EZ link card top up $ 50.00 credit card 3 08/07/2022 Clothing $ 120.00 cash 4 15/07/2022 Books $ 45.00 cash 5 17/07/2022 Movie $ 10.00 credit card 6 25/07/2022 Phone Bill $ 45.00 credit card 7 8 Cash expenses: $ 165.00 9 Credit card expenses: 10 Total expenses: (a) Identify the most appropriate data type for the data in the following cell references: Cell Data type A1 A3 C6 D4 (b) The cell C10 will calculate the total expenses. Identify the function that will need to be entered into C10. …………………………………………………………………………………………….. [1] (c) The cell C9 will calculate the total expenses that he had paid using credit card. Anthony uses one function to calculate this value. Describe the formula that will need to be entered in cell C9. ………………………………………………………………………………………………… ………………………………………………………………………………………………… ………………………………………………………………………………………………… ………………………………………………………………………………………………… …………………………………………………………………………………………….. [3] [4]

3 2 Anthony wants to make sure his computer is secure against cyberattacks. (a) Some of the following words need to be used to complete the description of cyberattacks. cookies data hardware harmless internet LAN pharming phishing software spamming spyware Trojan-horse reputable restricted worm Insert five words from the list given to complete the following statements. A cyberattack is an unwelcomed attempt to steal, expose, alter, disable or destroy information through unauthorised access to computer systems. It is usually carried out over a network such as the ……………………………………… . One type of cyberattack is ……………………………………… . This is a type of malware that downloads onto a computer disguised as a ……………………………………… program and attacks a co