CARIBBEAN FOOD AND DRINK FESTIVAL 2025

CANDIDATE NAMES:

CANDIDATE NUMBER:

CENTRE NAME: Iere High School

CENTRE NUMBER: 160029

YEAR OF EXAMINATION: 2022

SUBJECT: Information Technology

TITLE OF PROJECT: Caribbean Food & Drink Festival 2022

TEACHER: Curt Ramnarine

TERRITORY: Trinidad & Tobago

1
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Contents
WORD PROCESSING.........................................................................................................................................................12
WEB PAGE DESIGN........................................................................................................................................................... 19
SPREADSHEET SECTION............................................................................................................................................... 22
DATABASE SECTION........................................................................................................................................................ 27
PSEUDOCODE ALGORITHM DEVELOPMENT..................................................................................................35

2
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

CARIBBEAN FOOD & DRINK FESTIVAL

2020

BACKGROUND
Food festivals are popular attractions in many countries worldwide. Food in the Caribbean
is influenced by many other countries: this makes the Caribbean and increasingly popular
destination for any foodie or food travel lover. Over the past decade, may international travelers
have planned their vacations to coincide with at least one major food festival. Some of the festival
where ‘foodies’ have enjoyed the cuisine of the region include the Caribbean Food and Wine
Festival (Providenciales), Barbados Food and Wine and Rum Festival (Barbados), Cayman
Cookout (Cayman Islands) and Saborea Puerto Rico: A Culinary Extravaganza (Puerto Rico).
These food and drink festivals have afforded travelers the opportunity to taste some of the local
dishes, as well as versions of international dishes of the Caribbean.
A major challenge, however, if the absence of proper coordination among the various
territories, resulting in travelers being unable to island hop and experience multiple food festivals
during their Caribbean trip.

DESCRIPTION OF THE PROJECT

A group of tourism interests in 10 Caribbean islands – Anguilla, Barbados, Barbuda, Bequia, Nevis,
Puerto Rico, St Maarten, Turks and Caicos, Tortola and Tobago - has collaborated to plan for the
staging of the inaugural Caribbean Food and Drink Festival from October 10 to November 26,
2025. You are required to utilise suitable word processing, web design, spreadsheet,
database management as well as programming tools to design and implement computer-
based solutions to the tasks involved in the event planning process.

WORD PROCESSING ASSIGNMENT

You are required to prepare two documents for dispatch to potential sponsors:
 An event brief that summarises the festival events
 A fillable form for sponsors to complete and return.

TASK A - EVENT BRIEF

1. Prepare a four-page event brief that includes:

i. The need for the event
ii. A brief geographic profile of each participating island, a well-formatted table containing
the draft schedule of the event dates, and
iii. A brief description of the two sponsorship packages: Tier 1 (US$50,000) and Tier 2
(US$25,000). The document should be made ready for presentation by adding a cover

3
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

page with table of contents and an image. Pages should be numbered; use the following
to guide your design with headings and sub-headings:

Cover page
Table of Contents
The Need
Col 1 Col 2

Schedule
of
Ten Events

Country Profiles
Country 1
Country 2
Country 3
Country 4
Country 5
Country 6
Country 7
Country 8
Country 9
Country 10
Sponsorship
Tier 1
Tier 2

1. Include a footnote on the last page (the Sponsorship page) to indicate that the ‘Sponsorship
Expression of Interest Form’ is available on the website at www.cfdf2025.biz.
2. Ensure that you appropriately utilise the text formatting and page layout features to
produce a well-laid out and easy-to-read document.
3. Print out the document, store it in your SBA folder and update your submission checklist.

4
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

TASK B - FILLABLE FORM

1. Create a fillable form with the title:

Caribbean Food and Drink Festival 2025 Sponsorship Expression of Interest

The form should be clearly laid out and easy to use and should capture the following data:
(i) Name of organisation
(ii) Name, email address and telephone number of the contact person
(iii)Sponsorship
(a) Select events being sponsored
(b) Sponsorship level – Tier 1 or Tier 2 – for each event selected
(iv)Date of application.

2. Print out the form document

3. Create and print out a screenshot showing the from in Design mode.
4. Store the printouts in your SBA folder and update your submission checklist.

WEB DESIGN ASSIGNMENT

You are required to prepare a single informational web page for tourists who might wish to attend
the festival as well as for potential sponsors.

TASK A - EVENT WEBSITE

1. Create a web page that will contain the following information:

