2021 ACSBR Computing P2

Anglo-Chinese School (Barker Road) Preliminary Examination 2021 1 Secondary 4 Express Computing 7155/02 Name: Class: Index Number: PRELIMINARY EXAMINATION 2021 SECONDARY FOUR EXPRESS COMPUTING PAPER 2 7155/02 2 HOUR 30 MINUTES INSTRUCTIONS TO CANDIDATES Additional Materials: Electronic version of TICKETS.XLSX data file Electronic version of LOGIN.PY Python file Electronic version of RESULTS.PY Python file Insert Quick Reference Glossary Answer all questions. All tasks must be 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 number of marks for this paper is 50. This document consists of 8 printed pages, inclusive of the cover page Anglo-Chinese School (Barker Road)

Anglo-Chinese School (Barker Road) Preliminary Examination 2021 2 Secondary 4 Express Computing 7155/02 Task 1 XYZ Airlines uses spreadsheet software to calculate the sales of air tickets to ABC island. Customers can choose between first, business or economy class for their air tickets. They are also entitled to additional discounts according to membership status. You are required to finish setting up the spreadsheet to calculate the cost of each transaction. Open the file TICKETS.xlsx. You will see the following data. Only selected rows from the file have been shown below. Save the file as MYTICKETS_<your name>_<centre number>_<index number> 1 The Tickets Cost needs to be calculated for the correct Number of Tickets the customer has ordered. In cells F3 to F25 enter a formula that uses an appropriate function to search for the Price of each ticket in the Ticket Information table. Use it to calculate the Tickets Cost of each transaction. [2] 2 The Discount can be calculated by applying the appropriate Discount rate depending on the Membership of the customer. In cells G3 to G25 enter a formula that uses an appropriate function to search for the Discount rate of each transaction in the Membership Type table. Use it to calculate the Discount of each transaction.. [2] 3 In cells H3 to H25 enter a conditional statement to calculate the Final Cost of each transaction. This is the Tickets Cost subtracted by the Discount. An additional 5% reduction is applied to the Final Cost for Early Bird transactions. [2]

Preliminary Examination 2021 3 Secondary 4 Express Computing 7155/02 4 In cells C29, C30 and C31 enter a formula that uses an appropriate function to calculate the number of tickets sold for each cabin type. [2] 5 In cells A3 to H25 use a form