CXC CSEC Information Technology 2016 June P1

(1)

FORM

TP

2016083

MAY/JUNE 2016

CARIBBEAN

EXAMINATIONS

COUNCIL

CARIBBEAII

SECOI\IDARY

EDUCATION

CERTIFICATE@

EXA]VIINATION

.

INFORMATIONTECHNOLOGY

Paper

01

_-

General ProficiencY

7 hour 30 minutes

READ THE F'OLLOWING INSTRUCTIONS CAREFULLY.

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, flnd 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?

(A)

Spreadsheet and database

software

Sample Answer

(B)

Word processor and accounting sofbware

(C)

Student record system ana aataUase

.ot*ur"

O @

@

(D)

Insurance processing and spreadsheet software

The best answer to this item is "spreadsheet and database software", so (A) has been shaded'

5

If

you want to change your answer, erase

it

completely before you

fill

in your new choice.

When you are told to begin, tum the page and work as quickly and as carefully as you can.

If

you cannot answer an item, go on to the next one. You may return to that item later.

DO NOT TURN THIS

PAGE

UNTIL YOU ARE TOLD

TO DO

SO.

1 2 3 4

I

6. 31

MAY

2016 (p.m.) I I

-I

-I I

Copyright @ 2Ol4 Caribbean Examinations Council

All

rights reserved.

(2)

1.

Keyboards, speakers and CD drives

are

6.

(A)

peripheral devices

(B)

storage devices

(C)

output devices

(D)

input devices

2.

Scanning

an item

at a

computerized

checkout station

in

a

supermarket

is

an

example

of

What

type

of

management

occurs

when

the

operating system undertakes communication between a printer and the

system unit?

(A)

File

(B)

Process

(C)

Memory

(D)

InpuVoutput

Which ofthe following has the largest data

storage capacity?

(A)

Optical drive.

(B)

USB flash dnve

(C)

Flash memory card

(D)

Hard drive

Which

of

the

following

primary storage

devices can be programmed only once?

(A)

RAM

(B)

PRoM

(c)

EPROM

(D)

EEPROM

The time taken by the read/write head to locate and transfer data is termed

7 11

t2

l3

t4

15. 3

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

The Arithmetic/Logic

Unit

(ALLD is part

of the

input

output storing processing

Control Unit (CI-D

Read Only Memory (ROM)

Central Processing

Unit

(CpU)

Random Access Memory

_GAM)

8. 4.

(A)

(B)

(c)

(D) 5. 1002 1012 1102 1112 Plotter Laser printer Dot-matrix printer

Thermal transfer printer

The _{binary equivalent ofthe decimal}_number

7is

9

Which of the following is MOST suitqble for printing building plant?

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) seek time access time transfer time rotational time

RAM

ROM PALU PROM

10. To use a prograrn stored on a flash drive,

it

must be transferred into

(A)

(B)

(c)

(D)

(3)

li

I I'

LI

Adiskette is dividedinto anumber ofconcentric circles called

tracks

sectors

clusters cylinders

Which ofthe following user interfaces/devices

is BEST suited for avisually impairedperson?

Touchscreen Menu driven Braille keyboard Command driven

13.

Laser beam technology is used by a

In

the URL

http://www.shoes.com,

'shoes.com' represents the

11.

t2

14. 15.

(A)

(B)

(c)

(D) 16. 17. 18. 19 20.

(A)

(B)

(c)

(D) (A) (B)

(c)

(D)

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

Which of the following prefixes which relate to bytes are alTanged from the smallest to the

largest?

(A)

Mega, giga, tera,

kilo

(B)

M"gq

tera, giga,

kilo

(C)

Kilo,

mega, giga,tera

(D)

Kilo,

giga, mega, tera

Which of the following provides transmission

of data in BOTH directions at the same time?

(A)

Half Duplex

(B)

Full Duplex

(C)

Null

Duplex

(D)

Simplex

Transferring data from a remote computer to your computer is referred to as

(A)

uploading

(B)

browsing

(C)

downloading

(D)

data mining

Scrambling ofmessages before sending is called internet company company name domain name extension expert systems virtual systems engineering systems knowledge systems teleconferencing telecommuting telemarketing telephony coding encryption espionage eavesdropping

Programs

that

duplicate

the

knowledge

and diagnostic skills displayed by humans

performing specialized tasks are referred to as

floppy disk

optical disk magnetic disk

magnetic tape

The use of Inforrnation and Communications Technology (ICT) to conduct meetings at

different locations is called

(A)

(B)

(c)

(D) :ll, ' ": .'

(A)

(B)

(c)

(D)

