2022 ACSBR Computing P2 Solutions

Secondary 4 Express 1 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2022 SECONDARY FOUR EXPRESS COMPUTING PRELIMINARY EXAMINATION Task 1 MYCUSTOMER Marking Scheme Paper 2

Secondary 4 Express 2 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2022 Question Answer Marks 1 One mark for correct working conditional IF formula (in cell B3), One mark for the rest =IF(MID(A20,3,1)="S", "Staff", IF(MID(A20,3,1)="M", "Member", "Non-Member")) [1] [1] 2 One mark for correct working HLOOKUP formula (in cell D3), One mark for the rest =(1-HLOOKUP(B3,$A$23:$D$24,2,TRUE))*C3 [1] [1] 3 One mark for correct working ROUND formula (in cell F3), One mark for the rest =FLOOR.Math(D3,1) [1] [1] 4 One mark for correct working SUMIF formula (in cell B23), One mark for the rest =SUMIF($B$3:$B$20,B23,$E$3:$E$20) [1] [1] 5 One mark for yellow fill for cells with staff, One mark for whole row. =$B3="Staff" [1] [1]

Secondary 4 Express 3 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2022 Task 2 MYFIB n1 = 0 n2 = 1 fiblist = [] #8 while True: #7 nterms = int(input("Enter the nterm(s): ")) #6 if nterms > 0: #7 break else: print("nterms must be a positive integer.") #7 for i in range(nterms): print(n1) fiblist += [n1] #8 nth = n1 + n2 n1 = n2 n2 = nth print(fiblist)#8 Task 2 INFIB n1 = 0 n2 = 1 fiblist = [] nterms = 100 for i in range(nterms): fiblist += [n1] nth = n1 + n2 n1 = n2 n2 = nth print(fiblist) num = int(input("Enter the number: "))#9 if num in fiblist:#9 print("Yes, it is in the 100th sequence")#9 else: print("No, it is not in the 100th sequence") Question Answer Marks 6 One mark for input of nterms with appropriate message [1] 7 One mark for using while loop One mark for correct condition One mark for appropriate error message [1] [1] [1] 8 One mark for initialisation list One mark for adding terms in the list One mark for printing the list [1] [1] [1]

Secondary 4 Express 4 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2022 9 One mark for input of the positive integer One mark for checking if the number is in the 100th list One mark for output message is appropriate [1] [1] [1] Task 3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 while True: date = input("Enter the date (DD-MM-YYYY): ") #1 test = date if len(test)== 10 and test[2]=="-" and test[5]=="-": #2 day = int(test[0:2]) month = int(test[3:5]) #3 year = int(test[6:]) check_year = year>1900 and year<=2022 #4 check_month = month>=1 and month<=12 #5 check_day_31 = day<=31 and (month in [1,3,5,7,8,10,12]) check_day_30 = day<=31 and (month in [4,6,9,11]) check_day_Feb = mont