NASS S4_2022_Prelim P1_MS

Name: Register no: Class: NGEE ANN SECONDARY SCHOOL O Marking Scheme 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: ______________ For Examiner’s Use

2 NAS/2022/PRELIM/4E/COMPUTING(7155/01) This document consists of 16 printed pages and 2 blank pages. 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: Both networks can still continue to operate even when one of the computers breaks down. The replacement can be done without affecting the rest of the network. [1] Difference: Setting up a star topology typically costs more as it uses more cabling as compared to a bus topology which is easy and cheap to install as it uses less cabling. [1] [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: Modem [1] Function: A modem is responsible for modulation and demodulation which is the conversion of digital data into a form suitable for transmission and vice versa. [1] [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. TIME [1] [1] (b) Describe how Ms Anna can make the spreadsheet display the expected ratio. She can select cells C2 to C4 [1] and change their data type into TEXT [1]. OR she can type in an apostrophe in front of the data [1] like this: '20:20 [1] describe + example [2] (c) Cell D2 needs to show the percentage of girls in each class. Identify the most appropriate function that will need to be entered into D2 and copied to cells D3 and D4.