ZHSS 2019 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 2019 SECONDARY 4 EXPRESS Candidate’s Name Class Register Number COMPUTING 7155/02 Paper 2 (Lab Based) 4 September 2019 2 hours 30 minutes Additional Materials: Instruction Set 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 A Server Farm Service uses spreadsheet software to calculate the cost of the service for each customer. The Server Farm has five classes of server type and offers half service and full service. You are required to finish setting up the spreadsheet to calculate the cost of each service. Open the file SERVERFARM.xlsx Save the file as SERVERFARMCOST _<YOUR NAME>_<INDEX NO> 1 In cell C20 enter a formula to count the number of half service servers that have been booked. [1] 2 In cell C21 enter a formula to count the number of full service servers that have been booked. [1] 3 Use an appropriate function to search for the Cost per Server class in the Server Class table, and use it to complete the Cost column. The cost must take into consideration the Number of Units each customer will use. [2] 4 Use a conditional statement to identify whether a customer will receive a Discount (reduction in cost). For customers that have booked more than 5 units or have bought a service that costs $500 or more, put Yes in the Discount column, otherwise put No in the Discount column. [2] 5 Use a conditional statement to calculate the total cost of the service in the Total Cost column. Customers who are identified as Yes for the Discount must have a 10% reduction for the total cost. The Total Cost for customers without a discount is the same as Cost. [2] 6 In cell H20 enter a formula to calculate the average total cost of all the services, rounded to the nearest dollar($). [2] Save and close your file.

3 Task 2 The following program accepts temperature readings for 6 intervals. It also records the highest temperature reading and calculates f