(i) Event logo and title of the event
(ii) A navigation section
(iii) Background to the event
(iv) Hyperlink to the email address of the event office: [email protected]
(v) Hyperlink to the sponsorship Expression of Interest Form.

2. Print out the web page document.

3. Create and print out a screenshot showing a hyperlink to a web browser.
4. Store the printout in your SBE folder and update your submission checklist.

5
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

SPREADSHEET ASSIGNMENT
You are required to design a spreadsheet worksheet and enter the data submitted on the
Sponsorship Expression of Interest Form.
On a second worksheet enter your own ‘Location/projected attendance’ data.
On a third worksheet calculate the projected event deficit or surplus. Produce the required charts to
support the presentation of the financial report at the Quarterly Event Planning Meeting.

Suggested Values:
 Entry fee: $40
 Number of sponsors responding from 10 to 20
 Proportion of sponsors in each tier (1 and 2) varies between 40 and 60%.

Base Data:

Location Projected Attendance

Anguilla 725
Barbados 4,100
Barbuda 600
Bequia 1,780
Nevis 600
Puerto Rico 5,400
St. Maarten 3,700
Tobago 1,800
Tortola 1,725
Turks and Caicos 1,125

Table 1 Projected attendance for the events

Calculations you will need:

 Gate receipts per location = projected attendance * entry fee
 Total gate receipts = sum (gate receipts per location)
 Sponsorship value = (fee for tier)
 Total sponsorship = sum (sponsorship value)
 Total income = (total sponsorship + total gate receipts)
 Venue expenditure = venue expenses (the expenses for each venue are 25% of the entry
fee)
 Advertising expenditure = $200,000
 Administration expenditure = $150,000
 Total expenditure = (venue expenditure + advertising expenditure+ administration
expenditure)
 Surplus/deficit = all income from event - all expenses from event

6
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

TASK A - SPREADSHEET DESIGN & CONSTRUCTION

1. Create a worksheet (named Sponsorship) that accepts and stores the data provided on the
Sponsorship Expression of Interest Forms: organisation, a contact name, email, telephone
number, H location, number of events sponsored at Tier 1 and the number of events
sponsored at Tier 2.
2. Insert a column that shows the results of the calculation of the sponsorship value.
3. Create a formula to sum the total sponsorship
4. Create a formula to show the average sponsorship
5. Create a formula to show the maximum sponsorship
6. Print out the Sponsorship worksheet
7. Print out the sponsorship worksheet showing all formulae.
8. Create a second worksheet (named Location) that accepts and stores data like that shown in
table 1.
9. Insert a column that shows the results of the calculation of the gate receipts per location.
10. Create a formula to sum the total gate receipts.
11. Print out the Locations worksheet.
12. Print out the Locations worksheet showing all formulae.
13. Create a worksheet (named Accounts) that copies (links) the total gate receipts and the
total sponsorship from different worksheets and use a formula to calculate the total
income.
14. Enter the data for the expenditure and create a formula to calculate the venue expenses
and the total expenditure.
15. Create a formula to calculate surplus/deficit.
16. Print out the Accounts worksheet.
17. Print out the Accounts worksheet showing all formulae
18. Store the printouts n your SBA folder and update your submission check list.

TASK B - Sorting, Extracting and Summarising Data

1. Sort the data in the Sponsorship worksheet by the name of the organisation (in ascending
order).
2. Print out the sorted Sponsorship worksheet showing sorting.
3. In the Sponsorship worksheet extract all sponsors with zero Tier 1 sponsors.
4. Print out the filtered Sponsorship worksheet.
5. Summarise the data in the main section of the Sponsorship worksheet into a meaningful
pivot table. Column label is HQ location., row labels are Name of Organization and Sum
values is Sponsorship value.
6. Print out the pivot table worksheet.
7. Store the printouts in your SBA folder and update your submission checklist.

7
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

TASK C - PRESENTATION OF RESULTS

1. Generate an appropriate bar/column chart that compares the projected attendance for each
location.
2. Print out the bar/column chart.
3. Generate a pie chart that compares venue expenditure, advertising expenditure and
Administration Expenditure. Each slice of the chart must be appropriately labelled to show
the value data label. Give this chart the title “Expenses”.
4. Print out the pie chart.
5. Store the printouts in your SBA folder and update your submission check list.

DATABASE MANAGEMENT ASSIGNMENT

