Free CXC Information Technology Paper 2 January 2017 past paper from 2017. 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 January 2017 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 January 2017 past paper from 2017. 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.
Write the appropriate name for the IT professional who performs EACH of the following functions.
[2 marks]
Determines access privileges for users of the database
[1 mark]
Repairs malfunctioning computer equipment
[1 mark]
Describe the function of EACH of the following units found in a computer system.
[6 marks]
Control unit
[2 marks]
Arithmetic-logic unit
[2 marks]
Central processing unit
[2 marks]
In the box below, draw a diagram showing the relationship between the control unit, arithmetic-logic unit and central processing unit.
[3 marks]
Convert EACH of the following data from the number system specified to its decimal equivalent. (Show all steps in calculations.)
[10 marks]
[3 marks]
[3 marks]
[3 marks]
as a binary coded decimal (BCD)
[1 mark]
A technician was checking a computer to see if it needed replacement parts. State the specification for EACH component indicated in (a) to (c) as required.
[10 marks]
Intel Pentium IV 64 bit 3.6 GHz
[3 marks]
The word size
[1 mark]
The processor type
[1 mark]
The processor speed
[1 mark]
2GB 533MHz SDRAM
[3 marks]
The type of RAM
[1 mark]
The memory capacity
[1 mark]
The speed
[1 mark]
160GB SATA HDD 7200 rpm
[4 marks]
The storage device described
[1 mark]
The storage capacity
[1 mark]
The speed
[1 mark]
The device interface
[1 mark]
Identify ONE input OR output device that is useful for EACH of the following situations.
[10 marks]
Identify ONE input OR output device that is useful for EACH of the following situations.
[4 marks]
Used by the visually impaired
[1 mark]
Used by the hearing impaired
[1 mark]
To fly a simulation program
[1 mark]
To produce an electronic signature
[1 mark]
The diagram below represents a storage device. Draw and label a sector and a track on the diagram.
[4 marks]
State ONE secondary storage device that uses sectors and tracks to store data and programs.
[1 mark]
Identify ONE device interface that is suitable for connecting internal storage devices.
[1 mark]
The following scenario describes an example of an automated (computerized) application in an industrial information processing system. Use the scenario to answer the questions that follow.
This application reads in data about the heat generated in a reactor of an industrial plant.
Instructions are sent to a device.
Users can determine whether the reactor is working efficiently in regulating the flow of water that cools the reactor.
[10 marks]
Identify ONE example of
[2 marks]
data that can be entered
[1 mark]
an input device used to enter the data.
[1 mark]
Identify ONE example of
[2 marks]
information that is output
[1 mark]
a suitable output device.
[1 mark]
State whether the processing in the scenario above is batch, online or real-time. Provide ONE reason for your answer.
[2 marks]
State ONE other example of an automated information processing system.
[1 mark]
List THREE advantages of using an automated information processing system over the corresponding manual system.
[3 marks]
Read the following scenario and answer the questions that follow.
The BBB Company uses a computerized system for ordering items as follows:
- The data entry clerk enters the names of the items required and the amount needed on a paper-based request form.
- The data entry clerk then enters the data into the computer system.
- The administrative assistant re-enters the data from the form into the computer system.
- The computer system outputs a report indicating if data entered by the data entry clerk is the same as the data entered by the administrative assistant.
- The administrative assistant makes any corrections as necessary.
- The computer system then produces a purchase request.
[4 marks]
State
[2 marks]
the technical term for the original document in the scenario
[1 mark]
whether the original document is machine readable or human readable
[1 mark]
State the term used for re-entering the data into the system. Explain why this is a useful method.
[2 marks]
Name the file organization structure MOST suitable to access and store the purchase requests. Give ONE reason to justify your answer.
[2 marks]
Identify the storage device that is MOST suitable to store the data from the purchase requests. Give ONE reason to justify your answer.
[2 marks]
State ONE data check and explain how it can be used to confirm that the data entered is accurate.
[2 marks]
[7 marks]
State
THREE formatting features used in the document.
[3 marks]
The number of paragraphs after EACH of the following tasks is performed
<p><table> <thead> <tr> <th></th> <th></th> </tr> </thead> <tbody> <tr> <td>Paragraph 2 is moved below Abstract as the new paragraph 1.</td> <td></td> </tr> <tr> <td>Paragraph 1 is copied and placed below paragraph 1.</td> <td></td> </tr> </tbody> </table></p>[2 marks]
The reason why the word "spiralling" was underlined by the software
[1 mark]
Using the search and replace option, all occurrences of cyber are to be changed to cybercrime. State the result after this change.
[1 mark]
Consider the following table which consists of a sample of items in a supermarket, their cost and corresponding barcode.
[8 marks]
Complete the following database structure for the table above.
[3 marks]
State:
[5 marks]
The field that can be used as a primary key
[1 mark]
A suitable size for the barcode field
[1 mark]
The result of a query that finds all items that cost less than $5.00
[1 mark]
The field name and order of the sorted records in the table
[2 marks]
Study the algorithm below and answer the questions that follow.
Line 1 Total = 0
Line 2 While Total <= 5
Line 3 Prompt to enter name of subject
Line 4 IF Subject already entered
Line 5 THEN Prompt to enter another subject
Line 6 IF Total < 3
Line 7 THEN Give 5% Discount
Line 8 Total = Total + 1
Line 9 ELSE Total = Total + 1
Line 10 END WHILE
Line 11 Display Total
[5 marks]
Identify ONE line in the algorithm above which contains each item in the following table.
[5 marks]
Complete the following trace table using the algorithm on page 18.
[5 marks]
State ONE suitable data type for EACH of the following variables:
[4 marks]
STUDENTS
[1 mark]
FEESPAID 'Y'
[1 mark]
AVGMARK MARK/3
[1 mark]
GRADE[1]
[1 mark]
Identify the variable in Part (b) that is NOT an elementary data type.
[1 mark]
Consider the following algorithm.
Line 1 ** Algorithm SUBJECT_ENTRY
Line 2 Declare variables and constants
Line 3 Discount = 0.05
Line 4 Total = 0
Line 5 SubjectCode = ''
Line 6 While Total <= 5 and (SubjectCode <> 'X')
Line 7 Prompt to enter one-character code of subject
Line 8 Accept SubjectCode
Line 9 Total = Total + 1
Line 10 IF Total = 3
Line 11 THEN Display ('5% Discount Due')
Line 12 IF SubjectCode <> 'X'
Line 13 THEN Add 1 to SubjectCode
Line 14 ELSE Display the number of subjects
Line 15 END WHILE
Line 16 Display Total
Line 17 End of algorithm
Using the algorithm on page 20, complete the following Pascal program by filling in spaces (1) to (10).
subject_entry;
Const Discount = 0.05;
Var Total : (1) ;
SubjectCode: char;
Begin
Total := 0;
SubjectCode := ' ';
While (Total <= 5) and (SubjectCode <> 'X') (5)
Begin
(6) ('Enter code of subject');
ReadLn( (7) );
Total = 3;
(8)
Then WriteLn('5% discount due');
If SubjectCode <> 'X'
Then Total := Total (9)
else WriteLn(total);
End;
(10)
[10 marks]
Consider the programming code in the following table. Example 1 and Example 2 are different versions of the same instructions.
| Instruction | Example 1 | Example 2 |
|---|---|---|
| ACCEPT | ACC | 1000 |
| DISPLAY | DIS | 0111 |
| NUMBER | NUM | 1010 |
| TEXT | TEX | 0101 |
[15 marks]
State the programming language generation used in Example 2.
[1 mark]
Write the generic name of the programming language illustrated in
| Example 1 | Example 2 |
|---|---|
[2 marks]
Answer the following questions based on code written using Example 1.
ACC NUM ACC TEX DISP NUM
[7 marks]
Identify the error in the code.
[1 mark]
Correct the error by stating the code that should be used.
[1 mark]
State the technical term for EACH of the following:
[4 marks]
Rewrite the code in (c) using the instruction column in the table on page 22.
[5 marks]
The corrected code was executed. Write the output when the following data were entered by a user.
56 Passed
[1 mark]
The following one dimensional array was used to store the number of subjects studied by a group of students.
SUBJECTS: ARRAY[1..15] of integer;
[5 marks]
State: (i) The size of the array (ii) The data type of the array
[2 marks]
The size of the array
[1 mark]
The data type of the array
[1 mark]
Some of the contents of the array are illustrated in the following table.
| 4 | 3 | 6 | 5 | 5 | |
|---|---|---|---|---|---|
| ... | 7 | 8 | 9 | 10 | 11 |
[3 marks]
Write the term INDEX in the appropriate location in the table above.
[1 mark]
Explain the meaning of the numbers in the shaded column.
[2 marks]