SFSS 4EX_Computing_Prelim_QP1_MS_2022

SPRINGFIELD SECONDARY SCHOOL “BETTER SELF FOR BETTER TOMORROW” Preliminary Examination 2022 COMPUTING 7155/01 Paper 1 Secondary 4 Express / 5 Normal Academic MARKING GUIDE FOR TEACHERS 2 hours MAXIMUM MARK: 80 This document consists of 8 printed pages.

2 Question Number Answer Marks Total Marks 1a A3 – Number B3 – Currency D7 – Percentage 3 8 1b = SUM(B2:B7) 1 1c =COUNTIF(F2:F7,"Yes") 1 1d The formula will check that either B7 is more than $50000 or C7 is more than 5 [1]. The formula will return “Yes” if the criteria is fulfilled [1], it will return a blank otherwise [1]. =IF(OR(B7>50000,C7>5), "Yes","") 3 2a arithmetic logic unit control unit memory data and address buses input, output For each correct answer [1] 6 11 2b Statement Optical Magnetic Solid- state Data is stored as very small pits.  Fastest in reading and writing  Relatively large storage capacity (at least 1TB).  Vulnerable to drops, mechanical shock, scratches, and fingerprint.   For each correct answer [1] 5 3a 157 1 5 3b 13A Working [1], Correct Answer [1] 2 3c It makes the data or binary values easier to read/write/debug. It is a shorter way to represent the binary values. It will reduce the amount of possible errors as compared to using binary representation. 2

3 [Turn Over 4a Input The list of item and the quantity sold. [1] The list of cost of each item. [1] Output The most popular item sold for the day. [1] The total earnings for the day. [1] Process From the quantity list, find the item with the most quantity sold for the day and output it as the most popular item. [1] The sales received from each item is calculated by multiplying the quantity of each item sold and its cost in the cost list. The total earning for the day is obtain ed by adding the sales of every item. [1] 2 2 2 6 5a Positive impact - Use of video conferencing tools for medical consultation allows patients to have better access to healthcare. - Analysing of medical data to identify warning signs of possible health problem and provide doctors with more accurate diagnosis. Negative impact - Patients find the use of robot and other technology impersonal and may mistrust the ability of machines to provide proper healthcare. - Patients may be uncomfortable with the collection of medical data to improve the performance of healthcare- related AI. Any 1 positive and negative impact / arguments with sound discussion. 2 9 5b Positive impact - Use of internet banking allows financial services to be more efficient, hence saving time and cost for both individuals and businesses. - Use of AI to analyse transaction data allows banks to identify unusual spending patterns, hence detect and prevent financial fraud more effectively. Negative impact - Use of internet banking causes indi