I- qto TEST CODE OI229O2O -l

FORM TP 2018014 JANUARY 2OI8

CARIBBEAN EXAMINATIONS COUNCIL

CARIBBEAN SECONDARY EDUCATION CERTIFICATE@
EXAMINATION

INF'ORIVIATIONTECHNOLOGY

Paper 02 - General ProficiencY

2 hours 15 minutes

READ THE FOLLOWING INSTRUCTIONS CAREFULLY.

questions'AnswerALL
1. This paper consists of THREE sections and TWELVE
questions.
this booklet.
2. Write your answers in the spaces provided in

3. Do NOT write in the mdrgins.

4. Code is to be written in Pascal-

space to do so on-
tf you need to rewrite any answer and there is not enough the
5. provided at the back of
original page, you must use the extra lined page(s)
your original answer'
this booklet. iemember to draw a line through
question number clearly
6 If you use the extra page(s) you MUST write the inine box provided
where relevant, answer'
at the top of the extra page(s) and, include the question part beside the

DoNoTTURNTHISPAGEUNTILYoUAREToLDToDoSo.
Council
Copyright O 2Ol7 Caribbean Examinations

J
All rights reserved.

L }L2290201JANUARY 2018
lllllll llu llffi llllllllll lllllilll llillllll lffi lil llll

0122902003

ffii
 r -4- -l
SECTION I

THEORY-60 marks

AnswerALL questions.

1. (a) State whether EACH of the following devices is an input or output devices.

Plotter..

Joystick

ocR....

Printer

Speaker......

Microphone
(6 marks)
state oNE
(b) device which could be used for EACH of the following activities:

(i) Participants
in an online meeting sharing video to see each other

(ii) A bank teller processing cheques

A cashier
(iii) checking out items being purchased in a supermarket

(iv) Electronic marking of l0 000 multiple choice sheets

(4 marks)

Total 10 marks

GO ON TO THE NEXT PAGE

01229020/JANUARY 2018

L rffiffiffiffiffiililffiffiililffitiltfi
0122902004
J
 r 5 -l
2. (a) Sharon is output
at a workshop and decides to join a teleconference with her staff. Which audio
device
would you recommend that she use? Give a reason for your recommendation.
Audio output device

Reason

(2 marks)

(b) For EACH of the following, suggest ONE scenario (and provide a reason), in which it
would be more suitable to use

(D a dot matrix as opposed to a laser printer

(2 marks)

(iD a plotter as opposed to a printer

(2 marks)

GO ON TO THE NEXT PAGE

01229020/JANUARY 2018

L r rflil ililr illt ll]t rilr

0122902005
llil[]ll il]t uil ilt ililrl

-J
Effi
r -6-
_|

(USB) drive
(iiD a magnetic tape as opposed to a flash

(2 marks)

(iv) a joystick as opposed to a mouse

(2 marks)

Total 10 marks

GO ON TO THE NEXT PAGE

0L229020/JANUARY 2018

L I ll]il lillm[ffi lilll l]ll lffi H[ ffil l]ll ffi llll

0'122902006
J
r -7 - -|

3. (a) Convert 4Zroto base two

(3 marks)

(b) Determine the decimal equivalent of 1001r.

(2 marks)

(BCD)
(c) Write a representation for the positive sign of a binary-coded decimal

(1 mark)

GO ON TO THE NEXT PAGE

0t229020lIANUARY 2018

L I ffilllllll llil llll lllll llllllffi lllllllllllllllffi llll

0122902007
I
ffi

r (d) If the ASCII equivalent

-8-

of the letter P is 1010000, determine the ASCII

-l
equivalent for the
letter U.

(4 marks)

Total l0 marks

0I229020{IANUARY 2018

L GO ON TO THE NEXT PAGE

I il]fl ffit Hh ffi lfll lllll llll lHl llil lll lil llll

0122902008
J
 t- -9- -l
4. (a) At Magnet Defence Systems Ltd there is a 24-hour production system in place. Timely
reports must be constantly produced and sent to the engineers for immediate action. A
decision must be made on the choice of processing modes to be used: batch, real-time or
time-sharing.

(D Explain which processing mode is MOST suitable for the production of the reports.

(2 marks)

in (a)
(ii) Describe TWO situations in which one mode, other than the one explained (i),
would be MOST suitable.

(2 marks)

GO ON TO THE NEXT PAGE

0I2290201JANUARY 2018

L I ffiil illllllllllil llllllllll lllll lllll lllll lllllllllllll

0122902009
J
ffi
r -10- -1
follow
(b) Study the laptop specifications below and answer the questions which

Windows l0 Home 64

rM
Intel@ Core i7-6560U Processor
x1440)
Beautiful 33.8 cm (13.3')Diagonal Quad-HD OLED (2560 Touchscreen display

8 GB RAM and 512 GB PCIe@ SSD Storage

500 GB SATA Hard Drive 720 RPM

Intel@ IRISTM Graphics; Audio by Bang & Olufsen

True Vision Full-HD Webcam

Cortana Optimized Microphone; QWERTY Keyboard

State

(D the primary memory capacity

(ii) the type of hard drive

(iii) the operating system

(iv) the hardware interface

(v) TWO input devices.

(6 marks)

Total 10 marks

GO ON TO THE NEXT PAGE

J
0L229020/IANUARY 2018
L
r ililfl ill fiffi ilfi illfi ffi ffi fiff lll] |ilil llll llll
0122902010
 r - 11- -l
s. (a) The following is a list of terms associated with the use of computer systems to facilitate
a variety of secondary storage media and devices.

Broadcast, Comp uter fraud, Extranet, Half-duplex, S implex, Intranet, propaganda,

Wifi , Point-to-point, Software piracy

Select the appropriate term from the list to match EACH of the following situations

(i) High-speed wireless access to a network or the Internet

(iD Direct line between two computers

(iii) Data can travel in two directions but only one way at a time

(iv) A private network that belongs to an organization

(v) Unauthorized distribution of computer programs

(vD Use of computer systems to distribute information

(6 marks)

GO ON TO THE NEXT PAGE

0t229020tJANUARY 2018

L ilililfl]] ilIll il]ililil]lilill illil l]|ilffi ilil til

0122902011 _l
ffii
r -12- -l
devices
(b) State ONE advantage and ONE disadvantage of using EACH of the following
(i) DVD

Advantage

Disadvantage

(ii) Extemal hard drive

Advantage

Disadvantage

(4 marks)

Total 10 marks

GO ON TO THE NEXT PAGE

0l229020iJANUARY 2018

L I lllil fit flm Hil ffil lffi ffi Iflfl llll lllil lil llll

0122902012
J
 r
6. (a)
-13-
The DIGITS company collects personal data from customers which it stores in filing
-l
cabinets or on computers.

(i) State TWO possible effects of improper storage of data.

(2 marks)

(ii) For EACH of the following storage locations, state TWO measures that can be used
to protect the data:

Filing cabinets .....

Computer systems

(4 marks)
be applied to
(b)
the
Outline when EACH of the following procedures would MOST likely
company'sdata:

Recovery

(2 marks)

Archiving

(1 mark)

Backing up

(1 mark)

Total 10 marks
GO ON TO THE NEXT PAGE
01229020/JANUARY 2018

L
iltil[]llllllluHllililffi ll$lffilllruilillfil

0122902013
J
ffi
 r -14- -l
SECTION II

PRODUCTMTY TOOLS - 15 marks

AnswerALL questions.

7, The
following is an excerpt from an advisory that was sent out to shoppers warning them
of the dangers of shopping online during the Christmas season.

CARCIRT-Ad-20!7 .002v 1 (ALL)

First Refease: November 1, 2otj

ADvrsoRY
lcHRrsxrras] carilcbean crRT christnas Advisory

Important information from CARIBBE,NiI CIRT

1/11/2017 72:40 PM EST
major
The chrj-stmas season is one of the times of the year for
popurar
shopping- online shopping is becoming increasingly and we
all
are being bombarded with offers of types - onri-ne shopping is
great but shoppers are encouraged to take certain precautions
especiarly when using their credit cards.

State TWO
(a) (i) text formatting features, other than bold and underline, used in the
document.

(1 mark)

(ii) justification
State the line used in the first two lines of the document.

(1 mark)
(iiD What word processing
feature will allow the first two lines of this
advisory to be repeated on every page of the document?

(1 mark)

GO ON TO THE NEXT PAGE

01229020/IANUARY 2018

L I ffiflillil ilil ilffi luililfl!ililil[il fl!il ]]

0122902014
llll
J
 r -15- -l
(b) The committee wants to personalize the advisory for distribution to its workers without
having to type each worker'sname into the advisory.

(i) Name the word processing feature that is MOST suitable to achieve this.

(1 mark)

(iD List THREE fields that should be inserted into the advisory

(3 marks)

(iii) Insert the THREE fields listed in (b) (ii) on the advisory on page 14.
(1 mark)

Total S marks

GO ON TO THE NEXT PAGE

01229020/JANUARY 2018

L I lllill u] ilil llffi til[ llll[]ll ltfl ilil ilfl ]ll tilt

