CXC CSEC Information Technology 2017 January P1

(1)

TEST CODE

OI229OLO

FORM

TP

2017013

JANUARY

20I7

CARIBBEAN

EXAMINATIONS

COUNCIL

CARIBBEAN

SECONDARY

EDUCATION

CERTIFICATE@

EXAMINATION

INFORMATION TECHNOLOGY

Paper

0l

_-

General

ProficiencY

1

ltour

30 minutes

READ THE

FOLLOWING

INSTRUCTIONS CAREFULLY.

l.

This test consists of 60 items. You

will

have

I

hour and 30 minutes to answer them. In addition to this test booklet, you should have an answer sheet.

Each item in this test has four suggested answers lettered (A), (B), (C),

(D).

Read each item you

are about to answer and decide which choice is best.

On your answer sheet, find the number which corresponds to your item and shade the space having the same letter as the answer you have chosen. Look at the sample item below.

Sample Item

Which of the

following

pairs represents general

purpose software tools? Sample Answer

(A)

Spreadsheet and database software

(B)

Word processor and accounting software

(C)

Student record system and database software

(D)

Insurance processing and spreadsheet software

2 3 4.

o

5 6

The best answer to this item is "spreadsheet and database sofiware", so

(A)

has been slraded.

If

you want to change youranswer, erase itcornpletely beFore you

fill

in your new clroice.

When you are told to begin, turn the page and work as qLrickly and as caref,ully as yoll can.

lf

you catlnot altswer an itern, go on to the next

one.

You tttay I'etLlnt to that iterir"later'.

l)O NO-t'1'UlfN-f

t-ttS

t'.\Glr. lii'.-f

1t.

\

(r{ iiil.

I'()i-l)'l'()

I)O

So

17

JANUARY

2017 (p.m.)

t ..,'.,,,1,,

'l _. -ri, 't..'.:

(2)

I

Resolution determines the

clarity

of

the

image displayed on

a

monitor. The term

'resolution' _{refers to the number}_of_pixels

(A)

that rnakes up the colour

(B)

aranged vertically on the screen

(C)

aranged lrorizontally on the screen

(D)

arranged in a unit area of the screen

Which of the following operations displays results?

Which

of

the following

devices

is

an

example of a manual input device? 6 r0

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) (A) (B)

(c)

(D)

7 Which part

of

the central processing unit

(CPU) coordinates its activities? Touchscreen monitor Barcode reader Speaker Plotter Register Control unit Main memory

Arithmetic logic unit

tirne-sharing multiprocessing batch processing real time processing

2 (A) (B)

(c)

(D) (A) (B)

(c)

(D) Input Output Storage Processing

Of the storage devices listed below, which group does NOT use laser technology?

(A)

CD, DVD, flash drive

(B)

CD, floppy disk, flash drive

(C)

Hard disk, floppy

disk,

magnetic

tape

(D)

Magnetic tape, flash memory card,

DVD

A

set

of

data that

is

waiting

to

be either

processed or output, is stored in a temporary

block of memory called a

The processing rnode that allows one CPU

to run many applications at the same time

is called

8 3

9 Which of the following types

of

technology is commonly used by banks

to read data on cheques?

4

(A)

track

(B)

sector

(C)

buffer

(D)

cylinder

(A)

POS

(B)

OCR

(c)

oMR

(D)

MrCR

5 Which of the following processing modes

is used for processing

utility

bills?

A

socket which is provided in a conrputer

to allow foradditionalcornponents is known

AS Real tirne Multitasking Tirne sltaring Batclt processing

(A)

(B)

(c)

(D) a 6re wire a systern bus

arr expanS.!orr cald

(3)

3

11. CabledtransmissionmediadoNOTinclude

15. The i I legal copying and sel ling ofprograms

is referred to as

t2

t4

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

t6

17. 18 19.

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) Open Print Edit Cut copy Rename

13.

The diagram above represents a

Which of the following is NOT a physical

access restriction? coaxial fibre optics satellite twisted pair Encryption Security guard Biometric system

Fire and water-proof cabinet

button window pop-up menu pull-down menu

Tl

lirre Networl< Dial-Lrp

