2021 MSHS Computing P2

Class/ Index Number / Centre Number/ ‘O’ Level Index Number / Name MARIS STELLA HIGH SCHOOL PRELIMINARY EXAMINATION SECONDARY FOUR COMPUTING 7155/02 Paper 2 Practical (Lab-based) 20 August 2021 2 hours 30 mins Additional Materials: Electronic version of REGISTER.XLSX file Electronic version of PRODUCT.PY file Electronic version of GUESS.PY file Insert Quick Reference for Python 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. For Examiner’s Use This document consists of 8 printed pages. 50 Thumb drive No:

2 Task 1 Your company is in charge of organising the National Coding Competition held every year. Students register using their names, birth years (year they were born) and their school codes. As the organiser, you have to create a unique password for each student so that each student is able to access his personal account space in the National Coding Competition website. You are required to finish setting up the spreadsheet to create the unique passwords for the registered students. Open the file REGISTER.xlsx and you will see the following data. Save the file as PASS_<class>_<index number>_<your name>.xlsx 1 In cells D3 to D23, enter a formula that uses the Current Year and Birth Year to calculate the Age of the student. [1] 2 In cells F3 to F23, enter a formula that uses an appropriate function to search for the Category in the Category By Age table. [2] 3 The unique password for each student is obtained using the following: First 2 letters of the Name + length of Name + First letter of Category e.g. If the record reads as follows Jackie Chan 2004 17 MVSS Open His password will be Ja11O In cells G3 to G23, use the function CONCATENATE with appropriate parameters to join different strings together to form the password. [2] 4 In cells K10 to K12, enter an appropriate function to calculate the total number of students registered for each Category. [2] 5 In cells N16 to N24, enter a formula to calculate the total cost of registration for each category for each school by multiplying the Number Registered by the Cost per Category. [1]

3 6 In cells N9 to N11, enter an appropriate function to calculate the total cost chargeable to each school. [2] Save and close your file.

4 Task 2 The following program is used to determine if the product codes for a particular shop are valid. All product codes are 9 digits long. The first 8 digits are multiplied by a fixed weight based on their positions, then the total sum