SPSS 2018 P1

READ THESE INSTRUCTIONS FIRST Write your name, class, index number in the spaces at the top of this page. Write in dark blue or black 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. Parent’s Signature : ____________________________ Date: ____________________________ Remarks (if any) : For Examiner’s Use Marks /80 Total % This document consists of 14 printed pages including this page. ST. PATRICK'S SCHOOL PRELIMINARY EXAMINATIONS 2018 SECONDARY 4 EXPRESS NAME CLASS INDEX NUMBER COMPUTING Paper 1 Written 7155/01 11 September 2018 2 h Candidates answer on the Question Paper. No Additional Materials are required.

2 [Turn over 1 Draw a line to match the spreadsheet function to the correct description. Function Description MAX Returns the most frequently occurring or repeated value in the given numbers or the given range/cell references LARGE Returns a user-defined number of characters starting from a position of the text value text MODE.SNGL Returns the largest number out of the given numbers or the numbers in the given range/cell references Returns the kth largest number in a range of cells [3] 2 (a) Convert the binary number 10110110 into a denary number. Show your working. [2] (b) Convert the hexadecimal number F5 into a binary number. Show your working. [2] (c) Convert the denary number 34 into a hexadecimal number. Show your working. [2]

3 [Turn over 3 Insert six of the following words about computer hardware, memory and storage devices in the correct place in the respective spaces below. optical storage(s) digital storage(s) solid-state storage(s) processor register(s) ROM RAM ALU secondary storage(s) address bus(es) data bus(es) control unit(s) The type of memory or storage employed in a computer depends on how the data stored inside is meant to be used: are physically located inside the processor. The extremely fast but small data storage spaces are used directly by the and . or main memory is where data and instructions are stored temporarily so that they can be quickly accessed by the processor when needed. is where data and instructions that rarely need to change or would be needed for a computer to start up are stored. is where large amounts is where large amounts of data are stored, such as in a hard disk or a hard drive. . [6] 4 Signals are sent to and fro