2018 Computing S4 Prelim MS

1 2018 SEC 4 COMPUTING PRELIM PAPER 2 MARKING SCHEME Task 1 Question Answer Marks 1 One mark for the correct formula. ==B3*12 or =$B$3*12 or =B$3*12 or =$B3*12 1 2 One mark for the correct values. 1 3(a) One mark for the correct formula, with B4 as a fixed reference. =IF(ROW(B10)-9>$B$4, "", ROW(B10)-9) (Or equivalent) 1 3(b) One mark for the correct formula.. =IF(B10="","",CEILING(B10/12,1) ) =IF(B11="","",CEILING(B11/12,1)) … =IF(B489="","",CEILING(B489/12,1)) (Or equivalent) 1 3(c) One mark for the correct formula. =IF(B10="","",ABS(PMT(C10/12,$B$4,$B$2))) (Or equivalent) 1 3(d) One mark for the correct formula. =IF(B10="", "", ABS(IPMT(C10/12, B10, $B$4, $B$2))) (Or equivalent) 1 3(e) One mark for each correct formulae. In cell G10: =IF(B10="", "", E10-F10) In cell H10: =IF(B10="", "", D10-G10) (Or equivalent) 2

2 3(f) One mark for copying formulae A10:H10 to rows 11 to 489. 1 4 One mark for the correct length of tenure. He should set the loan tenure to 27 years and 3 months. 1 Task 2 Question Answer Marks 5(a) size = 10 1 5(b) One mark for the correct validation criterion One mark for printing feedback AND asking for input again. Insert between line 4 and 5: 2 while True: try: income = int(input("({})Annual income in $: ".format(employee+1))) if income < 0 or income > 120000: raise Exception except: print("Please enter a value from 0 to 120000!") else: break OR income = int(input("({})Annual income in $: ".format(employee+1))) while income < 0 or income > 120000: income = print("Please enter a value from 0 to 120000!") 5(c) One mark for the correct code to obtain the highest tax. One mark for printing the value. 2

3 highestTax = 0 if tax > highestTax: highestTax = tax n = employee + 1 OR highestTax = max(highestTax, tax) print("Highest tax payable is $", round(highestTax,2)) 5(d) One mark for the printing the correct employee. if tax > highestTax: highestTax = tax n = employee + 1 print("Employee {} paid the highest tax.".format(n)) 1 5(e) One mark for the correct code to calculate the required percentage. One mark for printing the value. count = 0 … if income <= 20000: tax = 0 count += 1 … print("Percentage who do not need to pay tax: {}%.".format(round(count/size*100,1))) 2 6 Correct the four highlighted parts: elif income <= 30000: tax = (income-20000) * 0.02 elif income <= 40000: tax = 200 + (income-30000) * 0.035 elif income <= 80000: tax = 550 + (income-40000) * 0.07 else: tax = 2800 + (income-80000) * 0.115 2

4 Task 3 Question Answer Marks 7 s = 0 count = 0 while True: x = input('Enter a positive integer. Type "done" to finish.') if x == "done": break elif not x.isdigit(): print ("Invalid input. Try again.") else: x = int(x) if count == 0: M = m = x else: M = max(M, x)