MFSS 2019 P1 Solution

2019 Computing Sec 4 Prelim Paper 1 Marking Guide Qn Answer & Marking Guide 1a A1: Text B1: Currency B2: Percentage 1bi Correct formula and arguments =PMT($B$2/12, $B$3, $B$1) 1bii Correct formula and arguments =SUM(D8:D11) 1biii Correct formula and arguments, accept arguments from other columns =COUNT(C8:C11) 2ai One mark for correct answer, one mark for correct working. 1001 1011 2aii One mark for correct answer, one mark for correct working. BE 2aiii One mark for correct answer, one mark for correct working. 205 2b As memory dumps are usually large, … …the hexadecimal number system is ideal for displaying bytes in a compact manner.

2 3a one mark for each correct column GrpA GrpB X Count Check Output [] [] 2 1 [2, ] 3 2 1 [2,3] 4 1 3 1 [4] 5 2 0 4 1 3 2 2 1 [2,3,5] 6 1 5 1 4 2 [4,6] 7 3 0 6 1 5 2 4 3 3 1 2 1 [2,3,5,7] 8 1 7 1 6 2 5 3 [4,6,8] 0 4 0 [2,3,5,7] [4,6,8] 3b Separate… …prime and composite numbers into two lists.

3 4 5 iteration repeating selection sequence fixed 6a Arithmetic logic unit (ALU): processes data by performing basic mathematical and logical operations 6b Control unit: follows instructions and decides when data should be stored, received or transmitted by different parts of the computer 6c “multi-core” processors contain multiple processing units inside a single package. … … These “multi-core” processors can perform more than one instruction at the same time, and thus are more powerful than “single-core” processors. 7a Positive: • On the positive side, the Internet has enabled diverse cultures to interact and share ideas with each other. Social networking sites have also allowed users to remain connected with friends, family and colleagues even over long distances. Negative: • On the negative side, some people use the Internet to reinforce their existing opinions or to spread rumours and misinformation. 7b Any two from: • The rise of self-driving vehicles is likely to open new areas of growth Term Description Ethernet Media Access Control (MAC) Router Wireless access point (WAP) Internet Protocol (IP) A device responsible for modulation and demodulation. A device that forwards packets between separate networks. The most commonly used wired network protocol for local and metropolitan are networks. A device that provides connection between wireless devices up to 100 metres away and can connect to wired networks. Sequence of bytes that is used to identify a computer or device on the internet. Sequence of bytes (usually permanent in nature) that is used to identify a particular network interface card.

4 in the travel industry. Singapore is one of the first countries where self-driving cars are being tested, and if successful, the technology will likely revolutionise the motor industry. • There are also multiple new companies that offer on-demand rides via mobile applications. These developments have led to sweeping