2Arc

(4)

21.

Telecommuting can be BEST described

as

25. using the computer while commuting

using the telephone while commuting

working

from

home

by

connecting

home and offi.ce

working

from the office

after

establishing a connection at home

26

A

webmaster

is

important

to

the company

because he/she

Which of the following is detected by the

use of a pressure sensor?

(A)

Motion

(B)

Light

(C)

Weight

(D)

Warrnth

The illegal copying, distribution or sale

of

proprietary software is known as

(A)

computer fraud

(B)

computer theft

(C)

software fraud

(D)

software pimcy

In

an

algorithm,

item_price

is

a

variable used to store the price of a grocdry

item.

The

MOST

appropriate data type

usedfor

item_price

is real

integer boolean character

Which ofthe following types ofdocuments

is

used

for

the

initial

recording

of

data

relating to business transactions?

(A)

(B)

(c)

(D) _.) . 'iil ,.t .j :i. 22.

(A)

(B)

(c)

(D)

backs up files and stores the disks at another location

monitors

the

shutting

down

of

competitors' websites

assigns web addresses to all users

in

a comp:rny

is

responsible

for

the

company's website

23.

Any

unauthorized person is allowed to view

another person's name by merely providing a

phone number to a service representative at a

telephone company. This is an example

of

(A)

propaganda

(B)

eavesdropping

(C)

computer fraud

(D)

violation of privacy

Which

of

the

following

checks

is NOT

a

validation technique? Main Source Primary Tumaround Floppy disk Compact disk Magnetic tape Winchester disk 27 28.

(A)

(B)

(c)

(D) 24. 29

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) t

(A)

(B)

(c)

(D) Range Double entry Inconsistency Reasonableness

Which

of

the

following

is

a

sequential

access medium?

0t229010tF 2016

GO ON TO

TIIE

(

j.i. ill . &::, * i,. ',} ir,-, ?.t:. i,: 1..: li iirr' ;i. I, i. ls. :1: '-'l':ir.r ; l,'r. ,: lf.t . iii*l ,-ri ,[ir;:,{} ttrr'll ffiffiff $:rl;t ffi,;',* $,i:4

(5)

f the rle

of

Isa

ocery 'type ments

i

data ential 30.

(A)

Budgeting

(B)

Invoice processing

(C)

Payroll Processing

(D)

Forecasting hurricanes

31.

In computing, 'word wtap'refers to

Which ofthe following is NOT an example

of commercial data processing?

While entering text

in

a word processing document, Michelle noticed that each new

letter entered was replacing the previous

one. The mode activated in this case is

35.

placing text around a graPhic placing text at the back of a graphic

the automatic carrying forward

of

text once the current line is

filled

the user having to manuallY Place

the cursor on a new

line

when

the previous one is

filled

36.

A thumbnail image on a webpage is used

to

represent

a

smaller version

of

a

larger image

provide a link to the other contents

emphasize text and images

type over word wrap delete insert

I

only

III

only

I

and

II

only

II

and

III

only

Superscript

Hishlisht

Subscript Italics Database Spreadsheet Word processing Operating system (A) (B)

(c)

(D)

(A)

(B)

(c)

(D) I.

II. Itr.

32

Which

word

processing feature MUST

John

use

if

he wants

to

include

his

company's logo

in

the bottom margin

of

every page of a document?

Header Footer Endnote Footnote

While typing

a

document

it

maY be necessary

to

change

the height

of

the

characters. Which word processing feature should be used?

You have typed the characters '3'd'. Which ofthe following forrnatting features should be used to create

_'d'?

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) 37 38.

(A)

(B)

(c)

(D) 33

(A)

(B)

(c)

(D) Letter size Paper siZe Page size Font size i

Which of the following types

of

software shouldbe used for applications that involve

repetitive numerical calculations?

3.1.

(A)

(B)

(c)

(D)

When text is aligned with both the left and right margins atthe same time, this is called

(A)

left and right alignment

(B)

right and Ieft alignment

(C)

justified alignment

(D)

centre alignment

TGE

nt r:ronl

0E

)n1 6

(6)

6

39.

In what form is data stored in a

database?

42

Table Chart Numeric

String

40.

In

creating a query, a student entered the

following criteria for the date field.

>

:

051 11/201

I

and <

:

05ll4l20ll

The output

will

show days

after

l4th

May 2011 only

between 1lth and

l4th

May 2011

before 1 1 th Mayand after l4th May

20lr

between

the

14th

May

and

5th November 2011

43 Which of the following MUST be placed in

front ofthe colurnn letter and row numberto

create an absolute reference?

(A)

(B)

(c)

(D)

44

You

need

to

enter

the text

"WEEKLY

REPORT" to appear

in

the middle

of

the space used

by

the

five

columns below.

Which

of

the following

spreadsheet commands

will

enable this to be done?

(A) (B)

(c)

(D)

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

Centre the text Indent the cells Merge and centre Merge the columns

4t

Which

of

the

following

can be used

in

a

spreadsheet to copy the same number across

multiple rows in a single column?

Fill

handle

Cursor Label

Cell

In

a

spreadsheet,

the

column

titles

will

always

be

visible

when

you scroll

the

spreadsheet

ifyou

first

freeze the top row lock the last column lock the spreadsheet

fueeze the first column

*

+ $

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D) WEEKLY REPORT January 1,245 February 1,450 March 2,550

(7)

(

t

s

u

€

45

Which

of

the following

is

the

correct sequence

of

steps

to

delete

a

fleld

in

a

database table?

(A)

Choose the delete row option.

Select row to be deleted and right click.

Open table in design view.

Choose yes to confirm deletion.

(B)

Select row to be deleted and right click.

Choose yes to confirrn deletion.

(C)

Select row to be deleted and right

click.

Choose yes to confirm deletion.

(D) Select row to be deleted and right click.

Open table in design

view

Choose yes to confirrr deletion.

46.

Consider the following algorithm.

a:7

b:9

a:b-a

b:a+b

Write a, b

47, Which of the following flowchart

qmbols

represents a process?

(A)

(c)

(D)

48.

Program debugging should be performed

(A)

during the designphase

(B)

during the testing phase

(C)

before compiling the program

(D)

before identifuing any test data

49

In

representing algorithms,

which

of

the

following

statements would be placed in

the flowchart box shown below?

A>25

ReadA

Output C

Count

<-

count

*

1

50 Data that cannot be changed during the execution of the program are called

(B)

(A)

(B)

(c)

(D)

The output of this'algorithm is

(A)

2,9

(B)

2,11.

(c)

7,9

(D)

7,

tt

(A)

(B)

(c)

(D) variables constants characters

stings

012290r0tF 2016

(8)

51

52

53.

Which

of

the

following

tasks does the algorithm below perform?

Read

(A,

B)

IfA<B

Then

Print(A);

The terms

"END"

and "STOP"

used

in

algorithms are called

55.

(A)

(B)

(c)

(D) loops outputs processes terminators

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

(A)

(B)

(c)

(D)

The type ofprogramminglanguage inwhich

instructions are written using abbreviated forms of words is known as

Reads two numbers and prints the

fust number

Reads two numbers and prints the smaller number

first

number

if

it

is

larger than the second number

first number

if

it

is smaller than the second number

assembly language machine language high level language machine code Numeric Real Number Letter Grammar Run time Syntax Logic

56.

The LAST step in creating a program is to

(A)

evaluate the solutions

(B)

test the solution

(C)

develop the algorithm

(D)

speciff the design

Item 57 refers to the following code.

sum:0

count:

?

While count

<

10 do

count:

count

*

1

Read num

suln:

sum

*

num endwhile

Printsum

57

If

the While loop is to be executed 10 times,

what should be the

initial

value stored in

count?

Which

of

the

following

is a

valid

Pascal

datatype?

(A)

(B)

(c)

(D) 0 1 2 1

54.

What type

of

errors are caused

by

not following the rules of a particular computer

programming language when creating a

software?

(A)

(B)

(c)

(D) 0t2290r0/F 2016

(9)

..Cl}r"

9

Item 58 refers to the following

algorithm.

60

I

users for length, width

II

length, width, area

<-

length x width

III

"Area of rectangle is", area

Which of the following options can be used

to replace I,

II

and

III

in the algorithm?

(A)

Read, write, prompt

(B)

Write, read, prompt

(C)

Prompt, read, write

(D)

Read, prompt, write

Which of the following is the Pascal code

used to declare an array WORD

with

20 letters?

What

is

the MOST

appropriate control

structure to be used for calculating the total of ten numbers?

(A)

(B)

(c)

(D) If-then-else Repeat-until While-do For-do 58. 59

(A)

(B)

(c)

WORD: ARRAY[1..20] of char;

Vr\R LIST: ARRAY[2O] of char;

VAR

WORD: ARRAY[1..20]

of

char;

VAR WORD:

ARRAY[I

to 20]

of

char;

(D)

END OF TEST

IF

YOU

FINISH

BEFORE

TIME

IS

CALLED,

CHECK YOUR

WORI(

ON

TIIIS

TEST.

. :'l!i