Free CXC Information Technology Paper 2 May/June 2015 past paper from 2015. 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 2015 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 May/June 2015 past paper from 2015. 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.
The board of PG high school has donated a computer system to the school.
[10 marks]
State TWO additional peripheral devices that can be used with the computer system.
[2 marks]
Identify ONE way in which EACH device mentioned in Part (a) (i) above can be used.
[2 marks]
State THREE types of application software that could be used on the computer.
[3 marks]
Identify ONE way in which EACH application stated in Part (b) (i) above can be used.
[3 marks]
For EACH of the following devices, indicate the communication mode used to transmit data:
[3 marks]
Walkie-Talkie
[1 mark]
Telephone
[1 mark]
Radio
[1 mark]
Classify EACH of the following methods as (S) Software restriction or (P) Physical restriction:
[5 marks]
Use of passwords on files
[1 mark]
Biometric scanner to access a computer room
[1 mark]
Store files in fire/waterproof cabinets
[1 mark]
Encryption of files
[1 mark]
Use of a firewall once connected to the Internet and intranet
[1 mark]
List TWO ways in which sensitive data can be misused.
[2 marks]
Name the TYPE of software that performs EACH of the following tasks:
[5 marks]
Compresses the size of a file
[1 mark]
Converts program instructions into machine code one line at a time
[1 mark]
Provides a medical diagnosis based on the patient's illness
[1 mark]
Controls machine tools and related machinery in the manufacturing of car parts
[1 mark]
Contains a number of applications that run as a single program
[1 mark]
Consider the following scenarios.
Scenario 1: Raymond communicates with the computer by typing specific commands to get some tasks done. Scenario 2: Mary communicates with the computer by using the mouse to click on a picture on the screen representing the task she wants to do. Scenario 3: The cashier communicates with the computer by touching pictures on the screen representing items being sold in the store.
[10 marks]
Identify the type of user interface indicated in Scenario 1: Scenario 2: Scenario 3:
[3 marks]
Name the type of software which provides the user interface.
[1 mark]
State the scenario number which indicates a hardware interface.
[1 mark]
Answer the following questions based on the six figures shown below.
[6 marks]
Which of the figures above describe EACH of the following types of media?
[6 marks]
Magnetic storage media
[3 marks]
Optical storage media
[1 mark]
Neither optical nor magnetic storage media
[2 marks]
Which of the figure(s) use the following access methods? (i) Sequential access (ii) Direct access
[2 marks]
For each of the following, state whether it describes optical storage media or magnetic storage media. (i) More storage capacity (ii) Faster data access
[2 marks]
Write down the correct number of the task that corresponds to the device component in the spaces provided.
Sensor Joystick Pad and tablet MICR Barcode reader Modem OCR ROM Printer OMR
[10 marks]
The decimal number 53 is represented by 00110101. Find the two's complement 8-bit representation of the decimal number -53. Show all working.
[2 marks]
Find the BCD of a signed decimal number +579.
[4 marks]
The hexadecimal representation of a decimal number is 5D. Find the decimal number.
[2 marks]
The ASCII representation of the character "M" is 1001101. Determine the ASCII representation of the character "O".
[2 marks]
The Teachers' Training College has prepared a spreadsheet showing the number of teachers trained during the period 2012–2014. Answer the following questions based on the spreadsheet given below.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | TEACHERS' TRAINING COLLEGE | |||||
| 3 | ||||||
| 4 | Specialization | 2012 | 2013 | 2014 | Total | |
| 5 | Early Childhood | 300 | 600 | 800 | 1,700 | |
| 6 | Primary | 1,500 | 2,600 | 3,000 | 7,100 | |
| 7 | Secondary | 1,200 | 1,800 | 2,200 | 5,200 | |
| 8 | Technical | 150 | 320 | 540 | 1,010 | |
| 9 | Total | 3,150 | 5,320 | 6,540 | 15,010 | |
| 10 |
[7 marks]
State the cell address that contains the total number of teachers for the three years.
[1 mark]
In 2012, it cost $3,000 to train each teacher. Write a formula to compute the total cost for training teachers in 2012.
[2 marks]
What format has been applied to the numeric data in the spreadsheet?
[1 mark]
The chart below was produced from the data in the spreadsheet. <image>
<caption>Pie chart showing distribution of teachers by specialization: Technical (1,010), Secondary (5,200), Early Childhood (1,700), Primary (7,100).</caption> </image>[3 marks]
State the type of chart shown.
[1 mark]
State the range of data used to construct the chart.
[2 marks]
The Technical Council has created a database with one table named SKILL to store information on persons certified as Assessors and Trainers. Part of the database is shown below. <image>
<caption>Table named 'skill' with columns LAST NAME, FIRST NAME, SPECIALIZATION, GENDER(M/F), DOE(MM-DD-YYYY) and sample data.</caption> </image>[8 marks]
Name TWO data types used in the skill table.
[2 marks]
If the data were sorted by the DOE(MM-DD-YYYY) field in ascending order, state the last name of the person who would be at the top of the sorted table.
[1 mark]
Write a query to find all males (M) who are Assessors in the table below.
| SPECIALIZATION | GENDER (M/F) |
|---|---|
[3 marks]
How many records will be displayed in the result of the query?
[1 mark]
A report was created from the table and the records were grouped by a field. State the names of TWO appropriate fields which could be used to group the records.
[2 marks]
The Management Committee for the city has approved the following property tax charges for the next year:
Write Pascal code to do the following:
[15 marks]
Declare TWO constants which can be used in the program.
[2 marks]
Declare TWO meaningful variables which can store the data to be input to the program.
[2 marks]
Compute the property tax to be paid for property owned for 25 years. Use the variables and constants declared in Parts (a) and (b) above.
[2 marks]
In the space provided below, draw a flowchart for the program.
[9 marks]
The following represents examples of programming code from different programming languages:
EX1: X := X + 20; EX2: ADD X, 20 EX3: 1100 1110 EX4: SELECT tax FROM SALARY WHERE BONUS> 50 000
State the generation of the programming language for EACH example.
[4 marks]
State the technical term(s) for EACH of the following descriptions: (i) TWO errors which can occur when a program is executed (ii) A document which contains instructions for the user of the program (iii) An error which can occur when the source code is being compiled (iv) The process of locating and fixing errors in a program (v) Code created after a program is compiled successfully
[6 marks]
TWO errors which can occur when a program is executed
[1 mark]
A document which contains instructions for the user of the program
[1 mark]
An error which can occur when the source code is being compiled
[1 mark]
The process of locating and fixing errors in a program
[1 mark]
Code created after a program is compiled successfully
[2 marks]
A one-dimensional array named FAMILY is used to store the number of children in each of four families. Write Pascal code to do the following:
[10 marks]
Declare the array FAMILY.
[4 marks]
Assign six children to the fourth family.
[2 marks]
Initialize the variable CHILDREN to zero.
[1 mark]
Add the number of children in the four families and store the total in a variable named CHILDREN.
[3 marks]
A room is monitored by a temperature sensor and a smoke sensor. These sensors are connected to an alarm. If the temperature is too high, the alarm is sounded. If smoke is detected, then the alarm is sounded.
Suppose:
[10 marks]
Complete the following table which will determine when to sound the alarm.
| Temperature | Smoke | Sound Alarm |
|---|---|---|
| 1 | 0 | |
| 1 | 1 | |
| 0 | 0 | |
| 0 | 1 |
[4 marks]
Using the template provided below, construct a trace table to test the following segment of an algorithm:
a = 1 b = 1 WHILE (a<10) DO a = a + 3 Print a b = b + 2 Print b END WHILE
[6 marks]