Free CXC Information Technology Paper 2 May/June 2011 past paper from 2011. 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 2011 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 May/June 2011 past paper from 2011. 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 hardware component that performs EACH of the following functions:
[3 marks]
Performs calculations and/or comparisons
[1 mark]
Holds the data and programs that are currently being used by the Central Processing Unit (CPU)
[1 mark]
Contains instructions that are used during the booting of the computer
[1 mark]
Mike bought a notebook computer with the following specifications:
| Intel® Atom Processor® N270 (1.6GHz/533MHz FSB/512K cache) | | 1GB DDR2 SDRAM | | 10.1" Widescreen Display (1024 x 600) | | Intel Graphic Media Accelerator (GMA) 950 | | 160GB, 2.5 inch, 5400RPM SATA Hard Drive | | 3 USB Ports | | Wireless 802.11g (1397) Mini Card | | 24WHr Lithium-ion Battery (3-cell) |
Using the computer specifications listed above, state the specifications for EACH of the following components:
[5 marks]
Type, capacity and speed of the hard drive
[3 marks]
Memory capacity
[1 mark]
Resolution of the display
[1 mark]
Indicate the type of method used to access data for the following:
[2 marks]
Hard drive
[1 mark]
Magnetic tape
[1 mark]
Match EACH of the following applications with the most appropriate device. In your answer booklet write the application number with the device letter next to it to indicate your choice.
| Application No. | Application | Device Letter | Device |
|---|---|---|---|
| 1 | Cheque Processing | A | Biometric systems |
| 2 | Point-of-sale | B | Joystick |
| 3 | Security | C | Plotter |
| 4 | Games | D | Magnetic ink character recognition |
| 5 | Architectural Design | E | Bar code reader |
[5 marks]
Consider the following scenarios:
Scenario 1: Mike communicates with his computer by typing in specific commands using a specific language to get tasks done.
Scenario 2: Mary communicates with her computer by using the mouse and selecting pictures representing tasks.
[5 marks]
Name the type of interface indicated in EACH scenario.
[2 marks]
Which of the above interfaces is MORE user friendly for someone who is learning to use a computer?
[1 mark]
State the type of program that provides the user interface.
[1 mark]
Name ONE type of interface other than those named in (b) (i) above.
[1 mark]
An organisation has bought a software package containing several applications to be used in the various departments of the organisation.
[3 marks]
State the name of this type of software package.
[1 mark]
Give ONE advantage and ONE disadvantage of using this type of software package.
[2 marks]
State the type of processing that is BEST suited for EACH of the following tasks:
[2 marks]
Processing of monthly electricity bills
[1 mark]
Processing of airline reservations
[1 mark]
Convert Octal 243 to decimal, binary and hexadecimal.
[3 marks]
Convert to Binary Coded Decimal (BCD).
[2 marks]
A landscape gardening company has six employees who work in the main office. Each employee has a stand-alone computer system and printer to use for his/her daily tasks. It was recommended that it would be more efficient if the six computers were networked.
Explain what is meant by a 'network'.
[2 marks]
Describe TWO benefits of networking the computer systems in the office.
[2 marks]
State, with reasons, whether the network among these employees in the office would be an intranet, extranet, or internet.
[2 marks]
Describe TWO security measures that would protect the computers and data from unauthorised access.
[2 marks]
Identify TWO ways in which employees in the office can contact gardeners who are on a job.
[2 marks]
A local agent leaves a catalogue and order sheet for homeowners, and checks on the order a week later. The agent sends the details of the goods ordered to the Head Office where they are processed. The completed order is returned to the agent who distributes the goods and collects payment.
Describe TWO methods homeowners may use to get their orders to the agent each week. State ONE disadvantage of EACH method.
[4 marks]
Operators at Head Office enter the orders, where they are validated and verified.
[6 marks]
Explain how the orders can be verified.
[2 marks]
Describe briefly TWO validation checks that might be carried out on an agent's order.
[4 marks]
You have recorded some interviews and stored them on two devices. The devices below show the lengths of the interviews stored in minutes:
Device A: 98, 84, 105, 39, 31, 78, 109 Device B: 31, 39, 78, 84, 98, 105, 109
State which of the devices has the interviews ordered sequentially, and explain your choice.
[2 marks]
You have just recorded another interview which is 63 minutes long. Re-write the two lists showing the result after saving this interview to the two devices.
[2 marks]
The 39-minute interview was poorly recorded and needs to be deleted. Explain the process of deleting this interview from Device B.
[3 marks]
Consider the diagram below which illustrates a method of file organisation.
[3 marks]
State the type of file access that is illustrated in the diagram.
[1 mark]
Write the index and keys that are used to locate Calypso.
[2 marks]
Answer the following questions based on the spreadsheet given below:
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | FIRST | LAST | STATUS | YEARS | RATE | FEES |
| 2 | Ray | Charles | Junior | 3 | 100 | $300.00 |
| 3 | Imran | Ally | Junior | 4 | 100 | $400.00 |
| 4 | John | Persaud | Senior | 5 | 200 | $1,000.00 |
| 5 | Michael | Scott | Senior | 6 | 200 | $1,200.00 |
| 6 | Mary | Allen | Senior | 7 | 200 | $1,400.00 |
| 7 | TOTAL |
[7 marks]
Junior members are charged a rate of 100 while senior members are charged a rate of 200. Write a function in Cell E2 that would insert the correct rate.
[2 marks]
Write the function that would be appropriate for Cell F7.
[2 marks]
State the numeric data format which has been applied to Column F.
[1 mark]
The data in the spreadsheet have been sorted by a primary field and then by a secondary field. List the primary and secondary field.
[2 marks]
The Office of Investment uses a database named FOREIGN with two tables shown below to store data on foreign companies operating in the country.
| CID | Name | Sector | Ccode | Employees |
|---|---|---|---|---|
| A200 | BJ | Petroleum | CA | 75 |
| M200 | CMX | Mining | RI | 120 |
| M100 | FEDCO | Electricity | US | 190 |
| A100 | TPL | Agriculture | TT | 230 |
| T100 | ATM | Telecommunications | US | 550 |
| Ccode | Cname |
|---|---|
| US | United States of America |
| CA | Canada |
| TT | Trinidad and Tobago |
| RU | Russia |
[8 marks]
State the data type of the Sector and Employees fields of the COMPANY table.
[2 marks]
Identify a primary key for the COMPANY table.
[1 mark]
The records in the COMPANY table are sorted. Indicate the field name and the order of the sort.
[2 marks]
State the name of the field that would be used to join the two tables.
[1 mark]
Write a query to find ALL companies with over 200 employees in the Telecommunications sector.
[2 marks]
The following are some rules for passing a course:
[10 marks]
Copy and complete the following table in your answer booklet:
[4 marks]
State the TWO boolean values that are used to test the rules in part (a).
[1 mark]
Write pseudocode to represent the rule that states if BOTH tests are passed then award Grade P.
[5 marks]
A Pascal program contains 10 integers in an array named LONG. Assume that the array and all variables are already initialised.
Write a program fragment to print:
[15 marks]
the sum of the integers
[7 marks]
all integers smaller than the integer nine.
[8 marks]
Copy and complete the trace table to find the result of the following algorithm.
Start = 2 Finish = 4 Result = 0 For number = 1 to Finish do Result = Result + Number End For Output 'The answer is', result
[5 marks]
State the value of the variable Finish.
[1 mark]
What is the purpose of the algorithm?
[1 mark]
Mya's teacher looked at her Pascal program and said that she should consider using conditional branching in a section of the looping structure. She also suggested that Mya debug the rest of the program, declare meaningful variables, and initialise more variables, as well as use more internal documentation, or Mya will lose marks.
For EACH of the following, explain and give ONE example to illustrate what is meant by
[15 marks]
conditional branching
[3 marks]
looping structure
[3 marks]
debug a program
[3 marks]
declaring and initialising variables
[3 marks]
document a program.
[3 marks]