BLSS 2018 Computing P2 Solution

1 MARKING SCHEME & TOS Subject: Computing Paper : 2 - Practical Level : Secondary FOUR Express Exam : Preliminary Examinations Year : 2018 Marking Scheme Qn Answer Marks allocated Remarks Q1 =SUM(B4:B18) 1 Q2 =COUNT(B4:B18) or =COUNT(A4:A18) 1 Q3 =MAX(C4:C18)-MIN(C4:C18) 1 Q4 One mark for working first row formula One mark for the rest =VLOOKUP(C4,$D$25:$F$28,3,TRUE) 1 1 Q5 Two mark for correct formula One mark for using ROUND function =ROUND(B4*C4*D4,0) 2 1 Q6 One mark for correct IF formula One mark for use of AND =IF(AND(B4>=50000, C4>5),"YES","NO") 1 1 Total for Task 1 10 Q7a data = 10 1 Q7b shortest = 100 # Declare variable and assign a high value or initializing var shortest with the length of the first input 1 elif len(text) < shortest: shortest = len(text) 2 print("The shortest input length is ", shortest) 1 Q7c while " " in text: #Check if input contains spacing text = input("Please enter the text again: ") WHILE loop used 1 1 1 Q8 data = int(input("Enter the number of data ")) # input Typecast to integer 1 1 Total for Task 2 10

2 Qn Answer Marks allocated Remarks Q9 rejected = 0 # change to 0 1 age = int(input("Please enter student's age:" )) # corrected syntax error 1 while age != 0 and result != 0: # <> to != 1 if age < 14 or age > 18 or result <= 60: # Change 15 to 14, Change == to <= Both instant below must be changed to get the marks if age < 14: # Change 15 to 14 if result <= 60: #Change == to <= 2 rejected = rejected + 1 #Change - to + 1 else: #indentation 1 eligible = eligible + 1 # Eligible to eligible 1 age = int(input("Please enter student's age:" )) #Change indentation 1 print("Number of students eligible is ", eligible) #Added , # corrected syntax error 1 Total for Task 3 10 Q10 Read and store user input 2 Validation for input 2 Variable set up 1 Use of loops for 4 postmen for 5 days 2 Correct calculation and output of number of parcels collected each day 1 Correct calculation and output of average 1 Correct calculation and output of total 1 Q11 Test: 12 lines of output 3 Output matches stored program 2 Q12 Extend: Correct output 3 Q13 Extend: Correct Input Entry 2 Total for Task 4 20 TOTAL 50

3 Sample Python Code Answers for Task 2 to Task 4

4 Task 2 – Q7 longest = 0 shortest = 100 # Declare variable and assign a high value total = 0 data = 10 # Change value to 10 for count in range(data): text = input("Please enter the text: ") while " " in text: #Validation to check if input contains spacing text = input("Please enter the text again: ") if len(text) > longest: longest = len(text) elif len(text) < shortest: # Added condition to check and store shortest length shortest = len(text) total += len(text) print("The longest input length is ", longest) print("