Computing Prelim 2018 S4Exp Paper 2 Share with Schools

Preliminary Examination (2018) Secondary 4 Express Candidate Name Register No Class COMPUTING Paper 2 Practical (7155 / 02) Date: 28 August 2018, Tuesday Duration: 2 hours 30 minutes READ THESE INSTRUCTIONS FIRST 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. Task 1 (10 m) Task 2 (10 m) Task 3 (10 m) Task 4 (20 m) Total (50 m) At the end of the practical exam Number of files submitted : (including the given files) Declared by candidate : _____________________ Signature Verified by teacher : _____________________ Signature This document consists of 7 printed pages Setter : Katrina, Wong Shing Liu Files provided: CARD.py EMPLOYEE.py HOUSELOAN.xls TELEPHONECHARGES.xls

- 2 - 2018 Computing Prelim S4 Express Paper 2 Practical Task 1a (4 marks) A couple uses spreadsheet software to keep track of loans from different banks that will be repaid using a lump sum. You are required to finish setting up the spreadsheet to record the loan details. Open the file HOUSELOAN. You will see the following data. Save the file as LOANLIST_<your_name>_<class>_<index_number>. 1 Use an appropriate function to calculate the amount of payment made at the end of each month and use it to complete the Monthly instalment column. [1] 2 Use an appropriate function to calculate the amount that needs to be paid at the end of the loan period and use it to complete the Lump sum repayment column. [1] 3 Use a conditional statement to indicate if the loan is affordable. The loan is affordable if the monthly instalment is $1500 or less and put YES in the Affordability column. Otherwise put NO in the Affordability column. [2] Save and close your file.

- 3 - 2018 Computing Prelim S4 Express Paper 2 Practical Task 1b (6 marks) A company uses a spreadsheet to keep track of the telephone charges of some users. You are required to finish setting up the spreadsheet to record the telephone charges. Open the file TELEPHONECHARGES. You will see the following data. Save the file as TRACKUSES_<your_name>_<class>_<index_number>. 4 The plan type can be found from the Customer ID. It is the 3 rd character in the Customer ID. Example: Customer ID: 15A0251 Plan type : A Use an appropriate function to extract the plan type and use it t