Preface from the Teacher
This is the current draft of the School Based Assessment(SBA) which you will be required to complete and submit. The final draft will be posted on or before October 31. Please check back for an update.
This SBA is for students sitting the exam from St Jago High School and St Jago.s Evening Institute in May/June 2010. This document is final and supersedes all publication of the St Jago High School prior to December 01, 2009. Propriety Statement
This is intellectual property of the Caribbean Examination Council and has been used with permission. Their work remains their property. Portions of this work have been adopted to suit the context for which it will be used.
IT SBA 0910 (Revised November 28) Page 2 of 13
St Jago High School Information Technology (Business Education) Department SCHOOL BASED ASSESSMENT
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 steelband, 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.
Here we will place miscellaneous limitations, which include the number of items you may have. 1. For spreadsheet please limit your masqueraders as follows: a. You may not have less than 20 15 persons (masqueraders).
b. You may not have more than 30 persons (masqueraders).
2. For database management please limit your masqueraders as follows: a. You may not have less than 12 7 persons (masqueraders) in EACH section. b. You may not have more than 15 9 persons (masqueraders) in EACH section. IT SBA 0910 (Revised November 28) Page 3 of 13
St Jago High School Information Technology (Business Education) Department 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 $160, $220, $280, $350 and $425 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 10%, while payment by installments attracts an interest of 15%. Installments should be spread over three equal payments. Each masquerader pays an .Inclusive. fee. A $150 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 several amenities for masqueraders during the carnival. The bandleader must supply food, drinks, portable bathroom facilities, transportation, music, security personnel, and artiste fees. In addition, the costs of material for the manufacture of costumes as well as labour costs are incurred.
Because of the anticipated large number of masqueraders, the bandleader has decided to manage the income and expenditure of each section separately.
You are required to:
1. Design a worksheet(s) which accepts income and...