You are asked to use a suitable database application to manage data on sponsors and the associated
events. Appropriately named tables must be used to store the data related to sponsors, events and
sponsorship deals.

TASK A - DATABASE DESIGN AND CREATION

1. Create a database table, Sponsors, to store the data about sponsors obtained from the
Sponsorship Expression of Interest Forms: unique (three letters) sponsor ID, name of
organisation, contact name, email, telephone number and HQ location. Include a suitable
primary key.
2. Create and print out a screenshot showing the table design and primary key.
3. Create a suitable form for inputting data and populate the table with data from the
Sponsorship Expression of Interest Form.
4. Print out the populated Sponsors table.
5. Design and create a second table, Events, and store data related to the events: unique
(number) event ID, event name, projected attendance per location, and event country.
Include a suitable primary key.
6. Create and print out a screenshot showing the table design and primary key.
7. Populate the table with data from table 1.
8. Print out the populated Events table.
9. Design and create a third table, Sponsorship Deals, and store the following data: unique
(number) sponsorship deal ID, sponsor ID, event ID and tier. Include a suitable primary
key.
10. Create and print out a screenshot showing the table design and primary key.
11. Populate the table with suitable data.
12. Join/relate the three tables together.
13. Create and print out a screenshot showing the relationships between tables.
14. Store the printouts in you SBA folder and update your submission check list.

8
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

TASK B – QUERIES

Generate the following queries:

1. List of locations with projected attendance is greater than or equal to 2,000. Extra facilities
will be needed at these events.
2. Create and print out a screenshot showing the query design and criteria.
3. Print out the result of the query.
4. IT is anticipated the 35% of projected attendees will be adult females, 25% adult males and
the remainder children. Create a query to show the event, country, sponsoring
organisations and the number of females, males and children projected to attend. Sponsors
need this information to manage their stands at the fair.
5. Create and print out a screenshot showing the query design and calculated fields.
6. Print out the result of the query.
1. Store the printouts in you SBA folder and update your submission check list.

TASK C - VIEWING and REPORTING

1. Generate a form and sub-form to view the information about sponsors and the events they
have sponsored.
2. Create and print out a screenshot showing the form and sub-form.
3. Generate a report based on the following specifications:
 Grouping: sponsorship tier
 Sort Order: country name
 Fields: country name, organisation, tier, projected number of females
 Title: ‘Projected Adult Female Attendance at Sponsored Events’.
4. Print out the report.
5. Store the printouts in you SBA folder and update your submission check list.

PROBLEM SOLVING AND PROGRAM IMPLEMENTATION ASSIGNMENT

TASK A - Algorithm Development

1. Develop and algorithm to determine the total income for each of the 10 events and the
grand total for all events. The algorithm must loop through all the 10 events and prompt the
user to enter the total sponsorship value and total gate receipts value. The algorithm should
output the total sponsorship value for each event and, if the total value is greater than or
equal to $50,000, output ‘Star Event’. At the end the algorithm should output the grand total
for all events. Document your algorithm using pseudocode OR a flowchart.

9
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

2. Print out the pseudocode algorithm.

3. Your flowchart document may be neatly hand drawn.
4. Store the printouts in your SBA folder and update your submission checklist.

TASK B - Test and Validate Algorithm

1. Design and execute a trace table that utilises appropriate test data to verify the algorithm is
correct.
2. Your trace table document may be word processed or neatly hand drawn.
3. Print out the test data document.
4. Store the printouts in your SBA folder and update your submission checklist.

TASK C - Program Implementation

1. Implement the program using your chosen programming language.

2. Print out the source code document.
3. Create and print out a screenshot showing the program operating correctly.
4. Store the printouts in your SBA folder and update your submission checklist.

10
CARIBBEAN FOOD AND DRINK FESTIVAL 2025

WORD PROCESSING SECTION

11
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

THE NEED

A multitude of tourists, travel annually to

several countries worldwide, to partake
At the Caribbean Food and Drink Festival
in diverse festivals and fairs. One
2025, there will be ten participating
popularly recognized festival is called the
countries including:
“Food and Drink festival”, where multiple
countries containing their distinctive
cultures are given the opportunity to
collectively exhibit their most
 Anguilla
distinguished and relished cuisines. In the
 Barbuda
Caribbean, food is significantly inspired
 Barbados
by a number of other countries
 Bequia
worldwide, which makes the Caribbean fit
 Nevis
for any foodie or food travel lover!
 Puerto Rico
