Exam Paper ICT May

Sat in May 2009

HideShow resource information
  • Created by: Abigail
  • Created on: 29-04-12 15:09
Preview of Exam Paper ICT May

First 215 words of the document:

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
· Write your name clearly in capital letters, your Centre Number and Candidate Number in the boxes above.
· Use black ink. Pencil may be used for graphs and diagrams only.
· Read each question carefully and make sure that you know what you have to do before starting your
answer.
· Answer all the questions.
· Do not write in the bar codes.
· Write your answer to each question in the space provided, however additional paper may be used if
necessary.
INFORMATION FOR CANDIDATES
· The number of marks is given in brackets [ ] at the end of each question or part question.
· The total number of marks for this paper is 120.
· No marks will be awarded for using brand names of software packages or hardware.
· This document consists of 16 pages. Any blank pages are indicated.
© OCR 2009 [F/500/7937] OCR is an exempt Charity
SP SJF4847 T65522/4 Turn over

Other pages in this set

Page 2

Preview of page 2

Here's a taster:

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 the data on potential customers from direct and indirect sources.
Describe two advantages of gathering the data from an indirect source.
1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................…read more

Page 3

Preview of page 3

Here's a taster:

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.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................…read more

Page 4

Preview of page 4

Here's a taster:

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 verification?
...........................................................................................................................................
..................................................................................................................................... [1]
(ii) Describe how proof reading works as a method of verification.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
..................................................................................................................................... [2]
(c) The database contains tables, records and fields.…read more

Page 5

Preview of page 5

Here's a taster:

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?
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
..................................................................................................................................... [2]
(ii) Give an example of a simple query and a complex query that could be used to search
the customer database.
Simple ...............................................................................................................................
...........................................................................................................................................
Complex ............................................................................................................................
.....................................................................................................................................…read more

Page 6

Preview of page 6

Here's a taster:

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 (windows, icons, menus, pointers) interface.
Describe the characteristics of a WIMP interface.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................…read more

Page 7

Preview of page 7

Here's a taster:

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 tailored data-entry screen.
Describe two considerations that should have been taken into account when designing the
data-entry screen.
1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................…read more

Page 8

Preview of page 8

Here's a taster:

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 standardisation amongst the software used could affect the airline.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
....................................................................................................................................................…read more

Page 9

Preview of page 9

Here's a taster:

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 the master slide.
1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [4]
(c) Describe the following features of presentation software:
(i) Slide transition
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
..................................................................................................................................... [2]
(ii) Animation
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................…read more

Page 10

Preview of page 10

Here's a taster:

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 advantages of using clipart in the presentation.
1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [4]
(c) Some of the images used in the presentation are vector graphics.…read more

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »