JYSS 4E_COM_Prelim_P2_QP

JUNYUAN SECONDARY SCHOOL PRELIMINARY EXAMINATION 2022 SECONDARY FOUR EXPRESS CANDIDATE NAME CLASS INDEX NUMBER COMPUTING 7155/02 Paper 2 (Practical) 12 Sep 2022 2 hours 30 minutes Additional Materials: 1 x Thumb Drive Electronic version of TASK1.xlsx file Electronic version of TASK2.py file Electronic version of TASK3.py file Insert Quick Reference Glossary 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. This document consists of 8 printed pages, 4 blank pages and 1 insert. [Turn over For Examiner’s Use Task 1 10 Task 2 10 Task 3 10 Task 4 20 Total 50

2 Task 1 Ms. Yeo is consolidating the academic results of her students at the end of the year. She uses a spreadsheet software to make calculations and plan for school events. Students who do well will be awarded a monetary award on Speech Day. Ms. Yeo also plans to help her students who are underperforming by conducting a holiday bridging programme. You are required to finish setting up the spreadsheet to record the details for her students. Open the file TASK1.xlsx and you will see the following data. Save the file as MARKS_<Class>_<Index>_<Name>.xlsx. 1 In the Average column, enter a formula that uses a function to calculate the average of all the subjects attained for each student rounded up to one decimal place. [2] 2 In the Award column, enter a formula that uses an appropriate function to search for the Award in the Speech Day Awards table. [2]

3 4E Computing P2 2022 Prelim [Turn over 3 A student is awarded a Top Student award if their average score is the highest. In the Top Student column, enter a formula that uses functions to find the student(s) with the highest average and display the text ‘Top’ for the student. All other cells in the column must be empty. [3] 4 In cells K17 and K18, enter a formula that uses an appropriate function to count the number of students that meets the criteria description in the Holiday Bridging Programme table. [3] Save your work.

4 Task 2 The following program accepts positive integers and outputs their corresponding binary (base-2) equivalent. a = int(input("Enter a denary number: ")) converted = 0 loop = 0 while a != 0: remainder = a % 2 converted = converted + remainder*(10**loop) a = a // 2 loop += 1 print(converted) Open the file TASK2.py Save the file as BINARY