Tourists even plan their vacations to
 St Maarten
correspond with food festivals that are
 Turks and Caicos
held in the Caribbean! Here is a list of
 Tortola
some of the most popular Food Festivals
 Tobago
hosted in the Caribbean, where “foodies”
have enjoyed the region’s cuisine:
The Caribbean Food and Drink Festival is
set to occur from October 10th to
November 26th, 2025. The estimated cost
 Caribbean Food and Wine Festival
of this festival is $350,000 and as a result,
(Providenciales)
the team is kindly requesting for sponsors
 Barbados Food and Wine and Rum
that would like to help this festival be a
Festival (Barbados)
captivating and memorable one!
 Cayman Cookout (Cayman Islands)
 Soborea Puerto Rico: A Culinary There are two packages that can be
Extravaganza (Puerto Rico) selected by various sponsors, interested
in providing necessary funds for this
festival to take place, which comes with
As a result of these Food and Drink their own benefits.
festivals, several individuals have been
All donations and sponsorships will be
granted the experience of a lifetime, to
condsiderably be appreciated and will be
unwind, taste some of the local, cultural
put towards ensuring the success of the
and international dishes of the Caribbean,
Caribbean Food and Drink Festival 2025.
as well as to enjoy the serenity of the
Caribbean atmosphere.

12
CARIBBEAN FOOD AND DRINK FESTIVAL 2025

COUNTRY PROFILES

Anguilla: Known for as well as goat

its coral reefs and water stew.
beaches, as well as
Puerto Rico: Known
its pigeon peas and
for its
rice, flavored with
rugged
herbs and spices.

mountains as well as its

Barbuda: Known for
arroz con gandules (rice
its beaches with pink
with pigeon peas)
sand as well as its
fungie and
pepperpot
St Maarten: Known
for its colonial
architecture,
Barbados: Known
casinos, as well as its
for its tropical
conch and
beaches and the land
dumplings and
of the flying fish, as
callaloo soup.
well as its cou cou
and fired flying fish.
Turks and Caicos:
Known for its white
Bequia: Known for
sand beaches and
scuba diving,
turquoise waters as
snorkeling and
well as its conch
kayaking, as well as
and hominy.
their Jack’s Fried
Chicken.
Tortola: Known for
its collection of
Nevis: Known for its
spices, coral reef
beaches, including
snorkeling, sailing,
the famous Pinney’s
as well as its
and clear water
snorkeling at Oualie,

13
CARIBBEAN FOOD AND DRINK FESTIVAL 2025

national dish, fish

and fungi.

Tobago: Known for

its cultures, its
sandy beaches,
rainforests, as well
as its popular street
food, doubles.

14
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

SCHEDULE
DATE (2025) COUNTRY TIME

SUNDAY 10th OCTOBER Shoal Beach Food Fest 8:00 A.M. – 10:00 P.M.
(ANGUILLA)

FRIDAY 15th OCTOBER Gravenor Bay Food Fair 8:00 A.M. – 10:00 P.M.
(BARBUDA)

WEDNESDAY 20th Little Bay Fair 8:00 A.M. – 10:00 P.M.

OCTOBER (BARBADOS)

MONDAY 25th OCTOBER Lower Bay Food Festival 8:00 A.M. – 10:00 P.M.
(BEQUIA)

SATURDAY 30th OCTOBER Cades Bay Food Fair 8:00 A.M. – 10:00 P.M.
(NEVIS)

FRIDAY 5th NOVEMBER Flamenco Beach Food Lime 8:00 A.M. – 10:00 P.M.
(PUERTO RICO)

WEDNESDAY 10th Orient Bay Beach Food Fair 8:00 A.M. – 10:00 P.M.
NOVEMBER (ST MAARTEN)

MONDAY 15th NOVEMBER Half Moon Bay Food Fest 8:00 A.M. – 10:00 P.M.
(TURKS & CAICOS)

SATURDAY 20th NOVEMBER Brewers Bay Food Fair 8:00 A.M. – 10:00 P.M.
(TORTOLA)

THURSDAY 25th Canoe Bay Food Lime 8:00 A.M. – 10:00 P.M.
NOVEMBER (TOBAGO)

15
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

SPONSORSHIP PACKAGES

There are two sponsorship packages available:

 Tier 1- US $50,000
 Tier 2- US $25,000

