---

---

1

This picture shows a part of a web page. There are six numbered icons in the picture. Write down what happens when you click each of the six numbered icons. icon 1 icon 2 icon 3 icon 4 icon 5 icon 6

21. Website authoring  →  21.2. Create a web page

Open

2

Tick the most appropriate output device for each of the following applications. Application Graph plotter ✓ Laser printer ✓ Dot matrix printer ✓ Rapid, high quality and high volumes of output CAD, where large printouts are required such as A0 Industrial environments such as car repair companies Printing on multipart forms

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

7. The systems life cycle  →  7.2. Design

18. Databases  →  18.3. Present data

Open

3

Complete the table by identifying the most appropriate storage method for each type of application. Application Storage method Theatre booking systems Storing photographs in a camera for printing at a later time The most portable device used to transport data from computer to computer A disc used to sell music albums without video

3. Storage devices and media  →  3.1. Storage devices

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

Open

4

Tick whether the following are uses of modelling, control or measurement. Use Modelling ✓ Control ✓ Measurement ✓ The maintaining of growing conditions in a greenhouse Simulating car driving Monitoring the environment Using what ifs

6. ICT applications  →  6.2. Modelling applications

7. The systems life cycle  →  7.1. Analysis

Open

5

Complete each sentence using words from the following list. ROM a bar code reader RAM magnetic tape a joystick OCR a chip reader MICR The input device used in flight simulation is The type of memory used to store the work that the user is currently working on is A medium used to backup data is

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

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

Open

6

A student wishes to use a floor turtle to draw this shape. All lines are of different lengths. Give three different instructions other than PENUP and PENDOWN which the turtle graphics software could use in order to draw the shape. For each one, explain the meaning of the instruction. Instruction 1 Meaning Instruction 2 Meaning Instruction 3 Meaning

14. Styles  →  14.1. Style management

Open

7

Students are investigating the behaviour of a colourless liquid in a beaker. As the colourless liquid heats up, it becomes cloudy. Name two sensors that would be connected to a computer in such an experiment. Describe how the student would set up the equipment in the experiment and how the computer would monitor and present the change in readings produced by the experiment.

7. The systems life cycle  →  7.1. Analysis

Open

8

Describe each of the following types of network. LAN WAN WLAN

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

Open

9

Tick three benefits to workers of the introduction of robots into car manufacture. ✓ Once bought robots do not have to be paid They have to do less hazardous jobs They don’t need to lift heavy loads They can become deskilled It can lead to unemployment They work in a cleaner/healthier working environment They can work whenever they want They get a massive pay rise

6. ICT applications  →  6.3. Computer controlled systems

Open

10

A bank customer wishes to withdraw cash from an ATM. Describe the computer processing which takes place in the ATM device itself.

6. ICT applications  →  6.6. Banking applications

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

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

Open

11

Describe what is meant by a microblog.

Open

12

The manager of a computer shop uses a database to store data about the computers he sells. This is part of the database. Makers_name Computer_ type Processor_type RAM (Gb) Hard disk (Tb) Never-never Laptop G4000 0.5 Johnsang PC L5000 1.0 Rany PC E3000 1.0 Hello-John PC F3500 2.0 Never-never PC A1000 1.0 Johnsang Laptop C2000 0.5 Hello-John Laptop D2500 1.0 Rany Laptop B1500 0.5 Write down the number of records shown in this part of the database. Write down the number of fields shown in this part of the database. The records shown are to be sorted in ascending order of Makers_name then ascending order of Processor_type. Give the Processor_type of the last record in the database after it has been sorted. Give the field that could be amended to contain Boolean data. Name and describe the most appropriate validation check other than a length check which would be carried out on the Processor_type field. Data in RAM is accessed more quickly than from a fixed hard disk. Give two reasons why fixed hard disks are still necessary.

18. Databases  →  18.1. Create a database structure

7. The systems life cycle  →  7.2. Design

20. Spreadsheets  →  20.1. Create a data model

Open

13

A company has decided to introduce a new computer system. It has employed a systems analyst to oversee this. Her first task is to research the current system. Identify three methods of carrying out this research other than by observation. For each method, give an advantage compared to the other methods. Method 1 Advantage Method 2 Advantage Method 3 Advantage The new system will be designed after the current system is analysed. Identify three items which will be part of the design. Once the system is implemented, the systems analyst will provide documentation for the new system. Explain why two types of documentation are needed.

7. The systems life cycle  →  7.1. Analysis

7. The systems life cycle  →  7.6. Evaluation

Open

14

Smart phones are used to send and receive emails with and without attachments. Describe four other ways in which emails can be managed on a smart phone.

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

6. ICT applications  →  6.1. Communication

Open

15

Identify three network devices, other than a router or modem, which are used to connect computers together in a network. For each one, describe how it uses the data it receives. Use Use Use

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

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

Open

16

Discuss the advantages and disadvantages to a teacher of using a tablet computer instead of another type of computer.

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

6. ICT applications  →  6.3. Computer controlled systems

10. Communication  →  10.2. Effective use of the internet

Open

17

Describe the characteristics and uses of different types of DVD.

3. Storage devices and media  →  3.2. Storage media

3. Storage devices and media  →  3.1. Storage devices

Open