MFSS 2019 P2

Name: ______________________________ ( ) Class: _______ MONTFORT SECONDARY SCHOOL PRELIMINARY EXAMINATION 2019 Secondary 4 Express COMPUTING Paper 2 (Lab-based) 11.30 am 7155/02 2 Sep 2019 (Mon) 2 hours 30 minutes Additional Materials: Electronic version of VEHICLES.xlxs data file Electronic version of VOWELS.py file Electronic version of SORTNUMBER.py file Insert Quick Reference Glossary attached as ANNEX A READ THESE INSTRUCTIONS FIRST Do not open this booklet until you are told to do so. Write your name, index number and class in the spaces provided at the top of this page. Write in dark blue or black pen. 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 marks for this paper is 50. For Examiner’s Use Total 50

2 This document consists of 6 printed pages. Setter: Mr Wong Teck Piaw, Mr Ricky Tan Task 1 A company uses spreadsheet software to record the list of vehicles they are interested in purchasing. You are required to finish setting up the spreadsheet to record the loan amount and monthly installment for each vehicle. Open the file VEHICLES.xlsx. You will see the following data. Save the file as MYVEHICLES_<your name>_<your class>_<index number>.xlsx 1 In cell B20 enter a formula to count the number of vehicles listed. [1] 2 In cell B21 enter a formula to calculate the range of prices of vehicles listed. [1] 3 Enter a formula to calculate the loan amount for each vehicle and use it to complete the Loan Amount column. The loan amount is the balance after the downpayment is paid. [1] 4 Use an appropriate function to search for the Interest Rate per Year in the Rates table and use it to complete the Interest Rate (p.a.) column. [2] 5 Enter a formula to calculate the monthly instalment for each vehicle and use it to complete the Monthly Instalment column. [2]

3 6 The company now decides to consider all BrandA vehicles only. Use a conditional statement to identify all BrandA vehicles and put Yes in the Shortlist column. Otherwise put No in the Shortlist column. Save and close your file. [3] Task 2 The alphabet is made up of 26 letters, 5 of which are vowels (a, e, i, o, u) and the rest of which are consonants. The following program accepts the input string 'computing' and prints out the number of occurrences for vowels in the string, and the consonants in the string. vowel_num = 0 consonants = '' for letter in 'computing': if letter in ['a','e','i','o','u']: vowel_num += 1 else: consonants += letter print('Number of Vowels: ',vowel_num) print('Consonan