Projects:


Overview
The Orientation Steering Committee Internal Site is a massive project just recently completed. Some final modules are still being built, but it stands currently at over 11,000 lines of code and is loaded with features. It manages all internal operations, including on-line volunteer application process, interview schedule management, selections, and matching new students to their volunteers. It also manages event planning for the OSC and other groups. It has features like automatic e-mail reminders for events and interviews, PDF generation of mailing labels, mass-emailing, and even mass-text messaging of volunteer groups. The site manages 800 volunteer users and 3,500 new students every year. Future plans include a customizable on-line orientation schedule for incoming students.

Technology
The site employs many different technologies to aid the smooth operation of the OSC. It's written in PHP and interfaces an extensive MySQL database backend. It has Javascript AJAX support for certain searching features and PHP classes for PDF generation and rich HTML text entry. It has complex algorithms that can match volunteers to buildings for move-in, training rooms, and even geo-spatially to new students based on their dorm location. Dorm locations are entered using an interactive map and can be updated as the campus changes. This product ahs been a highly successful organization and communication tool, having sent over 130,000 emails in the first year of use to volunteers and new students. It uses Cornell's Kerberos for the Web authentication to restrict access to the Cornell community.

Link
Unfortunately, due to the nature of the project, only authorized access is allowed. You can find the page at the following link, but it requires a Cornell NetID for access and will take you to an application if you are not a user of the site.