ZHSS 7155_PRELIMS_2022_4E_P2_QP

ZHONGHUA SECONDARY SCHOOL PRELIMINARY EXAMINATION 2022 SECONDARY 4 EXPRESS Candidate’s Name Class Register Number COMPUTING 7155/02 Paper 2 Practical 13 September 2022 2 hours 30 minutes Additional Materials – Digital versions of: GOLDSTRIKEINTERNALMATCH.xlsx WEIGHFISH.py MULTIPLY_BY_RA.py 4DGUESS.py READ THESE INSTRUCTIONS FIRST Write your name, index number and class in the spaces at the top of this page. Write in dark blue or black pen. You may use an HB pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, glue, correction fluid or correction tape. Approved calculators are allowed. Answer all questions. The number of marks is given in brackets [ ] at the end of each question or part question. You should show all your working. The total of the marks for this paper is 50. Rename the folder A_Student to <Index_Number>_<Your_Class>_<Your Name> Store all your answer files in the renamed folder. Setter: Mr. Calvin Heng Vetted by: Mr. Low Kee Ley For Examiner’s Use TOTAL This question paper consists of 9 printed pages including this cover page.

2 Task 1 The Gold Strike archery club is preparing to select members for an upcoming international competition, by using a club level competition. The club uses spreadsheet software to record the details of the members scores. You are required to finish setting up the spreadsheet to record details of the members scores. Open the file GOLDSTRIKEINTERNALMATCH.xlsx. You will see the following data. Save the file as GOLDSTRIKESELECTION_2022_<your name>_<index number>.xlsx 1 In column D enter a formula that uses a function to add up the scores for Target 80 and Target 40 for each member. [1] 2 In cell B22 enter a formula that uses a function to find the highest score. [1] 3 In cell B23 enter a formula that uses functions to find the average score of all the members. The average score must be rounded up to the nearest integer. [2] 4 In the Ranking column enter a formula that uses functions to: [4]

3 • Find the highest score member and displays the text Gold for that member • Find the second highest score member and display the text Silver for that member. All other cells in the column must be empty. 5 In cells A5 to E19 use a conditional formatting tool to make the text red in the row that contains the lowest scoring member. [2]

4 Task 2 A program is used to input the weight of a fish on a fish farm. The minimum weight for the fish to be sold on the market is 1.2 kg. The following program checks whether the fish meets the minimum weight requirement. The program allows the farmer to enter the weights of 5 fishes. It will display a message after each weight entry is made, to indicate if the fish is ready to be sold on the market or not. number_fish = 5 minimum_weight = 1.2 for i in range(number_