---

---

1

Data can be stored on Magnetic, Optical or Solid state media. Tick the most appropriate type of medium for each of the examples. Solid state (✓) Optical (✓) Magnetic (✓) Blu-ray disc Hard disk Pen drive Flash memory card

3. Storage devices and media  →  3.1. Storage devices

3. Storage devices and media  →  3.2. Storage media

Open

2

Tick the most appropriate type of computer that matches each description. Smartphone (✓) Laptop (✓) Desktop (✓) A portable computer that would most easily fit into your pocket A computer that is not powered by batteries A computer that has the smallest screen A portable computer with a keyboard and with a built-in 15 inch monitor

1. Types and components of computer systems  →  1.4. Types of computer

Open

3

A bank has trialled the replacement of Magnetic Ink Character Recognition (MICR) for the details at the bottom of the cheques with bar codes. Describe two advantages of using Magnetic Ink Character Recognition (MICR) rather than bar codes when processing cheques. 1 15

6. ICT applications  →  6.10. Recognition systems

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

6. ICT applications  →  6.6. Banking applications

Open

4

Truck repair shops tend to use dot matrix printers to produce their invoices. Identify two advantages of using a dot matrix printer rather than a laser printer in this environment.

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

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

Open

5

A computer contains system software and applications software. Explain what is meant by system software. Explain what is meant by applications software. Circle two types of system software. Operating system Linker Actuator Spreadsheet Sensor Photo-editing software [Turn over 1 15

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

Open

6

Phishing, pharming and smishing can affect the security of your data. For each of these security issues describe the methods which you could use to try to prevent them. Phishing Pharming Smishing 1 15

8. Safety and security  →  8.3. Security of data

Open

7

A number of devices are used to enable computers to communicate within a network. Two of these devices are hubs and switches. Compare and contrast the use of a hub and a switch. Bluetooth is an alternative method of allowing computers to communicate with other computers and devices. Describe how a tablet computer can connect to a printer using Bluetooth. [Turn over 1 15

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

Open

8

Tawara Health Centre is creating a new online appointment system for its patients. The developer has created a table showing part of the file structure of the new database. Comment Field length Data type Field name 12-digit unique number Numeric: integer Medical_ID_number dd/mmm/yyyy Date/Time Date_of_birth Text Family_name Text Doctor_name hh:mm Date/Time Appointment_time Text Contact_telephone_number Text Current_medication A, O, AB, B Each can be + or – Text Blood_type Apart from presence check, for each field, name an appropriate validation check that could be used. Your answer should be different in each case. Validation check Field name Medical_ID_number Blood_type Date_of_birth Contact_telephone_number Referring to the fields in the table, name the most appropriate field that could be used as a primary key. 1 15 Using the fields given in the database complete the design below showing a suitable online data entry form for the receptionist to fill in. [Turn over 1 15 The health centre has a new logo that appears on their online data entry form. The developers originally produced a logo and then had to change it so that it could be used appropriately on the online data entry form. The original logo is shown before the changes and the new logo after the changes. Before After Describe the changes that have been made to the original logo to create the new logo. 1 15 The doctors in the health centre use an expert system to help them diagnose illnesses. The symptoms of the patient’s illness are typed in by the doctor. Describe the processing that the system uses so that it can suggest possible illnesses. [Turn over 1 15

7. The systems life cycle  →  7.1. Analysis

7. The systems life cycle  →  7.2. Design

Open

9

A large city centre hotel uses a computer-controlled barrier for entry into its car park. A light sensor is used to detect the presence of a car and prevent the barrier from dropping onto the car. Describe how a microprocessor uses the data from the sensor to control the car park barrier. 1 15

5. The effects of using IT  →  5.1. Microprocessor-controlled devices

7. The systems life cycle  →  7.1. Analysis

Open

10

Name three physical safety issues associated with the use of ICT equipment, and for each one, suggest a possible method to help to prevent the issue. The methods should be different in each case. Issue 1 Method Issue 2 Method Issue 3 Method [Turn over 1 15

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

11

A small library is situated in a village. When a book is borrowed from the library the borrower presents the book and their library card to the librarian. Discuss the advantages and disadvantages of the different input devices which could be used by the librarian to record a book being borrowed. 1 15 Sometimes specialist books are needed in the library. When this happens a message has to be sent to the main library in the town. The message can either be sent by email or by physical fax. Describe the advantages and disadvantages of using email compared with sending a fax. [Turn over 1 15

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

10. Communication  →  10.2. Effective use of the internet

Open

12

As student data is entered into a school registration system it needs to be verified. Name two types of verification. Explain using examples why it is necessary to carry out validation as well as verification for this system. 1 15

15. Proofing  →  15.2. Proofing techniques

6. ICT applications  →  6.4. School management systems

Open

13

Explain the term function with reference to spreadsheets. State the purpose of absolute cell referencing and give the symbol that is used to indicate absolute cell referencing. Explain why named ranges are sometimes used in spreadsheets. [Turn over 1 15

20. Spreadsheets  →  20.1. Create a data model

Open

14

Several EFTPOS terminals have recently been installed in the ticket booking area of a train station. Describe the inputs and outputs of such a system when purchasing a ticket. 1 15

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

7. The systems life cycle  →  7.1. Analysis

Open

15

Peter is researching his family tree for his history project. He has the choice of using historical records stored in the local library or the internet to find the necessary information. Apart from not having to travel, discuss the advantages and disadvantages to Peter of using historical records stored in the local library rather than the internet. 1 15

10. Communication  →  10.2. Effective use of the internet

7. The systems life cycle  →  7.1. Analysis

Open