l

MtniSY of EduJsilon
SoftsarÉþfiffia-
'-i.*--' Cà\È _rESrcoDE01229020
FORM TP 2011014 'ÃC, rANUARY2oll

CARIBBEAN EXAMINATIONS C OUNCIL

SECONDARY EDUCATION CERTIFICATE
EXAMINATION
INFORMÄTION TECHNOLOGY
Paper 02 - General Proficiency

2 hours 75 minutes

12 JANUARY 2011 (a.m.)

INSTRUCTIONS TO CANDIDÄTES

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

Candidates MUST answerAl-I- questions in all THREE sections.

2. Number EACH answer correctlv in the answer booklet.

3. Code is to be written in the programming languageo Pascal.

*\

DO NOT TURN THIS PAGE UNTILYOU ARE TOLD TO DO SO.

Copyright @ 2010 Caribbean Examinations Council

All rishts reserved.

01229020/JANUARY 2011
 12 -.

SECTION I
THEORY- 60 marks

AnswerALL questions.

1. (a) A user interface allows a user to communicate with the computer to get some tasks done.

(Ð List ONE hardware user interface and give an example of where it is used.
(2 marks)

(iÐ State T'WO types of software user interfaces and indicate which one is more
suitable for use by someone who is learning to use a computer. (3 marks)

(b) List ONE advantage and ONE, disadvantage of real-time processing. (2 marks)

(c) Match the following applications with the type of software that BEST describes the
application. In your answer booklet, write the application number (l ,2,3) and the software
type letter (4, B, C) besides it.

Application Application Software Tlpe of Software

No. Tlpe Letter

I Microsoft Office 2003 A Operating system software

2 Ubuntu Linux B Specialized software

a
J Spanish for beginners C Integrated application software

(3 marks)

Total 10 marks

) (a) (i) If the ASCII code for the letter 'f is 11 001 10, find the ASCII code for the letter
"K". ShowALL calculations. (3 marks)

(iÐ Convert the binary number 01011110 to hexadecimal. (1 mark )

(iiÐ Using two's complement, find the 8-bit representation of -72. (1 mark )

(b) John has an external hard drive with a capacity of 1 terabyte (TB) and Mary has a USB
flash drive with a capacity of 16 gigabytes (GB). Calculate how many flash drives of
information, similar to Mary's, can be accommodated on John's external hard drive.
(2 marks)

GO ON TO THE NEXT PAGE

01229020/IANUARY 2011
 -3-

(c) For EACH of the following storage media, indicate whether it is a secondary or primary
storage media.

(Ð Flash Memory Card

(iÐ RandomAccess Memory

(iiÐ Programmable Read Only Memory (PROM) (3 marks)

Total 10 marks

3. Match the following tasks with the BEST device suitable to perform the task. In your answer
booklet, write the device number (1,2,3..., 10) with the task letter (4, B, ..., J) you choose besides
it.

Device Device Task Task

No. Letter

I Touch terminal A Printing of large building plans

2 Joystick B Marking a multiple choice examination

J Optical Mark Reader (OMR) C Preparing architectural drawings

4 Magnetic Ink Character D Activating abuzzer when someone enters

Reader (MICR) the server room

5 Biometric System E Making selection by touching parts of the

screen

6 Plotter F Listening to music on your computer

7 Inkìet Printer G Allowing access to a computerby scanning

the iris of your eye

8 Pads and Tablets H Processing of cheques

9 Headphones I Printing colour greeting cards at home

l0 Sensor J Used for playing games

Total l0 marks

GO ON TO THE NEXT PAGE

0L229020/IANUARY 2011
 -4-

4. A computer supplies company has eight technicians who travel to businesses and homes to
sell computer supplies and accessories. Each technician has the ability to complete purchase
transactions usins debit or credit cards at anv client's location.

(a) Explain, giving a reason, the type of transaction media that is described above.
(2 marks)

(b) Explain what is a 'hotspot' and give ONE disadvantage of having access to a hotspot.
(2 marks)

(c) Name TWO devices that can connect to a Wi-Fi. (2 marks)

(d) Explain the difference between'line-of-sight communication' and'scattered infrared

communication'. (2 marks)

(e) Explain whether line'oÊsight communication or scattered infrared communication is

MORE effective in transmitting data. (2 marks)

Total l0 marks

5. State ONE advantase and ONE disadvantaee of EACH of the followins scenarios:

(a) Offering automated voice mail where the caller presses a number to be transferred to an
extension. (2 marks)

(b) Working at home or conducting business using a computer to communicate with colleagues
and/or clients. (2 marks)

(c) Using only credit or debit cards for transactions. (2 marks)

(d) Use of Information Technology and computers in most areas of work. (2 marks)

(e) Using a computer for a long time to complete an urgent task. (2 marks)

Total l0 marks

GO ON TO THE NEXT PAGE

0|229020|IANUARY 20ll
 -tr-

6. (a) For EACH of the file structures labelled (i) to (v) below, state whether the record
arangement is ordered (O), unordered (U) or can either be ordered or unordered (OU).

(Ð Direct Access File

(iÐ Indexed-Sequential File

(iiÐ RandomAccess File

(iv) Sequential File

(v) Serial File (6 marks)

(b) State whether EACH of the following files is temporary or permanent:

(Ð Grandfather file

(ii) Master file

(iiÐ Transaction file

(iv) Transaction log (4 marks)

Total l0 marks

GO ON TO THE NEXT PAGE

01229020/JANUARY 2011
 -6-

SECTION II
PRODUCTIVITYTOOLS - 15 marks

AnswerALL questions.

1 Answer the following questions based on the spreadsheet given below:

A B C D E F
I
2 Bank Savings Checking Loan Total
3 BD 800 500 125
4 DB 12,000 15,000 3,000
5 GBTI 5,000 600 200
6 RB 15,000 r,250 900
SB 2,500 1,500 600
8

(a) State the range of cells containing the names of the banks. (1 mark )

(b) What data format has been applied to the data with the number of accounts for each of
the banks? (1 mark )

(c) The data in the spreadsheet have been sorted. Indicate the name of the field used for the
solt. (1 mark )

(d) Write the function that should be used to find the HIGHEST number of loan accounts in
a bank. (2 marks)

(e) You are asked to create a pie chart to show the TOTAL number of accounts in EACH
bank. Write the TWO ranges of data you would use. (2 marks)

TotalT marks

GO ON TO THE NEXT PAGE

OI22qO2O/JANUARY 2011
8. Auniversity uses a database with two tables to store information on courses thatare being offered
by the various faculties. The data in the two tables are given below:

TABLE 1: COURSE

cid Name Credits Faculty

a
MTH 2OO Mathematics 2 J NS
ECN 1OO Economics 1 aA SS

HST 1OO History I 6 EH

CSI 4OO Computer Science 4 8 NS

TABLE 2: FACULTY

Faculty Dean
NS Tiwari
SS Scott
EH Hussain

(a) What fleld in the COURSE table is used to sort the records? (1 mark )

(b) State the primary key in the COURSE table. (1 mark )

(c) The two tables have been joined by a common field. State the name of the Dean of the
faculty that is offering the course with Cid: ECN 100. (1 mark )

(d) write a query to showALL courses in the NS faculty with MoRE than 5 credits.
(2 marks)

(e) In the COURSE table it is required to insert a calculated field named FEE to compute the
fee for EACH course. If the cost per credit is $250, write the formula for the calculated
field. (2 marks)

(Ð State the field in the COURSE table that would be MOST appropriate to use to group the
data when preparing a repoft. (1 mark )

Total S marks

GO ON TO THE NEXT PAGE

OI229O2O/JANUARY 201I
 -8-

SECTION III
PROBLEM SOLVING,AND PROGRAMMING - 45 marks
AnswerALL questions.

9. The two affays below contain four numbers each.

Listl: 2458
List2: 13s7
(a) Write code in Pascal to declare the arca5r Listl. (5 marks)

(b) Write the contents of the two arrays after execution of the following fragment of code:

for x :: l- to 4 do
Listl [x] :: Listl [x] - List2 [x] (5 marks)

Total l0 marks

10. A program reads two characters comprising *, ar # into a 6-index array îamed TEST. Assuming
that the array and all variables are already initialized write a program fragment to

(a) inittalize tho aray (3 marks)

(b) print the number of stars (*) in the array (6 marks)

(c) print the comment "hIO" for all characters other than * ar # in the array. (6 marks)

Total 15 marks

GO ON TO THE NEXT PAGE

01229020/JANUARY 2011
 -9-

11. (a) Copy and complete the trace table below to show the result of the following algorithm.

1 last:
2 count:O
3 While number:3 to 7 Do
4 V/hile (number <> last) DO
Count: Count * 1

6 End While
7 Otttput count

Number Count
a
J

4 I
5

7
(4 marks)

(b) What is the name of the structure from lines 3 to 6? (1 mark )

Total5 marks

12. Explain the difference between EACH of the following pairs of terms.

(a) Low-level and high-level languages (2 marks)

(b) Looping structure and conditional structure (2 marks)

(c) Testing and debugging (2 marks)

(d) Variable and constant (2 marks)

(e) The symbols: and <> (2 marks)

(Ð Integer and real values (2 marks)

(g) Pseudocode and flowchart (3 marks)

Total 15 marks

END OF TEST

OT229O2O/JANUARY 201I