---

---

1

This diagram shows a smart phone. Name two input devices shown on the phone diagram. Name one storage device which would be available in the phone shown above. Identify three ways the phone shown above could be used to contact a bank apart from making a phone call to the bank.

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

6. ICT applications  →  6.1. Communication

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

Open

2

Tick the most appropriate method of inputting data for the following uses. Use MICR ✓ Bar code reader ✓ OMR ✓ Inputting exam answers from a multiple choice test paper Inputting the account number from the bottom of a cheque Inputting the ISBN from the back cover of a book Inputting pencil marks from a school register

6. ICT applications  →  6.10. Recognition systems

2. Input and output devices  →  2.2. Direct data entry and associated devices

7. The systems life cycle  →  7.2. Design

Open

3

Explain what is meant by computer hardware and computer software, giving an example of each. Hardware Software

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

Open

4

Tick whether the following statements apply to verification, validation or neither. Verification ✓ Validation ✓ Neither verification nor validation ✓ Data is entered by two different operators Data is checked to see if it is present Data is checked to make sure it is correct Data entered is checked to see if it matches data on the source document

15. Proofing  →  15.2. Proofing techniques

7. The systems life cycle  →  7.2. Design

Open

5

Complete each sentence using a word from the list below. The type of processing used for updating bank accounts at ATMs is called The type of access used on a magnetic tape is called The type of software used to create printed magazines is called batch sensor spreadsheet online direct random serial DTP

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

3. Storage devices and media  →  3.2. Storage media

Open

6

Describe two recent developments in ICT which have improved the quality and speed of communication using the internet.

10. Communication  →  10.2. Effective use of the internet

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

Open

7

There are many causes of health and safety issues related to the use of computers in the workplace. Explain, giving examples, the differences between the causes of each issue.

5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment

8. Safety and security  →  8.1. Physical safety

Open

8

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 REPEAT n Repeat the following instructions n times END REPEAT Finish the REPEAT loop 72° 90° 50 mm 80 mm Start 60 mm Each shape has equal sides The turtle is facing up the page and the pen is up. A student has written the following set of instructions to make the floor turtle draw the above shapes. 1. PENDOWN 2. LEFT 90 3. REPEAT 6 4. FORWARD 50 5. RIGHT 72 6. BACKWARD 80 7. RIGHT 90 8. FORWARD 60 9. END REPEAT Although the first two instructions are correct, this set of instructions would not draw the shapes exactly as shown. Four instructions have been missed out and one is incorrect. Identify the incorrect instruction and state the correct instruction to be used. Write down the four missing instructions and indicate where they should be positioned in the list of instructions provided.

Open

9

An office has a microprocessor controlled central heating system. Name and describe, in detail, the use of two input devices in such a system. Name 1 Use 1 Name 2 Use 2 Describe how the microprocessor would keep the temperature of the office at a constant 19°C.

7. The systems life cycle  →  7.1. Analysis

1. Types and components of computer systems  →  1.2. The main components of computer systems

Open

10

Apart from security aspects, describe the role of a proxy server.

8. Safety and security  →  8.3. Security of data

10. Communication  →  10.2. Effective use of the internet

Open

11

A headteacher keeps all details of students in a database. Describe what is meant by the following terms, using examples of student data. Field File Record Describe what is meant by a key field, using examples of student data.

18. Databases  →  18.1. Create a database structure

7. The systems life cycle  →  7.2. Design

Open

12

An airline keeps a database of all the flights it operates. A short extract is shown below. Flight_ number Departure_ Airport_Code Number_of_ passengers Destination_Airport_code Ticket_prices EK236 JNB LHR $1200 EK080 DXB DEL $500 EK029 LHR DXB $650 Explain fully, what is meant by the following validation checks using the extract above. Range check Format check Length check Using the extract above, give an example of one field which would contain: Text data Numeric data

7. The systems life cycle  →  7.2. Design

15. Proofing  →  15.1. Software tools

Open

13

Explain how a SUMIF function works, using the example of SUMIF(A1:A6, ">29", B1:B6). A spreadsheet contains the following data and formula. D E F G Months in employment Days holiday due =SUMIF(D2:D10,>31

20. Spreadsheets  →  20.1. Create a data model

Open

14

Biometric methods are increasingly being used to authorise user access to computer systems. Explain, giving examples, why biometric methods are considered to be a more secure method of authorising access to a network than using id and passwords. Give three disadvantages of using biometric methods compared to user id and passwords.

8. Safety and security  →  8.3. Security of data

6. ICT applications  →  6.10. Recognition systems

Open

15

Many computer networks are connected using cables but some are now connected using wireless technology. Discuss the advantages and disadvantages of using wireless networks compared to using cabled networks.

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

16

A travel company uses an online booking system to book flights for its customers. The travel agent will type in the departure date, departure airport and destination airport. The system does not allow invalid airport names. Describe the processing and outputs involved in such a system. Give three other organisations which make use of online booking systems.

6. ICT applications  →  6.5. Booking systems

7. The systems life cycle  →  7.1. Analysis

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

Open

17

A headteacher has decided that the school newsletter will no longer be printed out for parents but, instead, will appear on the school website. Name three features available on a website not available in a hard copy version of the newsletter. For each one describe how it could be used on the school website. Feature 1 Use Feature 2 Use Feature 3 Use

10. Communication  →  10.2. Effective use of the internet

21. Website authoring  →  21.2. Create a web page

Open