Free CXC Information Technology Paper 2 May/June 2013 past paper from 2013. 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 2013 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 May/June 2013 past paper from 2013. 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.
Name the input or output device that is BEST suited to perform EACH of the following activities:
[5 marks]
Viewing images from one computer to another over the Internet
[1 mark]
Producing architectural drawings such as building plans
[1 mark]
Playing games using the computer
[1 mark]
Retrieving information electronically from a code on a product
[1 mark]
Identifying users by scanning their fingerprints
[1 mark]
Kim wants to purchase a printer. State TWO characteristics of printers that Kim should consider when purchasing the printer.
[2 marks]
State the general name associated with devices such as a printer.
[1 mark]
Explain what is meant by a 'bistable' device.
[2 marks]
Name TWO types of user interface.
[2 marks]
State an appropriate input device for EACH interface named in (a) (i) above.
[2 marks]
Name the type of menu illustrated in Menu A and Menu B below.
[2 marks]
Name ONE operating system.
[1 mark]
Explain ONE function of an operating system.
[3 marks]
State the computer term that is described in EACH of the following statements:
[5 marks]
Secret information is obtained by spying on competitors or opponents
[1 mark]
A malicious program that is designed to corrupt files on a computer or to cause the computer hardware to malfunction
[1 mark]
The illegal copying of programs
[1 mark]
Using another person's credit card for transactions without his/her permission
[1 mark]
Using a computer to alter company data
[1 mark]
State the technical term that describes EACH of the types of misuse of data labelled (i), (ii), (iii), (iv) and (v) as underlined in the passage below.
A commercial bank has experienced several security breaches. In one instance, an employee who was interviewed for promotion was not selected because he (i) used emails to mount a vicious attack on a supervisor. Some employees were (ii) electronically accessing other employees' systems without permission. The organization then hired a software expert to install additional software which would be able to (iii) monitor the use of the computers by employees. However, since the installation of the new software, there has been an increase in the rate at which people are able to (iv) access cash from some customers' accounts at the ATM during weekends. The computer system also allows websites to place cookies on the company's computers to (v) collect personal information on certain employees.
[5 marks]
State TWO differences between RAM and ROM.
[2 marks]
Give TWO reasons why it is necessary for computers to have secondary storage.
[2 marks]
Write the numbers (I) to (VI) in your answer booklet. Match EACH term in column X with the letter (A) to (F) that corresponds to the MOST appropriate term in column Y.
EACH term in column Y must be used only once.
(Your answer should show ONLY the Roman numerals and the corresponding letters you have chosen.)
[6 marks]
The company has been asked to use encryption.
[2 marks]
State the purpose of encryption.
[1 mark]
Suggest the type of data that the company may want to encrypt.
[1 mark]
Suggest TWO security measures that can be used to prevent an agent from viewing another agent's confidential files.
[2 marks]
State TWO precautionary measures that can be taken to protect the client data in case of a fire.
[2 marks]
Explain TWO validation checks that the company can carry out while entering data in the computer.
[4 marks]
What is the hexadecimal equivalent for the decimal number 21? [Working must be shown.]
[2 marks]
The ASCII representation for the letter 'D' is 1000100. What is the ASCII representation for the letter 'G'? [Working must be shown.]
[4 marks]
What does the acronym BCD stand for?
[3 marks]
State how many bits are represented by one digit using BCD representation.
[1 mark]
State the number of rows that are illustrated in the spreadsheet.
[1 mark]
Write the formula used to calculate the total number of students who passed Chemistry.
[4 marks]
If range A4 to F6 was sorted in ASCENDING order by subject, state the cell location of Biology after the sort.
[1 mark]
State the name of the function that should be used to find the
[2 marks]
number of subjects listed in the spreadsheet
[1 mark]
LEAST number of passes with Grade I.
[1 mark]
The following is a list of customers, money owed and phone numbers.
Jimmy Smith $355.98 654-2586 Daniel Maharaj $564.76 653-8652 Gemma Gordon $456.23 658-8693 Sarah Daniels $ 35.89 659-5781
[7 marks]
Copy and complete the following database structure to store this data in the format given.
| Field Name | Data Type | Field Description |
|---|---|---|
[3 marks]
State a field name from the list you have provided in (a) above that can be used as a primary key.
[1 mark]
Write the criteria to search the database table for all the persons who owe more than $500.00.
[2 marks]
State the feature of a database management system that prints data in a specified format with a title.
[1 mark]
Draw a flow chart to illustrate the following fragment of code:
IF THEN ELSE
[7 marks]
Copy and complete the following table using the code in (a) above.
| P | Q | P > Q? (Y or N) | PA | QA |
|---|---|---|---|---|
| 1 | 1 | |||
| 1 | 0 | |||
| 0 | 1 | |||
| 0 | 0 |
[8 marks]
Aliyah wrote the following program.
1 Program lesser;
2 Var X, Y: integer;
3
4 Begin
5 readln(X, Y);
6 IF X < Y
7 Then Writeln ('X is the smaller number')
8 Else Writeln ('Y is the smaller number');
9 End.
10
[10 marks]
Aliyah executed the program and input the number 4 for both X and Y.
State the output from the program.
[2 marks]
State the line number that produced the output statement in (a) (i) above.
[1 mark]
The output suggests an error exists. State the name of the type of error.
[1 mark]
State the line number in which the error exists and rewrite the program code that would correct the error.
[2 marks]
State the type of structure that is used in lines 7 to 9.
[1 mark]
Aliyah wants to modify the program.
[3 marks]
Write a statement to initialize the variable X to zero.
[2 marks]
State the line number in which the statement in (b) (i) above could be appropriately inserted.
[1 mark]
Consider the following array named LIST.
Rewrite the Pascal statement given below to declare an array called LIST. Replace the letters (A), (B) and (C) with the appropriate term or value.
VAR ________ (A) ________ : ARRAY [________ (B) ________] of ________ (C) ________ ;
[5 marks]
Write program statements in PASCAL to do the following:
Write a program header with the name of the program as TOTAL.
[3 marks]
Declare a variable named SUM to store whole numbers.
[4 marks]
Initialize the variable SUM to give it the value, zero.
[4 marks]
Print the value stored in the variable SUM. Ensure that the cursor is placed on the next line.
[4 marks]