!

-,
I
"v
!!
I TEST CODE 01229020
I
FORM TP 2012087 MAY/JUNE 2012
I
iiI CARIBBEAN EXAMINATIONS COUNCIL
iI SECONDARY EDUCATION CERTIFICATE
I EXAMINATION

ffiFORMATIONTECHNOLOGY

Paper 02 - General Proficiency

2 hours 15 minutes

( 14 MAY 2012 (a.m.) )

READ THE FOLLOWING INSTRUCTIONS CAREFULLY.

1. This paper consists of THREE sections and a total of TWELVE questions.

Candidates MUST answer ALL questions in all TIIREE sections.

2. Number EACH answer correctly in the answer booklet.

3. Code is to be written in the programming language, Pascal.

-
iiiiii

--
iiiiii
;;;;;
DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO DO SO.

-
==
==
Copyright 2011 Caribbean Examinations Council
All rights reserved.
 -2 -

SECTION I

THEORY - 60 marks

Answer ALL questions.

1. (a) Rearrange the following units of storage in order of size with the SMALLEST at the top:

Gigabyte
Terabyte
Kilobyte
Megabyte (4 marks)

(b) (i) What is the meaning of the term 'bit'? (1 mark)

(ii) How was the term 'bit' derived? (1 mark)

~

(c) Explain ONE difference between a 'word' and a ~byte'. (2 marks)

(d) Explain the term 'bi-stable device'. (2 marks)

Total 10 marks

2. (a) Write the output devices listed below in your answer booldet. Write the appropriate related
task next to EACH output device.

Output Devices Tasks

Print
Draw a video
Outputcheques
house plan audio responses in a language lab
individual

VDU
Plotter
Printer
Headphones (i)

(ii)

(iii)

(iv)

(4 marks)
(b) Give ONE situation when it would be better to use

(i) an impact printer instead of an ink jet printer. State ONE reason to justify your
answer. (2 marks)

(ii) a laser printer instead of a dot matrix printer. State ONE reason to justify your
answer. (2 marks)

(iii) a page printer instead of a character printer. State ONE reason to justify your
answer. (2 marks)

Total 10 marks

GO ON TO 'fHE NEXT PAGE

01??Q020/F 2012
 . ', -..,

