For those of you that have used UK's writing center before, you may be familiar with the Oxford scheduling system. All in all, its a rather advanced system that matches the best qualified consultants with the needs of the clients based on the answers to a few questions.

Due some technical and administrative issues with the system, as well as a change in requirements by the new administration at the Writing Center Oxford will be receiving a major rewrite. The new system will be much simpler. It will no longer do any advanced matching, leaving the selection of consultants up to the clients. This means we can do away with the list of questions asked everytime an appointment is made.

Our plan is for the new version of Oxford to be written as a drupal module. This does several things for us. First of all it will show off drupal, a technology we're excited to be using. Secondly, it will allow our entire team to become more experienced with drupal and module development. Those two aspects will help us to meet one of our new goals here at A&S computing, namely, becoming more agile so that we can rapidly push out useful applications.

The current concept and design for the new Oxford is as follows. To schedule an appointment the client would be presented with a list of appointments (each labeled with the associated consultant), selecting one would schedule the appointment. Upon logging in consultants would be shown a page of their upcoming appointments. Additionally there will be some sort of report screen, where a log of all appointments will be kept, and statistics can be generated that give the percentage of undergrad students using the service, for example.

To do this as a drupal module we have to create a few database tables. We need a users table with fields for user group (client/consultant), ESL (for logging purposes), student status (grad/undergrad again for logging). We need a schedule table that stores the schedules of the consultants. Lastly we'll need an appointments table that links client users to consultant schedules.

Overall this should be a great project for getting our feet wet with drupal and when its finished it'll be a useful application.