Business
DINTHILL TECHNICAL HIGH SCHOOL
CARIBBEAN EXAMINATIONS COUNCIL – INFORMATION TECHNOLOGY
SCHOOL – BASED ASSESSMENT
SCHOOL YEAR: 2012 – 2013
SBA Overview
Carnival has long been a traditional cultural festival in several Caribbean territories. Every year, thousands of costumed masqueraders parade through the streets, dancing to the pulsating sounds of steel band, calypso and soca. Most of these revelers register to participate in the band of their choice months before the festivities begin. Organizers of these bands must utilize management and organizational skills in order to stage a successful event. As a bandleader of one of these carnival bands, you are required to utilize suitable Word processing, Spreadsheet, Database management as well as a programming application to design and implement computer-based solutions to the tasks involved in the management of your carnival band.
Spreadsheet
The financial records of the band are maintained using a spreadsheet application. The names of masqueraders are listed by section. Both men as well as women may register to play in each section. There are five sections in the band. The cost of costumes is quoted in US dollars. The cost by section is USD$165, USD$220, USD$285, USD$355 and USD$430 respectively. Masqueraders are given the option of paying for the costume in three installments, or paying the full cost in one payment. Many people utilize the installment option. Single full payment attracts a discount of 15%, while payment by installments attracts an interest of 20%. Installments should be spread over three equal payments.
Each masquerader pays an ‘Inclusive‘ fee. A USD$155 Inclusive fee entitles the masquerader to food, drinks, access to portable bathroom facilities and bottled water during the carnival parade through the streets. However, a payment of $50.00 entitles the masquerader to portable bathroom facilities and bottled water only.
Expenditure is incurred in the provision of
CARIBBEAN EXAMINATIONS COUNCIL – INFORMATION TECHNOLOGY
SCHOOL – BASED ASSESSMENT
SCHOOL YEAR: 2012 – 2013
SBA Overview
Carnival has long been a traditional cultural festival in several Caribbean territories. Every year, thousands of costumed masqueraders parade through the streets, dancing to the pulsating sounds of steel band, calypso and soca. Most of these revelers register to participate in the band of their choice months before the festivities begin. Organizers of these bands must utilize management and organizational skills in order to stage a successful event. As a bandleader of one of these carnival bands, you are required to utilize suitable Word processing, Spreadsheet, Database management as well as a programming application to design and implement computer-based solutions to the tasks involved in the management of your carnival band.
Spreadsheet
The financial records of the band are maintained using a spreadsheet application. The names of masqueraders are listed by section. Both men as well as women may register to play in each section. There are five sections in the band. The cost of costumes is quoted in US dollars. The cost by section is USD$165, USD$220, USD$285, USD$355 and USD$430 respectively. Masqueraders are given the option of paying for the costume in three installments, or paying the full cost in one payment. Many people utilize the installment option. Single full payment attracts a discount of 15%, while payment by installments attracts an interest of 20%. Installments should be spread over three equal payments.
Each masquerader pays an ‘Inclusive‘ fee. A USD$155 Inclusive fee entitles the masquerader to food, drinks, access to portable bathroom facilities and bottled water during the carnival parade through the streets. However, a payment of $50.00 entitles the masquerader to portable bathroom facilities and bottled water only.
Expenditure is incurred in the provision of