MSHS 2020 Computing P1

Class/ Index Number / Centre Number/ ‘O’ Level Index Number / Name MARIS STELLA HIGH SCHOOL PRELIMINARY EXAMINATIONS SECONDARY FOUR COMPUTING 7155 Paper 1 Written 26 August 2020 2 hours Candidates answer on the Question Paper No Additional Materials are required. READ THESE INSTRUCTIONS FIRST Write your class, index number and name in the spaces at the top of this page. Write in dark blue or black pen. You may use a HB pencil for any diagrams or graphs. Do not use staples, paper clips, highlighters, glue or correction fluid. Approved calculators are allowed. Answer all the 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 This document consists of 13 printed pages. 80

2 1 Draw a line between the description and the correct spreadsheet function. Description Function CEILING Returns the kth largest number in range RAND Returns the largest number out of the numbers in the given range or cell references RANDBETWEEN Returns a random number greater than or equal to zero and less than one HLOOKUP Rounds up a number to an exact number of significance LARGE Search for data in a row and returns associated data in the same column. MAX [5] 2 (a) A sports event company uses a digital camera attached to a drone to video their events from the sky. The video is stored as it is captured, on a device that is attached to the drone. Circle the most suitable type of media to store the video. (i) Optical Magnetic Solid State [1] (ii) Give two reasons to justify your choice. 1 ……………………………………………………………………………………….. …………………………………………………………………………………………. 2 ……………………………………………………………………………………….. …………………………………………………………………………………………. [2]

3 3 Insert three of the following words about different types of software in the correct place in each scenario below. public domain software proprietary software open courseware shareware freeware (a) Ali’s company requires productivity software that can be used in his business for emailing customers, creating orders, and tracking of the company’s profits and losses. He would also like regular customer support and updates from the software company that owns the source code of the software. The most suitable category of software for this usage is …………………………… (b) Mingxuan wants to learn more about Python programming during the school holidays. He wants to enrol for free online lessons provided by a university’s website that contains videos and training materials for his learning. The most suitable category of software for this usage is …………………………… (c) Sharon wants to purchase accounting software for her company’s use. She wants to try out a few features of the softwar