,. - ;
'''r'.''" ..'
-..,.'11,

;-3-

3. (a) State THREE functions of an operating system. (3 marks)

(b) Use the items below to answer (b) (i) - (b) (iv).

Pascal Compiler

Microsoft Office Suite

Window~XP

Select from the list above, ONE item that serves as an example for EACH ofthe following
software.

(i) System sofl1vare (1 mark)

(ii) Operating software (1 mark)

(Hi) General purpose software (1 mark)

(iv) Integrated software (1 mark)

(c) Explain why it is necessary to customize certain types of software and give ONE example
of customized software. (3 marks)

Total 10 marks

I GO ON TO THE NEXT PAGE

 -4-

4. (a) Name the THREE types of cabling shown in Figure I. (3 marks)

... ,.

A.~

B.
( (tIs D

c.
(_. ~

Figure 1

(b) Identity TWO types of wireless media. (2 marks)

(c) Write the types of network listed below in your answer booklet. Write the associated
application next to EACH network.

Network Application
A network connecting computers in a university
country
secondary campus
school

MAN
WAN
LAN(i)

(ii)

(iii)

(3 marks)

(d) (i) What is the meaning of the term 'modem'? (1 mark)

(ii) How was the term 'modem' derived? (1 mark)

Total 10 marks

GO ON TO THE NEXT PAGE

01229020/F 2012
 -5-

5. (a) The table below lists job titles of computer professionals and tasks. Write the job titles of
the computer professionals in your answer booklet. Write the task performed by EACH
professional next tothe correct job title.

Computer Professional Job Title Task

Installs
DevelopsWAPs
Identifies
Maintains
Replaces utilities
functional
schema drives requirements
programs
hard
Systems programmer
,Computer technician
1-

Network
Database administrator
administrator
Programmer
Systems analyst (i)

(ii)

(Hi)

(iv)

(v)

(vi)

(6 marks)

(b) The table below lists different types of technology and professions. Write the professions
in your answer booklet. Write the technology associated with EACH profession next to
the correct profession.

Profession Biometrics
MIDI
Multimedia
Sensors
Technology

Music
Law enforcement(i)
Training
Engineering

(ii)

(iii)

(iv)

(4 marks)

TotallO marks

I
I

GO ON TO THE NEXT PAGE

o 1229020/F 2012
 -6 -

6. In most national census exercises, data are collected and entered on forms by interviewers. Data
from the forms are then captured on tapes by data entry personnel. Finally, the data from the tapes
are merged into a single file.,.

(a) Identify ONE error that can occur during the data collection phase. (1 mark)

(b) Identify ONE error that can occur during the data capture phase and describe how this
type of error can be reduced. (2 marks)

.(c) Before the merged data can be used to generate reports it must be validated. State the
meaning of the term 'validation'. (1 mark)

(d) Name and describe THREE checks that can be used to validate the data. (6 marks)

Total 10 marks

GO ON TO THE NEXT PAGE

01229020/F 2012
J
-7-

SECTION II

PRODUCTIVITY TOOLS - 15 marks

Answer ALL q;uestions.

7. Students preparing for an international music examination must pass an internal assessment (IA)
component to be eligible to sit the final examination. The IA consists of one assignment worth
20 marks, one test worth 20 marks and one practical exercise worth 20 marks. To pass the IA,
students must obtain 60% or above out of a total of 60 marks. The marks earned by five students
for the IA are shown in the spreadsheet below.

. 15
11 ,
14 I Status
Practical
12
14
13
15 12
16,12
11
12
TotalIA
10
I I 15
%of
(20)(60) Test
(20)
Assi~ent
Harewood TotalIA I

(a) State the name ofthe student who will be at the top if the data in the spreadsheet are sorted
in descending order by the Total IA marks. (1 mark)

(b) Write the function in cell E4 to compute the Total IA marks obtained by Persaud.
(2 marks)

(c) If a student scores 60 % or above on the IA the student is given a status of' Eligible' while
for any mark below 60%, the student is given a status of 'Not Eligible'. State the function
that will be inserted in cell G6 to indicate the status of student Harewood. (3 marks)

(d) A pie chart was created to show the names of the students and the percentage scores they
obtained on the IA. State the data range used in the chart. (1 mark)

Total 7 marks

GO ON TO THE~ NEXT PAGE

;~
o 1229020/F 2012
 -8-

8. The TECHVOC unit ofthe Ministry of Labour uses a database with two tables to store information
on the number ofuncertified persons with technical skills in the various areas of the country. The
data in the two tables are shown below .
... ,.

TABLE 1: AREA

AREA
:;
In Corriverton
New
East
Anna Amsterdam
Coast
AREA_NAME
Supemaam
Regina
Georgetown
E1~
D2
E2
D1
B2
B1

TABLE 2: SKILL

Dl
SKILL . UNCERTIFIED
AREA
30
D260
B225
E245
E1100
D2120
B120
B125 ID

Mason
Welder
Mechanic
Carpenter

GO ON TO THE NEXT PAGE

o 1229020/F 2012
 i
I
. 1I'
r

-9 -

(a) List TWO data types used in the SKILL table. (2 marks)

(b) Write a query to show all areas with MORE THAN 50 uncertified masons and indicate
how many records would be in the output ofthe query. (3 marks)

(c) State the number ofuncertified persons in New Amsterdam. (1 mark)

(d) On which field is the SKILL table sorted? (1 mark)

(e) A report was generated for the SKILL table and the records were grouped by a field. State
the name of ONE appropriate field that can used to group the records. (1 mark)

Total 8 marks

::

Ii

GO ON TO THE NEXT PAGE

o 12290201F 2012
 - 10-

SECTION III

PROBLEM SOLVING AND PROGRAMMING - 45 marks

Answer ALL questions.

9. (a) Categorize the following pseudocode statements as input, processing, or output.

81 Accept
S2 . Add two numbers
S3 Calculate percentages
S4 Prompt the user
S5 Read a character
86 Write a resrnt (6 marks)
,
(b) (i) Copy and chmplete the following truth table where 1 represents 'Good at' and 0
represents 'Not good at'.

Homework
Homework AND
Homework I Studying AND Determination I Studying
Studying AND
Determination

(8 marks)

(ii) In the column for 'studying', explain what '0' represents. (1 mark)

Total 15 marks

GO ON TO THE NEXT PAGE

01 ??QO?O/F 2012
 - 11 -

10. Each Play Station III game has a tax of 10% added to its cost to calculate the final price. Write
Pascal code to

(a) declare the tax value (3 marks)

(b) declare TWO variables (3 marks)

(c) calculate the final price of a game. (4 marks)

Total 10 marks

11. (a) Rewrite the following fragment of code using the control structures below.

For count := 1 to 10 DO
Begip.
:;read (count) ;

End;

(i) While loop (4 marks)

(ii) Repeat Loop (4 marks)

(b) Complete the following two sentences by replacing the letters A, B, C, D and E with the
appropriate programming terms.

Shadwayne (A) the program to see if it was grammatically correct, meaning no

(B) errors, that it did what it was intended to do, meaning no (C) errors,
and that it produced some results, meaning no (D) errors. If there were errors,
he would then (E) the program to locate and correct these errors. (5 marks)

(c) THREE of the following statements describe external documentation. Identify them and
write the corresponding numbers in your answer booklet.

D 1: Includes frequently asked questions

D2: Makes it easier to read and understand the program

D3: States the version of the program and the installation procedure

D4: Suggests how users should use the program such as starting or exiting the program

D5: Use of indentation (2 marks)

Total 15 marks

GO ON TO THE NEXT PAGE

01229020/F 2012
 - 12-

12. Consider the following program in Pascal, and answer the questions that follow.

PROGRAMlRG;
VAR ALPH:ARRAY[1..3] of CHAR;
Let: CHAR;
Ine : INTEGER;

BEGIN
Ine:= 0;
Let:= 'G';

FORIne:= 1 TO 3 DO
ALPH [Ine] := Let;

FOR Ine :=1 to 3 DO

Wri~eln(ALPH [IneD;
END. 1

(a)

(b)
State the name of the program.

State the name of the array.

(1 mark)

(1 mark)
I
(c) State the size of the array. (1 mark)

(d) What is the output when the program is executed? (2 marks)

TotalS marks

END OF TEST

IF YOU FINISH BEFORE TIME IS CALLED, CHECK YOUR WORK ON THIS TEST.

01229020/F 2012