The Caribbean Food and Drink Festival 2025 committee is kindly inviting the public to
generously make donations in contribution towards the various Caribbean regions and
sectors, which are currently working together to create the most memorable and
captivating festival extravaganza. These donations are conducive towards payments for the
establishment of venues, payment of staff, DJ’s as well as planners, purchases of prizes and
much more. Each of the sponsorship packages comes with their own benefits as well as
rewards.

PACKAGE BENEFITS:
 Tier 1: US $50,000
- Brand awareness from regular announcements
- Accommodation and food for representatives
- Products and services will be featured
- First hand VVIP experience for representatives

 Tier 2: US $25,000
- Brand awareness from regular announcements
- Accommodation and food for representatives
- First hand VIP experience for representatives

IF YOU WISH TO BECOME A SPONSOR OF OUR EVENT, PLEASE

FILL OUT THE SPONSORSHIP EXPRESSION OF INTEREST FORM.

*
The Sponsorship Expression of Interest Form is available at www.cfdf2025.biz.

16
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Caribbean Food and Drink Festival 2025

Sponsorship Expression of Interest
THIS FORM CONTAINS FILLABLE INFORMATION FOR COMPANIES AND PERSONS INTERESTED IN
SPONSORING THIS EVENT

ORGANIZATION INFORMATION
DATE OF APPLICATION: Click or tap to enter a date.
NAME OF ORGANIZATION: Click or tap here to enter text.
LOCATION: Click or tap here to enter text.

CONTACT PERSONAL INFORMATION:

NAME: Click or tap here to enter text.
EMAIL ADDRESS: Click or tap here to enter text.
CONTACT NUMBERS: Click or tap here to enter text.

SPONSORSHIP INFORMATION:
EVENT BEING SPOSNSORED:
SPONSORSHIP PACKAGE:
- TIER 1 (US $50,000)
- TIER 1 (US $50,000)

ACCOMMODATION:
NUMBER OF PERSONS:
DATE OF ARRIVAL: Click or tap to enter a date.
DATE OF DEPARTURE: Click or tap to enter a date.
ACCOMMODATION TYPE:
- FOOD AND ACCOMMODATION
- ACCOMMODATION ALONE

17
CARIBBEAN FOOD AND DRINK FESTIVAL 2025

SPONSORSHIP EXPRESSION OF INTEREST FORM

IN DESIGN MODE:

18
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

WEB PAGE DESIGN

19
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

SPREADSHEET SECTION
Sponsorship Worksheet

Sponsorship worksheet showing formulae used

Location Worksheet

20
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Location Worksheet showing formulae used

Accounts Worksheet

21
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Accounts Worksheet showing formulae used

Filtered Sponsorship Worksheet

22
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Pivot Table
Presentation of Results

23
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

DATABASE SECTION
Sponsor Table

Sponsors Table in Design View

Sponsors Subform

24
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Events Table

Events Table in Design View

Events Form

25
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Sponsorship Deals Table

Sponsorship Deals Table in Design View

26
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Relationships

Query for Attendance greater than 2000 in Design View

27
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Query for Attendance greater than 2000 product

Query for Projected Attendance of Females, Males and Children

Query for Female Projected Attendance in Design View

28
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

Query for Projected Female Attendance Product

Report for Projected Female Attendance

29
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

PSEUDOCODE ALGORITHM DEVELOPMENT

Begin
Initialize Final total = 0
FOR integer = 1 to 10 DO

Begin
Write ‘Enter the sponsorship tier value for event’
Read the total sponsorship tier value
Write ‘Enter gate receipts value for event’
Read the gate receipts value
sponsorship total = sponsorship tier value + gate receipts value
Write ‘The total sponsorship value for this event is ‘, sponsorship total
If sponsorship total is greater than or equal to 50000 then
Write ‘******STAR EVENT******’
Final total = Final total + sponsorship total
Write ‘The grand total for all ten events is ‘, Final total
End

30
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

TRACE TABLE

SponsTier Count Gatereceipt Sponstotal Finaltotal Output

50000 1 168000 218000 218000

25000 2 78000 103000 321000

50000 3 34000 84000 405000

50000 4 32000 82000 487000

50000 5 228000 278000 765000

25000 6 88000 113000 878000

50000 7 20000 70000 948000

25000 8 29000 54000 1002000

25000 9 132000 157000 1159000

25000 10 64000 89000 1248000 1248000

31
 CARIBBEAN FOOD AND DRINK FESTIVAL 2025

PROGRAM IMPLEMENTATION

TEST DATA

32