SRSS Sec 4 COMP PRELIM 2022 PAPER 1 MS

Serangoon Secondary Computing Sec 4E 2022 Preliminary Exams (Marking scheme) 1. (a) Cell Data type A1 String / Text [1m] A3 Date [1m] C6 Currency [1m] D4 String / Text [1m] (b) SUM [1m] (c) = SUMIF(D2:D6 , “credit card” , C2:C6) use of =SUMIF [1m] correct range for evaluation and criteria [1m] correct range for summation [1m] 2. (a) 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 computer by enabling intruders to open backdoors for unauthorised access to the computer. A second type of cyberattack is ……………………………………… . This is a form of social engineering attack which sends fraudulent communications that appear to come from ……………………………………… sources in order to steal personal information such as passwords and credit cards numbers from users. Internet [1m] Trojan-horse [1m] harmless [1m] phishing [1m] reputable [1m]

(b) Problem Effect Preventive measure Power failure Any one of: • Data corruption if data is in the midst of being save • Data lost if data has not been saved [1m] Any one of: • Set up of backup power supply or UPS (Uninterrupted Power Supply) • Make regular backups of data [1m] Human error Any one of: • Accidental deletion or over- writing of data. • Accidental damage to storage medium (e.g. transport or spillage of water) [1m] Any one of: • Set up of file sharing rules and rights • Adequate protection to storage medium (e.g. avoid eating/drinking near devices, and protection during transport • Make regular backups of data. [1m] Hardware failure Any one of: • Data corruption due to hardware failure of storage device • Data loss due to hardware failure of storage device [1m] Any one of: • Check storage devices regularly and replace them when signs of failure are detected • Use of redundancy storage solutions such as RAID systems • Make regular backups of data [1m]

3. Function Description [1m] for each correct line COUNT COUNTA COUNTIF LARGE MAX Counts the number of cells in a range that contain numbers, currencies, dates, times and percentages Counts the number of cells in a range that are not empty Counts the number of cells in a range that meet a given condition Finds a numeric value based on its position in a list when sorted by value in descending order Finds the largest numeric value in a given range of cells Rounds a number up to the nearest level of significance

4. (a) (i) Feature that is the same [1m] Any one from: • Connects 2 or more devices together to allow them to c