---

---

1

For Examiner's Use Name the methods of storage A, B, C and D using the words from the list. A B C D Bar code Chip DVD RAM Graphics tablet Light pen Magnetic disc Magnetic tape Pen drive A B C D

3. Storage devices and media  →  3.1. Storage devices

3. Storage devices and media  →  3.2. Storage media

Open

2

Ring two items which are output devices. Blu-ray disc Graph plotter Graphics tablet Optical mark reader Projector Web cam

2. Input and output devices  →  2.3. Output devices and their uses

3. Storage devices and media  →  3.1. Storage devices

1. Types and components of computer systems  →  1.1. Hardware and software

Open

3

For Examiner's Use Tick TRUE or FALSE next to each of these statements. TRUE FALSE Input devices are examples of hardware Backing storage devices are examples of software A Graphical User Interface is a part of an operating system A laptop computer cannot be carried around

1. Types and components of computer systems  →  1.1. Hardware and software

18. Databases  →  18.1. Create a database structure

Open

4

Draw five lines on the diagram to match the input device to its most appropriate use. Input device Use Remote control Inputting freehand drawings into a computer Keyboard Operating a television Touch screen Entering text when writing a book Chip reader Selecting options in a tourist information kiosk Graphics tablet Reading information from a credit card

2. Input and output devices  →  2.1. Input devices and their uses

2. Input and output devices  →  2.3. Output devices and their uses

7. The systems life cycle  →  7.2. Design

Open

5

Complete each sentence below using one item from the list. A hub An intranet A proxy server A WAN A WLAN is a device used to connect computers together to form a LAN. is a network with restricted access. can allow networked computers to connect to the internet. is a wireless local area network.

4. Networks and the effects of using them  →  4.1. Networks

Open

6

For Examiner's Use Students can use CDs or pen drives for storing their work. Give three reasons why students may prefer to use pen drives.

3. Storage devices and media  →  3.1. Storage devices

Open

7

For Examiner's Use 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 Start Finish Complete the set of instructions to draw this shape by filling in the blank lines. PEN DOWN FORWARD 80 RIGHT 90

Open

8

For Examiner's Use Tick three developments which have arisen because of the internet.
Web logs Databases Models Wikis DTP Social networking sites

10. Communication  →  10.2. Effective use of the internet

Open

9

Tick TRUE or FALSE next to each statement to indicate whether it is an example of batch processing. TRUE FALSE Withdrawing money from an ATM Producing utility bills Booking a plane ticket Producing payslips

18. Databases  →  18.1. Create a database structure

Open

10

A school uses a computer controlled greenhouse to grow plants. Name three sensors that would be used in the greenhouse. Explain why analogue to digital conversion is needed when computers are used to control a greenhouse. For Examiner's Use Tick three advantages of using computers, rather than students, to control the growing conditions.
Computer readings are more accurate Students always forget to take readings Students might be unavailable to take readings during school holidays Computers can record data for later use Computers can analyse the results Computers can react to changes in the conditions immediately The students want a printed record of the computer readings as they are taken. They want to put the printer inside the greenhouse. Their teacher has suggested a dot matrix printer. The students suggested an inkjet printer. Give two reasons why the teacher has suggested a dot matrix printer. Give two reasons why the students have suggested an inkjet printer.

2. Input and output devices  →  2.3. Output devices and their uses

7. The systems life cycle  →  7.1. Analysis

Open

11

For Examiner's Use 11 A school library has a file for storing details of the books it has and a file for storing details of its borrowers. The two files are linked using a common field. Book File Years 10 and 11 Borrower File How many records are there in the book file? How many fields are there in the borrower file? What type of database do these two files form? Give two reasons why this type of database system is used rather than having two flat files. Code Title Author Published Number in stock Cost 1857028898 The Code Book Simon Singh £10.99 0747591054 The Deathly Hallows J K Rowling £17.99 0748791167 Sepulchre Kate Mosse £18.99 0563371218 Full Circle Michael Palin £19.99 Number Name Form Book Borrowed Due Back Me Te Loan 11A 14/06/2010 Gurvinder Moore 10C 12/06/2010 Akhtar Aftab 10B 06/06/2010 Graham Reeves 10D 08/06/2010 For Examiner's Use Which field is the primary key in the Book file? Which field is the foreign key? Which field has the data type currency? What data type would be most appropriate for the Due Back field? Name the most appropriate validation check for the Number in stock field. Name the most appropriate validation check for the Form field.

