BLSS 2019 P2

BOON LAY SECONDARY SCHOOL PRELIMINARY EXAMINATION 2019 Name CCA Subject : COMPUTING Paper No : 2 (Lab-based) Subject Code : 7155/02 Level : SECONDARY FOUR EXPRESS Date/Day : 26 AUGUST 2019 / MONDAY Time : 1145 - 1415 Duration : 2 HOURS 30 MINUTES Additional Materials: Electronic version of TRIATHLON.xlsx Electronic version of TEMPERATURE.py Electronic version of PARITY.py Electronic version of Insert Quick Reference Glossary READ THESE INSTRUCTIONS FIRST Before you start your exam, check that you have received the correct paper and the number of printed pages are correct. Write your name, last four digits and the ending letter of your NRIC number, and CCA in the spaces at the top of this page. Answer all questions All tasks must be done in the computer laboratory. You are not allowed to bring in or take out any pieces of work or materials on paper or electronic media or in any other form. Programs are to be written in Python. Save your work using the file name given in the question as and when necessary. The number of marks is given in brackets [ ] at the end of each question or part question. The total number of marks for this paper is 50. This document consists of 8 printed pages.

2 BLS/EYE/2019/4E/COMP/7155/02 Task 1 Mr. Kwek used a spreadsheet to keep track of the results in Boon Lay Secondary School’s annual ironman triathlon. The triathlon consists of three segments, cycling, running and swimming, and the awards are determined by the number of points each student accumulates. You are required to finish setting up the spreadsheet to display the information correctly. Open the file TRIATHLON.xlsx. You will see the following data. Save the file as TRIATHLON_<NAME>_<CCA>_<CENTRE_NUMBER>_<INDEX_NUMBER >.xlsx. 1 In cells B22:B23 enter a formula to count the number of males and females who took part in the triathlon. [1] 2 In cells J18:J20 enter a formula to calculate the average, fastest and slowest timings for running. The average timing must be rounded to 1 decimal place. [4] 3 Use an appropriate function to search for the points that each runner achieves from the Run Score table and use it to complete cells K2:K16. [2] 4 Use a conditional statement to determine whether a participant will receive a special mention. For participants who have achieved a total timing not more than 125 minutes, put Yes in the Special Mention column, otherwise put No in the Special Mention column. [1]

3 BLS/EYE/2019/4E/COMP/7155/02 5 In cells P2:P16 enter a formula to calculate the total points that each participant receives from all three events. [1] 6 In cells Q2:Q16 enter a formula to search the Points-Awards table to determine the award that each participant will receive. [1] Save and close your file. Task 2 begins on the next page.

4 BLS/EYE/2019/4E/COMP/7155/02 Task 2 The following program takes an input in Fah