2023 BVSS PRELIM P1 QP

Bukit View Secondary School Secondary 4 Express Preliminary Examination 2023 BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL BUKIT VIEW SECONDARY SCHOOL SCHOOL CANDIDATE NAME CLASS INDEX NUMBER COMPUTING 7155/01 Paper 1 25 August 2023 2 hours Candidates answer on the Question Paper. READ THESE INSTRUCTIONS FIRST Write your name, class and index number on the top of this page. Write in dark blue or black pen. You may use an HB pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, glue or correction fluid. Approved calculators are allowed. Answer all questions. No marks will be awarded for using brand names of software packages or hardware. At the end of the examination, fasten all your work securely together. The number of marks is given in brackets [ ] at the end of each question or part question. You should show all your working. The maximum number of marks is 80. For Examiner’s use Marks 80 Setter: Ms Lee Poh Tin Parent's Signature:__________________ This question paper consists of 18 printed pages.

2 1 A Science teacher records the first Weighted Assessment (WA1) marks of 20 students who are registered for the subject. The full marks of this WA1 Science Paper is 25 marks. The marks of students who were absent from the WA1 are recorded as VR (Valid Reasons) if they have Medical Certificates; otherwise, they are given zero mark. The teacher will need to produce a report on a list of students who need remedial lessons and their marks. Students who scored less than 40% will need remedial lessons. (a) Specify the inputs, stating the requirements for valid inputs. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [2] (b) Specify the outputs, stating the requirements for correct outputs. …………………………………………………………………………………… …………………………………………………………………………………… [1] 2 A software company develops software for the consumers to use technology for entertainment. (a) Describe one positive social impact for people to use technology in entertainment. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [2] (b) Describe one negative social impact for people to use technology in entertainment. …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… …………………………………………………………………………………… [2]

3 3 Four descriptions of spreadsheet functions are on the left, and five spreadsheet functions are on the right. Draw one line to link each description to the correct spreadsheet function. Description Spreadsheet Function LARGE Returns the most frequently occurring or repetitive value in the set of given numbers. MEDIAN Returns the largest value in the set of given numbers. AVERAGE Returns the number in the middle of the set of given numbers. MAX Returns the k-th largest value in the set of given numbers. CEILING.MATH MODE.SNGL [4]

4 4 An English Language Teacher uses a spreadsheet to keep track of students scores. There are 4 assessments in a year, namely WA1 (Weighted Assessment 1), WA2 (Weighted Assessment 2), WA3 (Weighted Assessment 3) and EOY (End of Year Exam). The weightage of the respective assessments is shown in the table below. The overall marks is calculated based on the weighted sum of the various assessments. Students who score at least 50 marks overall have passed the subject. Assessment Weightage WA1 15% WA2 15% WA3 15% EOY Exam 55% The spreadsheet is shown: (a) State the formula for cell F4 to calculate the overall marks for student ST01. …………………………………………………………………………………… [1] (b) The cell F13 shows the number of students passing the subject. Identify the function in cell F13. …………………………………………………………………………………… [1] (c) The text color of cells F4 to F11 changes to green if the student passes the the subject. Identify the spreadsheet feature used to change the colour of the cells depending on their value. …………………………………………………………………………………… [1]

5 5 A kindergarten is planning to have a computer network for the staff working at the kindergarten. (a) The operation manager has decided to set up a wireless computer network for the kindergarten. (i) Describe one advantage of a wireless computer network compared to a wired network for the kindergarten. …………………………………………………………………………… …………………………………………………………………………… …………………………………………………………………………… …………………………………………………………………………… [2] (ii) Describe one disadvantage of a wireless computer network compared to a wired network for the kindergarten. …………………………………………………………………………… …………………………………………………………………………… …………………………………………………………………………… …………………………………………………………………………… [2] (b) Describe the function of a wireless access point. …………………………………………………………………………………… …………………………………………………………………………………… [1]

6 6 Parity check is an error checking method to ensure that the data received at the destination is the same as the source. (a) The 7-bit binary value of 0110011 is to be transmitted from one computer to another computer on a network which uses the odd parity check with a prepended parity bit. Fill in the boxes below to show the final 8-bit binary value which will transmitted over the network. [1] (b) State the limitation of the parity checking method. …………………………………………………………………………………… …………………………………………………………………………………… [1] (c) Identify and describe one other error checking method that could be used to detect errors in data transmission. Error checking method ………………………………………………………… Description …………………………………………………………………….... ……………………………………………………………………..………..……. ……………………………………………………………………..………..……. ……………………………………………………………………..………..……. ……………………………………………………………………..………..……. [3]

7 7 There are various privacy and security threats that may impact the computer users. Complete the following paragraphs by filling in the missing words. A ................................... is a computer program that pretends to be a harmless file or useful application. Once this program is run, it does something harmful such as giving intruders ................................... access to the computer instead. .................................... involves the use of emails and fake websites that appear to be from reputable companies in order to steal personal information such as passwords and credit card numbers from users. A .................