18. Databases  →  18.1. Create a database structure

7. The systems life cycle  →  7.2. Design

Open

12

For Examiner's Use 12 Aftab and his family have three computers in their home. He wants to connect the computers into a network. Explain why he would need: A router A browser Email An ISP

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

The use of computer networks can lead to problems in keeping data secure and confidential. Tick two problems which can affect the security of data.
Data encryption techniques are easy to crack Data can be accessed without being in the building where it is stored Data thieves often do not leave physical signs of robbery Data passwords are easy to guess Tick two ways of increasing the confidentiality of data.
Make backups of the data Users should write down their password in case they forget it Have a firewall connected to the network Have different levels of access to the data

8. Safety and security  →  8.3. Security of data

Open

14

For Examiner's Use 14 Joan owns a small company. She wishes to replace the existing computerised system with a new one. She has employed a systems analyst, Jasvir, to plan this. Before Jasvir decides on a system he must collect information about the existing system. Tick whether the following statements about the various methods of information collection are TRUE or FALSE. TRUE FALSE Examining documents has to be done in the presence of all the workers Appointments have to be made with a worker in order to complete a questionnaire It is possible to change questions in the course of an interview Observing the current system can provide a detailed view of the workings of the system After Jasvir has completed the analysis of the existing system, he will need to design the new system. Tick four items which would need to be designed.
Inputs to the current system User and information requirements Data capture forms Validation routines Problems with the current system File structure Report layouts Limitations of the system

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. Give one advantage of each of the following methods of implementation. Direct changeover Parallel running Phased implementation

7. The systems life cycle  →  7.4. Implementation

7. The systems life cycle  →  7.6. Evaluation

7. The systems life cycle  →  7.3. Development and testing

Open

16

After a system has been implemented it needs to be evaluated. Identify two evaluation strategies and state a reason why each is needed. Strategy 1 Reason 1 Strategy 2 Reason 2

7. The systems life cycle  →  7.6. Evaluation

7. The systems life cycle  →  7.1. Analysis

Open

17

For Examiner's Use 17 Describe three items of hardware which would be needed, in addition to those normally supplied with a PC, in order to take part in a video conference.

4. Networks and the effects of using them  →  4.2. Network issues and communication

1. Types and components of computer systems  →  1.1. Hardware and software

7. The systems life cycle  →  7.1. Analysis

Open

18

A supermarket uses POS terminals at its checkouts. This enables stock levels to be updated automatically. Put the following steps in order using the numbers 2 to 8. Step 1 has already been done for you. The number in stock of the matching record is read Until a match is found with the entered bar code The data file is searched The bar code on the product is read by the bar code reader The new value of number in stock is written back to the file If it is equal to the re-order number then more goods are automatically re-ordered One is subtracted from the number in stock The number in stock is compared with the re-order number

6. ICT applications  →  6.9. Computers in the retail industry

Open

19

For Examiner's Use 19 Give three reasons why pilots are trained using flight simulators rather than by flying real aircraft.

6. ICT applications  →  6.2. Modelling applications

6. ICT applications  →  6.3. Computer controlled systems

Open

20

Explain what is meant by the following terms. Phishing Pharming Spam

8. Safety and security  →  8.3. Security of data

10. Communication  →  10.1. Communication with other ICT users using email

Open

21

For Examiner's Use 21 When sending documents companies sometimes use email and sometimes use ordinary post. Give two reasons why email might be used. Give two reasons why ordinary post might be used.

10. Communication  →  10.1. Communication with other ICT users using email

6. ICT applications  →  6.1. Communication

Open