Free CXC Information Technology Paper 2 May/June 2012 past paper from 2012. 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 2012 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 May/June 2012 past paper from 2012. 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.
Rearrange the following units of storage in order of size with the SMALLEST at the top:
[4 marks]
What is the meaning of the term 'bit'?
[1 mark]
How was the term 'bit' derived?
[1 mark]
Explain ONE difference between a 'word' and a 'byte'.
[2 marks]
Explain the term 'bi-stable device'.
[2 marks]
Write the output devices listed below in your answer booklet. Write the appropriate related task next to EACH output device.
| Output Devices | Tasks |
|---|---|
| (i) VDU | Draw a house plan |
| (ii) Headphones | Print cheques |
| (iii) Plotter | Output individual audio responses in a language lab |
| (iv) Printer | Output video |
[4 marks]
Give ONE situation when it would be better to use
an impact printer instead of an ink jet printer. State ONE reason to justify your answer.
[2 marks]
a laser printer instead of a dot matrix printer. State ONE reason to justify your answer.
[2 marks]
a page printer instead of a character printer. State ONE reason to justify your answer.
[2 marks]
State THREE functions of an operating system.
[3 marks]
Use the items below to answer (b) (i) – (b) (iv).
Select from the list above, ONE item that serves as an example for EACH of the following software.
System software
[1 mark]
Operating software
[1 mark]
General purpose software
[1 mark]
Integrated software
[1 mark]
Explain why it is necessary to customize certain types of software and give ONE example of customized software.
[3 marks]
Name the THREE types of cabling shown in Figure 1.
[3 marks]
Identify TWO types of wireless media.
[2 marks]
Write the types of network listed below in your answer booklet. Write the associated application next to EACH network.
| Network | Application |
|---|---|
| (i) LAN | A network connecting computers in a university campus |
| (ii) WAN | A network connecting computers in a secondary school |
| (iii) MAN | A network connecting computers in a country |
[3 marks]
What is the meaning of the term 'modem'?
How was the term 'modem' derived?
[1 mark]
The table below lists job titles of computer professionals and tasks. Write the job titles of the computer professionals in your answer booklet. Write the task performed by EACH professional next to the correct job title.
| Computer Professional Job Title | Task |
|---|---|
| (i) Network administrator | Develops schema |
| (ii) Systems programmer | Identifies functional requirements |
| (iii) Programmer | Maintains programs |
| (iv) Systems analyst | Installs WAPs |
| (v) Database administrator | Replaces hard drives |
| (vi) Computer technician | Installs utilities |
[6 marks]
The table below lists different types of technology and professions. Write the professions in your answer booklet. Write the technology associated with EACH profession next to the correct profession.
| Profession | Technology |
|---|---|
| (i) Music | Biometrics |
| (ii) Law enforcement | Multimedia |
| (iii) Engineering | MIDI |
| (iv) Training | Sensors |
[4 marks]
Identify ONE error that can occur during the data collection phase.
[1 mark]
Identify ONE error that can occur during the data capture phase and describe how this type of error can be reduced.
[2 marks]
Before the merged data can be used to generate reports it must be validated. State the meaning of the term 'validation'.
[1 mark]
Name and describe THREE checks that can be used to validate the data.
[6 marks]
Students preparing for an international music examination must pass an internal assessment (IA) component to be eligible to sit the final examination. The IA consists of one assignment worth 20 marks, one test worth 20 marks and one practical exercise worth 20 marks. To pass the IA, students must obtain 60% or above over a total of 60 marks. The marks earned by five students for the IA are shown in the spreadsheet below.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Name | Assignment (20) | Test (20) | Practical (20) | Total IA (60) | % of Total IA | Status |
| 2 | Smith | 15 | 12 | 13 | |||
| 3 | Allen | 12 | 11 | 12 | |||
| 4 | Persaud | 16 | 12 | 14 | |||
| 5 | Mohamed | 10 | 12 | 15 | |||
| 6 | Harewood | 14 | 15 | 11 |
[7 marks]
State the name of the student who will be at the top if the data in the spreadsheet are sorted in descending order by the Total IA marks.
[1 mark]
Write the function in cell E4 to compute the Total IA marks obtained by Persaud.
[2 marks]
If a student scores 60 % or above on the IA the student is given a status of 'Eligible' while for any mark below 60%, the student is given a status of 'Not Eligible'. State the function that will be inserted in cell G6 to indicate the status of student Harewood.
[3 marks]
A pie chart was created to show the names of the students and the percentage scores they obtained on the IA. State the data range used in the chart.
[1 mark]
The TECHVOC unit of the Ministry of Labour uses a database with two tables to store information on the number of uncertified persons with technical skills in the various areas of the country. The data in the two tables are shown below.
| AREA_ID | AREA_NAME |
|---|---|
| B1 | Corriverton |
| B2 | New Amsterdam |
| D1 | East Coast |
| D2 | Georgetown |
| E1 | Supernaam |
| E2 | Anna Regina |
| SKILL | AREA_ID | UNCERTIFIED |
|---|---|---|
| Mechanic | D2 | 120 |
| Mason | E1 | 100 |
| Mason | D2 | 60 |
| Carpenter | E2 | 45 |
| Welder | D1 | 30 |
| Mason | B1 | 25 |
| Mechanic | B2 | 25 |
| Carpenter | B1 | 20 |
[8 marks]
List TWO data types used in the SKILL table.
[2 marks]
Write a query to show all areas with MORE THAN 50 uncertified masons and indicate how many records would be in the output of the query.
[3 marks]
State the number of uncertified persons in New Amsterdam.
[1 mark]
On which field is the SKILL table sorted?
[1 mark]
A report was generated for the SKILL table and the records were grouped by a field. State the name of ONE appropriate field that can used to group the records.
[1 mark]
Answer ALL questions.
[15 marks]
Categorize the following pseudocode statements as input, processing, or output.
S1 Accept S2 Add two numbers S3 Calculate percentages S4 Prompt the user S5 Read a character S6 Write a result
[6 marks]
Copy and complete the following truth table where 1 represents 'Good at' and 0 represents 'Not good at'.
| Homework | Studying | Homework AND Studying | Determination | Homework AND Studying AND Determination |
|---|---|---|---|---|
| 1 | 1 | 1 | ||
| 1 | 0 | 1 | ||
| 0 | 1 | 0 | ||
| 0 | 0 | 0 |
[9 marks]
In the column for 'studying', explain what '0' represents.
[1 mark]
Each Play Station III game has a tax of 10% added to its cost to calculate the final price. Write Pascal code to
[10 marks]
declare the tax value
[3 marks]
declare TWO variables
[3 marks]
calculate the final price of a game.
[4 marks]
Rewrite the following fragment of code using the control structures below.
For count := 1 to 10 DO
Begin
read (count);
End;
[8 marks]
While loop
[4 marks]
Repeat Loop
[4 marks]
Complete the following two sentences by replacing the letters A, B, C, D and E with the appropriate programming terms.
Shadwayne (A) the program to see if it was grammatically correct, meaning no (B) errors, that it did what it was intended to do, meaning no (C) errors, and that it produced some results, meaning no (D) errors. If there were errors, he would then (E) the program to locate and correct these errors.
[5 marks]
THREE of the following statements describe external documentation. Identify them and write the corresponding numbers in your answer booklet.
D1: Includes frequently asked questions D2: Makes it easier to read and understand the program D3: States the version of the program and the installation procedure D4: Suggests how users should use the program such as starting or exiting the program D5: Use of indentation
[2 marks]
Consider the following program in Pascal, and answer the questions that follow.
PROGRAM IRG;
VAR ALPH: ARRAY[1..3] OF CHAR;
Let : CHAR;
Inc : INTEGER;
BEGIN
Inc := 0;
Let := 'G';
FOR Inc := 1 TO 3 DO
ALPH [Inc] := Let;
FOR Inc :=1 TO 3 DO
Writeln(ALPH [Inc]);
END.
[5 marks]
State the name of the program.
[1 mark]
State the name of the array.
[1 mark]
State the size of the array.
[1 mark]
What is the output when the program is executed?
[2 marks]