0122902015 -J
Etr
r -16- -l
8. The director of Emrock is creating a budget for the company'ssmall response division, and produces the
following spreadsheet which has been sorted.

r,,l :::-.1.i.r:. :

. .:,i.r: ...r,,1,g1i.!''.,]..1r,

Items Quantity Cost per Item Total Cost

.,.,? Digital Forensic Tool Kit I 3000
Write Blocker Kit 2 1699
.'.1..i
4 Mac Desktop 1 1 100

Desktop Workstation 4 900

Wireless Router 2 500

Computer Screens 27'and34' 4 400

Response Field Kit 2 300

(a) Write the formulato be inserted into cell D2 to calculate the total cost ofthe digital forensic
tool kit.

(3 marks)

(b) Outline how to insert the formula in (a) into cell D3 to D8 in order to calculate the totals of
the remaining items without retyping the formula.

(2 marks)

(c) State

(i) the field that was used to sort the spreadsheet

(ii) the order used to sort the field.

(2 marks)

TotalT marks

GO ON TO THE NEXT PAGE

0L229020/JANUARY 2018

L I ffi lt uil ll]t ilil lill illt ilfl tilt il] lilt til ilt

0122902016
I
r -17 -
 SECTION III

PROBLEM-SOLVING AI\D PROGRAMMING - 45 marks -l

AnswerALL questions.

9. Consider the following algorithm

INPUT WEIGHT, YEAR

:
IF (WEIGHT < 180.0) AND (YEAR 1990)
THEN PRINT "PERFECT"
ELSE PRINT "NOT FIT"
ENDIF

(a) (D Explain the purpose of the program

(ii) State the data type of the variable WEIGHT.

(2 marks)

(1 mark)

the pseudocode.
(b State TWO examples of data that would NOT be suitable to test
)
Example 1

Example 2 ....................
(2 marks)

algorithms.
Complete the following trace table to show the output from the nvo
(c rF (wErGrTI< 180) AI\D rF(wErGHT< 180) OR
) WEIGIIT YEAR (YEAR= 1990) (YEAR= 1990)
*PERFECT"
TITEN PRINT THEN PRINT "PERFECT'
150 r990
130 1998
180 1990
200 1998
marks)

Total 10 marks
GO ON TO THE NEXT PAGE
0L2290201JANUARY 2018

L r mil Iilr Hllffi lffi ffi lHl lffi l$l fl|il ilfi llll

0122902017
J
ffitr

l- - 18 -
-l
10. Consider the following pseudocode for a program.

Initialize count to zero

Initialize temp to zero
While temp is not equal to -l
Input temp
Output'tempaccepted'
If (temp: -l) then
Output'Endof test'
Else add I to count
Output'Exit'

In the space on page 19, draw a flow chart for the program

GO ON TO THE NEXT PAGE

01229020/IANUARY 2018

L I llllll llil il]ilffi iltr ilil ilIt flfl ilililflt ilil ilt

0122902018
J
 r -t9- -l

(15 marks)

Total 15 marks

GO ON TO THE NEXT PAGE

01229020/JANUARY 2018

L I llffi ffi m[ il]l lltr illll l]ll lllll lffil lill ffi llll

0122902019
I
ffih
r -20 - -l
the number
11. Consider the following one-dimensional array named CLASS which is used to store of
students in Class 1 to Class 4.

Class 45 54 63 76

Index I 2 J 4

(a) State

O the number of children in Class t

(ii) the class that has 54 children

(2 marks)

(b) Write Pascal code for EACH of the following:

(i) lnput the number 63 into Class 3.

(4 marks)

(ii) Add the number of

children in the four classes and store the total in a variable
named TOTAL.

(4 marks)

Total l0 marks
GO ON TO THE NEXT PAGE
01229020lJANUARY 2018

L l ll]il illlilill tilt il]t llilt ill! illlt illt ll]l illt llll

0122902020
I
 r -2t - -l
12. Each of the following programming statements in the table below is incorrect. Rewrite EACH
statement using correct Pascal code.

Statement
Incorrect Programming Statement Correct Programming

(D Cost: array 1, 8 of real;

(ii) While (Week < 5) Week:Week+1;

(iii) Const
]NTEREST < 252;

(iv) Repeat
Print Ans;
Ans:Ans+1;
:
UntiL Ans 4 or 5;

(10 marks)

Total 10 marks

END OF TEST
WORK ON THIS TEST.
IF YOU FINISH BEFORE TIME IS CALLED, CIIECK YOUR

2018
0L229020/JANUARY

L r rilill ffi ffi llffi lfitffi ffi lllll lllll il] ffi llll

o122902021
J
Effi