Jan 2019 P2.pdf
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Jan 2019 P2.pdf as PDF for free.
More details
- Words: 3,040
- Pages: 28
CARIBBEAN
E XAM I NAT I O N S
COUNCIL
CARIBBEAN SECONDARY EDUCATION CERTIFICATE® EXAMINATION
‘‘*’’Barcode Area”*” Front Page Bar Code
17 JANUARY 2019 (a.m.)
FILL IN ALL THE INFORMATION REQUESTED CLEARLY IN CAPITAL LETTERS. TEST CODE
0
SUBJECT
INFORMATION TECHNOLOGY – Paper 02
PROFICIENCY
1
2
2
9
0
2
0
GENERAL
REGISTRATION NUMBER
SCHOOL/CENTRE NUMBER
NAME OF SCHOOL/CENTRE
‘‘*’’Barcode Area”*” Current Bar Code
CANDIDATE’S FULL NAME (FIRST, MIDDLE, LAST)
DATE OF BIRTH
D
D
M
M
Y
Y
Y
SIGNATURE __________________________________________________
‘‘*’’Barcode Area”*” Sequential Bar Code
Y
IS
TH
T
NO ON
E
PA G
TE
RI
W
DO
TEST CODE
FORM TP 2019016 CARIBBEAN
01229020
JANUARY 2019
E XAM I NAT I O N S
COUNCIL
CARIBBEAN SECONDARY EDUCATION CERTIFICATE® EXAMINATION INFORMATION TECHNOLOGY Paper 02 – General Proficiency 2 hours 15 minutes
READ THE FOLLOWING INSTRUCTIONS CAREFULLY. 1.
This paper consists of THREE sections and TWELVE questions. Answer ALL questions.
2.
Write your answers in the spaces provided in this booklet.
3.
Do NOT write in the margins.
4.
Code is to be written in Pascal.
5.
If you need to rewrite any answer and there is not enough space to do so on the original page, you must use the extra lined page(s) provided at the back of this booklet. Remember to draw a line through your original answer.
6.
If you use the extra page(s) you MUST write the question number clearly in the box provided at the top of the extra page(s) and, where relevant, include the question part beside the answer.
DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO DO SO. Copyright © 2018 Caribbean Examinations Council All rights reserved. 01229020/JANUARY 2019
‘‘*’’Barcode Area”*” Sequential Bar Code
SECTION I THEORY – 60 marks Answer ALL questions. 1.
Danielle recorded her classmates playing the clarinet and saved the recordings on two devices.
(a)
Identify (i)
ONE input device that could have been used to record the music
................................................................................................................................. (1 mark)
(ii)
ONE output device that could be used to listen to the music on the devices
................................................................................................................................. (1 mark)
(iii)
ONE device that could have been used to store the music
............................................................................................................................. (1 mark)
(iv)
the category of software that could be used to play music
................................................................................................................................. (1 mark)
(b)
State how EACH of the following can be applied to Danielle’s music: (i)
Human readable format
................................................................................................................................. (2 marks)
(ii)
Machine readable format
................................................................................................................................. (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-4-
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-5
(c)
State how Danielle could use ONE named network technology to access or listen to her music on a device.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
2.
(a)
Aaron and Nathalie recorded their favourite songs on two different devices. The table below shows the length of EACH recording, stored in minutes and seconds. Name Aaron’s device Nathalie’s device
(i)
Length of Recording Time in Minutes and Seconds 4:89 1:12
3:14 1:39
1:52 1:52
1:39 3:14
4:54 3:18
3:18 4:54
1:12 4:89
State whose device has the music recorded in serial order, giving ONE reason for your choice.
................................................................................................................................. ................................................................................................................................. ................................................................................................................................. ................................................................................................................................. (2 marks)
(ii)
Another song was recorded, which was 2 minutes and 15 seconds in length. Rewrite the TWO lists showing the result after storing the music on the two devices. Name
Length of Recording Time in Minutes and Seconds
Aaron’s device Nathalie’s device (2 marks)
(iii)
The song that was 4:54 long was not recorded well and needs to be removed. State the steps in the process of removing this song from Aaron’s device.
................................................................................................................................. ................................................................................................................................. (2 marks)
(b)
State whether the communication mode for listening to music is simplex, duplex or half duplex. Give ONE reason for your choice.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-6-
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-7
(c)
State TWO ways in which information technology has impacted the music industry.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
3.
Romario found a box with the name System Mechanic — Version 6 Professional.
(a)
The box advertises that the compact disk (CD) inside contains ‘everything you need to keep your PC safe, fast and error-free’. Complete the table below by identifying ONE type of software that can be used to perform EACH of the following functions, and describe the function of the software. Software Function
Software
Description of Function
Keep a computer safe
Keep a computer running fast or errorfree
01229020/JANUARY 2019
(4 marks)
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-8-
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-9
(b)
The box in (a) has the following system specifications:
PC running Microsoft® Windows 98, Me, NT4, 2000, XP, or 2003 server. CD-ROM drive, 60 GB free hard disk space. 128 MB RAM. Internet connection recommended.
Romario’s laptop has the following specifications:
Microsoft® Windows 10, DVD-RW drive, 60 MB free hard disk space, 4 GB RAM. Wi-Fi and broadband available.
Complete the table below by identifying the generic term used to describe EACH of the following features. Feature
Generic Term Used to Describe the Feature
Microsoft® Windows CD-ROM, DVD-RW RAM MB, GB (4 marks)
(c)
Suggest TWO reasons why the software of System Mechanic CANNOT be used with Romario’s laptop.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
4.
Complete EACH of the following statements using the terms or values below. Not all terms and values will be used. 0 to 7
ASCII
Base-8
Decimal
Hexadecimal
0 to 9
BCD
Base-10
Three
Byte
Bit
Base-16
Four
Sign and magnitude
10 to 15
(a)
A .............................................................. is a binary digit and can have one of two values generally represented as the numbers 0 and 1.
(b)
With .............................................................. notation, each succeeding digit’s contribution is ten times greater than the previous digit.
(c)
In octal notation, each digit represents .............................................................. bits.
Similarly, hexadecimal notation uses .............................................................. numbers,
representing .............................................................. bits with each digit.
Octal numbers use only the digits .............................................................., while hexadecimal numbers use all ten Base-10 digits (0–9) and the letters a to f (representing the numbers
(d)
..............................................................).
(e)
.............................................................. is a system of writing numerals that assigns a fourdigit binary code to each digit.
(f)
.............................................................. is a straight-forward method for representing both positive and negative integers.
(g)
The most common character representation is .............................................................. .
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 10 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 11 5.
(a)
Consider the four items below.
Complete the following table by identifying ONE of the four items that would MOST likely require EACH of the following: (Each item maybe used more than once) Access to the Internet Virus protection Random-access memory Hardware interface Secondary storage
(b)
(5 marks)
Identify ONE item in (a) which has improved with the use of technology. Give TWO reasons for your response.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
(c)
Identify ONE item in (a) that is most suitable for EACH of the following professions. Profession
Item
Medicine Banking (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 12 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 13 6.
Consider the following reservation form.
(a)
Identify TWO fields that
(i)
restrict the user to specific options
................................................................................................................................. (2 marks)
(ii) cannot be validated based on the information entered in the fields.
................................................................................................................................... (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
(b)
State TWO specific fields and explain how they can be used to validate ONE other field of data.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks)
(c)
Describe the type of validation check that was used in (b).
.............................................................................................................................................. .............................................................................................................................................. (2 marks)
(d)
Identify ONE other example where forms would be useful.
.............................................................................................................................................. .............................................................................................................................................. (1 mark)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 14 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 15 SECTION II PRODUCTIVITY TOOLS – 15 marks Answer ALL questions. 7.
1
Consider the following spreadsheet which shows the booking data for guests arriving at a hotel.
PAYMENT DUE
DISCOUNT Yes/No
03/08/2018
1
$770
B
C
D
E
LAST NAME
FIRST NAME
ARRIVAL DATE
DEPARTURE DATE
NUMBER OF NIGHTS
01/08/2018
F
2 3
Downs Ball
Robin
02/08/2018
05/08/2018
2
$2,310
4
Doepke
Cheryl
03/08/2018
07/08/2018
2
$3,080
5 6 7 9 8 10 11 12 14
Anders
Kat
06/08/2018
09/08/2018
3
$3,465
Bordeau
Kristen
06/08/2018
10/08/2018
1
$1,540
Gao
Xia
06/08/2018
08/08/2018
2
$1,540
Besete
Cheryl
14/08/2018
16/08/2018
4
$2,310
Coats
Bill
17/08/2018
20/08/2018
2
$2,310
Figerald
Ed
17/08/2018
20/08/2018
1
$385
Blackwell
Dean
20/08/2018
25/08/2018
2
$3,850
Chin
Roger
20/08/2018
23/08/2018
1
$1,155
Comen
Angela
28/08/2018
02/09/2018
1
$1,925
15
G
H
NUMBER OF GUESTS
A
Total number of guests
(a)
Complete EACH of the following tasks in the spreadsheet above:
(i) In cell E4, write the MOST suitable formula to calculate the number of nights. (1 mark)
(ii)
In cell F15, write the function to determine the total number of guests booked. (2 marks)
(iii)
In column H, for EACH booking, write the word ‘Yes’ in the appropriate cell if three or more guests are booked. (2 marks)
Identify the TWO fields on which the data is sorted.
(b)
.............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
(c)
State the type of alignment that is used for the results in column E.
.............................................................................................................................................. (1 mark)
01229020/JANUARY 2019
Total 8 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 16 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 17 8.
Consider the following data table in a database.
(a)
State an appropriate data type for EACH of the following fields. Field Name
Data Type
Bed Number of guests Payment due (3 marks)
(b)
Write a query to produce ‘ALL guests occupying single-bed rooms whose payments are less than $1000.’
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks)
(c)
Write the result of the query in (b), using the FIRST NAME field only.
.............................................................................................................................................. (1 mark) Total 7 marks
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
SECTION III PROBLEM-SOLVING AND PROGRAMMING – 45 marks Answer ALL questions. 9.
(a)
(i)
Complete the following table by stating whether EACH of the following statements represents input, process, or output.
Statement I
Read the discount
II
Subtract discount
III
Prompt for a discount
IV
Enter a discount
V
Display the amount
Category
(5 marks)
(ii)
Arrange the statements in (a) (i) in a logical order using the numbers I–V.
.................................................................................................................................. .................................................................................................................................. (5 marks)
(b)
During the months of April and May, students should attend school only if there is an exam for one of their subjects. Complete the following truth table to determine whether a student should attend school. ‘Y’ denotes Yes and ‘N’ denotes No. School_ Holiday
Exam_in_a_ Subject
Y
Y
Y
N
N
Y
N
N
01229020/JANUARY 2019
Attend_School
(4 marks) GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 18 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 19
(c) State a suitable data type for the variable ‘School_Holiday’ as described in (b).
.............................................................................................................................................. (1 mark) Total 15 marks
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
10.
Answer EACH of the following questions based on the three sentences and diagram below.
Wait for the bus. Are you late for the bus? Walk to school.
(a)
Write EACH of the sentences within the appropriate symbol on the diagram above to show the flow of information. (3 marks)
(b)
Write ‘Yes’ and ‘No’ in the appropriate spaces on the diagram to direct the flow of information. (2 marks)
(c) State
(i)
the type of diagram shown above
................................................................................................................................. (1 mark) (ii)
the name of the loop illustrated in the diagram.
................................................................................................................................. (1 mark)
(d)
Rewrite the THREE sentences as a conditional statement.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks) Total 10 marks 01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 20 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 21 11.
A programmer is asked to write a program for a health store that is offering a 10% discount on local juices.
Write Pascal code for EACH of the following:
(a) Declare ONE constant which can be used in the program.
.............................................................................................................................................. .............................................................................................................................................. (3 marks)
(b) Declare TWO meaningful variables and their data type, which can store the data to be input to the program.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (4 marks)
(c)
Write a statement to calculate the discount if a customer purchases a local fruit juice.
.............................................................................................................................................. .............................................................................................................................................. (3 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
12.
The following sale prices for four of its popular items have been advertised by the Computer Store.
Mouse $5.00 Battery $30.50 Webcam $55.95 Remote $65.00
(a)
Complete the following table to store the prices of the sale items in the array named SALE. Include labels for the index of EACH item in the array. The first column has been completed for you.
ARRAY: SALE PRICE
5.00
Index
1 (3 marks)
(b)
Write Pascal code to (i)
declare the array SALE
................................................................................................................................. ................................................................................................................................. (4 marks)
(ii)
output the price of the third item in the array.
................................................................................................................................. ................................................................................................................................. (3 marks)
Total 10 marks
END OF TEST IF YOU FINISH BEFORE TIME IS CALLED, CHECK YOUR WORK ON THIS TEST.
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 22 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 23 EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 24 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 25 EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 26 -
IS
TH
T
NO ON
E
PA G
TE
RI
W
DO
CANDIDATE’S RECEIPT INSTRUCTIONS TO CANDIDATE: 1.
Fill in all the information requested clearly in capital letters.
TEST CODE:
SUBJECT:
PROFICIENCY:
REGISTRATION NUMBER:
FULL NAME: ________________________________________________________________ (BLOCK LETTERS)
Signature: ____________________________________________________________________
Date: ________________________________________________________________________
2.
Ensure that this slip is detached by the Supervisor or Invigilator and given to you when you hand in this booklet.
3.
Keep it in a safe place until you have received your results.
0
1
2
2
9
0
2
0
INFORMATION TECHNOLOGY – Paper 02 GENERAL
INSTRUCTION TO SUPERVISOR/INVIGILATOR: Sign the declaration below, detach this slip and hand it to the candidate as his/her receipt for this booklet collected by you.
I hereby acknowledge receipt of the candidate’s booklet for the examination stated above.
Signature: _____________________________ Supervisor/Invigilator
Date: _________________________________
E XAM I NAT I O N S
COUNCIL
CARIBBEAN SECONDARY EDUCATION CERTIFICATE® EXAMINATION
‘‘*’’Barcode Area”*” Front Page Bar Code
17 JANUARY 2019 (a.m.)
FILL IN ALL THE INFORMATION REQUESTED CLEARLY IN CAPITAL LETTERS. TEST CODE
0
SUBJECT
INFORMATION TECHNOLOGY – Paper 02
PROFICIENCY
1
2
2
9
0
2
0
GENERAL
REGISTRATION NUMBER
SCHOOL/CENTRE NUMBER
NAME OF SCHOOL/CENTRE
‘‘*’’Barcode Area”*” Current Bar Code
CANDIDATE’S FULL NAME (FIRST, MIDDLE, LAST)
DATE OF BIRTH
D
D
M
M
Y
Y
Y
SIGNATURE __________________________________________________
‘‘*’’Barcode Area”*” Sequential Bar Code
Y
IS
TH
T
NO ON
E
PA G
TE
RI
W
DO
TEST CODE
FORM TP 2019016 CARIBBEAN
01229020
JANUARY 2019
E XAM I NAT I O N S
COUNCIL
CARIBBEAN SECONDARY EDUCATION CERTIFICATE® EXAMINATION INFORMATION TECHNOLOGY Paper 02 – General Proficiency 2 hours 15 minutes
READ THE FOLLOWING INSTRUCTIONS CAREFULLY. 1.
This paper consists of THREE sections and TWELVE questions. Answer ALL questions.
2.
Write your answers in the spaces provided in this booklet.
3.
Do NOT write in the margins.
4.
Code is to be written in Pascal.
5.
If you need to rewrite any answer and there is not enough space to do so on the original page, you must use the extra lined page(s) provided at the back of this booklet. Remember to draw a line through your original answer.
6.
If you use the extra page(s) you MUST write the question number clearly in the box provided at the top of the extra page(s) and, where relevant, include the question part beside the answer.
DO NOT TURN THIS PAGE UNTIL YOU ARE TOLD TO DO SO. Copyright © 2018 Caribbean Examinations Council All rights reserved. 01229020/JANUARY 2019
‘‘*’’Barcode Area”*” Sequential Bar Code
SECTION I THEORY – 60 marks Answer ALL questions. 1.
Danielle recorded her classmates playing the clarinet and saved the recordings on two devices.
(a)
Identify (i)
ONE input device that could have been used to record the music
................................................................................................................................. (1 mark)
(ii)
ONE output device that could be used to listen to the music on the devices
................................................................................................................................. (1 mark)
(iii)
ONE device that could have been used to store the music
............................................................................................................................. (1 mark)
(iv)
the category of software that could be used to play music
................................................................................................................................. (1 mark)
(b)
State how EACH of the following can be applied to Danielle’s music: (i)
Human readable format
................................................................................................................................. (2 marks)
(ii)
Machine readable format
................................................................................................................................. (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-4-
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-5
(c)
State how Danielle could use ONE named network technology to access or listen to her music on a device.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
2.
(a)
Aaron and Nathalie recorded their favourite songs on two different devices. The table below shows the length of EACH recording, stored in minutes and seconds. Name Aaron’s device Nathalie’s device
(i)
Length of Recording Time in Minutes and Seconds 4:89 1:12
3:14 1:39
1:52 1:52
1:39 3:14
4:54 3:18
3:18 4:54
1:12 4:89
State whose device has the music recorded in serial order, giving ONE reason for your choice.
................................................................................................................................. ................................................................................................................................. ................................................................................................................................. ................................................................................................................................. (2 marks)
(ii)
Another song was recorded, which was 2 minutes and 15 seconds in length. Rewrite the TWO lists showing the result after storing the music on the two devices. Name
Length of Recording Time in Minutes and Seconds
Aaron’s device Nathalie’s device (2 marks)
(iii)
The song that was 4:54 long was not recorded well and needs to be removed. State the steps in the process of removing this song from Aaron’s device.
................................................................................................................................. ................................................................................................................................. (2 marks)
(b)
State whether the communication mode for listening to music is simplex, duplex or half duplex. Give ONE reason for your choice.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-6-
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-7
(c)
State TWO ways in which information technology has impacted the music industry.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
3.
Romario found a box with the name System Mechanic — Version 6 Professional.
(a)
The box advertises that the compact disk (CD) inside contains ‘everything you need to keep your PC safe, fast and error-free’. Complete the table below by identifying ONE type of software that can be used to perform EACH of the following functions, and describe the function of the software. Software Function
Software
Description of Function
Keep a computer safe
Keep a computer running fast or errorfree
01229020/JANUARY 2019
(4 marks)
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-8-
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
-9
(b)
The box in (a) has the following system specifications:
PC running Microsoft® Windows 98, Me, NT4, 2000, XP, or 2003 server. CD-ROM drive, 60 GB free hard disk space. 128 MB RAM. Internet connection recommended.
Romario’s laptop has the following specifications:
Microsoft® Windows 10, DVD-RW drive, 60 MB free hard disk space, 4 GB RAM. Wi-Fi and broadband available.
Complete the table below by identifying the generic term used to describe EACH of the following features. Feature
Generic Term Used to Describe the Feature
Microsoft® Windows CD-ROM, DVD-RW RAM MB, GB (4 marks)
(c)
Suggest TWO reasons why the software of System Mechanic CANNOT be used with Romario’s laptop.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
4.
Complete EACH of the following statements using the terms or values below. Not all terms and values will be used. 0 to 7
ASCII
Base-8
Decimal
Hexadecimal
0 to 9
BCD
Base-10
Three
Byte
Bit
Base-16
Four
Sign and magnitude
10 to 15
(a)
A .............................................................. is a binary digit and can have one of two values generally represented as the numbers 0 and 1.
(b)
With .............................................................. notation, each succeeding digit’s contribution is ten times greater than the previous digit.
(c)
In octal notation, each digit represents .............................................................. bits.
Similarly, hexadecimal notation uses .............................................................. numbers,
representing .............................................................. bits with each digit.
Octal numbers use only the digits .............................................................., while hexadecimal numbers use all ten Base-10 digits (0–9) and the letters a to f (representing the numbers
(d)
..............................................................).
(e)
.............................................................. is a system of writing numerals that assigns a fourdigit binary code to each digit.
(f)
.............................................................. is a straight-forward method for representing both positive and negative integers.
(g)
The most common character representation is .............................................................. .
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 10 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 11 5.
(a)
Consider the four items below.
Complete the following table by identifying ONE of the four items that would MOST likely require EACH of the following: (Each item maybe used more than once) Access to the Internet Virus protection Random-access memory Hardware interface Secondary storage
(b)
(5 marks)
Identify ONE item in (a) which has improved with the use of technology. Give TWO reasons for your response.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
(c)
Identify ONE item in (a) that is most suitable for EACH of the following professions. Profession
Item
Medicine Banking (2 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 12 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 13 6.
Consider the following reservation form.
(a)
Identify TWO fields that
(i)
restrict the user to specific options
................................................................................................................................. (2 marks)
(ii) cannot be validated based on the information entered in the fields.
................................................................................................................................... (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
(b)
State TWO specific fields and explain how they can be used to validate ONE other field of data.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks)
(c)
Describe the type of validation check that was used in (b).
.............................................................................................................................................. .............................................................................................................................................. (2 marks)
(d)
Identify ONE other example where forms would be useful.
.............................................................................................................................................. .............................................................................................................................................. (1 mark)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 14 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 15 SECTION II PRODUCTIVITY TOOLS – 15 marks Answer ALL questions. 7.
1
Consider the following spreadsheet which shows the booking data for guests arriving at a hotel.
PAYMENT DUE
DISCOUNT Yes/No
03/08/2018
1
$770
B
C
D
E
LAST NAME
FIRST NAME
ARRIVAL DATE
DEPARTURE DATE
NUMBER OF NIGHTS
01/08/2018
F
2 3
Downs Ball
Robin
02/08/2018
05/08/2018
2
$2,310
4
Doepke
Cheryl
03/08/2018
07/08/2018
2
$3,080
5 6 7 9 8 10 11 12 14
Anders
Kat
06/08/2018
09/08/2018
3
$3,465
Bordeau
Kristen
06/08/2018
10/08/2018
1
$1,540
Gao
Xia
06/08/2018
08/08/2018
2
$1,540
Besete
Cheryl
14/08/2018
16/08/2018
4
$2,310
Coats
Bill
17/08/2018
20/08/2018
2
$2,310
Figerald
Ed
17/08/2018
20/08/2018
1
$385
Blackwell
Dean
20/08/2018
25/08/2018
2
$3,850
Chin
Roger
20/08/2018
23/08/2018
1
$1,155
Comen
Angela
28/08/2018
02/09/2018
1
$1,925
15
G
H
NUMBER OF GUESTS
A
Total number of guests
(a)
Complete EACH of the following tasks in the spreadsheet above:
(i) In cell E4, write the MOST suitable formula to calculate the number of nights. (1 mark)
(ii)
In cell F15, write the function to determine the total number of guests booked. (2 marks)
(iii)
In column H, for EACH booking, write the word ‘Yes’ in the appropriate cell if three or more guests are booked. (2 marks)
Identify the TWO fields on which the data is sorted.
(b)
.............................................................................................................................................. (2 marks)
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
(c)
State the type of alignment that is used for the results in column E.
.............................................................................................................................................. (1 mark)
01229020/JANUARY 2019
Total 8 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 16 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 17 8.
Consider the following data table in a database.
(a)
State an appropriate data type for EACH of the following fields. Field Name
Data Type
Bed Number of guests Payment due (3 marks)
(b)
Write a query to produce ‘ALL guests occupying single-bed rooms whose payments are less than $1000.’
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks)
(c)
Write the result of the query in (b), using the FIRST NAME field only.
.............................................................................................................................................. (1 mark) Total 7 marks
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
SECTION III PROBLEM-SOLVING AND PROGRAMMING – 45 marks Answer ALL questions. 9.
(a)
(i)
Complete the following table by stating whether EACH of the following statements represents input, process, or output.
Statement I
Read the discount
II
Subtract discount
III
Prompt for a discount
IV
Enter a discount
V
Display the amount
Category
(5 marks)
(ii)
Arrange the statements in (a) (i) in a logical order using the numbers I–V.
.................................................................................................................................. .................................................................................................................................. (5 marks)
(b)
During the months of April and May, students should attend school only if there is an exam for one of their subjects. Complete the following truth table to determine whether a student should attend school. ‘Y’ denotes Yes and ‘N’ denotes No. School_ Holiday
Exam_in_a_ Subject
Y
Y
Y
N
N
Y
N
N
01229020/JANUARY 2019
Attend_School
(4 marks) GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 18 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 19
(c) State a suitable data type for the variable ‘School_Holiday’ as described in (b).
.............................................................................................................................................. (1 mark) Total 15 marks
01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
10.
Answer EACH of the following questions based on the three sentences and diagram below.
Wait for the bus. Are you late for the bus? Walk to school.
(a)
Write EACH of the sentences within the appropriate symbol on the diagram above to show the flow of information. (3 marks)
(b)
Write ‘Yes’ and ‘No’ in the appropriate spaces on the diagram to direct the flow of information. (2 marks)
(c) State
(i)
the type of diagram shown above
................................................................................................................................. (1 mark) (ii)
the name of the loop illustrated in the diagram.
................................................................................................................................. (1 mark)
(d)
Rewrite the THREE sentences as a conditional statement.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (3 marks) Total 10 marks 01229020/JANUARY 2019
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 20 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 21 11.
A programmer is asked to write a program for a health store that is offering a 10% discount on local juices.
Write Pascal code for EACH of the following:
(a) Declare ONE constant which can be used in the program.
.............................................................................................................................................. .............................................................................................................................................. (3 marks)
(b) Declare TWO meaningful variables and their data type, which can store the data to be input to the program.
.............................................................................................................................................. .............................................................................................................................................. .............................................................................................................................................. (4 marks)
(c)
Write a statement to calculate the discount if a customer purchases a local fruit juice.
.............................................................................................................................................. .............................................................................................................................................. (3 marks)
01229020/JANUARY 2019
Total 10 marks
GO ON TO THE NEXT PAGE
‘‘*’’Barcode Area”*” Sequential Bar Code
12.
The following sale prices for four of its popular items have been advertised by the Computer Store.
Mouse $5.00 Battery $30.50 Webcam $55.95 Remote $65.00
(a)
Complete the following table to store the prices of the sale items in the array named SALE. Include labels for the index of EACH item in the array. The first column has been completed for you.
ARRAY: SALE PRICE
5.00
Index
1 (3 marks)
(b)
Write Pascal code to (i)
declare the array SALE
................................................................................................................................. ................................................................................................................................. (4 marks)
(ii)
output the price of the third item in the array.
................................................................................................................................. ................................................................................................................................. (3 marks)
Total 10 marks
END OF TEST IF YOU FINISH BEFORE TIME IS CALLED, CHECK YOUR WORK ON THIS TEST.
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 22 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 23 EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 24 -
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 25 EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
EXTRA SPACE If you use this extra page, you MUST write the question number clearly in the box provided. Question No. ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ........................................................................................................................................................................... ...........................................................................................................................................................................
‘‘*’’Barcode Area”*” Sequential Bar Code
01229020/JANUARY 2019
DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA DO NOT WRITE IN THIS AREA
- 26 -
IS
TH
T
NO ON
E
PA G
TE
RI
W
DO
CANDIDATE’S RECEIPT INSTRUCTIONS TO CANDIDATE: 1.
Fill in all the information requested clearly in capital letters.
TEST CODE:
SUBJECT:
PROFICIENCY:
REGISTRATION NUMBER:
FULL NAME: ________________________________________________________________ (BLOCK LETTERS)
Signature: ____________________________________________________________________
Date: ________________________________________________________________________
2.
Ensure that this slip is detached by the Supervisor or Invigilator and given to you when you hand in this booklet.
3.
Keep it in a safe place until you have received your results.
0
1
2
2
9
0
2
0
INFORMATION TECHNOLOGY – Paper 02 GENERAL
INSTRUCTION TO SUPERVISOR/INVIGILATOR: Sign the declaration below, detach this slip and hand it to the candidate as his/her receipt for this booklet collected by you.
I hereby acknowledge receipt of the candidate’s booklet for the examination stated above.
Signature: _____________________________ Supervisor/Invigilator
Date: _________________________________
Related Documents
Guxzut_07-jan-2019.pdf
November 2019 20
Jadual Jan 2019.docx
April 2020 8
Berkowits Jan 2019.pdf
November 2019 12
Dfrancavilla Resume Jan 2019
December 2019 14
Healthcare-jan-2019.docx
July 2020 10
Jan - March 2019 Newsletter.pdf
October 2019 30More Documents from ""
Jan 2019 P2.pdf
July 2020 5
Maths_may_2015.pdf
July 2020 4
Csec Pob June 2006 P1.pdf
July 2020 5
Csec June 2015 Mathematics P1.pdf
July 2020 8
Dxdiag_lumion.txt
December 2019 24