Free CXC Information Technology Paper 2 May/June 2016 past paper from 2016. 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 2016 - Free CXC Past Paper with Answers
Free CXC Information Technology Paper 2 May/June 2016 past paper from 2016. 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.
Explain the difference between 'application software' and 'system software'.
[4 marks]
Categorize the following software as system or application software:
EXCEL LINUX
[2 marks]
State TWO examples of utility software and outline the purpose of EACH.
[4 marks]
A company packages 10 000 eggs per day.
State TWO advantages of using a robot (or robotic arm) over using a manual method to carry out this process.
[2 marks]
Apart from loss of jobs, state ONE disadvantage of using a robot (or robotic arm) over using a manual method.
[1 mark]
State ONE type of sensor that the robot (or robotic arm) should have. Give ONE reason why this sensor would be useful when packaging the eggs.
Sensor: Reason:
[2 marks]
A barcode sticker is placed on each package of eggs. State TWO types of data that are contained in the barcode.
[2 marks]
State ONE other industrial application that uses a robot (or robotic arm).
[1 mark]
Outline ONE job function that is critical as a result of the implementation of robotics in industry.
[2 marks]
Find the binary coded decimal representation of .
[4 marks]
The two's complement 8-bit representation of a decimal number is . What is the decimal number? Show all working.
[2 marks]
The ASCII code for the letter A is in hexadecimal. What is the binary representation of the ASCII code for the letter E? Show all working.
[4 marks]
A school has acquired ten computers and related peripherals to set up a computer laboratory. The school was advised to connect the computers and peripherals in a network.
State the type of network that should be used to link the computers and peripheral devices in the computer laboratory. Give a reason for your answer.
[2 marks]
List TWO benefits of networking the computers and peripheral devices in the computer laboratory.
[2 marks]
The school was also advised that a firewall is needed. Explain the purpose of a firewall.
[2 marks]
List TWO transmission media that can be used to link the computers in the laboratory.
[2 marks]
You need to send a file with confidential data to a friend via the Internet. List TWO measures that could be used to secure the file.
[2 marks]
State the name of the computer personnel who performs the following tasks:
(i) Maintains an organization's website (ii) Fixes and maintains computer hardware (iii) Develops web service applications for an organization (iv) Writes code to create software programs
[4 marks]
State the most suitable file access method to be used in the following applications and provide ONE reason for your answer:
(i) Payroll application (ii) Point of sale (POS) application
[4 marks]
Outline TWO differences between a website and a webpage.
[2 marks]
Data from a paper-based form are being entered into the computer by a data entry clerk. List TWO types of data entry errors which could occur.
[2 marks]
State TWO verification checks which may be done to ensure that the data entered are correct.
[2 marks]
The data entry form has a field to store the age of students attending a secondary school. Using the table below, state THREE validation checks that can be applied to the age field and explain what EACH check does.
[6 marks]
The Staff Welfare Department of an organization has prepared the following database table showing employees who would receive long service awards this year. The database table is named SERVICE.
| EmpNo | Department | Years | Award |
|---|---|---|---|
| A100 | Agriculture | 12 | Cash |
| A200 | Agriculture | 30 | Medal |
| B100 | Bursary | 16 | Cash |
| C100 | Arts | 15 | Cash |
| C110 | Library | 25 | Medal |
| L100 | Library | 22 | Certificate |
| M100 | Maintenance | 23 | Medal |
| M110 | Maintenance | 28 | Medal |
| N100 | Sciences | 18 | Certificate |
| N110 | Sciences | 14 | Cash |
State the data types for the Years and EmpNo fields in the SERVICE table.
[2 marks]
The records in the SERVICE table were sorted in ascending order on the Award field. State the EmpNo of the record that would be at the top of the sorted table.
[1 mark]
Identify TWO fields that could be used to group the records in a report.
[2 marks]
State the MOST appropriate field which could be used as the primary key. Indicate the reason for your choice.
[2 marks]
A query was created to show all employees with more than 20 years of service. How many records will be displayed when the query is executed?
[1 mark]
The following spreadsheet shows the number of workers in various sectors of the economy whose ages range from 20 to 60.
(Spreadsheet table is shown with columns: Sector, Age Group (20-29, 30-39, 40-49, 50-60), Total_sec, Percentages)
[7 marks]
The formula =F3/SF\$9 was entered in cell G3.
What type of cell referencing was used in $F$9?
[1 mark]
Explain why this type of cell referencing was used.
[2 marks]
A pie chart is to be created. Each sector (slice) of the pie chart will represent the total number of workers in the various age groups and also indicate the name of the age group. State the data range and the category labels range to be used to create the pie chart.
[2 marks]
Write the functions to find the following:
The average of the sector totals
[1 mark]
The maximum of the age group totals
[1 mark]
SECTION III PROBLEM SOLVING AND PROGRAMMING – 45 marks
Answer ALL questions.
[10 marks]
The following table shows lines of code from three types of programming languages.
Complete the table to indicate the type of programming language and the generation to which EACH sample of code belongs.
| Code | Program Instruction | Type of Language | Generation |
|---|---|---|---|
| A | Add Y | ||
| B | 89 F8 A9 01 00 75 06 6B C0 | ||
| C | X := X + Y |
[6 marks]
Insert the numbers 1 to 4 to indicate the correct steps that correspond to the following program implementation activities.
| Step Number | Activity |
|---|---|
| Compiling | |
| Creating source code | |
| Linking object code | |
| Creating executable code |
[4 marks]
Complete the following trace table using , and for the following algorithm:
Read X
Read Y
Read Z
Y = X + Y
X = X + Z
Z = X + Y + Z
Print X, Y, Z
| Line | X | Y | Z |
|---|---|---|---|
| 1 | 5 | - | - |
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 |
[5 marks]
Consider the following program segment:
Readln(salary);
If salary <= 5000 then
tax := 0
else
tax := (salary - 5000) * 0.25;
Writeln (tax);
Complete the flowchart below by writing appropriate program code from the segment above in the corresponding symbols.
[5 marks]
State the Pascal data type to store EACH of the following values:
[3 marks]
Each of the following program statements is incorrect. Rewrite each statement using correct Pascal code.
[5 marks]
What type of error would occur when EACH of the following lines of Pascal code are executed?
[2 marks]
;
[1 mark]
;
[1 mark]
Write a program named SWAP to do the following:
[15 marks]