As part of our support for some of our system-wide Arts programs, a few months back I agreed to build a web site and some online registration tools for the March 2004 American College Dance Festival (Southwest Regional) being hosted by our Scottsdale Community College. There are some 350 attendees from 31 different college dance programs.
This was a fun design project as I got to go full bore into using pure XHTML design, two sets of style sheets to mask out those pesky NetScape 4 users/abusees (plus a print style sheet), a one template PHP output template, random background images, use of fancy CSS for a navigation bar that looks like the kludgy JavaScript image swaps, but renders iin source as a good old, accessible friendly, <ul> list….
They did not give enough lead time to set up totally online registration, but we did take some weakly formatted materials, and have the attendees use MS Word protected “Form” documents to submit their registration details.
But the fun came this past 2 weeks in setting up a completely online system for the college representatives to sign their students up for the classes that are offered over 4 days. The first part was getting the class details (name, location, instructor, maximum registration). I had made an Excel spreadsheet with different sheets to match the database tables (especially as the class titles continue to change, student names were dropped, added) so that the conference folks could send me data, I could then import into the mySQL database. The fist tool was generating a schedule preview, with link to the instructor bios (also drawn from the database).
This was a messy pile of data to sort out- nearly 150 different classes, with different maximum numbers (room dependent), participants could select 1,2,3 class preferences for 14 time slots, and having to work around conflicting events such as rehearsals and adjudication (I have no idea what that is, but I had to type it a lot ;-). Oh, and there are these “Master Classes” where each college was allotted so many registration slots, AND, a person could take only one Master Class.
I was told that in years past, attendees had to stand in line at the conference registration to get their class requests, so if this work, it would take away that hassle, and provide the event planners more room to plan for the conference details.
The system has been open just a few days, and it appears that 26/31 colleges have already gotten their participants . registrations in. It is competitive as classes fill, so they were eager to log in and sign up. I cannot let you see, but have collected some screen shots.