CWSS 2020 Computing P2

COMMONWEALTH SECONDARY SCHOOL PRELIMINARY EXAMINATION 2020 COMPUTING Paper 2 (Practical) Name: _____________________________________ ( ) Class: ___________ SECONDARY FOUR EXPRESS/NORMAL (ACADEMIC) Wednesday 2 Sep 2020 7155/2 1100 – 1330 2 hour 30 min 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. Name of setter: Mr Cheong Hock Soan This paper consists of 6 printed pages including the cover page. [Turn over

2 Task 1 A delivery company is trying to incentivise its delivery staff to work harder amidst the spread of the COVID-19 virus. It uses spreadsheet to track the staff’s trips and amount of money they clocked in their deliveries for a particular week. Open the file WEEKLY. You will see the following data. Save the file as GENREPORT_<your name>_<class>_<index number>.xlsx 1 The first letter of the Employee ID states the area that he/she is deployed to work in. Enter an appropriate function in the Area column to find the area that the employee is deployed to. [1] 2 Use an appropriate function to search for the Incentive in the Incentive Table, complete the Incentive column. [2] 3 Enter a formula in the Commission column to calculate the commission that each staff gets. The commission is calculated by multiplying the incentive to the amount clocked. [1] 4 Use a conditional statement, to identify those staff who have commission more than $75.00 and put YES in the Award column. Otherwise, put NO in the Award column. [2] 5 Use conditional formatting, to identify those staff who have commission less than $20 by highlighting the cells in the Commission column in red. [2] 6 Use an appropriate function to count the number of staff deployed in each area and put the number in the Number of Staff column in the Staff Deployment table. [2] Save and close your file.

3 Task 2 The following program takes in 2 user entries and verifies if the users are Singaporeans by checking if the first letter of each entry is “S”. If the user is a Singaporean, the program prints a welcome home message. Otherwise, it prints a welcome to Singapore message. ID = '' for i in range(2): ID = input("Enter ID: ") if ID[0] == "S": print("Welcome home!") else: print("Welcome to Singapore!") 7 Open the file VERIFY.py Save the file as MYVERIFY_<your name>_<class>_<index number>.py Edit the program so that (i) It takes in 5 entries, [1] (ii) It prints the same welcome home message if the first letter of the entry is either