BVSS 2018 P1 Solution

1 COMPUTING 7155/01 PAPER 1 Marking Scheme ------------------------------------------------------------------------------------------------------------------------------------Q1 1(a) Description Function AND It is one of the logical functions to determine if all conditions in a test are TRUE AVERAGE Returns number rounded up, away from zero, to the nearest multiple of significance CEILING Returns the mean of the given numbers ROUND Search the data in column and use associated data in the same row VLOOKUP BUKIT VIEW SECONDARY SCHOOL 2018 PRELIM EXAMINATION Secondary 4 Express

2 Q2 1 mark for correct answer and 1 mark for showing relevant working. Qn Answer Mark 2(a) 1110 1001 (binary) = 1*128 + 1*64 + 1*32 + 1*8 + 1*1 = 233 (denary) 2(b) 121 / 16 is 7 remainder 9 121 (denary) = 79 (hexadecimal) 2(c) E (hexadecimal) = 1110 (binary) 4 (hexadecimal) = 0100 (binary) E4 (hexadecimal) = 1110 0100 (binary) 2(d) 1001 (binary) = 9 (denary) = 9 (hexadecimal) 1100 (binary) = 12 (denary) = C (hexadecimal) 11001001 (binary) = 9C (hexadecimal) Q3 1 mark for correct answer at the correct blank of the text. Encoding Decoding Firewall Private Spyware Data corruption

3 Q4 Qn Answer Mark 4(a) Inputs: • The day in the month of May • Average temperature of each corresponding day in May 4(b) Outputs: • The day in May with the highest temperature • The temperature of the day having the highest average temperature 4(c) Processes required: • Initialise a variable to represent the highest temperature • Read in the 30 data of temperature and day using a list / array or otherwise • The average temperature readings and its respective day of the month are to be linked • Sort the temperature to get the highest value and extract the day of the month or compare the temperature to get the highest value and the day of the month. 4(d) No, we do not expect 100oC to be a valid room temperature.

4 Q5 Statement Terms Mark (a) Creative works that are the creations of the mind and can exist purely as data with no physical form. Intellectual property. (b) The legal right of owners to control the use and distribution of their intellectual property. Copyright (c) Official description of activities that are authorised or forbidden by the owner of intellectual property. Licence (d) Software where the legal protections that are typically granted to intellectual property have either expired, been surrendered or are simply inapplicable. Public domain software (e) Demonstration software that is distributed for free but for a specific evaluation period only. Shareware Q6 6(a) Machine code are processor’s instruction set which specifies how it should be directly executed on a computer’s processor and is represented in byte form. 6(b) Compiler - Code translator program that translates source code into machine code completely befo