Free CXC Information Technology Paper 2 May/June 2018 past paper from 2018. Includes a worked answer key. Open the PDF, take a timed test, and study with AI on Caribbean AI.
Answer keys are free on Caribbean AI. View the answers to every past-paper question at no cost - no payment needed - with step-by-step worked solutions and instant AI marking available on Premium.
CSEC Information Technology Paper 2 May/June 2018 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 May/June 2018 past paper from 2018. Includes a worked answer key. Open the PDF, take a timed test, and study with AI on Caribbean AI.
Opening the interactive papers…
Every question from this paper as text. See the answers and worked solutions. Questions are the property of the Caribbean Examinations Council; Caribbean AI is not affiliated with CXC.
Akia regularly needs to access many documents that are sent to her. She uses one or more applications to receive and send notes and information that her colleagues. Sometimes she needs to access her company's website for information when working with a client.
[10 marks]
Based on the scenario above, identify TWO examples of software applications that Akia would use.
[2 marks]
Define the term 'telecommunication'.
[2 marks]
Complete the following table by writing ONE advantage and ONE disadvantage of using (i) a laptop computer and (ii) a mobile device for conducting business while travelling.
[4 marks]
Akia needs to print a document that is located on a mobile device. Outline TWO ways in which the document can be printed.
[2 marks]
State TWO examples of a hardware interface.
[2 marks]
The following list includes various specifications of computer devices.
Specifications:
For EACH of the following scenarios, (i) to (iv), recommend TWO relevant computer specifications from the list above. Specifications can be used more than once.
[8 marks]
The table below illustrates sources that are used for the input of data. For EACH source, identify the device that is used to capture data from it, and describe ONE example of data that is captured.
| Illustration of Source | Device Used | Example of Data that is Captured |
|---|---|---|
| (i) | ||
| (ii) | ||
| (iii) |
[10 marks]
The table below illustrates sources that are used for the input of data. For EACH source, identify the device that is used to capture data from it, and describe ONE example of data that is captured.
[6 marks]
State, with reasons, which of the sources illustrated (i) is the LEAST popular (ii) is MOSTLY associated with point-of-sale systems.
[4 marks]
is the LEAST popular
[2 marks]
is MOSTLY associated with point-of-sale systems.
[2 marks]
The diagram below shows the decimal binary or hexadecimal representation of the characters H, I, M. Complete the diagram by writing the correct representation in the spaces (i), (ii), (iii) and (iv).
[10 marks]
The diagram below shows the decimal binary or hexadecimal representation of the characters H, I, M. Complete the diagram by writing the correct representation in the spaces (i), (ii), (iii) and (iv).
[4 marks]
Daniel wants to represent 12:35:47 p.m. using a clock, where each column shows the binary-coded decimal number.
In EACH of the three unshaded columns below, shade the appropriate circles that correspond to the decimal digit, indicated below it. Three columns have been completed for you.
[6 marks]
Jarad is playing an online game where the user needs to move the STAR over different TARGETS in order to gain points. Use this gaming example to answer the questions that follow.
[10 marks]
Jarad is playing an online game where the user needs to move the STAR over different TARGETS in order to gain points. Use this gaming example to answer the questions that follow.
(i) State TWO examples of input devices that can be used to move the star to the target. (ii) ONE output device AND ONE hardware interface that notifies the user that the star is over the target.
[4 marks]
TWO examples of input devices that can be used to move the star to the target.
[2 marks]
ONE output device AND ONE hardware interface that notifies the user that the star is over the target.
[2 marks]
Describe TWO ways in which the gaming application can indicate to Jarad that the star is over the target.
[2 marks]
Complete EACH of the following statements by writing in the MOST suitable expression associated with the term in brackets. (i) Jarad is able to play the game interactively with other users in different countries in .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
<![CDATA[An online banking website shows the following screen to transfer money from one account to another.[4 marks]
Jarad is able to play the game interactively with other users in different countries in .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
<![CDATA[An online banking website shows the following screen to transfer money from one account to another. Complete the table below by stating the fields for which the following validation checks can be used. Give ONE reason why each check is suitable for the fields stated.Complete the table below by stating the fields for which the following validation checks can be used. Give ONE reason why each check is suitable for the fields stated.
| Check | Field(s) | Reason |
|---|---|---|
| Data type | ||
| Consistency | ||
| Range |
[7 marks]
A customer is transferring $2500 from one account to another on Thursday, 4 January 2018. After clicking the next button, an error message is shown.
State (i) ONE factor that could have led to an error caused by the customer (ii) TWO factors that could have led to an error caused by the technology.
[3 marks]
ONE factor that could have led to an error caused by the customer
[1 mark]
TWO factors that could have led to an error caused by the technology.
[2 marks]
Study the spreadsheet below and answer the questions that follow.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | Passenger | Number of Trips | Accompanying Family Members | Pieces of Luggage | Luggage Charge |
| 3 | Parris | 12 | 0 | 1 | |
| 4 | Moore | 4 | 1 | 2 | |
| 5 | Greene | 2 | 2 | 3 | |
| 6 | Sweeny | 9 | 1 | 2 | |
| 7 | Walrond | 1 | 1 | 2 | |
| 8 | |||||
| 9 | FUNC-X | 10 | |||
| 10 | FUNC-Y | 2.0 |
[7 marks]
State the names of the functions that produced the results in cells D9 and D10.
FUNC-X FUNC-Y
[2 marks]
Write a function for cell E5 that would place the comment "Yes" in that cell, if a passenger has more than TWO pieces of luggage.
[3 marks]
State the range of cells that would be selected to create a chart that compares the number of trips AND pieces of luggage for each passenger.
[2 marks]
Study the following table which contains the schedules for four flights.
| FLIGHT | DEPARTURE | ON TIME |
|---|---|---|
| BEL111 | 6:50 a.m. | Yes |
| CBR123 | 8:25 a.m. | No |
| BBA556 | 4:30 p.m. | Yes |
| NAB900 | 5:00 p.m. | Yes |
[8 marks]
Complete the database structure for the table.
| Field Name | Data Type |
|---|---|
| FLIGHT | |
| DEPARTURE | |
| ON TIME |
[3 marks]
State the field that can be used as a primary key.
[1 mark]
Write a suitable size for the FLIGHT field.
[1 mark]
Write the result of a query that finds all flights that are delayed.
[1 mark]
State the field name AND the order of the records which are sorted in the table.
[2 marks]
Aaron is playing a new online car game. He can gain or lose points in the game as follows:
[10 marks]
Complete the following table to show Aaron's updated points while completing the moves indicated.
| Move | Aaron's Car | Updated Number of Points |
|---|---|---|
| 0 | ||
| 1 | Gains distance | |
| 2 | Knocks a sidewalk and gets stopped | |
| 3 | Gains distance and gets stopped | |
| 4 | Turns and crashes | |
| 5 | Gains distance and increases speed | |
| 6 | Is stopped and knocks a sidewalk |
[6 marks]
Using pseudocode, write an IF statement for Move 1 (Gains distance) in (a) that updates the number of points.
[4 marks]
The following table shows two translations of a set of programming instructions. Study the table and answer the questions that follow.
| Instruction | Translation 1 | Translation 2 |
|---|---|---|
| JUMP | JMP | 1001 |
| TAP | TAP | 1010 |
| TURN | TRN | 1111 |
| FALL | FAL | 0000 |
| KNOCK | KNK | 10100 |
| SEIZE | SZE | 1110 |
[10 marks]
State the programming language generation used in Translation 1.
[1 mark]
Write the generic name of the programming language illustrated in (i) Translation 1 (ii) Translation 2
[2 marks]
Translation 1
[1 mark]
Translation 2
[1 mark]
Identify the error in the following instructions: SZE TAP JNP TRN.
[1 mark]
State the technical term for the type of error identified in (c) (i).
[1 mark]
Correct the error by stating what the instruction should be.
[1 mark]
State the technical term for locating this type of error in a program.
[1 mark]
The following table shows a set of instructions and the output after being translated.
| Instructions (from Program) | Output (of Program) |
|---|---|
| FAL JMP KNK SZS | 0000 1111 10100 1110 |
State (i) the general name given to the original set of code before the translation (ii) the term given to the translation that produced the output of the program (iii) the name of a programming language that has user-friendly programming instructions.
[3 marks]
the general name given to the original set of code before the translation
[1 mark]
the term given to the translation that produced the output of the program
[1 mark]
the name of a programming language that has user-friendly programming instructions.
[1 mark]
State whether EACH of the following operations is described as input, output, processing or storage.
[5 marks]
State whether EACH of the following operations is described as input, output, processing or storage.
[5 marks]
Entering a player's name in a competition
[1 mark]
Showing the number of points on a screen
[1 mark]
Calculating the number of points lost in a game
[1 mark]
Exiting a game
[1 mark]
Saving the points for the last three games
[1 mark]
Sketch a flow chart for the following control structure.
While Points >= 20
level = level + 1
Output "You need 20 or more points"
[5 marks]
Study the following outline of an office where a thick line denotes a wall and the numbers represent blocks.
| 11 | 12 | 13 |
|---|---|---|
| 21 | 22 | 23 |
| 31 | 32 | 33 |
| 41 | 42 | 43 |
Using the terms START, DOWN, UP, LEFT, RIGHT and STOP, write the sequence of steps required to walk from Block 11 to Block 13.
[5 marks]
Using the following algorithm, write a complete Pascal program named MAZE.
Step = 0
Turn = 0
AtWall = False
While AtExit is not equal to True
Step = Step + 1
If (AtWall = True)
Then Turn = Turn + 1
Else Step = Step + 1
If AtExit = True
Then Output number of steps, number of turns
EndWhile
Stop
[10 marks]
[1 mark]