Pages in this set

Page 1

Preview of page 1
THIS IS A NEW SPECIFICATION




ADVANCED SUBSIDIARY GCE
INFORMATION AND COMMUNICATION TECHNOLOGY G061
Information, Systems and Applications




Friday 15 May 2009
*OCE/T65522*




Candidates answer on the question paper

OCR Supplied Materials:
Morning
None
Duration: 2 hours
Other Materials Required:
None



* G 0 6 1 *




INSTRUCTIONS TO CANDIDATES
·…

Page 2

Preview of page 2
2
The OCR Airline makes use of ICT in a number of different ways.

1 The airline collects data on its customers.

(a) Using an example, show how data collected by the airline about its customers can become
information.

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

............................................................................................................................................. [3]

(b) The airline collects…

Page 3

Preview of page 3
3
(c) Customers can obtain information on different airlines and flights from holiday brochures or
from the internet.

Compare the use of holiday brochures and the internet as means of obtaining information on
airlines and flights.

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

............................................................................................................................................. [3]




© OCR 2009 Turn over

Page 4

Preview of page 4
4
2 The airline has a database of customer names and addresses.

(a) Identify the most appropriate data type for the following fields:

House number ...........................................................................................................................

Price of tickets ...........................................................................................................................

Telephone number ............................................................................................................... [3]

(b) Data entered into the database needs to be verified.

(i) What is the purpose of…

Page 5

Preview of page 5
5
(d) The database structure has been normalised.

Describe two disadvantages of normalisation.

1 ................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

2 ................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

............................................................................................................................................. [4]

(e) The database makes use of simple and complex queries.

(i) What is the difference between a simple and a complex query?

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

.....................................................................................................................................…

Page 6

Preview of page 6
6
3 The airline computers have keyboards and mice.

(a) Identify two other input devices that the airline computers could have and give an example of
how each could be used.

1 ................................................................................................................................................

...................................................................................................................................................

Use ...........................................................................................................................................

...................................................................................................................................................

2 ................................................................................................................................................

...................................................................................................................................................

Use ...........................................................................................................................................

............................................................................................................................................. [4]

(b) The computers have a WIMP…

Page 7

Preview of page 7
7
4 The airline has a computerised booking system that customers can use to book tickets via the
internet.

(a) Describe three characteristics of the airline booking system.

1 ................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

2 ................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

3 ................................................................................................................................................

...................................................................................................................................................

...................................................................................................................................................

............................................................................................................................................. [6]

(b) The booking system has a…

Page 8

Preview of page 8
8
5 At the airport, the airline needs to give announcements of flights.

Describe two advantages of using sound as a means of making announcements.

1 .......................................................................................................................................................

..........................................................................................................................................................

..........................................................................................................................................................

..........................................................................................................................................................

2 .......................................................................................................................................................

..........................................................................................................................................................

..........................................................................................................................................................

.................................................................................................................................................... [4]


6 The airline has many offices throughout the world.

Explain how a lack of…

Page 9

Preview of page 9
9
7 The airline uses a computer based presentation in all the airports to advertise its in-flight
services.

(a) Give two reasons why a master slide should be used when creating the presentation.

1 ................................................................................................................................................

...................................................................................................................................................

2 ................................................................................................................................................

............................................................................................................................................. [2]

(b) Describe two advantages of using a wizard to create…

Page 10

Preview of page 10
10
8 The airline occasionally needs to use material from another document in its presentation.

(a) Identify three stages, in order, required to export and import files between applications with
no common file format.

Stage 1 .....................................................................................................................................

...................................................................................................................................................

Stage 2 .....................................................................................................................................

...................................................................................................................................................

Stage 3 .....................................................................................................................................

............................................................................................................................................. [3]

(b) Describe two…

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »