CSEC Information Technology Paper 2 January 2026 - Free CXC Past Paper with Answers

Identify ONE difference between 'serial file organization' and 'sequential file organization'.

State the appropriate file organization method for EACH of the following scenarios.

The Transport Authority has hired a research specialist to conduct a review on road usage for the year.

Identify TWO sources of information that can be used by the research specialist.

State ONE way in which EACH of the sources of information identified in (c) (i) can be used by the Transport Authority.

The research specialist hired by the Transport Authority completed a report of findings to share with the CEO. In reviewing the report, the specialist noticed that a few paragraphs in the report were not properly structured.

Write the steps required, in the correct order, that should be taken to place the fourth paragraph above the third paragraph.

The research specialist used the formatting feature highlighted below in the report.

Identify the alignment feature selected and describe how text formatted using this alignment will be displayed.

A table of contents was placed at the beginning of the document to assist readers in locating sections within the report. List the steps required, in the correct order, to generate an automated table of contents in the document.

The completed traffic report was uploaded to the Transport Authority's website and accessed using a hyperlink. Define the term 'hyperlink'.

State THREE ways in which hyperlinks can be used on a website.

For the list of sectors in the table below, identify ONE impact of ICT and provide ONE example of how it is applied in EACH sector.

Define the term 'telecommuting' and state ONE advantage of telecommuting.

Information will be saved on a company's network both locally and online. Outline the difference between 'cloud storage' and 'local storage'.

The chief information officer (CIO) would like to implement a program that determines the total distance travelled to work by 50 employees as a test project. The program should

• accept the following data: employee's name, and employee vehicle details such as the make, model, year, petrol type (gas or diesel) and distance travelled to work (in kilometres).
• calculate the total combined distance for all the employees
• print the total combined distance for all the employees.

State ANY TWO variables and their data types required for the program.

Outline FOUR characteristics of algorithms.

Write an algorithm to create the program requested by the CIO in (d) on page 15.

Cambridge Statistics Centre collects data, manipulates and presents it to help with making decisions within the city. Differentiate between the terms 'data' and 'information'.

Cambridge Statistics Centre hired individuals within its IT department to assist in making tasks easier for the company. Complete the table below by inserting the name of the correct professions in the first column to match the description of the roles given in the second column.

The marketing team at Cambridge Statistics Centre were tasked with identifying the leading coffee shops within the city. The spreadsheet extract below shows data for the first four months of 2025 that was collected and stored.

Write the function, including the range, that can be used to determine the number of shops in the spreadsheet.

Write the function formula that would be required to display the correct

• total in Cell F5
• average in Cell G3

A chart was required to show the percentage share/sales for each coffee shop. The results are displayed below.

Chart Showing the Percentage Share for the Cambridge Centre Coffee Shops for January to April 2025

Identify the type of chart used to display the data above.

List the steps required, in the correct order, to create the chart identified in (d) (i).

State the name and corresponding percentage value of the coffee shop which had the highest sales for the quarter.

Define the term 'run-time error'.

State the difference between 'pseudocode' and 'flowchart'.

The IT Team at Cambridge Statistics Centre is required to create a program that will be used by the team to collect data from the coffee shops in Cambridge Centre for the first four months of 2025. The program should

• accept the following data: name of coffee shop, and sales for the period January to April.
• calculate the total sales for the period
• calculate the average of the sales for the period
• print the name of the coffee shop, the total sales and the sales average for the period.

Complete the following defining diagram (IPO Chart) that represents the program requirements above.

As the programmer from the IT team, you are required to write the pseudocode algorithm to instruct the program to collect the sales data for the coffee shops. Draw the flowchart for the program described in part (g)above.