SFSS 4EX_Computing_Prelim_QP2_MS_2022

SPRINGFIELD SECONDARY SCHOOL “BETTER SELF FOR BETTER TOMORROW” Preliminary Examination 2022 COMPUTING 7155/02 Paper 2 Secondary 4 Express / 5 Normal Academic MARKING GUIDE FOR TEACHERS 2 hours 30 minutes MAXIMUM MARK : 50 This document consists of 7 printed pages.

2 Task 1 1 =MID(A4,2,3) Formula for entire column ----- [1] [2] 2 =SUM(E4:E11) ----- [1] [1] 3 =SUMIF(C4:C11,"Electric",E4:E11) ----- [1] [1] 4 =(D4-VLOOKUP(C4,$A$19:$B$21,2,FALSE))*E4 Correct VLOOKUP search ----- [1] Correct formula for calculating Revenue ----- [1] [2] 5 =IF(F4=MAX($F$4:$F$11),"1st","") Correct formula and “1st” indicated on the correct cell ----- [1] All other cells empty ----- [1] [2] 6 =$F4=MIN($F$4:$F$11) Correct row highlighted Correct rule description ----- [1] Correct cell range selected ----- [1] [2]

3 [Turn Over Task 2 7 weight = float(input("Enter the weight of baggage: ")) while weight > 50: #1mark weight = float(input("Passengers are not allowed to carry more than 50 kg of baggage. Please re-enter the weight of baggage: ")) #1mark if weight >= 20 and weight <= 30: cost = (weight - 20) * 20 elif weight > 30: cost = 200 + (weight - 30) * 25 else: cost = 0 print("The excess baggage cost is $", cost) [2] 8 member = input("Are you a member with the airline? (Y/N): ") #1 mark weight = float(input("Enter the weight of baggage: ")) while weight > 50: weight = float(input("Passengers are not allowed to carry more than 50 kg of baggage. Please re-enter the weight of baggage: ")) if weight >= 20 and weight <= 30: cost = (weight - 20) * 20 elif weight > 30: cost = 200 + (weight - 30) * 25 else: cost = 0 if member == 'Y': cost = cost * 80/100 #1 mark print("Thank you for being a member of ABC airline.") #1 mark print("The excess baggage cost is $", cost) [3]

4 9 passenger = int(input("Enter the number of passenger: ")) #1 mark totalweight = 0 # totalcost = 0 #1 mark for i in range(passenger): #1 mark member = input("Are you a member with the airline? (Y/N): ") weight = float(input("Enter the weight of baggage: ")) while weight > 50: weight = float(input("Passengers are not allowed to carry more than 50 kg of baggage. Please re-enter the weight of baggage: ")) if weight >= 20 and weight <= 30: cost = (weight - 20) * 20 elif weight > 30: cost = 200 + (weight - 30) * 25 else: cost = 0 if member == 'Y': cost = cost * 80/100 print("Thank you for being a member of ABC airline.") print("The excess baggage cost is $", cost) totalweight = totalweight + weight # totalcost = totalcost + cost #1 mark print("The total weight of baggage for the flight is {}kg and the total excess baggage cost collected is ${}.".format(totalweight, totalcost)) #1 mark [5]

5 [Turn Over Task 3