CSEC Information Technology Paper 2 May/June 2023 - Free CXC Past Paper with Answers

Question 2 (20 marks)

< ![CDATA[Ali and Raffy are working together to create the lyrics of a song. They are not experts at using technology and need your assistance with completing certain tasks.

(a)

Ali typed the first verse in a document saved as VERSES, while Raffy typed the chorus in another document saved as BRIDGE. State TWO features that would produce a new document containing both the verse and the chorus.

[2 marks]

(b)

State the purpose of including the comments feature in a document.

[1 mark]

(c)

After making updates to the lyrics, identify the feature that should be used to ensure that the document is regularly updated.

[1 mark]

(d)

Suggest to Ali and Raffy the BEST feature to use to ensure that no one can view the content of their document.

[1 mark]

(e)

Suggest the feature which both Ali and Raffy could use to see updates/amendments made to the lyrics by each other.

[1 mark]

(f)

Raffy used a fillable electronic form to complete the payment option for an online music course.

[6 marks]

(f)(i)

The fillable electronic form was created using various content controls. Identify FOUR labels and their associated content controls.

Label	Content Control
1.
2.
3.
4.

[4 marks]

(f)(ii)

The fillable electronic form is designed for a graphical user interface (GUI). State TWO advantages of using a GUI instead of a command line interface.

[2 marks]

(g)

Ali and Raffy were discussing the approaches to prevent and detect incorrect data entry. Complete the following table by inserting the definition of EACH approach and giving TWO examples of each.

Approach	Definition	Example
Validation		1.
		2.
Verification		1.
		2.

[8 marks]

Question 3 (25 marks)

The Ministry of Transport has captured data on the amount of traffic using the highway during the day. This data is transmitted from the tollbooths to the headquarters using the network. Use the Highway Traffic Monitoring Data shown in the table below to answer the questions that follow.

[5 marks]

(a)

Write spreadsheet formulae or functions to calculate EACH of the following.

[4 marks]

(a)(i)

The total traffic observed at 11 AM

[2 marks]

(a)(ii)

The total road tax owed if every car that crosses the highway pays $5

[2 marks]

(b)

State the spreadsheet feature that allows a user to summarize and manipulate data without making changes on the worksheet.

[1 mark]

(c)

State the function that has produced the values in Column H, with field heading ANS.

[1 mark]

(d)

The syntax for the VLOOKUP function is = VLOOKUP (P1, P2, P3, P4). State exactly what EACH of the four parameters in the VLOOKUP function represents.

P1 P2 P3 P4

[4 marks]

(e)

Consider the following algorithm.

Accept total_vehicles If total_vehicles is greater than 500 Then print “Toll Free” Otherwise print “Pay Toll”

Identify EACH of the following.

(e)(i)

The type of algorithm shown

[1 mark]

(e)(ii)

ONE variable

[1 mark]

(e)(iii)

The type of branching used

[1 mark]

(f)

Use the algorithm in (e) to create the following input-processing-output chart.

Input	Processing	Output

[4 marks]

(g)

You need to use a dry run to test the algorithm for correctness.

List THREE numbers that could be used to adequately test many aspects of the algorithm.

[3 marks]

(h)

Define the term 'wide area network' (WAN).

[2 marks]

(i)

The traffic data can be viewed by clicking a hyperlink on the ministry's homepage. Name the TWO basic parts of a hyperlink.

[2 marks]

(j)

State the MOST important aspect that must be considered when assessing the impact of automation on job security.

[1 mark]

Question 4 (24 marks)

The payroll department of an organization stores information on employee salaries in a database. Salary amounts are then uploaded electronically to each employee's bank account. A payroll clerk enters data or searches for information on full-time or part-time employees.

(a)

State the job title given to the computer-related personnel who would be responsible for ensuring the integrity and security of the database.

[1 mark]

(b)

For EACH of the following scenarios, identify ONE type of computer misuse that is described and state whether an individual or the company is impacted.

(i) Employees in the payroll department were unable to log on to upload the payroll files. Misuse Impact

(ii) An employee was caught emailing directors' salaries to a competing company. Misuse Impact

[4 marks]

(c)

The computer-related personnel wish to use encryption to mitigate against interception. Explain how encryption protects data when it is being transmitted.

[2 marks]

(d)

Identify EACH of the following cyber threats for the given counter methods in the table below.

| Cyber Threat | Counter Method
<questions>

<![CDATA[Raffy used a fillable electronic form to complete the payment option for an online music course. **MUS-ERA ONLINE SHORT COURSE** Click to enter first name and last name. Payment Method: Credit Card Amount Due: 49.95 Card Number: [text boxes] Payment Schedule: [checkbox] Full Payment [checkbox] Monthly Expiry Date: [text box] Select card expiry date. [Button] Continue ->

[2 marks]

(e)

A file with the following information for the payment of salaries was prepared for upload.

CheckNum	StaffID	BankCode	FirstName	LastName	Full-Time	Hours	Salary
63120104	8912	112	Linda	Montre	Y	25	2500
63120105	2359	156	Blu	Handle	N	25	750
63120106	1107	112	Windy	Longe	Y	17	1750
63120107	7011	156	Topla	Black	Y	2500
63120108	4529	189	Paige	White	N	15	550
63120109	1203	189	Austral	Hunt	Y	17	1875
63120110	1432	156	Atticus	Byrd	Y	25	2500

State the data types of EACH of the following variables in the table below.

(e)(i)

StaffID

[1 mark]

(e)(ii)

After the algorithm was converted to a working program, two types of documentation were created as shown in the following examples.

Identify the TWO types of documentation shown in the examples above.

[2 marks]

(e)(iii)

Salary

[1 mark]

(f)

State the file access method which would be used to load the salary data from the file in (d).

[1 mark]

(g)

Categorize EACH of the following activities in the table below as either input, processing or output.

[3 marks]

(g)(i)

Calculate the salary.

[1 mark]

(g)(ii)

Print salary slip.

[1 mark]

(g)(iii)

Enter the StaffID.

[1 mark]

(h)

In writing an algorithm with the information in (d) on page 15 as input, state the fields that can be used as criteria to determine employees who are part-time.

[2 marks]

(i)

If the algorithm mentioned in (d) (iv) was produced, state why StaffID would be the MOST suitable field to determine the field organization method used to read the file.

[1 mark]

(j)

The following is a flowchart of an algorithm illustrating the steps used to upload employees' salaries to their banks.

For EACH statement in the following table, state ONE example from the algorithm.

[4 marks]

(j)(i)

Initialization

[1 mark]

(j)(ii)

Condition

[1 mark]

(j)(iii)

Processing

[1 mark]

(j)(iv)

Output

[1 mark]

CSEC Information Technology Paper 2 May/June 2023 Questions

Question 1 (18 marks)

Question 2 (20 marks)

Question 3 (25 marks)

Question 4 (24 marks)