---

---

1

Many word processing packages have a number of formatting features. Write down six of these features which have been used in the following passage. The boiling point of water, H2O, at normal atmospheric pressure is 100° C. The two elements which make up water are Hydrogen and Oxygen. Water covers seventy percent of the surface of the earth. In different parts of the world, water can be found in liquid, solid, and gaseous forms. In its liquid form it is tasteless and odourless and more or less colourless. Many substances dissolve in water and because of this it is commonly referred to as the universal solvent.

14. Styles  →  14.1. Style management

17. Document production  →  17.1. Document layout

Open

2

Tick the most appropriate method of inputting data for the following uses. Use Web cam  Keyboard  Scanner  Applications where text has to be created rather than copied Inputting hard copy documents directly into a computer Inputting moving pictures from a fixed position into a computer Entering text directly into a word processing document

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

13. Layout  →  13.1. Create or edit a document

Open

3

Explain what is meant by the following terms, giving examples of their use. MICR OMR

7. The systems life cycle  →  7.5. Documentation

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

Open

4

When creating a database, it is important to assign the correct data type to each field. Tick the most appropriate data type for each of the following items of data. Numeric  Date  Text  A student’s name How many times a student has been late to a lesson The amount of money it costs to travel to school When the end of term is

18. Databases  →  18.1. Create a database structure

7. The systems life cycle  →  7.2. Design

Open

5

Complete each sentence using the most appropriate words from the following list. a word processor a control program a spreadsheet an inference engine a web authoring package a search engine a measuring program a DTP package The software used to find information on the internet is The software which is a component of an expert system is The type of software used to create financial models is

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

Open

6

Explain, using examples, what is meant by authentication techniques.

8. Safety and security  →  8.3. Security of data

Open

7

Give three reasons why it would not be sensible to use batch processing in an online theatre booking system.

6. ICT applications  →  6.5. Booking systems

Open

8

A floor turtle can use a number of instructions. For each of the following instructions give the correct meaning. FORWARD n REPEAT n LEFT t RIGHT t PENUP PENDOWN

Open

9

A chemistry student wants to measure how quickly a liquid cools after it has boiled. She will use a sensor connected to a computer to do this. Identify two variables which will need to be recorded. Describe how the computer would process the data into a form the student could use to analyse the results.

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

7. The systems life cycle  →  7.1. Analysis

20. Spreadsheets  →  20.1. Create a data model

Open

10

Describe the differences in use between WiFi and Bluetooth.

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

Open

11

Compare and contrast the use of optical discs and the use of fixed magnetic disks to store data.

3. Storage devices and media  →  3.1. Storage devices

3. Storage devices and media  →  3.2. Storage media

Open

12

Most supermarkets now operate online shopping. Discuss the advantages and disadvantages to supermarkets of this development.

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

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

Open

13

A company is going to introduce a new computer system. The company employs drivers to deliver orders and they are rarely in the office for more than a few minutes. The office secretaries process the orders and dislike being interrupted. A manager is in charge of the current system and appointments can be made to see her. Name three methods of researching the current system other than from examining documents. Identify the workers that each method would be most suitable for. Each method will be used with a different type of worker. After the current system has been researched, the new system will be designed. This means that the file structure will be designed. Identify three items of a flat file structure which will form part of this activity.

7. The systems life cycle  →  7.1. Analysis

18. Databases  →  18.1. Create a database structure

Open

14

A student types in the formula =IF(A1>12,"strong",IF(A1>6,"medium","weak")) into a spreadsheet. Explain, using the terms ‘condition’, ‘true’, ‘false’, how this nested IF function works. Another student wishes to reverse the formula to get the same result. She types in the formula IF(A1 Financial models and scientific experiments are examples of different types of modelling applications. Give three other examples of types of modelling.

20. Spreadsheets  →  20.1. Create a data model

Open

15

Students at a school visit a variety of websites on the internet to get information about a topic. Describe four features of a website that will prove that the information found on it is reliable. Describe three other features of a website that may indicate that the information found on it is not likely to be reliable. In order to make reliable information available to all students, schools often put the information on their intranet. Describe what is meant by an intranet.

10. Communication  →  10.2. Effective use of the internet

Open

16

Give four benefits of using social networking sites.

8. Safety and security  →  8.2. eSafety

10. Communication  →  10.2. Effective use of the internet

Open

17

There are many health issues associated with the use of computers. Name three of these health issues and for each one describe, in detail, a different cause. Health issue 1 Cause Health issue 2 Cause Health issue 3 Cause

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

10. Communication  →  10.2. Effective use of the internet

Open

18

Tick three features of wikis.  A wiki is an example of a spreadsheet. A wiki is quicker to search than a database. Wiki entries are in chronological order. A wiki can have several contributors. Wikis are always a reliable source of information. Wikis can be edited using a web browser. Anybody can create a wiki. Wikis never contain hyperlinks.

10. Communication  →  10.2. Effective use of the internet

21. Website authoring  →  21.2. Create a web page

Open