SST (for revision practice) 2024 S3 Computing EOY P2 QP_Final

SECONDARY 3 END-OF-YEAR EXAMINATION COMPUTING Paper 2 Practical (Lab-based) 7155/02 9 October 2024 (Wednesday) 2 hours 30 minutes CANDIDATE NAME CLASS INDEX NUMBER Additional Materials: Electronic version of AGE.ipynb file Electronic version of coe_bid.txt data file Electronic version of coe_id.txt data file Electronic version of MASTERMIND.ipynb file Electronic version of SALARY.xlsx data file Electronic version of TEMP.ipynb file Insert Quick Reference Guide for Python READ THESE INSTRUCTIONS FIRST Approved calculators are allowed. 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 70. This document consists of 13 printed pages including this cover page. For Examiner’s Use Task 1 15 Task 2 10 Task 3 10 Task 4 10 Task 5 25 Total /70 For revision practice

Task 1 SSTea Inc, a bubble tea company, uses spreadsheet software to calculate their employees’ salaries. Open the file SALARY.xlsx and you will see the following data. Save the file as: TASK1_<your class>_<index number>_<your name>.xlsx (e.g. TASK1_S300_08_Jane Tan.xlsx) 1 In cell G1, enter a function that displays the current date and time. [1] 2 In cell G3, enter a formula that uses (an) appropriate function(s) to create a Salary Reference Code. The reference code consists of the following information joined together with no extra characters in between: • the employee’s last name (the second word in Full Name) • the 3-letter abbreviation of the month (as shown in cell A1) • a random 1-digit number from 0 to 9 The Salary Reference Code must be calculated in a single formula. [4] 3 In cells C7 and C8, enter a formula that uses (an) appropriate function(s) to calculate the number of normal hours and overtime hours the employee worked. For a part-time employee, any hours after the 139th are considered overtime. For a full-time employee, any hours after the 176th are considered overtime. For example, if a part-time employee worked for 150 hours,139 hours are considered Normal Hours and 11 are considered Overtime Hours. [4]

Page 3 of 13 [Turn over 4 In cell C10, enter a formula that uses (an) appropriate function(s) to calculate the salary for this month. The formula should look up the correct salary rate for the employee’s job rank in the Salary Rate (per hour) table, then multiply the salary rate with the number of normal hours and overtime hours worked respectively. The salary rate should be multiplied by 1.5 for the overtime h