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

Free CXC Information Technology Paper 2 January 2024 past paper from 2024. Includes a worked answer key. Open the PDF, take a timed test, and study with AI on Caribbean AI.

Opening the interactive papers…

CSEC Information Technology Paper 2 January 2024 Questions

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.

Question 1 (20 marks)

Dom is starting a boating business as a digital company.

[20 marks]

(a)

Complete the table below by indicating whether the following devices, recommended to start Dom’s business, are input or output.

Device	Input/Output
Plotter
Keyboard
Scanner
Printer
Microphone

[5 marks]

(b)(i)

List THREE types of networks.

[3 marks]

(b)(ii)

Dom would like his network to be wireless.

Identify ONE critical hardware component that a device needs to access a wireless network and give a reason for the hardware component identified.

Component

Question 2 (19 marks)

(a)

Use the appropriate devices from the list below to complete the table by matching the devices with their uses.

Sensor	OCR	MICR	OMR	Light pen

Devices	Uses
	Reads codes on a cheque
	Turns on the buzzer when someone approaches the door
	Marks multiple-choice responses
	Digitizes handwritten notes for editing

[4 marks]

(b)

Complete the table below by indicating whether the tasks demonstrate the verification or validation of data and state the verification or validation method used.

Task	Verification/ Validation	Method
(i) Prompts the user to enter his/her password twice when creating an online account
(ii) Ensures that the number of hours entered into a payroll system is greater than 0 but less than or equal to 40
(iii) Ensures that the registration number of a vehicle, entered into a vehicle tracking system, is in the form of three letters of the alphabet followed by three or four digits

[6 marks]

(c)

A college has made it mandatory for all students to take a self-paced online course before they can graduate. Students can take the course anytime during their program of study.

Table 1 and Table 2 are extracts from a database which stores details of students who have enrolled in the course.

TABLE 1: STUDENT

RegNo	LastName	FirstName	Sex
1030968	Paul	Mary	F
1040276	Persaud	Alan	M
1070953	Eastmond	Alicia	F
1057680	Singh	Michael	M
1033000	Alphonso	Maria	F

TABLE 2: COMPLETION

DoC	YoS	RegNo	Specialization
2021-05-11	2nd	1057680	Business
2022-03-17	3rd	1040276	Technology
2021-09-12	4th	1030968	Science
2020-03-10	1st	1070953	Science
2021-09-24	2nd	1033000	Humanities

[DoC — Date of Completion; YoS — Year of Study]

(c)(i)

State the condition which allows any field in a database to be declared a Boolean data type.

[1 mark]

(c)(ii)

Identify the field from the STUDENT table that can be used as the primary key and state the reason.

Primary key

Reason

[2 marks]

(c)(iii)

State the RegNo of the student who will be second in the sorted list, if the COMPLETION table is sorted in ascending order by the Specialization field.

[1 mark]

(c)(iv)

Table 1 and Table 2 are linked. State the

MOST appropriate field used to link the tables.
LastName of the student who completed the online course in the first year.

[2 marks]

(c)(v)

Identify the number of records that will be displayed when the query is executed.

[1 mark]

(c)(vi)

A report was created from the two linked tables. State TWO fields which could be used to group the data in the report.

[2 marks]

Question 3 (24 marks)

The following is a list of specifications for a laptop that was bought by Jane.

Intel core i5, 2.9GHz 14" Touchscreen 8 GB DDR4 512 GB SSD 1 HDMI port; 1 Ethernet port; 2 USB 3.0 ports Intel Wi-Fi card Integrated webcam Adobe Acrobat DC reader Windows 11 pro (preloaded) Google chrome MS Office 2021 LTSC (preloaded)

Identify EACH of the following in the laptop specifications.

[10 marks]

(a)

Identify EACH of the following in the laptop specifications.

[5 marks]

(a)(i)

Secondary storage

[1 mark]

(a)(ii)

Processor speed

[1 mark]

(a)(iii)

Web browser

[1 mark]

(a)(iv)

Monitor

[1 mark]

(a)(v)

The component used for connecting to the school's Internet hotspot

[1 mark]

(b)

The major exports of a country for three years are given in the worksheet below.

[5 marks]

(b)(i)

State the formatting feature applied to Row 2.

[1 mark]

(b)(ii)

State the type of cell referencing used if the formula E4/SES11 was inserted in Cell F4.

