MSHS 2020 Computing P2 Solution

Class/ Index Number / Centre Number/ ‘O’ Level Index Number / Name MARIS STELLA HIGH SCHOOL PRELIMINARY EXAMINATIONS SECONDARY FOUR COMPUTING 7155/02 Paper 2 Practical (Lab-based) 28 August 2020 2 hours 30 mins Additional Materials: Electronic version of COMPANY.XLS file Electronic version of DEPOSITS.PY file Electronic version of CASHBACK.PY file Insert Quick Reference for Python READ THESE INSTRUCTIONS FIRST SOLUTION For Examiner’s Use This document consists of 6 printed pages. 50 Thumb drive No:

2 Task 1 Question Answer Marks 1 =MID(D4;10;2) =MID(D5;10;2) =MID(D6;10;2) =MID(D7;10;2) =MID(D8;10;2) =MID(D9;10;2) =MID(D10;10;2) =MID(D11;10;2) =MID(D12;10;2) Acceptable: RIGHT(D4;2) This is in the next syllabus but not in current syllabus 2 Question Answer Marks 2 =VLOOKUP(E4;$B$18:$C$22; 2) =VLOOKUP(E5;$B$18:$C$22; 2) =VLOOKUP(E6;$B$18:$C$22; 2) =VLOOKUP(E7;$B$18:$C$22; 2) =VLOOKUP(E8;$B$18:$C$22; 2) =VLOOKUP(E9;$B$18:$C$22; 2) =VLOOKUP(E10;$B$18:$C$22; 2) =VLOOKUP(E11;$B$18:$C$22; 2) =VLOOKUP(E12;$B$18:$C$22; 2) 2 Question Answer Marks 3 =G4*H4 =G5*H5 =G6*H6 =G7*H7 =G8*H8 =G9*H9 =G10*H10 =G11*H11 =G12*H12 1 Answer Marks =F4+I4 =F5+I5 =F6+I6 =F7+I7 =F8+I8 =F9+I9 =F10+I10 =F11+I11 =F12+I12 1

3 Question Answer Marks 4 Total Cost $270.00 $510.00 $160.00 $260.00 $327.00 $475.00 $170.00 $235.00 $260.00 1 Question Answer Marks 5 =SUM(J4:J12) 1 Question Answer Marks 6 =LARGE(G4:G12;2) 2 Task 2 Question Answer Marks 7 if names[i].startswith('D'): 1 8(a) print("The total amount of deposits are: ", sum(deposits)) 2 8(b) print("The average amount of deposit is: ", round(sum(deposits)/len(deposits))) 3 8(c) for i in range(len(names)): if names[i].endswith('n') and len(names[i]) == 4: print("Customer name is {}, Deposit amount is {}".format(names[i], deposits[i])) 4 MYDEPOSITS.PY names = ['Joy', 'Mary', 'John', 'Dean', 'Siva'] deposits = [540.35, 525.60, 539.50, 500.05, 570.95] for i in range(len(names)): if names[i].startswith('D'): print("Customer name is {}, Deposit amount is {}".format(names[i], deposits[i])) print("The total amount of deposits are: ", sum(deposits)) print("The average amount of deposit is: ", round(sum(deposits)/len(deposits))) for i in range(len(names)): if names[i].endswith('n') and len(names[i]) == 4: print("Customer name is {}, Deposit amount is {}".format(names[i], deposits[i]))

4 Task 3 Question Answer Marks 9 Errors are underlined customers = False count = 10 while customers == True: exp = int(input("Enter expenditure for quarter: ")) rewards = int(input("Enter rewards accumulated: ")) if exp >= 500 and rewards >= 1000: print("Customer receives 5 percent cashback.") count = count += 1 elif exp > 300 and rewards >= 700: print("Customer receives 3 percent cashback.") elif exp >= 200: print("Customer receives 2 percent cashback.")