ACSBR 2020 Computing P2

Anglo-Chinese School (Barker Road) Preliminary Examination 2020 1 Secondary 4 Express Computing 7155/02 Name: Class: 4S3 Index Number: PRELIMINARY EXAMINATION 2020 SECONDARY FOUR EXPRESS COMPUTING PAPER 2 7155/02 2 HOUR 30 MINUTES INSTRUCTIONS TO CANDIDATES Additional Materials: Electronic version of CARORDERS.XLSX data file Electronic version of BMI.PY Python file Electronic version of MARKS.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

Anglo-Chinese School (Barker Road) Preliminary Examination 2020 2 Secondary 4 Express Computing 7155/02 Task 1 ABC Company uses a spreadsheet to record the car orders and loans from customers. You are required to finish setting up the spreadsheet to calculate the monthly instalment for each of the order. Open the file CARORDERS. You will see the following data. Save the file as ORDERS_<your name>_<index number> 1 Use an appropriate function to search for the Basic Price of each car model type in the Model Basic Price table and use it to complete the Basic Price column. [2] 2 Use a conditional statement to determine the Package Price for each order. The Package Price costs 0%, 10% and 20% of the Basic Price for Classic, Deluxe and Luxury packages respectively. [2] 3 Thereafter, calculate the Total Price of the car. The Total Price is the Basic Price added to the Package Price. [1] 4 Use an appropriate function to calculate the Loan Amount of the car. The Loan Amount is the loan % of the Total Price. [1] 5 Use an appropriate function to search for the Annual Interest Rate in the Rates table and use it to complete the Rate column. [2]

Preliminary Examination 2020 3 Secondary 4 Express Computing 7155/02 6 Use an appropriate function to calculate the monthly instalment amount and use it to complete the Monthly Instalment column. [1] 7 Use an appropriate function to find out the Numbers sold for each car model in the Model Basic Price table. [1] Save and close your file.

Anglo-Chinese School (Barker Road) Preliminary Examination 2020 4 Secondary 4 Express Computing 7155/02 Task 2 The following program allows the weights and heights of 10 students to be input. The program then computes the body mass index, bmi and output the appropriate output if the bmi falls outside the acceptable range. students = 10 upp_bound = 25 low_bound = 18.5 for count in range(students): weight = float(input('Enter weight of s