SRSS Sec 4 COMP PRELIM 2022 PAPER 2 MS

1 Marking Scheme for COMP Prelim Practical Exam P2 2022 Name : ___________________________ ( ) Class: _______ Task 1 No Description M A 1. Any one from: • = COUNTA(A4:A18) • = COUNTA(B4:B18) • = COUNT(C4:C18) • = COUNT(D4:D18) [1] 2. Any one from: • = MODE.SNGL(D4:D18) • = MODE(D4:D18) [1] 3. One mark for finding average, one mark for rounding up Any one from: • =ROUNDUP(AVERAGE(C4:C18),0) • =CEILING.MATH(AVERAGE(C4:C18),1) • =CEILING(AVERAGE(C4:C18),1) [2] 4. Three marks for working top formula, one mark for rest On top formula, one mark for showing Captain for tallest student, one mark for showing Vice Captain for second tallest student, and one mark for showing Member for all other students. =IF(D4=MAX($D$4:$D$18),"Captain",IF(D4=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D5=MAX($D$4:$D$18),"Captain",IF(D5=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D6=MAX($D$4:$D$18),"Captain",IF(D6=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D7=MAX($D$4:$D$18),"Captain",IF(D7=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D8=MAX($D$4:$D$18),"Captain",IF(D8=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D9=MAX($D$4:$D$18),"Captain",IF(D9=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D10=MAX($D$4:$D$18),"Captain",IF(D10=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D11=MAX($D$4:$D$18),"Captain",IF(D11=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D12=MAX($D$4:$D$18),"Captain",IF(D12=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D13=MAX($D$4:$D$18),"Captain",IF(D13=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D14=MAX($D$4:$D$18),"Captain",IF(D14=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D15=MAX($D$4:$D$18),"Captain",IF(D15=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D16=MAX($D$4:$D$18),"Captain",IF(D16=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D17=MAX($D$4:$D$18),"Captain",IF(D17=LARGE($D$4:$D$18,2),"Vice Captain","Member")) =IF(D18=MAX($D$4:$D$18),"Captain",IF(D18=LARGE($D$4:$D$18,2),"Vice Captain","Member")) [4] 5. Two marks if the text in the row with shortest member changes to red. No marks if conditional formatting is not used. [2] Task 2 6. # replace num_rider = 10 num_rider = int(input("Enter number riders: ") [1] Task1 (10) Task2 (10) Task3 (10) Task4 (20) Total (50)

2 7. num_rider = int(input("Enter number riders: ") min_height = 1.4 for p in range(num_rider): name = input("Enter name of rider: ") height = float(input("Enter height of rider: ")) if height >= min_height: print("Rider is tall enough to ride a pony.") # Output message if rider is less than 1m elif height < 1: print("Rider is not tall enough to ride a pony.") [1] # Get input if accompanied by adult if height more than 1m else: adult = input("Is the rider accompanied by an adult? (Y/N) ") [1] # Output correct message if accompanied by ad