---

---

1

For Examiner's Use Name the devices A, B, C and D using the words from the list. A B C D bar code reader chip reader graphics tablet laser printer magnetic stripe reader pen drive remote control touch pad A B C D

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

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

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

Open

2

Ring two network devices. CD RW hard disc hub PIN plotter switch

Open

3

For Examiner's Use Tick whether the following items will appear in User or Technical documentation. User Technical frequently asked questions program coding system flowcharts trouble-shooting guide

7. The systems life cycle  →  7.5. Documentation

Open

4

Complete each sentence below using one item from the list. a bar code reader a CD ROM an inkjet printer a keyboard a knowledge base a magnetic hard disc The most suitable storage medium for storing data on a network server is Lists of illnesses and their symptoms are stored as An optical disc which cannot have data updated is Photos are output using

3. Storage devices and media  →  3.2. Storage media

3. Storage devices and media  →  3.1. Storage devices

Open

5

Draw five lines on the diagram to match the software to its most appropriate use. Software Use Desktop publishing software keeping a record of phone numbers Measuring program matching illnesses to symptoms Presentation software producing a multimedia slideshow Inference engine monitoring the weather Database producing a magazine

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

7. The systems life cycle  →  7.1. Analysis

Open

6

For Examiner's Use Tick whether the following statements apply to a CLI (Command Line Interface) or a GUI (Graphical User Interface). CLI GUI Instructions must be typed to get a computer to carry out an action. Icons represent programs. It is more important that users understand how a computer works. Menus are offered to help choose an action.

1. Types and components of computer systems  →  1.3. Operating systems

7. The systems life cycle  →  7.5. Documentation

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

Open

7

A student wishes to use floor turtle to draw this shape: Name and explain the meaning of four instructions that the turtle graphics software would need to contain in order to draw the shape. No two lines are the same length. Start Finish Instruction 1 Meaning Instruction 2 Meaning Instruction 3 Meaning Instruction 4 Meaning

Open

8

For Examiner's Use A greenhouse is controlled by a microprocessor. Tick three physical variables that would be monitored.
Humidity Temperature Pressure Wind speed Light Wind direction Explain the difference between measurement and control. Give four advantages of using a computer rather than allowing the students to control the growing conditions.

6. ICT applications  →  6.3. Computer controlled systems

7. The systems life cycle  →  7.1. Analysis

Open

9

For Examiner's Use A sports shop owner uses a spreadsheet to calculate his profits. This is part of the spreadsheet. A B C D E Item Selling Price Cost price Profit per item Number in stock Kino Trainers $45.00 $40.00 $5.00 Goalagame Boots $44.00 $38.00 $6.00 Melchester Rovers shirt $78.00 $65.00 $13.00 IOM football $51.00 $42.00 $9.00 Beckett shinpads $40.00 $32.00 $8.00 Give the cell reference of the cell that contains $42.00 Give the cell reference of a cell that contains an integer. How many rows are shown in the spreadsheet? Write down the formula which should go in cell D2. When the spreadsheet was created a similar formula to D2 had to go in cells D3 to D6. Describe how to enter these formulae without typing them. For Examiner's Use This spreadsheet is an example of a financial model. Give two examples of computer models, other than financial models. Tick three reasons why computer models are used.
The real thing may need too large a timescale. Computer models waste a lot of raw materials. The real thing is quicker to build. If a computer model fails it does not need rebuilding. Once a computer model is built it does not cost a lot to run. A model does not cost anything to make.

20. Spreadsheets  →  20.1. Create a data model

Open

10

For Examiner's Use 10 Aftab owns a company which has a small network of computers. Give two advantages of having computers networked. He wants to connect the computers to the internet. Name the device he would need to be able to do this. Give two benefits and two drawbacks of connecting to the internet. Benefit 1 Benefit 2 Drawback 1 Drawback 2

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

10. Communication  →  10.2. Effective use of the internet

Open

11

For Examiner's Use 11 Many banks offer internet banking. To access this online service customers have to log on to the system. Explain why authentication techniques are necessary. Customer data is encrypted. Explain what encryption is and why it is used.

8. Safety and security  →  8.3. Security of data

6. ICT applications  →  6.6. Banking applications

Open

12

For Examiner's Use 12 The growth of the internet has led to many new developments. Explain what the following terms mean. Spyware Spam Social networking site

10. Communication  →  10.2. Effective use of the internet

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

Open

13

For Examiner's Use 13 Anya has employed Raymond, a systems analyst, to create a new database system for sports day at her school. Here are some of the questions teachers and students might ask about the results of the athletics competition: What position did Peter Njoka come in the 100 metres? Who won the 1500 metres? The winner of the 800 metres was wearing which Race ID? Each athlete wore a Race ID consisting of one letter followed by three digits. The longest race is the 1500 metres. Complete the design table below filling in the field names and the most appropriate data types to create a database which would answer these questions. Field name Data type Race_ID Name and describe the most appropriate validation check which would be carried out on the Race_ID field. Name Description For Examiner's Use Anya wants to have a system which will make it easy to enter data. Describe five features of a well designed input screen.

18. Databases  →  18.1. Create a database structure

7. The systems life cycle  →  7.2. Design

Open

14

For Examiner's Use 14 Sarbjit has a desktop computer at home which he uses for internet banking. Identify two other computer systems he could use to do internet banking when away from home. Discuss the advantages and disadvantages to banks of using internet banking.

6. ICT applications  →  6.6. Banking applications

10. Communication  →  10.2. Effective use of the internet

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

Open

15

For Examiner's Use 15 Give four advantages to bank customers of using ATMs rather than going to the bank to withdraw cash.

6. ICT applications  →  6.6. Banking applications

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

Open

16

Some mobile telephones (cell phones) can be used to make video calls. Describe four advantages of making video calls rather than sending messages by email.

6. ICT applications  →  6.1. Communication

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

10. Communication  →  10.2. Effective use of the internet

Open