As Sports Co-Coordinator

[pic 1]

CSEC INFORMATION TECHNOLOGY

SCHOOL BASED ASSESSMENT

(General Proficiency)

Year 2016-2017

[pic 2]

SPREADSHEET

DATABASE MANAGEMENT

WORD PROCESSING

PROBLEM SOLVING AND PROGRAM DESIGN

Student Name:         ________________________________________

Student ID number:         ________________________________________

Teacher:                 ________________________________________

Class:                         ________________________________________

Date received:        ________________________________________

Description of Project

You are the Sports Coordinator for the University of Sports International (USI). The USI will be hosting a track meet to select student to be awarded scholarships for the Academic Year 2016-2017.

The track meet is open to both male and female Track and Field Athletes in their final year of study. There are 5 specially invited schools from Region 1.

As Sports Co-coordinator you are responsible for all the administrative activities of the meet. You are required to:

1. Record the information on each school and their track team
2. Generate the necessary reports to be sent back to each school on the performance of their athletes and who were selected for the scholarship
3. Prepare and send out the necessary correspondence to each school
4. Prepare the guidelines for the registration of all invited schools
5. Record the necessary data

You are required to use suitable word processing, spreadsheet, database management as well as programming application to design and implement a computer based solution of the tasks involved in managing the track meet

Guidelines

At a meeting of the executive the following guidelines were decided on:

1. Male and females athletes are allowed to enter.
2. Participants are to be  no older that 18yrs old and not younger than 16 yrs old
3. Students are only allowed to participate in 1 event
4. All schools are required to pay a registration fee of $ 500 per athlete
5. Schools are only allowed 10 athletes (male and female inclusive).
6. There should be at least one single sex school, however there must be no more than 45 athletes and no less than 40 athletes
7. The events to be contested are:  100m, 200m, 400m, 800m, 1500m
8. Deadline for submission of registration form is November 30, 2016

Spreadsheet

The financial and athlete track records are maintained using a spreadsheet application.  The names of the athlete are listed in a common table.  Both co-ed and single sex schools are registered for each of the five events.  The events include 100m, 200m, 400m, 800m and 1500m (Male and Female events).  Each school is required to pay $500.00 per athlete.  However, school that registers after November 30, 2016 will incur a 10 % penalty per entry.  

...