2022 MSHS Sec 4 Computing SA2_Paper 2_MS

Thumb drive No: STL 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) 26 August 2022 2 hours 30 mins Additional Materials: Electronic version of LIBRARY.XLSX file Electronic version of NUMBER.PY file Electronic version of WORD.PY file Electronic version of CONVERTER.PY file Insert Quick Reference for Python READ THESE INSTRUCTIONS FIRST MARK SCHEME For Examiner’s Use This document consists of 10 printed pages. 50

2 Task 1 Question Answer Marks 1 =LEFT(VLOOKUP(D5, $A$28:$B$40, 2, FALSE),6) & A5 2 marks: VLOOKUP 1 mark: LEFT 3 Question Answer Marks 2 =G5-F5 1 Question Answer Marks 3 =IF(H5>21, "Overdue", "Not Overdue") Minus 1 mark if message is of wrong spelling/case 2 Question Answer Marks 4 =COUNTA(A5:A21) 1 Question Answer Marks 5 =COUNTIF(J5:J21, "Overdue") 1 Question Answer Marks 6 =AND(I5="Yes",J5="Overdue") 2

3 Task 2 Quest ion Answer Marks 7 total = int(input('Enter total numbers to input: ')) #6a for count in range(total): 2 8 while number < 1 or number > 100: #6b range check number = int(input('Out of range, please re-enter a positive integer: ')) 2 9 total = int(input('Enter total numbers to input: ')) highlist = [] #6c for count in range(total): number = int(input('Enter a positive integer: ')) while number < 1 or number > 100: #6b range check number = int(input('Out of range, please re-enter a positive integer: ')) if number >= 1 and number <= 40: print(number, '- Low') elif number > 40 and number <= 70: print(number, '- Medium') elif number > 70 and number <= 100: print(number, '- High') highlist.append(number) #6c print("The numbers classified as high are: ", highlist) #6c 3 10 allnumbers = 0 #7 for count in range(total): number = int(input('Enter a positive integer: ')) while number < 1 or number > 100: #6b range check number = int(input('Out of range, please re-enter a positive integer: ')) if number >= 1 and number <= 40: print(number, '- Low') elif number > 40 and number <= 70: print(number, '- Medium') elif number > 70 and number <= 100: print(number, '- High') highlist.append(number) #6c allnumbers = allnumbers + number #7 print("The numbers classified as high are: ", highlist) #6c print("The average of all numbers are: ", allnumbers/count) #7 3

4 Task 3 Quest ion Answer Ma rks 11 Errors are underlined word = input("Please enter your word: ") word = word.islower() begin_p = word.beginswith("p") end_h = word.endswith("h") contain_e = word("e") word_length = word.length() if not begin_p and not end_h and cont