TSS 2019 P1

1 Match each of the following spreadsheet functions to the relevant data type of its output by putting a tick (√) in the box(es). Number Currency Text Date COUNTA RAND SMALL LEN [4] 2 A spreadsheet is used to record the Computing Exam results for a class of 16 students. (a) State what does the second row of the spreadsheet contain and what data type is used. …………………………………………………………………………………….. …………………………………………………………………………………. [2]

2 No part of the paper is to be reproduced without the approval of the Principal of Temasek Secondary School. (b) State a function that allows the result in cell E3 to be calculated as the nearest whole number. …………………………………………………………………………………. [1] (c) (i) Write a formula that calculates the variance of the Total Score for the class. …………………………………………………………………………… [1] (ii) State the other function closely related to variance. …………………………………………………………………………… [1] (d) State the function that determines the most commonly obtained Total Score. …………………………………………………………………………………. [1] 3 Compare between the spreadsheet functions PMT() and PPMT(). …………………………………………………………………………………………… …………………………………………………………………………………………… ……………………………………………………………………………………….. [2] 4 Name two methods to convert denary numbers to binary numbers. …………………………………………………………………………………………… ……………………………………………………………………………………….. [2] 5 State which number system is used in ASCII codes and briefly describe how they are used. …………………………………………………………………………………………… …………………………………………………………………………………………… ……………………………………………………………………………………….. [2]

3 No part of the paper is to be reproduced without the approval of the Principal of Temasek Secondary School. [Turn over 6 In April 2017, t he National University of Singapore (NUS) and the Nanyang Technological University (NTU) discovered a cyber -attack on their computer network. During a routine system check , malware were found hidden in the computer network. These malware had been undetected for a long period of time and it was suspected that they came from infected portable storage drives and email attachments. Cyber Security Agency (CSA) of Singapore investigated the incident and found that these malware came from oversea s with the intention to compromise government and research data. (a) Briefly describe two examples of how this cyber -attack may impact the universities negatively. (i) Negative Impact 1 ………………………………………………………… …………………………………………………………………………… [1] (ii) Negative Impact 2 ………………………………………………………… …………………………………………………………………………… [1] (b) State two possible measures to prevent this incident from occurring again. (i) Measure 1 …………………………………………………………………. …………………………………………………………………………… [1] (ii) Measure 2 …………………………………………………………………. …………………………………………………………………………… [1] 7 Distinguish between: (a) phishing and pharming, and …………………