SRSS 2019 P2 Solution

1 Marking Scheme for COMP Prelim Practical Exam P2 2019 Name : ______________________________ Class: _______ No Description 1. One mark for working top formula, one mark for rest =VLOOKUP(B7,$E$29:$G$35,3,TRUE) =VLOOKUP(B8,$E$29:$G$35,3,TRUE) =VLOOKUP(B9,$E$29:$G$35,3,TRUE) =VLOOKUP(B10,$E$29:$G$35,3,TRUE) =VLOOKUP(B11,$E$29:$G$35,3,TRUE) =VLOOKUP(B12,$E$29:$G$35,3,TRUE) =VLOOKUP(B13,$E$29:$G$35,3,TRUE) =VLOOKUP(B14,$E$29:$G$35,3,TRUE) =VLOOKUP(B15,$E$29:$G$35,3,TRUE) =VLOOKUP(B16,$E$29:$G$35,3,TRUE) =VLOOKUP(B17,$E$29:$G$35,3,TRUE) =VLOOKUP(B18,$E$29:$G$35,3,TRUE) =VLOOKUP(B19,$E$29:$G$35,3,TRUE) =VLOOKUP(B20,$E$29:$G$35,3,TRUE) =VLOOKUP(B21,$E$29:$G$35,3,TRUE) =VLOOKUP(B22,$E$29:$G$35,3,TRUE) =VLOOKUP(B23,$E$29:$G$35,3,TRUE) =VLOOKUP(B24,$E$29:$G$35,3,TRUE) 2. One mark for working top formula, one mark for rest =IF(C7>2,(C7-2)*0.1%,0) =IF(C8>2,(C8-2)*0.1%,0) =IF(C9>2,(C9-2)*0.1%,0) =IF(C10>2,(C10-2)*0.1%,0) =IF(C11>2,(C11-2)*0.1%,0) =IF(C12>2,(C12-2)*0.1%,0) =IF(C13>2,(C13-2)*0.1%,0) =IF(C14>2,(C14-2)*0.1%,0) =IF(C15>2,(C15-2)*0.1%,0) =IF(C16>2,(C16-2)*0.1%,0) =IF(C17>2,(C17-2)*0.1%,0) =IF(C18>2,(C18-2)*0.1%,0) =IF(C19>2,(C19-2)*0.1%,0) =IF(C20>2,(C20-2)*0.1%,0) =IF(C21>2,(C21-2)*0.1%,0) =IF(C22>2,(C22-2)*0.1%,0) =IF(C23>2,(C23-2)*0.1%,0) =IF(C24>2,(C24-2)*0.1%,0) 3. One mark for working top formula, one mark for rest =D7+E7 =D8+E8 =D9+E9 =D10+E10 =D11+E11 =D12+E12 =D13+E13 =D14+E14 Task1 (10) Task2 (10) Task3 (10) Task4 (20) Total (50)

2 =D15+E15 =D16+E16 =D17+E17 =D18+E18 =D19+E19 =D20+E20 =D21+E21 =D22+E22 =D23+E23 =D24+E24 4. One mark for working top formula, one mark for rest =FV(F7,C7,0,B7) =FV(F8,C8,0,B8) =FV(F9,C9,0,B9) =FV(F10,C10,0,B10) =FV(F11,C11,0,B11) =FV(F12,C12,0,B12) =FV(F13,C13,0,B13) =FV(F14,C14,0,B14) =FV(F15,C15,0,B15) =FV(F16,C16,0,B16) =FV(F17,C17,0,B17) =FV(F18,C18,0,B18) =FV(F19,C19,0,B19) =FV(F20,C20,0,B20) =FV(F21,C21,0,B21) =FV(F22,C22,0,B22) =FV(F23,C23,0,B23) =FV(F24,C24,0,B24) 5. =SUM(B5:B24) 6. =COUNTIF(B5:B24,">=100000") 7. a) for count in range (20): b) # initialized before for loop fastest = 99999 # within for loop, after timing input is received if timing < fastest: fastest = timing print("This is a new record timing!")

3 c) # within for loop, immediately after timing input is received while timing<0 or timing>30: print("Invalid timing entered.") timing = float(input("Enter shuttle run timing (s) : ")) 8. # initialized before for loop n = int(input("Enter number of timings to record: ")) # modify conditions of for loop for count in range (n):

4 9. age = 0 rejected = 100 Eligible = 0 age = int(input("Please enter student's age: " ) result = float(input("Please enter proficiency test score: ")) while age != 0 or result != 0: if age < 16 or age > 18 or result < 60 if age < 16: print("Age must be at least sixteen years.") elif age < 18: print("Age must not be more than eighteen years.") if result < 60: