CXC CSEC Electronic Document Preparation and Management — Paper 2 (Practical)

Total marks: 60 · Duration: 120 minutes

Instructions to candidates

• Answer ALL questions in BOTH Section A and Section B.
• Write your answers in the spaces provided in this booklet.
• All written responses must be legible. Work that cannot be read will not be marked.
• You MUST have access to a computer with word processing, spreadsheet, database, and presentation software for the duration of this examination.
• Save ALL electronic files using your candidate number as the filename prefix (e.g., 123456_Task1.docx).
• Submit ALL electronic files to the invigilator on the storage device provided before leaving the examination room.
• Section A is worth 36 marks; Section B is worth 24 marks.
• Scientific calculators may be used.

Paper

Section A — Structured Questions (36 marks)

Question 1

Caribbean Star Airlines is implementing a new electronic document management system for its regional offices in Jamaica, Trinidad, and Barbados.

(a) Define the term metadata as it relates to electronic document management. (2 marks)

(b) Explain TWO reasons why version control is important when multiple employees collaborate on flight safety documents. (4 marks)

(c) The airline stores passenger manifests, crew schedules, and incident reports electronically. State THREE security features that should be implemented to protect these documents from unauthorized access. (3 marks)

(d) Describe how a hierarchical folder structure would help the airline organize documents more efficiently than storing all files in a single location. (3 marks)

Question 2

The following data shows monthly sales figures (in thousands of Eastern Caribbean dollars, EC$) for Sunshine Supermarket across three branches:

(a) State the most appropriate type of chart to display trends in monthly sales for ALL three branches on a single visual. (1 mark)

(b) Calculate the total sales for the Castries Branch over the four-month period. Show your working. (2 marks)

(c) Using spreadsheet terminology, write the formula you would enter in cell E2 to calculate the average monthly sales for the Castries Branch across the four months. Assume the sales data for Castries Branch occupies cells B2:B5. (2 marks)

(d) Explain why using a 3D pie chart would be an inappropriate choice for presenting this data. (2 marks)

(e) The supermarket manager wants to identify which branch had the highest sales in March. Describe how the Sort function in a spreadsheet application could be used to accomplish this task. (3 marks)

Question 3

You have been asked to create a mail merge document to send personalized letters to 250 customers of Island Hardware Limited informing them of a special promotion.

(a) State TWO software applications required to complete a mail merge operation. (2 marks)

(b) Explain the purpose of the data source in a mail merge process. (2 marks)

(c) The data source contains the following fields: CustomerID, Title, FirstName, LastName, Address, City, EmailAddress, PurchaseHistory.

Write the merge field code that would insert the customer's title and last name in the salutation of the letter (e.g., "Dear Mr. Thompson"). (2 marks)

(d) Describe TWO advantages of using mail merge instead of manually creating 250 individual letters. (4 marks)

Question 4

Grenada Ministry of Education requires all secondary schools to submit their annual reports as PDF documents via email.

(a) State TWO reasons why PDF format is preferred over word processing formats (such as .docx) for official document submission. (2 marks)

(b) Explain what is meant by file compression and why it is useful when emailing large documents. (3 marks)

(c) A school administrator attempts to email a 15 MB PDF file but receives an error message stating "File size exceeds limit."

Suggest TWO methods the administrator could use to successfully send the document to the Ministry. (4 marks)

Section B — Extended Response (24 marks)

Question 5

Caribbean Spice Exports Ltd. is a Trinidad-based company that exports seasonings and sauces to North America and Europe. The company currently maintains paper-based records for:

• Product inventory
• Customer orders
• Supplier invoices
• Shipping manifests
• Employee timesheets
• Quality control reports

The Managing Director is considering transitioning to a fully electronic document management system.

(a) Discuss the benefits AND challenges Caribbean Spice Exports Ltd. would face in transitioning from paper-based to electronic document management. Your answer should address:

• Storage and retrieval efficiency
• Security and backup considerations
• Cost implications
• Staff training requirements
• Legal compliance with international trade regulations

(12 marks)

(b) The company plans to implement a database system to manage customer orders. Evaluate the extent to which a database management system would be more effective than using spreadsheet software for this purpose. (12 marks)