ACSBR 2020 Computing P2 Solution

Secondary 4 Express 1 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2020 SECONDARY FOUR EXPRESS COMPUTING PRELIMINARY EXAMINATION Task 1 ORDERS_sample - Formula view Question Answer Marks 1 One mark for correct working HLOOKUP with FALSE lookup (top formula), One mark for the rest =HLOOKUP(B3,B$26:F$27,2,FALSE) [2] Question Answer Marks 2 One mark for correct conditional statement. One mark for multiplying with Basic Price. =IF(C3="Luxury",0.2,IF(C3="Deluxe",0.1,IF(C3="Classic",0)))*D3 [2] Question Answer Marks 3 4 One mark for summing up Basic Price and Package Price. =D3+E3 One mark for multiplying Loan% to get the Loan amount =F3*G3 [1] [1] Question Answer Marks Solution Paper 2

Secondary 4 Express 2 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2020 5 One mark for correct working VLOOKUP with TRUE lookup (top formula. One mark for the rest =VLOOKUP(I3,A$33:C$36,3,TRUE) [2] Question Answer Marks 6 One mark for working top formula. (Accept negative answers) =-PMT(J3/12,I3*12,H3,0) [1] Question Answer Marks 7 One mark for working top formula. =COUNTIF($B3:$B22,B26) [1]

Secondary 4 Express 3 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2020 Task 2 MYBMI students = 15 upp_bound = 25 low_bound = 18.5 underwt, overwt = 0, 0 for count in range(students): weight = float(input('Enter weight of student in kg ')) height = float(input('Enter height of student in cm ')) bmi = weight/height**2 * 10000 if bmi > upp_bound: print('Student is overweight') overwt += 1 elif bmi < low_bound: print('Student is underweight') underwt += 1 else: print('Student\'s weight is normal') print("Number of overweight students ", overwt) print("Number of underweight students ", underwt) MYBMI2 students = int(input("Enter number of students ")) upp_bound = 25 low_bound = 18.5 underwt, overwt = 0, 0 for count in range(students): weight = float(input('Enter weight of student in kg ')) while weight < 30 or weight > 150: print('Invalid weight') weight = float(input('Enter weight of student in kg ')) height = float(input('Enter height of student in cm ')) while height < 80 or height > 200: print('Invalid height') height = float(input('Enter height of student in cm ')) bmi = weight/height**2 * 10000 if bmi > upp_bound: print('Student is overweight') overwt += 1 elif bmi < low_bound: print('Student is underweight') underwt += 1 else: print('Student\'s weight is normal') print("Number of overweight students ", overwt) print("Number of underweight students ", underwt)

Secondary 4 Express 4 Computing 7155/02 Anglo-Chinese School (Barker Road) Preliminary 2020 Task 3 MYMARKS nlist = ["Alden", "Belle", "Charles", "Dolly", "Elle", "Falken", "Grace", "Hacken"] mlist = [56, 64, 23, 78, 53, 46, 98, 33] to_find =