SPS 2022 Sec 4E Computing Prelim P1

NAME CLASS INDEX NO. ST. PATRICK'S SCHOOL PRELIMINARY EXAMINATION 2022 SUBJECT : Computing Paper 1 (7155/01) DATE : 18 AUG 2022 LEVEL : Secondary 4 Express DURATION : 2 hours READ THESE INSTRUCTIONS FIRST Write your Name, Class and Index No. in the spaces at the top of this page. Write in dark blue or back pen. You may use an HB pencil for any diagrams or graphs. Do not use staples, paper clips, glue or correction fluid. Approved calculators are allowed. Answer all questions. 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. For Examiner’s Use Score /80 This paper contains 14 printed pages including this cover page. Candidates answer on the Question Paper.

2 1 Draw lines to match each spreadsheet function to its correct description. Function Description COUNT • • Counts the number of cells that are not empty. COUNTA • • Counts the number of characters in a cell. COUNTIF • • Counts the number of cells within a range that meet a specified condition. • Counts the number of cells that contain numeric data. [3] 2 Hendra wants to upgrade his computer by replacing its processor and memory. (a) Some of the following words need to be used to complete the description of processor and memory. bi-directional memory non-volatile gigahertz volatile temporary gigabytes storage uni-directional CPU Insert five words from the list given to complete the following statements. When the Central Processing Unit (CPU) receives an instruction to write data to the memory, the ………………………………. address bus carries the destination address from ………………………………. to ……………………………… .. . The data bus carries the data to be written. The speed of a CPU is usually measured in ………………………………. . ………………………………. memory refers to Random Access Memory. This memory is ………………………………. , which means all data and instructions stored on it are erased when the computer is switched off. [5]

3 (b) Information is stored in a computer in units known as bits and bytes. Describe what is meant by a bit and a byte. (i) Describe what is meant by a bit and a byte. …………………………………………………………………………………….. …………………………………………………………………………………….. …………………………………………………………………………………….. [2] (ii) Convert the following amounts of data in the stated units. 139 MB = …………………………………. KB 2 450 000 000 B = …………………………………. GB [2]

4 3 Kenny works as an editor in a magazine company and uses his word processer to publish his essay. He wants