MFSS 2019 P2 Solution

2019 Computing Sec 4 Paper 2 Prelim Marking Guide Qn Answer 1 B20: =COUNTA(A4:A18) 2 B21: =MAX(B4:B18)-MIN(B4:B18) 3 D4: =B4-C4 propagate for whole column 4 F4: =VLOOKUP(E4,$E$23:$F$26,2,FALSE) ----[1m] Propagate for whole column [1m] 5 H4: =PMT(F4/12, G4*12, D4, 0) ----[1m] Propagate for whole column [1m] 6 Correct LEFT function [1m] Correct IF function [1m] Propagate for whole column [1m] I4: =IF(LEFT(A4,6)="BrandA","Yes","No") 7a if letter in ['a','e','i','o','u','A','E','I','O','U']: 7b mytext = input('Enter your string: ') for letter in mytext: 7c while len(mytext)>= 10: print ('String must be less than 10 characters') mytext = input('Enter your string again: ') 7d print('Length of consonants: ', len(consonants)) 8 2 marks : num = int(input('Number of words: ')) 1 for input, 1 for typecast 1 mark : for i in range(num):

2 9 negative = [] positives = [] zeros = [0] number = input("Enter an integer(enter q to quit): ) while number =! "q": num = str(number) if num < 0: negatives.append(num) elif num >= 0: positives.append(number) else zeros += num number = input("Enter an integer(enter q to quit): “) print("The numbers were: ") for n in negatives: print(n) for z in zeros: print(z) for p in positives: print(positives[p]) negatives = [] OR changing all negatives to negative [still only 1 mark] zeros = [] OR changing zeros to empty string number = input("Enter an integer(enter q to quit): ")

3 while number != "q": num = int(number) elif num > 0: positives.append(num) else: zeros.append(num) OR zeros+=number if zeros intialised as empty string print(p) 10 program: Input marks Validation marks 1 to 9 Variables set up for input of data variables set up processing of data use of loops and/or lists for 5 students and 3 subjects correct calculation of student total and average marks correct calculation of total marks (1) and number of distinctions(1) 11 test: 8 lines of output, -1 for each line with error output matches stored program 12 extend: correct test for students who fail in each subject correct output, -1 for each line of error 13 Extend: entry of number of students correct loop control

4