NASS S4_2022_Prelim P1

Name: ............................................................................ Register no: ............. Class: ............... NGEE ANN SECONDARY SCHOOL O PRELIMINARY EXAMINATION COMPUTING 7155/01 Paper 1 Written 25 August 2022 2 hours Candidates answer on the Question Paper. No Additional Materials are required. Instructions to Candidates Write your name, register number and class at the top of this page. Answer ALL questions. Write in dark blue or black pen. You may use pencil for any diagrams, graphs, tables or rough working. The use of an approved scientific calculator is expected, where appropriate. The number of marks is given in brackets [ ] at the end of each question or part question. You should show all your working. The total number of marks for this paper is 80. Checked by student: _____________________ Date: ______________ This document consists of 16 printed pages and 2 blank pages. For Examiner’s Use Total /80

2 NAS/2022/PRELIM/4E/COMPUTING(7155/01) 1 (a) The bus topology and the star topology are two possible physical layouts of a network. Give one feature that is the same for both a bus topology and a star topology, and one difference between the two. Feature that is the same: …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. Difference: …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. [2] (b) A home network typically requires a network interface controller and a router. Identify and describe the function of one other network device that could be part of the home network. Device: ……….………………………………………. Function: …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. [2]

3 NAS/2022/PRELIM/4E/COMPUTING(7155/01) 2 Ms Anna attempts to use a spreadsheet to record the gender ratio of each class. She records: • the number of girls and boys in each class • the ratio of girls to boys in each class • the classes Upon keying the ratio from cells C2 to C4, the spreadsheet detects the input and automatically changes the data type into something other than the expected ratio. (a) Identify the data type which cells C2 to C4 are changed into. …………………………………………………………………………………….. [1] (b) Describe how Ms Anna can make the spreadsheet display the expected ratio. …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. [2] (c) Cell D2 needs to show the percentage of girls in each class. Identify the most appropriate functio