Digital subscriber line (DSI.1

Which of the

following

is TRUE about an

intranet?

propaganda

software piracy

computer fraud

industrial espionage

Offers unlimited access

Allows access to suppliers

Allows access to employees

Offers limited access to employees and suppliers

Item 13 refers to the following diagram

[.ILE An electronic point of _{may most}_{likely NOT}sale (EPOS) system_be_found_in

(A)

an office

(B)

a pharmacy

(C)

a supermarket

(D)

an appliance store

A

type

of

utility

program used to remove application programs is

(A)

a file compression program

(B)

a troubleshooting program

(C)

an antivirus program

(D)

an uninstall program

What is the decimal equ ivalent forthe bi nary

number

l0l

?

(A)

(B)

(c)

(D)

Which

of

the followirrg

provides

the

SLOWEST Internet access?

2 4

5

8

(4)

20.

2t

22 24

(A)

(B)

(c)

(D)

Working from home and linking to the office computer system to submit work is

described as

25.

Records on magnetic tape are stored

(A)

(B)

(c)

(D) indexed sequentially sequentially randomly directly teleconferencing telecommuting telemarketing teleworking

Which device

is

essential

for

computer-controlled

systems

to

function with

precision in an assembly line?

(A)

Microphone

(B)

Speaker

(C)

Camera

(D)

Sensor

Which

of

the following checks

is

a

data

verification method?

What is the

function

of

a

network

of

computers?

(A)

Organizes data among computers

(B)

Receives data from one computer

(C)

Allows users to obtain data from a

central computer

(D)

Enables two or more computers to

communicate

Item

27

refers

to

the

following types

of

memory. 26. 27 28 I. II III

23. l0l

l00l

is an example

of

(A)

(B)

(c)

(D) (A) (B)

(c)

(D)

(A)

(B)

(c)

(D) Visual Range Length Parity raw data sorted data information secondary data Input Output Storage Processing

Which of the above types of memory are

non-volatile?

I and

Il

only

I and

III

only

II and

III

only

I,

Il

and

lll

Which access method is used

to

retrieve

data from a flash drive? ROM RAM EPROM Direct Serial SeqLrential lndexed sequential

(A)

(B)

(c)

(D)

Which of the following functions performs calculations in a cornputer?

(A)

(B)

(c)

(D) l.

(5)

5 29 30 31

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) 32 33 36. (A) (B)

(c)

(D)

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

Which type

of

interface allows the user to communicate with the computer system by

keying in instructions?

(A)

Menu driven

(B)

Graphical user

(C)

Command driven

(D)

Touch sensitive

Which ofthe following is/are advantage(s)

of

information processing?

I.

Retraining of staff

II.

Reducing human intervention

III.

Increasing the amount

of

equipment needed

The MOST appropriate data type for storing the amount

of

interest earned on a sum

of

money is

Item 31 refers to the following algorithm.

<_

x*y

<-

x-z

z

<-

x+y+z

display

x,y,z

What

will

be displayed when the algorithm

is executed?

34 In Pascal language, which ofthe

following

is an acceptable variable name?

(A)

real

(B)

#sum

(C)

9_num

(D)

dateofbirth

35.

What does the symbol represent in information technology? real char string integer Let

Marks:

[8]

Array:

Marks(8);

Var Marks: Array

[

..8] of integer;

Dim Marks (8) as integer

StarUStop Decision Input Process

It

is precise.

It

is unambiguous.

It has a finite number of steps.

It

is a graphical representatiorr ofl

the soltrtiolrr.

I

Which Pascal format is used to declare an array?

I only

II

only I and

II

only

II

and

III

only

v x v Z x v <_

(-<_ <_ 5 v

l0

3

Which

of

the

following

is

NOT

a

characteristic of a pseudocode? 5,10,3 15,12,3 15,12,20 I 5, 12, 30 ! t;,.1'. t-r-- _r-..

(6)

37.

The purpose

of

inserting comments

with

program code is to

(A)

allow the user to input data

(B)

provide an explanation of the program

(C)

ensure that the program compiles completely

(D)

provide information on special features of the program Items 38-39 refer to the following fragment of Pascal code.

Forx:=

2 TO 15 DO

Begin

Write("Enter the name of a

country:

");

Read (Country)

End;

38.

How many times

will

the program above be executed?

(A)

2

(B)

t4

(c)

rs

(D)

16

39 Which fragment of code would be the CORRECT option to output tlre prompt and enter the narne

of

the country on two lines?

(A)

Read ("Enter the name of a

country:

");

Write Country

(B)

Write

("Enter the name of a

country:

");

Read Country

(c)

Readln ("Enter the name of a

country: ")

Readln(Country);

(D) Writeln ("Enter the name of a

country: ");

Readln(Country);

(7)

7

Item 40 refers to the following atgorithrn

.

44.

Machine language is categorized as a

40.

Which Iine contains a processing

statement?

45.

Program testing can be described as

Write ("Enter

price:

")

(I )

Read

(price)

(2)

Vat = price

*

ls%o

(3)

Write

vat

(4)

(A)

(B)

(c)

(D)

4l-

A trace table is used

for

testing arr algorithrn declaring an array

coding arr algorithm

representi ng an algorithm

(A)

(B)

(c)

(D)

test the solution

define the problem

evaluate the solution to the pr oblern

develop the algorithm

for

the problem

III

Compiling

to

create

the

object

code

Creating the source code

Executirrg to test for accuracY

(A)

first generation language

(B)

second generation language

(C)

third generation language

(D)

fourtlr generation language

42.

The FIRST step in solving a problem is

to

46 Extracti ng i nformation from a database can

be achieved through the use

of

checking that all documentation is

included in the program

executing

the

program manually

with input values to see the results

running the program using sample

data

to

identify

errors

in

the

program I and

II

only I and

Ill

only

Il

and

III

only

I,

II

and

lll

files objects queries reports record table field file Red addl:essing Relative aclclressing [jorrrr r-r la aclcl ress i n g

\bst, Itite lLilclrcs;irt t: I 2 3 4 (A) (B)

(c)

(D) II

III

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) (A) (B)

(c)

(D) (A) (B)

(c)

(tr1

Item 43 refers to the following inforrnation about programming.

47.

A single row of data irr a database is called a

What is the correct sequence for the above

steps irr the developtrrent oFa progranl?

$A$3

is

an

exanrple

of

what

type of

addressing mecltan ism?

(A) (B)

(c)

iD)

ll

and

lll

and lt . I ancl

lll

i. ll:rir.i

I f

iiii;

L;,. _.', 43 48 II

(8)

49.

Item 49 refers to the following

spreadsheet.

50

5l

To add the values

17,35,45

and 39 in the

spreadsheet table above,

which

function should be placed in cell 86?

(A)

:SUM(B2:B5)

(B)

:SUM(82:86)

(C)

:ADD(B2:B5)

(D)

:COUNT(B2:86)

Which of the following actions is required

for creating a chart in a spreadsheet?

(A)

Print the data

(B)

Select the paper size

(C)

Select the data

(D)

Select the orientation

The

default alignment

for

numbers in

spreadsheet is

(A)

left

(B)

right

(C)

centre

(D)

justified *!f.iHq ffidgi &;tiir;=!i f.E:l,rlGll rfl-{rjt:

ffi

,:.1$-t i+t;_1

ffiffi

t7

35 45 39 .,:,1.:.:,,

_f,:

_. : Bonus Points

First Name Surname

Mark

I

Kingsley CIarke 69 No

John Henry 69 Yes

Zara Smith 7l Yes

9l

No

Sean Smith

52

Item 52 refers to the following spreadsheet

The spreadsheet has beerr sorted by a prirnary field and tlten a secondary

field.

What are the primary

and secorrdary fields respectively?

(A)

(B)

(c)

(D)

Surname, Mark I

First Name, Surnarne

Mark

l,

Bonus Points

Bonus Points, First Narne

(9)

9

Item 53 refers to the

following

spreadsheet.

A

B

c

D

!''

,,,? _VAT lSYo

Items Cost Price VAT Total

Washer 4300

'$, Dryer r 500

:.'n-1.. Stove 2750

53.

What formula should be inserted into C5 to calculate the VAT for the washer?

(A)

(B)

(c)

(D)

:

(58*2B)

:

(85*$B$2)

:

(5B*$B$2)

:

(85*82l100)

54 55 (A) (B)

(c)

(D) (A) (B)

(c)

(D) 50. 57

(A)

(B)

(c)

(D)

Which of tlre following features allows the

user to insem individual names in a primary

document?

In order to perform a block operation in a

word processing application; the required text must first be

A

website consists

of

a set

of

web pages

that are linked together with

I

need

to

search

a

SO-page document

for

the acronym

IT

and insert the words

'lnforrnation

Technology'

in

its

place.

Which

of

the following

is

the

MOST

efficierrt rnethod

for

accomplishing this

task?

cut copied aligned

selected

Find and replace option

lnsert key lourrd on the keyboard Scan

tlre

document ancl quickly

rnake the necessary clranges

Cut eaclr <.rikirr",r"" of, [T ancl therr

t1,'pc irr I rrfblrnation 1 echrrology

Footer Header

Mail

merge

Search and replace

hyperlinks Bluetooth HTTP HTML

(A)

(B)

(c)

i'r., t. l,i.f ' (D) I 3 4 )

(10)

58. Which of the following must be considered

when creating a website?

Which of the

following

PowerPoint Presentation icons represents the slide

sorter? 60 II.

III.

(A) (B)

(c)

(D)

(A)

(B)

(c)

(D)

The intended audience

The

artistic design

of

the

whole

website

The

layout

of

the

pages

in

the website

I and II only I and

III

only

Il

and

III

only I, II and

III

Modem Monitor Hypertext Hyperlink (A) (B)

(c)

(D)

tr

EE]

trlE

59 Which

of

the

following

is normally used

for website-to-website connections?

END OF TEST

TF

YOU FINISH

BEFORE

TIME

IS

CALLED,

CHECK

YOUR

WORK

ON

THIS

TEST.