ZHSS 2018 P2 Solution

ZHS Computing O Paper II Answer Key and Marking Guide Preliminary Examination 2018 1 TASK 1 Question Answer Marks 1 =SUM(B4:B15) 1 Question Answer Marks 2 =COUNT(B4:B15) 1 Question Answer Marks 3 =MAX(C4:C15)-MIN(C4:C15) 1 Question Answer Marks 4 one mark for working top formula, one mark for the rest =VLOOKUP(C4,$D$21:$F$24,3,TRUE) =VLOOKUP(C5,$D$21:$F$24,3,TRUE) =VLOOKUP(C6,$D$21:$F$24,3,TRUE) =VLOOKUP(C7,$D$21:$F$24,3,TRUE) =VLOOKUP(C8,$D$21:$F$24,3,TRUE) =VLOOKUP(C9,$D$21:$F$24,3,TRUE) =VLOOKUP(C10,$D$21:$F$24,3,TRUE) =VLOOKUP(C11,$D$21:$F$24,3,TRUE) =VLOOKUP(C12,$D$21:$F$24,3,TRUE) =VLOOKUP(C13,$D$21:$F$24,3,TRUE) =VLOOKUP(C14,$D$21:$F$24,3,TRUE) =VLOOKUP(C15,$D$21:$F$24,3,TRUE) 2 Question Answer Marks 5 one mark for working top formula, one mark for the rest =ROUND(B4*D4,0) =ROUND(B5*D5,0) =ROUND(B6*D6,0) =ROUND(B7*D7,0) =ROUND(B8*D8,0) =ROUND(B9*D9,0) =ROUND(B10*D10,0) =ROUND(B11*D11,0) =ROUND(B12*D12,0) =ROUND(B13*D13,0) =ROUND(B14*D14,0) =ROUND(B15*D15,0) =ROUND(B16*D16,0) 2

ZHS Computing O Paper II Answer Key and Marking Guide Preliminary Examination 2018 2 Question Answer Marks 6 one mark for working top formula, one mark for the rest =IF(AND((C4>3),(B4>=750)),"PINK","GREEN") =IF(AND((C5>3),(B5>=750)),"PINK","GREEN") =IF(AND((C6>3),(B6>=750)),"PINK","GREEN") =IF(AND((C7>3),(B7>=750)),"PINK","GREEN") =IF(AND((C8>3),(B8>=750)),"PINK","GREEN") =IF(AND((C9>3),(B9>=750)),"PINK","GREEN") =IF(AND((C10>3),(B10>=750)),"PINK","GREEN") =IF(AND((C11>3),(B11>=750)),"PINK","GREEN") =IF(AND((C12>3),(B12>=750)),"PINK","GREEN") =IF(AND((C13>3),(B13>=750)),"PINK","GREEN") =IF(AND((C14>3),(B14>=750)),"PINK","GREEN") =IF(AND((C15>3),(B15>=750)),"PINK","GREEN") 2 Question Answer Marks 7 =PV(3.2%/12, 8*12, 0, 70000) 1 TASK 2 Question Answer Marks 8(a) number_intervals = 12 1 Question Answer Marks 8(b) highest_timing = 0 1 If highest_timing > test_seconds: highest_timing = test_seconds 2 print(“Highest timing is “, convert_to_mmss(highest_timing)) 1 Question Answer) Marks 8(c) while test_seconds < 0 or test_seconds > 30*60: test_seconds = convert_to_seconds(input("Enter a timing (format mm:ss) :- ")) 1 Question Answer Marks 10 number_intervals = int(input(“Enter the number of intervals “)) 2 TASK 3 Question Answer Marks 12 Line 170 while which != “F” and which != “C” 2 260 converted_temp = (temp – 32) * 5/9 2 330 For temp in range(start, end + 1): 2 470 temp_end = int(input(“Enter ending temperature to convert: “)) 2 520 else: 2

ZHS Computing O Paper II Answer Key and Marking Guide Preliminary Examination 2018 3 TASK 4 Question Answer Marks 90 Program: input 10 names into a list. 1 Question Answer Marks 92 Conversion of characters to uppercase. 1 Question Answer Marks 94 Sorted names by alphabetical order in the list. 1 Question Answer Marks 96 Correct code to convert name into numerical worth 1 Correct code to include multiplying the position of the name 1 Use of loops to go thru all t