MSHS 2019 P2 Solution

Class/ Index Number / Centre Number/ ‘O’ Level Index Number / Name MARIS STELLA HIGH SCHOOL PRELIMINARY EXAMINATION SECONDARY FOUR COMPUTING 7155/02 Paper 2 Practical (Lab-based) 29 Aug 2019 2 hours 30 minutes MARKING GUIDE For Examiner’s Use This document consists of 5 printed pages. 50

2 Task 1 Question Answer Marks 1 =LEFT(A5,1) =LEFT(A6,1) =LEFT(A7,1) =LEFT(A8,1) =LEFT(A9,1) =LEFT(A10,1) =LEFT(A11,1) =LEFT(A12,1) =LEFT(A13,1) =LEFT(A14,1) =LEFT(A15,1) =LEFT(A16,1) 1 Question Answer Marks 2 =HLOOKUP(B5,$H$21:$K$22,2,FALSE) =HLOOKUP(B6,$H$21:$K$22,2,FALSE) =HLOOKUP(B7,$H$21:$K$22,2,FALSE) =HLOOKUP(B8,$H$21:$K$22,2,FALSE) =HLOOKUP(B9,$H$21:$K$22,2,FALSE) =HLOOKUP(B10,$H$21:$K$22,2,FALSE) =HLOOKUP(B11,$H$21:$K$22,2,FALSE) =HLOOKUP(B12,$H$21:$K$22,2,FALSE) =HLOOKUP(B13,$H$21:$K$22,2,FALSE) =HLOOKUP(B14,$H$21:$K$22,2,FALSE) =HLOOKUP(B15,$H$21:$K$22,2,FALSE) =HLOOKUP(B16,$H$21:$K$22,2,FALSE) 2 Question Answer Marks 3 =VLOOKUP(E5,$D$21:$E$24,2,FALSE) =VLOOKUP(E6,$D$21:$E$24,2,FALSE) =VLOOKUP(E7,$D$21:$E$24,2,FALSE) =VLOOKUP(E8,$D$21:$E$24,2,FALSE) =VLOOKUP(E9,$D$21:$E$24,2,FALSE) =VLOOKUP(E10,$D$21:$E$24,2,FALSE) =VLOOKUP(E11,$D$21:$E$24,2,FALSE) =VLOOKUP(E12,$D$21:$E$24,2,FALSE) =VLOOKUP(E13,$D$21:$E$24,2,FALSE) =VLOOKUP(E14,$D$21:$E$24,2,FALSE) =VLOOKUP(E15,$D$21:$E$24,2,FALSE) =VLOOKUP(E16,$D$21:$E$24,2,FALSE) 2 Question Answer Marks 4 =ROUND(FV(F5/12,E5*12,0,D5,0),0) =ROUND(FV(F6/12,E6*12,0,D6,0),0) 3

3 =ROUND(FV(F7/12,E7*12,0,D7,0),0) =ROUND(FV(F8/12,E8*12,0,D8,0),0) =ROUND(FV(F9/12,E9*12,0,D9,0),0) =ROUND(FV(F10/12,E10*12,0,D10,0),0) =ROUND(FV(F11/12,E11*12,0,D11,0),0) =ROUND(FV(F12/12,E12*12,0,D12,0),0) =ROUND(FV(F13/12,E13*12,0,D13,0),0) =ROUND(FV(F14/12,E14*12,0,D14,0),0) =ROUND(FV(F15/12,E15*12,0,D15,0),0) =ROUND(FV(F16/12,E16*12,0,D16,0),0) Question Answer Marks 5 =IF(AND(C5="Online",D5>45000),"YES","NO") =IF(AND(C6="Online",D6>45000),"YES","NO") =IF(AND(C7="Online",D7>45000),"YES","NO") =IF(AND(C8="Online",D8>45000),"YES","NO") =IF(AND(C9="Online",D9>45000),"YES","NO") =IF(AND(C10="Online",D10>45000),"YES","NO") =IF(AND(C11="Online",D11>45000),"YES","NO") =IF(AND(C12="Online",D12>45000),"YES","NO") =IF(AND(C13="Online",D13>45000),"YES","NO") =IF(AND(C14="Online",D14>45000),"YES","NO") =IF(AND(C15="Online",D15>45000),"YES","NO") =IF(AND(C16="Online",D16>45000),"YES","NO") 2 Task 2 Question Answer Marks 6 (a) no_of_students = 36 6 (b) lightest = 140 if lightest > weight: lightest = weight print("Lightest weight of the students is ", lightest) 6 (c) while (weight < 20 or weight > 140): weight = float(input("Please enter the weight of student in kg(between 20kg to 140kg): ")) Question Answer Marks 7 no_of_students = int(input("Enter number of students in the class: ")) Task 3 Question Answer Marks 8 customer = 1 data = input (("Enter details of customer: ") date=data.split(",")