Pathlight 2022 4E Computing Prelim P2 Mark Scheme

4E Computing Paper 2 PRELIM 2022 2022 PRELIMINARY EXAMINATION Secondary 4 Express Computing Paper 2 ANSWERS AND MARKING SCHEME Question Answer Marks 1 =TODAY() 1 2 =YEAR($B$1) – RIGHT(C3,4) in cell D3 1 Accept MID function: =YEAR($B$1) – MID(C3,6,4). Use of YEAR() function and absolute cell referencing to copy formula to rest of Number of Years Joined 1 3 =VLOOKUP(D3,$A$17:$C$20,3,TRUE)*F3 1 One mark for working top formula, one mark for the rest = VLOOKUP(D4,$A$17:$C$20, 3, TRUE)*F4 = VLOOKUP(D5,$A$17:$C$20, 3, TRUE)*F5 .. .. VLOOKUP(D14,$A$17:$C$20, 3, TRUE)*F14 1 4 =F3-G3 =F4-G4 … =F14-G14 1 5 One mark for working top formula, one mark for the rest =IF(AND(D3>=3,E3="Yes"),"Yes","No") =IF(AND(D4>=3,E4="Yes"),"Yes","No") … … =IF(AND(D14>=3,E14="Yes"),"Yes","No") 2 6 Conditional Formatting applied to range with correct formula and colour 2

4E Computing Paper 2 PRELIM 2022 Question Answer Marks 7 8 Program edited: member_no = int(input("Number of people: ")) minimum_age = 14 for i in range(member_no): name = input("Name of person: ") age = int(input("Age of person: ")) ## if age >= minimum_age: ## print("Person is old enough.") ## else: ## print("Person is not old enough.") healthcheck = input("Any medical condition? (Y/N) ") if healthcheck == "Y" or healthcheck == "y": fit = False else: fit = True if age >= minimum_age and fit == False: print("The person is not fit enough.") elif age < minimum_age and fit == True: print("The person is not old enough.") elif age < minimum_age and fit == False: print("The person is not fit enough and not old enough.") else: print("The person is old enough and fit enough.") 1 1 1 1 1 1 9 member_no = int(input("Number of people: ")) minimum_age = 14 fit_list = [] #initialise list for i in range(member_no): name = input("Name of person: ") age = int(input("Age of person: ")) healthcheck = input("Any health issues? (Y/N) ") if healthcheck == "Y" or healthcheck == "y": fit = False else: fit = True if age >= minimum_age and fit == False: print("The person is not fit enough.") elif age < minimum_age and fit == True: print("The person is not old enough.") elif age < minimum_age and fit == False: print("The person is not fit enough and not old enough.") else: print("The person is old enough and fit enough.") fit_list = fit_list + [name] #append to list for person in fit_list: print(person) #output list of fit and old enough 1 2 1

4E Computing Paper 2 PRELIM 2022 Question Answer Marks 10 # Task 3 solution # Variable declarati