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 individuals and businesses to be more susceptible to cyber criminals and scammers due to easier access to banking activities. 2

4 Any 1 positive and negative impacts / arguments with sound discussion. 5c Companies use data collected from gaming sites to make targeted approach and make money off addicted players. Companies do not closely monitor the access of age differentiated content, hence causing younger audience to be exposed to inappropriate contents. Any 1 ethical issue with sound discussion. 1 5di Copyright. [1] Check and follow the website’s term and condition / Consider using public domain material instead [1] 2 5dii Plagiarism [1] Passing off someone else’s original work as one’s own. [1] 2 6a Each correct gate with the correct input [1] 4 8 6b Working space A B C A NOR B NOT C NOT C AND B X 0 0 0 1 1 0 1 0 0 1 1 0 0 1 0 1 0 0 1 1 1 0 1 1 0 0 0 0 1 0 0 0 1 0 0 1 0 1 0 0 0 0 1 1 0 0 1 1 1 1 1 1 0 0 0 0 8 correct outputs [4] 6 correct outputs [3] 4 correct outputs [2] 2 correct outputs [1] 4

5 [Turn Over 7a For each correct match [1] 5 9 7b Factor - Cost Explanation – Wired network is cheaper initially, but wireless becomes more cost effective as network grows in size. Factor - Speed of transmission Explanation – Wired network is faster and has higher bandwidth. Factor – Reliability Explanation – Wired network is more reliable as data transmission is unaffected by interference. Factor – Security Explanation – Wired network less susceptible to interception and hacking. Factor – Mobility of users Explanation – Wireless network allows users to move about freely. Factor – Scalability Explanation – It is easier to add new devices t o a wireless network as there are no physical constraint such as the running of cables. Factor – Physical organization Explanation – Wireless network tend to be more organised since there are no cable connection. Accept any two of the above factors [2] and the corresponding explanations [2]. 4

6 8a 8b 8c Even parity check 00111000 [1] 11001101 [1] Checksum method [1] A checksum is calculated and sent together with the data [1]. At the destination, the checksum is recalculated and compared to the sent checksum value to verify that there is no error in transmission. [1] 1 2 3 6 9 Error 1 = Line 04 Correction = WHILE num is not an integer or num < 0 or num > 8 Error 2 = Line 09 Correction = bib_list = [] Error 3 = Line 11 Correction = FOR x = 1 to num Error 4 = Line 17 Correction = bib_list += [bib] Error 5 = Line 23 Correction = OUTPUT bib_list[i] 10 10 10 competitor1 = 0 #initialising [1] competitor2 = 0 furthest1 = 0 furthest2 = 0 FOR x = 1 to 3 #iteration [1] OUTPUT “Enter distance for competitor 1” INPUT distance1 #input [1] IF distance1 > furthest1 #highest [1] furthest1 = distance1 ENDIF competitor1 = competitor1 + distance1 #average [1] OUTPUT “Enter distance for competitor 2” #[1] INPUT distance2 IF distance2 > furthest2 furthest2 = distance2 ENDIF competitor2 = competitor2 + distance2 NEXT IF furthest1 > furthest2 #processing and output [1] OUTPUT “Competitor 1 wins! Distance: “, furthest1 8 8

7 [Turn Over ELSE IF furthest2 > furthest1 #processing and output OUTPUT “Competitor 2 wins! Distance: “, furthest2 ELSE #processing and output [1] IF competitor1/3 > competitor2/3 #average OUTPUT “Competitor 1 wins! Distance: “, competitor1/3 ELSE #processing and output OUTPUT “Competitor 2 wins! Distance: “, competitor2/3 ENDIF ENDIF 11. Flowchart START INPUT distance1 INPUT distance2 competitor1 = 0 competitor2 = 0 furthest1 = 0 furthest2 = 0 competitor1 += distance1 Is distance1 > furthest1 furthest1 = distance1 furthest2 = distance2 Is distance2 > furthest2

8 STOP competitor2 += distance2 Is index x = 3? Is furthest1 > furthest2? OUTPUT “Competitor1 wins”,furrthest1 Is furthest2 > furthest1? OUTPUT “Competitor2 wins”,furrthest2 average1 = competitor1/3 average2 = competitor2/3 Is average1 > average2 ? OUTPUT “Competitor2 wins”,average2 OUTPUT “Competitor1 wins”,average1

9 [Turn Over