ACSBR 2019 P2 Solution

PRELIMINARY EXAMINATION 2019 SECONDARY FOUR EXPRESS COMPUTING PAPER 2 Marking Scheme Task 1 / 10 Task 2 / 10 Task 3 / 10 Task 4 / 20 Total / 50 Task 1 .

Formula view

2 Question Answer Marks 1 One mark for working top formula, One mark for the rest =MID(A3,5,5) 2 One mark for working top formula, One mark for the rest =HLOOKUP(D3,$A$22:$D$24,2,TRUE) 3 One mark for working top formula, One mark for the rest =HLOOKUP(D3,$A$22:$D$24,3,TRUE)*C3 4 One mark for working top formula, One mark for the rest =-PMT(E3/12,D3*12,C3,0) 5 One mark for working top formula, One mark for the rest =COUNTIF($B$3:$B$19,F22) Task 2: MYFACTORS #6a - 1 mark for 2 changed to 5 for i in range(5): #6b - 1 mark for a list is declared factors = [] factor_count = 0 number = int(input("Enter a number:")) #6c - 1 mark for while loop with correct condition # 1 mark for meaningful invalid message # 1 mark for re-enter while number < 0: print("Number must be positive.") number = int(input("Enter a number:")) for i in range(1,number+1): if number%i==0: factor_count += 1 #6b - 1 mark for list updated, accept append method factors = factors + [i] #6b - 1 mark for list output, # 1 mark for meaningful message print("Factors for {} are {}".format(number, factors))

3 Task 2: MYFACTORS2 number = int(input("Enter a number:")) #7 - 1 mark for loop with correct condition while number != 0: factors = [] factor_count = 0 for i in range(1,number+1): if number%i==0: factor_count += 1 factors = factors + [i] print("Factors for {} are {}".format(number, factors)) #7 - 1 mark for input again number = int(input("Enter a number:")) Task 3: MYCHECKCODE check = [2, 7, 6, 5, 4, 3, 2] code = ["A","B","C","D","E","F","G","H","I","Z","J"] total = 0 counter = 1 NRIC = input("Enter the NRIC:") while NRIC.isalnum()== False or len(NRIC)!= 9: if NRIC.isalnum()== False: print("Special character is not allowed!") else: print("NRIC must be 9 digits") NRIC = input("Enter the NRIC again:") while counter<len(NRIC)-1: for digit in check: total += digit * int(NRIC[counter]) counter += 1 remainder = total%11 subtract = 11 - remainder if NRIC[-1]==code[subtract-1]: print("The NRIC is valid.") else: print("Invalid NRIC.")Task 4: Question Answer Marks

4 10 Max 10 marks from the following: - Input for attendance in correct format a b c d e - Correct condition for validation o … check for 0 and 1 o … use of while - Variable set up for total number of days of present for each student - Variable set up for total attendance - Use of loops for seven students - Correct calculation of the total number of days of present for each student - Correct calculation of the total attendance - Correct calculation of the total possible attendance - Correct calculation of the present rate - Present rate rounded to 1