ZHSS 2020 Computing P2

Setter: Mr. Calvin Heng Vetter: Mr. Low Kee Ley This question paper consists of 7 printed pages including this cover page. ZHONGHUA SECONDARY SCHOOL PRELIMINARY EXAMINATION 2020 SECONDARY 4 EXPRESS Candidate’s Name Class Register Number COMPUTING 7155/02 Paper 2 (Lab Based) 16 September 2020 2 hours 30 minutes Additional Materials: Instruction Set, Thumb Drive READ THESE INSTRUCTIONS FIRST Write your index number and name on all the work you hand in. Write in dark blue or black pen on both sides of the paper. You may use a pencil for any diagrams or graphs. Do not use staples, paper clips, glue or correction fluid. Answer all the questions. Write your answers in this question booklet. Give non-exact numerical answers correct to 3 significant figures, or 1 decimal place in the case of angles in degrees, unless a different level of accuracy is specified in the question. The use of a scientific calculator is expected, where appropriate. You are reminded of the need for clear presentation in your answers. At the end of the presentation, fasten all your work securely together. 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. For Examiner’s Use:

2 Task 1 Good Health Services is a health club offering spa and fitness related equipment and services to both members and day guests. The health club has five types of memberships and offers different rebates for members. You are required to finish setting up the spreadsheet to calculate the cost or each customer. Open the file GOODHEALTH.xlsx Save the file as: GOODHEALTH _<YOUR NAME>_<INDEX NO> 1 In cell C20 enter a formula to count the number of customers. [1] 2 In cell C21 enter a formula to count the number of members. [1] 3 Use an appropriate function to search for the Cost for each customer and use it to complete the Cost column. The cost must take into consideration the Number of Days each customer used the club. [2] 4 Use a conditional statement to calculate the rebate given for members only. Bronze receives 3% of the monthly cost, Silver receives 5% of the monthly cost, Gold receives 7% of the monthly cost, Platinum receives 13% of the monthly cost and Iridium receives 17% of the monthly cost. [2] 5 Calculate the Total Cost for each customer. Total Cost = Cost Less Rebate [2] 6 In cell G20 enter a formula to calculate the average total cost, rounded to the nearest dollar($). [2]

3 Save and close your file. Task 2 Every morning, students of a class (10 students) are required to report their temperature reading. The following program allows the teacher to input the temperature reading for each student (identified by Student Index Number). Open the file TEMPERATURE_READINGS.py Save the file as: TEMPERATURE_READINGS_<YOUR NAME>_<INDEX NO>.py 7 Edit the program so that it: