2022 MSHS Sec 4 Computing SA2 Paper 2_QP

Thumb drive No: STL 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) 26 August 2022 2 hours 30 mins Additional Materials: Electronic version of LIBRARY.XLSX file Electronic version of NUMBER.PY file Electronic version of WORD.PY file Electronic version of CONVERTER.PY file Insert Quick Reference for Python READ THESE INSTRUCTIONS FIRST Write your class, index number, Centre number, O level index number and name in the spaces at the top of this page. Answer all the 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 10 printed pages. 50

2 Task 1 The Chanel Library stores the loan records of its library users. It uses a spreadsheet software to record the details of the loans. You are required to fi nish setting up the spreadsheet to record the loan details for the users of the library. Open the file LIBRARY.xlsx. You will see the following data. Save the file as LOAN_<class>_<index number>_<your name>.xlsx 1 In cell E5, enter a formula that uses an appropriate function to search for the Book Genre in the Genre table. The Loan ID comprises the first six characters of the Book Genre and all characters of the Number field. You may use the symbol & to join them. For example , ="ABCDEF" & "1001" displays the text as ABCDEF1001. The Loan ID of the first record is CHILDR1001. Use it to calculate the Loan ID in column E. [3] 2 In cells H5 to H21, enter a formula to find the total days of the loan using the Date Borrowed and Date Returned fields. [1] 3 In cells J5 to J21, enter a conditional statement to identify if the loan is overdue. If the total days of loan exceeds 21 days, display the text “Overdue”. Otherwise, display the text “Not Overdue”. [2] 4 In cell J22, enter a function to calculate the total number