0417_w12_qp_11
A paper of Information and Communication Technology, 0417
Questions:
17
Year:
2012
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
4
Complete the following sentences using the most appropriate device from this list. A graph plotter A dot matrix printer A laser printer A buzzer A multimedia projector A trackerball is used to print on continuous multipart stationery. is used to output sound. is used in CAD applications for very large printouts. is used to produce high quality and high volume printouts. is used to move a pointer on a screen.
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.1. Hardware and software
Open
11
There are many safety issues associated with the use of computers. Tick three methods which could be used to avoid these issues.  Take regular breaks from working at the computer. Do not overload electrical sockets. Make sure all cabling is securely tied. Sit with your back upright at all times. Always have a CO2 fire extinguisher in the room. Use a wrist rest when typing.
8. Safety and security  →  8.1. Physical safety
5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment
Open
13
For Examiner's Use 13 Computers are used in supermarkets at point of sales terminals. When paying for goods the customer inserts the bank card into the chip reader. Identify three items of data contained in the chip on a bank card. Describe three checks that would be carried out using information on the card before the bank is asked to authorise the transaction. Describe five steps which would be carried out by the computers at the supermarket and at the customer’s bank to complete the transaction.
6. ICT applications  →  6.9. Computers in the retail industry
8. Safety and security  →  8.3. Security of data
Open
14
For Examiner's Use 14 Mario has asked Louise, a systems analyst, to create a new database system for keeping records of books he sells in his bookshop. Louise will collect information about the existing system. Describe three methods she would use to do this. After collecting information, Louise noticed that Mario sells both non-fiction and fiction books in hardback and paperback. She also discovered that no books cost more than $20. She wrote down some of the questions that customers ask, such as: Have you got any non-fiction books by Arthur C Clarke? Have you got the hardback version of ‘Harry Potter and the Philosopher’s Stone’? Have you got any books for less than $10? Complete the design table below filling in the field names and most appropriate validation checks to create a database which would answer these questions. Field name Validation Check none none Price For Examiner's Use Identify three items of test data which could be used with the Price field giving reasons for your choice. Item 1 Reason Item 2 Reason Item 3 Reason
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.2. Design
Open
16
For Examiner's Use 16 A company uses robots to manufacture cars. Tick four advantages to the company of using robots rather than humans to manufacture cars.  Robots are cheap to buy Running costs are lower as humans have to be paid wages Robots never need maintenance Humans cannot work continuously Robots can work in hazardous conditions There is lower productivity with robots Robots produce the same standard of finished product every time Humans have greater accuracy than robots Describe three tasks that humans will have to do when robots are used to manufacture cars.
6. ICT applications  →  6.3. Computer controlled systems
6. ICT applications  →  6.2. Modelling applications
Open