MSHS 2020 Computing P1 Solution

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. SOLUTION For Examiner’s Use 80

2 This document consists of 14 printed pages. 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. Three from: • It has no moving parts so it will be durable as the drone moves/ able to withstand large impact/ less prone to data loss from shaking/impact • It is small/compact so it can easily fit onto the device • It is light so it will not be difficult to lift for the drone • It can hold a large amount of data needed for the video/film footage • Uses less power so drone battery will last longer • Solid state provides faster access/transfer of data than the other two [2] Comment: To earn each mark, state one characteristic of storage media + explain how this characteristic makes it suitable (1m) Unacceptable: Solid state is portable (characteristic stated) but no explanation provided.

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 proprietary software (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 open courseware (c) Sharon wants to purchase accounting software for her company’s use. She wants to try out a