JYSS 2020 Computing P2

JUNYUAN SECONDARY SCHOOL PRELIMINARY EXAMINATION 2020 SECONDARY FOUR EXPRESS CANDIDATE NAME CLASS INDEX NUMBER COMPUTING 7155/02 Paper 2 (Practical) 1 Sep 2020 2 hours 30 minutes Additional Materials: 1 x Thumb Drive Electronic version of TASK1.xls file Electronic version of TASK2.py file Electronic version of TASK3.py file Insert Quick Reference Glossary 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. This document consists of 7 printed pages, 1 blank page and 2 pages of Python Quick Reference. [Turn over For Examiner’s Use Task 1 10 Task 2 10 Task 3 10 Task 4 20 Total 50

2 Task 1 Thorntastic Durian Imports uses a spreadsheet to track its durian sales records. You are required to finish setting up the spreadsheet to record the monthly sales data for the month of March. Open the file TASK1.xlsx. You will see the following data. Some of the rows in the file have been hidden in the display below. Save the file as DURIAN_<Class>_<Index>_<Name>.xlsx.

3 4E Computing P2 2020 Prelim [Turn over 1 Figure 1 below shows an example of an Order Code. The Order Code is made up of 13 characters and the breakdown of the code is shown below. I M - M S W 1 2 4 5 - M Y Figure 1 : Sample of Order Code For the cell range C7:C35, use an appropriate function to extract the Durian Code from the Order Code. [2] 2 Use an appropriate function to search for the Cost per KG in the Durian Price table given and use it to complete the Total Sales before Discount ($) column. The sales must take into consideration the Quantity Ordered (KG). [3] 3 For the cell range F7:F35, use an appropriate function to extract the Country Code from the Order Code. [1] 4 Use a conditional statement to identify orders that qualify for a discount or incur a surcharge. If the country code for the order is SG or MY, it qualifies for a Discount. If the country code for the order is OT, it incurs a Surcharge. [2] 5 Orders that qualify for a discount are given 12% off the total sales while orders that incur a surcharge have to pay 20% more than their total sales. Use a conditional statement to calculate the actual sale of each order in the Actual Sales ($) column. [2] Save your work. Import Status Durian Code Country Code Separator Separator Order Number

4 Task 2 The following program accepts the age in years for five employees and prints out the oldest age. oldest = 0 counter = 0 while counter < 5: age = int(input("Enter an employee’s age in years: "