College Sport Wellington
College Sport Wellington promotes, administers, coordinates, and
delivers secondary schools sports in the Wellington region of New
Zealand.
In 1996, their Director, John Hornal,
engaged Steve Schapel to develop a multi-purpose database, to assist
with the management of many aspects of the organisation's operations.
This has continued to evolve.
The database has become a key tool in College Sport's work, and covers
these areas:
Schools
contact details of all New Zealand schools
sports-related staff in Wellington Region schools
publication of this data to handbook
publication of this data to website
Sports Organisations
comprehensive details of national and local sports-related organisations
publication of this data to handbook
publication of this data to website
Sporting competitions
team entries for many grades of many sports
automated generation of playing schedules
default venues, dates, times
printouts of these draws in 2 different formats
publication of draws to website
export of draws to newspaper for publication
entry of scores and match results, with choice of entry parameters
automated calculation of premiership points
printouts of results summaries, points tables, season results grids, etc
publication of results to website
export of results to newspaper for publication
export of data to Wellington Rugby database, for inclusion in their
website
Financial
generation of invoices to schools for sports participation levies and
other charges
other customised or template-based invoicing
tracking of payments received
Parts of this system have
now been adapted for use by a number of other leading sporting
organisations, including:
school sports administration - College Sport Auckland, Sport Hawkes Bay,
Sport Manawatu, Sport Waikato
other sports administration - Wellington Rugby Football Union,
Wellington Region Junior Rugby, Auckland Cricket Association, Cricket
Wellington, Canterbury Cricket
