JYSS 2018 P2 Solution

1 Marking Scheme JYSS Computing (Paper 2) Prelim Year Exam 2018 Name: _______________________ Class: __________ TASK1 Qn Answer Marks Student 1 =LEFT(B10,1) 2 one mark for working top formula, one mark for the rest =VLOOKUP(F10,$E$24:$F$30,2,FALSE) 3 In the top formula, one mark for the simple interest calculation, one mark for the addition to principal and one mark for the rest =E10*F10*G10+E10 4 one mark for working top formula, one mark for the rest =H10/(12*F10) 5 one mark for working top formula, one mark for the rest =IF(AND(F10>3,D10="Online"),"YES","NO") TASK2 Qn Answer Marks Student 6 (a) student = 40 (b) smallest = 100 if weight < smallest: smallest = weight print("Smallest weight is ", smallest, "kg") (c) while weight < 40 or weight > 100: weight = float(input("Enter weight between 40kg to 100 kg: ")) 7 student = int(input("Enter the number of students"))

2 Task 3 Qn Answer Marks Student 8 Single errors are underlined height=0 accepted=0 rejected=100 input_str=input("Enter height in cm: ) while input_str != "" or height != "0": height=int(input_str) if height > 165 and height < 190: accepted = accepted + 1 else: rejected = rejected - 1 input_string=input("Enter height in m: ") print("Total accepted = ",height) print("Total rejected = ",rejected) Corrected lines. rejected=0 input_str=input("Enter height in cm: ") while input_str != "" and input_str != "0": if height >= 165 and height <= 190: rejected = rejected + 1 input_str=input("Enter height in cm: ") print("Total accepted = ",accepted)

3 Task 4 Qn Answer Marks Student 10 Test: nine lines of output (3) (-1 for each line with an error) Test: output matches stored program Qn Answer Marks Student 11 Extend: correct test for less than 20 shirts sold Correct output (-1 for each line with error) Qn Answer Marks Student 12 Extend: entry of number of sizes Correct loop control For Examiner’s Use Task 1 10 Task 2 10 Task 3 10 Task 4 20 Total 50 Qn Answer Marks Student 9 Program: input tshirt_sold validation for between 0 to 20 variable set up for average and total variables set up and initialised for totalshirt_day (1) and totalshirt_week (1) use of loops for 7 days (1) for 5 shirt sizes (1) Correct calculation of average rounded to nearest whole number Correct calculation of totals for totalshirt_day (1) and totalshirt_week (1)