0417_w12_qp_12
A paper of Information and Communication Technology, 0417
Questions:
17
Year:
2012
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
4
For Examiner's Use Draw five lines on the diagram to match the input device to its most appropriate use. Input Device Use Mouse to input voiceovers for a presentation Joystick to input a PIN Optical Mark Reader to select options from a menu Microphone to operate a flight simulator Number pad to input candidate responses on examination papers
2. Input and output devices  →  2.1. Input devices and their uses
7. The systems life cycle  →  7.2. Design
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open
8
For Examiner's Use A geography teacher wants to build a weather station. She wants to use a computer to collect the results. Describe three physical variables which would be measured. The geography teacher wants to create a model to demonstrate basic weather forecasting to her students. Describe three features of a spreadsheet which make it suitable for modelling purposes. Describe three other uses of modelling. For Examiner's Use Give two reasons, other than reducing timescale, why computer models are sometimes used rather than the real thing.
6. ICT applications  →  6.2. Modelling applications
20. Spreadsheets  →  20.1. Create a data model
Open
9
Aftab owns a company which has a small number of computers. He wants to connect the computers into a network. He does not wish to connect the computers to the internet but he does want the workers to be able to communicate within the company. Name a network device used to connect the computers together. Name an item of software used to send messages between the computers. What is the name given to this type of network? Give three reasons why Aftab may not want his workers to access the internet.
4. Networks and the effects of using them  →  4.1. Networks
4. Networks and the effects of using them  →  4.2. Network issues and communication
Open
13
Computers are used in supermarkets at point of sales terminals. Tick three input devices which could be used to enter data about an item when it is purchased.  Optical character reader Electronic scales Sound sensor Bar code reader Number pad Trackerball Describe how the supermarket’s computer uses a check digit to check that data has been entered correctly. For Examiner's Use This is part of the supermarket’s database of items: Product name Number in Stock Re-order level Re-order quantity Supplier code Kollege Corn Flakes L93512 Crikey Orange Juice G63824 Nice Café Coffee L93512 This is part of the supermarket’s database of suppliers: Supplier code Name of supplier Address of supplier Supplier phone number L93512 Lu Chen 14, Kinshasa Highway Box 41324 72 34 45 67 G63824 Hameen 2351, Avenue Rios Box 31496 24 17 39 81 The supermarket computer can automatically re-order items when the supermarket is running low on stock. Describe this process, using the example databases above when two more packets of Kollege Corn Flakes pass through the checkout.
6. ICT applications  →  6.9. Computers in the retail industry
Open
15
Paul is the headteacher of a school. He has employed Mary, a systems analyst, to create a new database system to store records of his students. Here are some of the questions that Paul might want to answer using the new database system: Which class is Steven Jones in? What are the first names of male students in class 11S? How many IGCSEs is Sara Patel taking? No student takes more than 10 IGCSEs. Typical records would be: Peter Ngong, 11S, 10, M Joan Murugo, 11R, 9, F Francis Uhuru, 11S, 9, M Susan Mathu, 11T, 10, F Complete the design table below, filling in the field names and most appropriate validation rule which could be applied to each field. Field name Validation rule First_name none class For Examiner's Use Name and describe three types of test data which are used when testing a system. After the new system has been implemented it will be evaluated. Tick three activities which Mary will need to carry out as part of the evaluation.  Interview users about the current system Design the new system Compare the solution with the original task requirements Decide on the method of implementation Identify any limitations of the system Identify any necessary improvements to the system
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.6. Evaluation
Open