Pathlight 2022 4E Computing_Prelim P2 QP

PATHLIGHT SCHOOL PRELIMINARY EXAMINATION SECONDARY 4 EXPRESS CANDIDATE NAME CENTRE NUMBER S INDEX NUMBER COMPUTING 7155/02 Paper 2 Practical (Lab-based) August 2022 2 hours 30 minutes Additional Materials: Electronic version of CLUB.xlsx data file Electronic version of CHECKAGE.py file Electronic version of LEAPYEAR.py file Insert Quick Reference Glossary READ THESE INSTRUCTIONS FIRST Write your Centre number, Index number and name in the spaces at the top of this page. Answer all questions. All tasks must b e 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 marks for this paper is 50. This document consists of 6 printed pages and 2 blank pages. [Turn over Task 1

2 A fitness club uses spreadsheet to keep track of its members’ particulars and activities. As part of its loyalty programme, the club is planning the following benefits for its members this year: • membership discount based on a tiered discount programme • members who have joined for 3 years and above and have been active will be given a special gift set You are required to finish setting up the spreadsheet for the fitness club. Open the file CLUB.xlsx. You will see the following data. Save the file as MYCLUB_<your name>_<centre number>_<index number>.xlsx 1 In cell B1 enter a function to show today’s date. [1] 2 The last four characters of the Member ID shows the year the member joined the club. In cells D3 to D14, enter a formula to find the number of years that each member has joined the club. [2] [Hint: the function =YEAR() extracts the year from a date.] 3 In cells G3 to G14 enter a formula that uses an appropriate function to search for the Discount in the Membership Discount table to calculate the discount given for each member. [2] 4 In cell s H3 to H14 enter a formula to calculate the Fees Payable for each [1]

3 member. 5 Use a conditional statement to identify whether a member will receive a gift set . For members who have joined the club for 3 years or more and have been active, put Yes in the Gift Set column, otherwise put No in the Gift Set column. [2] 6 In cells A3 to I14 use a conditional formatting tool to change the background colour of the member name to yellow in the row that contains the youngest member. [2]

4 Task 2 The following program checks whether a person is able to join a fitness c