NASS 2019 P2

Name: ............................................................................. Register no: ............. Class: ................ NGEE ANN SECONDARY SCHOOL O PRELIMINARY EXAMINATION COMPUTING 7155/02 Paper 2 (Lab-based) 30 August 2019 2 hr 30 min Additional materials: Electronic version of CARLOAN.py file Electronic version of VENDING.py file Electronic version of WORDS.py file Electronic version of PARK.py file Insert Quick Reference Glossary Instructions to Candidates Write your name, register number and class at the top of this page. 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. Checked by student: _____________________ Date: _________ This document consists of 9 printed pages and 1 blank page. For Examiner’s Use Marks /50

2 NAS/2019/PRELIM/4E/COMPUTING(7155) Task 1 A car dealer company uses a spreadsheet to calculate the car loans and payment details of its customers. The spreadsheet provides the loan amount and annual interest rates tagged to different loan periods. You are required to finish setting up the spreadsheet to calculate the monthly payment amounts of each customer. Open the file CARLOAN.xlsx. You will see the following data. Save the file as LOANPAYMENT_<your name>_<centre number>_<index number>.xlsx 1 In cell C3 enter an appropriate formula to extract the year of purchase of the car from the purchase date given, and use it to complete the Year of Purchase column. [1] 2 Use an appropriate function to search for the Annual Interest Rate (%) and use it to complete the Annual Interest Rate (%) column. [2] 3 In cell H3 enter an appropriate formula to calculate the monthly principal payment of the car, and use it to complete the Monthly Principal Payment ($) column. [2] 4 In cell I3 enter an appropriate formula to calculate the monthly interest payment of the car, and use it to complete the Monthly Interest Payment ($) column. [2] 5 In cell J3 enter an appropriate formula to calculate the total monthly payment of the car, and use it to complete the Total Monthly Payment ($) column. [1]

3 NAS/2019/PRELIM/4E/COMPUTING(7155) 6 The company uses a credit status system to classify its customer. There are 3 groups of customers: A: total monthly payment is less than $1000 B: total monthly payment is less than $2000 C: total monthly payment is $2000 or more Use a conditional statement in cell K3 to indicate if the customer belongs to group A, B or C, and use it to complete the Credi