2022 ACSBR Computing P2

Anglo-Chinese School (Barker Road) 1 Name: Class: Index Number: PRELIMINARY EXAMINATION 2022 SECONDARY FOUR EXPRESS COMPUTING PAPER 2 7155/02 2 HOUR 30 MINUTES INSTRUCTIONS TO CANDIDATES Additional Materials: Electronic version of CUSTOMERS.XLSX data file Electronic version of FIB.PY Python file Electronic version of DATE.PY Python file Electronic version of GET_PRICE.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 7 printed pages, inclusive of the cover page An g lo-C h in e s e Sc h o o l (Ba rke r R o a d )

Anglo-Chinese School (Barker Road) Preliminary Examination 2022 2 Secondary 4 Express Computing 7155/02 Task 1 The staff uses spreadsheet software to calculate the final cost that the customers incurred in the shop yesterday. You are required to finish setting up the spreadsheet. Open the file CUSTOMERS.xlsx. You will see the following data. Only selected rows from the file have been shown below. Save the file as MYCUSTOMERS_<your name>_<class>_<index number> 1 Use a function to extract the letter that is between the numbers to complete the Type column in the Cost for Customers table. Display “Member” for “M”, “Non- Member” for “N” and “Staff” for “S”. [2] 2 Use an appropriate function to search for the Discount Rate in the Type of Customers table and use it to complete the After Discount column. The after discount cost must take into the consideration of the cost that each customer incurred. [2] 3 Use a function to round down the after discount cost to the nearest dollar to complete the Final Cost column. [2] 4 In cell B25, C25 and D25 use a function to calculate the total final cost for each type of customer. [2] 5 In cells A3 to E20 use a formatting tool to change the colour of the row to yellow for staff type. [2] Save and close your file.

Anglo-Chinese School (Barker Road) Preliminary Examination 2022 3 Secondary 4 Express Computing 7155/02 Task 2 A Fibonacci sequence is the integer sequence of 0, 1, 1, 2, 3, 5, 8.... The first two terms are 0 and 1. All other terms are obtained by adding the preceding two terms. The following program outputs the first five terms in the Fibonacci sequence. n1 = 0 n2 = 1 nterms = 5 for i in range(nterms): print(n1) nth = n1 + n2 n1 = n2 n2 = nth Open the file FIB.py Save the file as MYFI