Exam paper Jan 2009 AS ICT

ict exam paper as level 2009

HideShow resource information
  • Created by: Vicky
  • Created on: 23-12-12 20:52
Preview of Exam paper Jan 2009  AS ICT

First 181 words of the document:

Candidate Centre Candidate
Name Number Number
2
GCE AS/A level
1241/01 New AS
INFORMATION AND
COMMUNICATION TECHNOLOGY
ICT1
INFORMATION SYSTEMS
P.M. MONDAY, 12 January 2009
21/4 hours
INSTRUCTIONS TO CANDIDATES
For Examiner's use only
Write your name, centre number and candidate number in the
spaces at the top of this page. Question Maximum Mark
mark awarded
Answer all questions. 1 7
Answers should be written in the spaces provided. Where the 2 4
space is not sufficient for your answer continue the answer at
3 6
the back of the book, taking care to number the continuation
correctly. 4 8
The intended marks for questions or part questions are given 5 5
in brackets [ ]. You are advised to divide your time 6 6
accordingly. The total number of marks available is 80.
7 6
You are reminded of the necessity for good written
communication and orderly presentation in your answers. 8 18
9 4
Quality of written communication will be assessed in
question 8. 10 16
Total 80
JD*(W09-1241-01)

Other pages in this set

Page 2

Preview of page 2

Here's a taster:

Examiner
only
SECTION A
Answer all questions.
1. Several types of Human Computer Interfaces (HCIs) are used with computer systems. Each type of
HCI provides specific benefits to the user.
(a) Describe a sensible use and benefit of the following types of HCI.
You should describe a different use and benefit in parts (i) and (ii).
(i) A touch sensitive screeen. [2]
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
(ii) A biometric device. [2]
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................…read more

Page 3

Preview of page 3

Here's a taster:

Examiner
only
2. Good quality information is needed to make informed decisions. Describe four characteristics of
good quality information. [4]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
3. The quality of the data input can often be improved by the use of validation techniques. Describe
three distinct types of validation technique that can be used and explain, using examples, the type
of error each technique is designed to prevent. [6]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................…read more

Page 4

Preview of page 4

Here's a taster:

Examiner
only
4. Database programs are often used for stock control.
(a) Some of the functions of the programs are mentioned below. State the purpose of each
function and give an appropriate example of its use.
(i) query, [2]
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
(ii) report, [2]
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
(iii) import/export. [2]
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
....................................................................................................................................................................................................................
(b) Flat file databases are now less widely used. Give two advantages of a relational database
approach over flat files. [2]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................…read more

Page 5

Preview of page 5

Here's a taster:

Examiner
only
5. Describe the important factors which must be taken into account when designing efficient data
processing systems. [5]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
6. "ICT has given criminals new tools to commit crimes."
Describe three forms of computer crime that illustrate this statement. [6]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
(1241-01) Turn over.…read more

Page 6

Preview of page 6

Here's a taster:

Examiner
only
7. Both LAN's and WAN's are widely used in health care. Using suitable examples describe the
impact these different types of networks are having upon the working practices in the Health
Service. [6]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
8. ICT has had a big impact on the home.
(a) Illustrating your answer with suitable examples, discuss both the benefits and drawbacks of
the impact of ICT on `home entertainment'. [10]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................…read more

Page 7

Preview of page 7

Here's a taster:

Examiner
only
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
1241-01 Turn over.…read more

Page 8

Preview of page 8

Here's a taster:

Examiner
only
(b) Discuss the impact of ICT on `home banking'. In your answer, describe the advantages that
it has brought the householder, the facilities offered and the effects on bank workers. [8]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................…read more

Page 9

Preview of page 9

Here's a taster:

Examiner
only
SECTION B
Answer all questions.
9. A small building company wants to use computer software to calculate the staff wages and also to
give quotes to customers for building jobs.
Describe the benefits to be gained from using spreadsheet software for these purposes. [4]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
YOU MUST REFER TO YOUR OWN SPREADSHEET TO ANSWER
THE FOLLOWING QUESTION.
IF NO SPREADSHEET EVIDENCE IS SUBMITTED THEN NO MARKS
CAN BE AWARDED.
10.…read more

Page 10

Preview of page 10

Here's a taster:

Examiner
only
(b) Describe in detail one method of simplifying data entry you created in your spreadsheet
stating two advantages and one disadvantage of using such techniques for entering data into
a spreadsheet. [4]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
(c) Describe two methods of validation error trapping used in your spreadsheet. [4]
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................…read more

Comments

dfgfth

THIS DOES NOT SHOW U DUMSHITES!

Similar ICT resources:

See all ICT resources »See all resources »