0417_m15_qp_12
A paper of Information and Communication Technology, 0417
Questions:
16
Year:
2015
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
3
Complete the table by identifying the most appropriate input device for each type of application. Application Device Inputting diagrams as they are being drawn Inputting printed text to a computer to be processed by another software package Inputting moving pictures, often pre-recorded, into a computer Used by a pilot to control a flight simulator
2. Input and output devices  →  2.1. Input devices and their uses
1. Types and components of computer systems  →  1.1. Hardware and software
Open
5
Complete the sentences using words from the list below. The device used for switching channels on a television is called A method of inputting answers from a candidate’s exam paper is called A printer which is suitable for producing large volumes of high quality printout is called ROM a remote control RAM a dot matrix printer a trackerball OMR a laser printer an inkjet printer
2. Input and output devices  →  2.3. Output devices and their uses
2. Input and output devices  →  2.1. Input devices and their uses
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open
7
A floor turtle can use the following instructions: INSTRUCTION MEANING FORWARD n Move n mm forward BACKWARD n Move n mm backward LEFT t Turn left t degrees RIGHT t Turn right t degrees PENUP Lift the pen PENDOWN Lower the pen REPEAT n Repeat the following instructions n times END REPEAT Finish the REPEAT loop 60° 120° 40 mm 100 mm Start 50 mm NOT TO SCALE A student has written the following set of instructions to make the floor turtle draw these shapes. The turtle is facing up at the start. 1. PENDOWN 2. LEFT 90 3. REPEAT 5 4. FORWARD 50 5. RIGHT 60 6. PENUP 7. PENDOWN 8. RIGHT 120 9. FORWARD 50 10. END REPEAT Although the first two instructions are correct, this set of instructions would not draw the shapes exactly as shown. Three instructions have been missed out and two are incorrect. Write down the three missing instructions and indicate where they should be positioned in the list of instructions provided. 1. 2. 3. Identify the two incorrect instructions and for each, state the correct instruction to be used. 1. 2.
Open
9
WBA is a company that makes little profit. Its newly commissioned ICT system is ready to be implemented. It needs the new system to be in use as soon as possible. Describe the advantages and disadvantages of using parallel running compared with direct changeover as a method of implementing the system. Choose which of these two methods of implementation WBA should use, giving reasons for your choice.
7. The systems life cycle  →  7.4. Implementation
7. The systems life cycle  →  7.1. Analysis
Open
13
Using the example of COUNTIF(A2:A10,” Rupinder has created a spreadsheet showing the following data and formula. 1DPH ' ( ) *          $YWDU.KROL 6XUMHHW6LQJK -DZDKDU1HKUX 6XQLO.DSRRU -DVYLU6KHUJLOO ,VKLWD'XWWD 1LNKLO%DQHUMHH $QLWD0HUFKDQW 6DQMLYH.XPDU 0RQWKVLQHPSOR\PHQW  &2817,) ( (µ µ       Write down the value that would be contained in cell G2. Rupinder subtracts the value in part from 9 (the number of workers). He thinks this will tell him the number of workers who have been in employment for more than 33 months. Explain why his reasoning does not work.
20. Spreadsheets  →  20.1. Create a data model
Open
15
Recaud Inc. stock many CDs. Below is a small selection of CDs stored on their database. ID number Artist_name CD_title Price (Rs) Year_released Number_of_tracks Nayan Pancholi Maa Na Nayan 249.00 Nayan Pancholi, Gargi Vora Maa Amba 145.00 Lakshmi Shankar Ecstasy 120.00 Anindo Chatterjee Anindo and His Tabla 230.00 Jagjit Singh Greatest Hits 255.00 Write down the most suitable data type for the following fields. CD_title Price (Rs) Year_released Number_of_tracks Describe the range check which could be carried out on the Price (Rs) field. The maximum price and the minimum price are shown in the table above. The owner of the shop, Alam, receives requests from customers about the CDs he has in stock. He makes a note of these requests using comparison and Boolean operators. For example, a customer might ask for a CD which was released after 2002 and has at least 7 tracks. Alam would write this down as: Year_released > 2002 AND Number_of_tracks >= 7 Write down a request for a customer who wants a list of all the CDs which were released before 2007. This list must also contain all the CDs which cost at least 145 rupees. Write down the ID numbers of those records which would match your criteria in .
20. Spreadsheets  →  20.2. Manipulate data
20. Spreadsheets  →  20.1. Create a data model
18. Databases  →  18.1. Create a database structure
Open