SPS 2020 Computing P2

READ THESE INSTRUCTIONS FIRST Write your name, class, index number in the spaces 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 number of marks for this paper is 50. Parent’s Signature : ____________________________ Date: ____________________________ Remarks (if any) : For Examiner’s Use Marks /50 Total % This document consists of 7 printed pages including this page and ANNEX A. ST. PATRICK'S SCHOOL PRELIMINARY EXAMINATIONS 2020 SECONDARY 4 EXPRESS NAME CLASS INDEX NUMBER COMPUTING Paper 2 (Lab-based) 7155/02 24 August 2020 2 h 30 min Additional Materials: Electronic version of THEMEPARK.xlsx data file Electronic version of GARGLE.py file Electronic version of INTEGERS.py file Quick Reference Glossary

2 [Turn over

3 [Turn over

4 [Turn over Task 1 A holiday theme park, Theme Park Pte Ltd uses a spreadsheet software to calculate their ticket sales. You are required to finish setting up the spreadsheet to calculate the revenue gained for each transaction number. Open the file THEMEPARK.xlsx. You will see the following data. Save the file as MYTHEMEPARK_<Class>_<Class_Index_Number>_<Your_Name> 1 The fifth character of each Transaction Number is the Code of the Package Name. In cells C7 to C16 enter a formula that uses an appropriate function to search for the Package Name in the Package table. Use it to display the Package Name. [2] 2 In cells E7 to E16 enter a formula that uses an appropriate function to search for the Price in the Package table. Use it to calculate the Full Cost in currency format. [2] 3 In cells G7 to G16 enter a formula that uses an appropriate function to search for the Discount in the Discount table. Use it to calculate the Discount given in currency format. [2] 4 In cells H7 to H16 enter a conditional statement to calculate the Revenue. If the Transaction Type is CORPORATE, apply an additional 2% of the Revenue. [2] 5 In cells F36 to H36 enter a conditional statement to calculate the number of each Transaction Type. [2]

5 [Turn over Task 2 The following program creates a Gargle Suite account for a user. It creates the username by taking the first letter of the user’s name and combining it with the user’s ID. It will also allow the user to enter a password. name = input("Please enter your full name: ") id = input("Please enter your ID: ") username = name[0] + id print("Your username is " + username) password = input("Please enter a password: "