SRSS Sec 4 COMP PRELIM 2022 PAPER 2

This question paper consists of 10 printed pages including the cover page. [Turn over SERANGOON SECONDARY SCHOOL PRELIMINARY EXAMINATION SECONDARY 4 EXPRESS CANDIDATE NAME ( ) CLASS CENTRE NUMBER S INDEX NUMBER COMPUTING 7155/02 Paper 2 29 August 2022 2 hours 30 minutes Additional Material: Quick Reference for Python Setter(s): Mr Adrial Tan READ THESE INSTRUCTIONS FIRST Write your name, class and index number on all the work you hand in. Write in dark blue or black pen. All tasks must be done in the computer laboratory. Programs are to be written in Python. A Quick Reference for Python is provided. Approved calculators are allowed. Answer all questions. 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. Retrieve the template files from the COMPEXAM folder. Save your work inside the COMPEXAM folder using the file names given in the question as and when necessary. For Examiner’s Use 50

2 Task 1 Serangoon Secondary School’s basketball team has several members. The teacher-in-charge uses spreadsheet software to record the details of the members. You are required to finish setting up the spreadsheet to record the details for the members in the team. Open the file BBMEMBERS.xlsx. You will see the following data. Save the file as SSSBBMEMBERS_2022_<Class>_<Index_Number>_<Your_Name>.xlsx 1 In cell B20 enter a formula that uses a function to show how many members are there in the basketball team. [1]

3 2 In cell B21 enter a formula that uses a function to find the height of the members that appear the highest number of times. [1] 3 In cell B22 enter a formula that uses functions to find the average age of the members. The average age must be rounded up to the nearest integer. [2] 4 In the Remarks column enter a formula that uses functions to: • find the tallest member and display the text Captain for that member • find the second tallest member and display the text Vice Captain for that member All other cells in the column must display the text Member. [4] 5 In cells A4 to E18 use a conditional formatting tool to make the text red in the row that contains the shortest member. [2] Save and close your file. Task 2 begins on the next page.

4 Task 2 The minimum height a rider can be to ride on a pony at a zoo attraction is 1.4 metres. The following program checks whether a rider meets the minimum height requirement. The program allows the user to enter the names and heights of 10 riders. It will display a message after each rider’s details are input, to indicate if the rider is tall enough or not. num_rider = 10 min_height = 1.4 for p in range(num_rider): name = input("Enter name of rider: ") height = float(input("Enter height of