BLSS Paper 2[QN][PRINT]

BLS/PRELIM/2022/4E/COMP/7155/02 BOON LAY SECONDARY SCHOOL PRELIMINARY EXAMINATION 2022 Name CCA Subject : COMPUTING Paper No : 2 (LAB-BASED) Subject Code : 7155/02 Level : SECONDARY FOUR EXPRESS Date/Day : 26 AUGUST 2022 / FRIDAY Time : 0945 – 1215 Duration : 2 HOURS 30 MINUTES Additional Materials: Electronic version of T1_MOBILE_PLANS.xlsx Electronic version of T2_BALANCER.py Electronic version of T3_PARITY_INDEXNO_NAME.py Electronic version of Quick Reference Glossary READ THESE INSTRUCTIONS FIRST Before you start your exam, check that you have received the correct paper and the number of printed pages are correct. Write your name, index number, and CCA in the spaces at the top of this page. 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 6 printed pages.

2 BLS/PRELIM/2022/4E/COMP/7155/02 Task 1 Table A2:G38 shows the number of people in Singapore with subscriptions for 2G, 3G and 4G mobile plans between 2016 and 2018. Open the file T1_MOBILE_PLANS.xlsx 1 In cells B3:B26, use vlookup() to fill in the number of 2G subscriptions for each respective month from January 2016 to December 2017 by looking up the data in table J2:J27. [2] 2 In cells E3:E38, sum up the total number of people with 2G, 3G and 4G subscriptions in each month. [1] 3 In cells F3:F38, use hlookup() to fill in the population for each corresponding year in the row by looking up the data in J29:J31. [2] 4 In cells G3:G38, determine the percentage of the total population who own either a 2G, 3G or 4G subscription in that month. Round your answer to 2 decimal places. [3] 5 In cells H3:H38, determine if there are more people who own 4G subscriptions than 3G subscriptions. Display a “T” if it is true and “F” if it is false in the month. [2] Save your file as T1_MOBILE_PLANS_INDEXNO_NAME.xlsx and close your file.

3 BLS/PRELIM/2022/4E/COMP/7155/02 Task 2 A program was written to determine if two strings are balanced. Two strings are considered balanced if all the characters in the second string can be found inside the first string, regardless of the order and number of appearances. while True: print("Welcome to the string balancer") st1 = input('string 1: ') st2 = input('string 2: ') check = True for char in st2: if char not in st1: check = False if check == True: print("Strings are balanced")