[1 mark]

(b)(iii)

Identify the product that would be in the fifth position in the sorted list if the data in the worksheet was sorted by the total column (total for three years) in descending order.

[1 mark]

(b)(iv)

Write the function you would use in Cell G8 to insert "GOOD" if the total exports for the three years is more than US$300 million or "POOR" if it is less than US$300 million.

[2 marks]

(b)(v)

The following chart was created from the data in the worksheet.

Exports: 2020-2022 [Pie chart showing 2022 34%, 2020 32%, 2021 34%]

State the type of chart shown.

(b)(vi)

State the data range used to construct the chart.

[2 marks]

(b)(vii)

State the TWO data label formats which have been applied to the chart.

[2 marks]

(c)

Consider the following algorithm used to compute the monthly income tax to be paid by an individual. The line numbers are for reference only.

Line 1. START Line 2. Set TAX $\leftarrow$ 0 Line 3. Write 'Enter your monthly pay' Line 4. Read mthpay Line 5. If (mthpay > 75000) AND (mthpay <= 200000) then Line 6. TAX $\leftarrow$ (mthpay – 75000) * 0.20 Line 7. Else Line 8. TAX $\leftarrow$ (mthpay – (0.25 * mthpay))* 0.40 Line 9. Endif Line 10. Write 'TAX :', TAX Line 11. STOP

(c)(i)

State the variable used that is of data type real.

[1 mark]

(c)(ii)

Name the type of construct used.

[1 mark]

(c)(iii)

State the line number where a relational operator is used.

[1 mark]

(c)(iv)

State the logical operator used.

[1 mark]

(c)(v)

Complete the following table by inserting the tax to be paid by John and Mary.

Name	mthpay	TAX
John	$175 000
Mary	$400 000

[2 marks]

(c)(vi)

Draw a flowchart to represent the construct used in the algorithm.

[4 marks]

Question 4 (25 marks)

Study the following pseudocode written for an algorithm. The line numbers are for reference only.

Line 1.   START
Line 2.   Set Temp ← 0
Line 3.   Set Cel ← 0
Line 4.   Set Fah ← 0
Line 5.
Line 6.   Write "Enter 1 for Fahrenheit to Celsius OR Enter 2 for Celsius to Fahrenheit"
Line 7.   Read Temp
Line 8.
Line 9.   IF Temp=1
Line 10.  THEN
Line 11.      Write "Enter Degrees Fahrenheit"
Line 12.      Read Fah
Line 13.      Set Cel ← (Fah – 32) * 5/9
Line 14.      Write Fah, "degrees Fahrenheit is", Cel, "degrees Celsius"
Line 15.  ELSE
Line 16.      Write "Enter Degrees Celsius"
Line 17.      Read Cel
Line 18.      Set Fah ← (Cel * 9/5) + 32
Line 19.      Write Cel, "degrees Celsius is", Fah, "degrees Fahrenheit"
Line 20.  ENDIF
Line 21.  STOP

[19 marks]

(a)

State exactly what the algorithm does.

[4 marks]

(b)

Complete the input processing output (IPO) chart below for the pseudocode from (a) on page 16.

Input	Processing	Output

[4 marks]

(c)

The pseudocode for the algorithm on page 16 is to be amended to use a FOR loop construct, enabling the algorithm to do exactly ten calculations before it terminates.

[3 marks]

(c)(i)

Using a new variable "number" as the loop counter, write the TWO pseudocode statements needed to achieve this.

[2 marks]

(c)(ii)

State ONE reason why the FOR loop is the most appropriate loop construct to use in this scenario.

[1 mark]

(d)

Using the variable "number" as the loop counter, write the FOUR pseudocode statements for a REPEAT...UNTIL loop construct, to enable the algorithm to do exactly ten calculations before it terminates.

[4 marks]

(e)

Jane wants to establish a wired network with desktop computers spread across all floors of the office building. List FOUR hardware devices that Jane will need to accomplish this task.

[4 marks]

(f)

Distinguish between the terms, the 'Internet' and the 'World Wide Web (WWW)'.

[2 marks]

(g)(i)

State what the acronym URL represents.

[1 mark]

(g)(ii)

Consider the URL https://cxc.org/student-results. Complete the table below by giving a description of the three parts of the URL.

Parts of URL	Description
https:
//cxc.org
/student-results

[3 marks]