UC Campus Visit Scheduler
The campus visit scheduling application is an interactive tool that prospective students use to make a visit appointment online. The user picks his or her major of interest and is presented with a calendar of available dates to choose from. Based on the user’s selections, the system builds a customized schedule based on availability in real time. Try it online now.
When the user finalizes his or her appointment, the wizard prints a barcoded confirmation sheet. The prospective student brings this sheet to campus and checks in with it. Front desk staff need only zap the barcode for the system to capture accurate tracking data.
This web-based front end is only a small part of the event planning, registration, and tracking system I designed. The system replaced a cumbersome series of manual tasks and Excel-based tracking procedures the office had been using.
The ‘behind-the-scenes’ applications all run on the desktop. They allow staff to manage and track the event schedule (such as on-campus events, off-campus college fairs, and high school visits), look at and edit registration, do efficient data entry, and check students in.
CRM Web App
Drag & drop query builder
An experimental project, this web app is my rudimentary implementation of CRM software.
The user is able to import data from CSV files, interactively build queries (which the server compiles into SQL queries), build email mail-merge templates, and send emails.
Built for maximum speed, every page is a simple static cacheable HTML page. Client-side script makes AJAX calls to a C# Web Service which returns JSON data. Using jQuery and a little magic, the pages are populated with data.
Because the only traffic that actually needs to cross the wire is JSON requests, page load times can be measured in the millisecond range – even when the app is used over slow connections, like a 3G cellular connection.