0417_s10_qp_13
A paper of Information and Communication Technology, 0417
Questions:
21
Year:
2010
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
4
Draw five lines on the diagram to match the input device to its most appropriate use. Input device Use Bar code reader Inputting voiceovers into presentation software Microphone Selecting options from a list Mouse Inputting a PIN at an ATM Numeric key pad Inputting data from a school register Optical mark reader Inputting code numbers from products at a POS terminal
2. Input and output devices  →  2.1. Input devices and their uses
2. Input and output devices  →  2.2. Direct data entry and associated devices
6. ICT applications  →  6.10. Recognition systems
Open
6
For Examiner's Use Tick three reasons why optical media may be used to store data rather than magnetic media.  It is easier to transfer data to other computers using optical media rather than fixed hard discs Optical media are cheaper to buy than magnetic media A CD stores more data than a fixed hard disk Data is easier to encrypt on optical media Optical media provide quicker access to individual data items than magnetic tape CD ROMs are easier to update than magnetic media
3. Storage devices and media  →  3.1. Storage devices
3. Storage devices and media  →  3.2. Storage media
Open
10
A hospital uses computers to monitor patients’ conditions. Name three physical variables that could be monitored. Explain why computers cannot read physical variables directly. For Examiner's Use Tick three advantages of using a computer rather than a nurse to monitor a patient’s condition.  Nurses always make mistakes Computers can monitor continuously without taking breaks Computers can measure more than one variable at the same time Computers can take readings more frequently Nurses cannot take readings regularly Computers can analyse the results The nurses will need a printed record of the computer readings as they are taken. They have decided to use a graph plotter. Give two reasons why they have chosen a graph plotter. When surgeons operate on patients they sometimes need to use computers. Give two reasons why they would use a light pen as an input device.
6. ICT applications  →  6.7. Computers in medicine
6. ICT applications  →  6.2. Modelling applications
6. ICT applications  →  6.3. Computer controlled systems
Open
11
For Examiner's Use 11 A DVD shop owner wants to use a spreadsheet to calculate his profits. This is part of a spreadsheet he could use. Give the cell reference of the cell that contains $18. Give the cell reference of a cell that contains a label. Write down the formula that has been used to calculate the value in cell D4. The Total profit per title is calculated by multiplying the Profit per DVD by the Number in stock. Write down the formula that should go in cell F2. The owner wants to enter a similar formula to calculate the Total profit per title in cells F3 to F5. Write down the name of the technique he could use to do this. How many columns are shown in the spreadsheet? A B C D E F DVD title Cost price Selling Price Profit per DVD Number in stock Total profit per title Alice in Wonderland $21 $24 $3 Toy Story 2 $18 $24 $6 How to train your dragon $15 $20 $5 Alpha and Omega $22 $31 $9 Total profit of the four titles For Examiner's Use The owner wants to find out his total profit for these four titles using a formula. Write down the formula he should use. Give the reference of the most appropriate cell to insert this formula. If the owner changes the Selling price of Alice in Wonderland to $28 which other three cells would now change as a result?
20. Spreadsheets  →  20.1. Create a data model
Open
13
For Examiner's Use 13 The use of computer networks can lead to problems of keeping data secure and confidential. Two methods of overcoming this are the use of authentication techniques and data encryption. Tick two authentication techniques.  Firewall Passwords Biometrics An intranet Tick two features of data encryption.  It makes it impossible to access computer systems Only authorised users can understand the data A key is needed to decrypt data It prevents viruses
8. Safety and security  →  8.3. Security of data
Open
14
For Examiner's Use 14 Peter owns a small company. He wishes to replace the existing computerised system with a new one. He has employed a systems analyst, Sarbjit, to plan this. Sarbjit wishes to collect information about the existing system using a variety of methods. Tick TRUE or FALSE to indicate whether the following statements give appropriate reasons why the method would be used. TRUE FALSE Examining documents helps to identify the inputs and outputs of the system A questionnaire makes the workers feel good An interviewer can ask questions based on the previous response Observing the current system helps to identify any problems with the system Sarbjit will need to design the file structure of the new system. Tick four items which would need to be included in this design.  Field names Screen layout Field types Key field Field lengths User needs System specification Input forms
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.6. Evaluation
Open
15
For Examiner's Use 15 After a system is designed it will be implemented. For each of the following situations, write down the most appropriate method of implementation. A small company with very little money to spare A company where the most important consideration is not to interrupt production A company which only wants a small scale implementation to begin with
7. The systems life cycle  →  7.3. Development and testing
7. The systems life cycle  →  7.4. Implementation
7. The systems life cycle  →  7.1. Analysis
Open
18
A bank uses a chip and pin system at its ATMs. A customer wishing to withdraw cash inserts their card. The ATM checks to see if the card is valid and if so asks the customer to type their PIN. Put the following steps in order using the numbers 2 to 8 for a customer whose transaction is successful. Step 1 has already been done for you. The customer types in the PIN If they are the same the customer is asked which service is required The customer’s account is checked to see if it has sufficient funds The amount is checked against the card limit The typed PIN is compared with the PIN stored in the chip The customer selects required service If there are sufficient funds and the amount is within the card limit the required notes are issued. The customer is asked how much money they want to withdraw
6. ICT applications  →  6.9. Computers in the retail industry
6. ICT applications  →  6.6. Banking applications
Open