Applying for college is a stressful process for high school seniors and their parents. Harvard College is the oldest and arguably the nation's most competitive college. In addition to answering a series of questions in their application, every prospective freshman is offered a personal interview, usually with a local Harvard alum.
Every year, 40,000 applicants apply for admissions. Managing the assignments of candidates with interviewers is a daunting task. Assigning candidates to interviewers requires tracking who's available, how many interviews they can handle, geographical constraints, scheduling issues, and personal conflicts with schools and candidates.
After assignments are mode, we need to also track if the interviewer accepted or declined it, or send reminders if there's no response, and understanding any declines to improve future assignments. Finally, one needs to track the process until interview reports are actually submitted.
FMS created and hosts a software application to manage the interview process for Harvard College by matching thousands of applicants with interviewers. The system collects the paperwork and provides the schools committee administrators with status updates throughout the process.
Rather than having a large number of emails assigning students to interviewers, then verifying their acceptance, and other steps throughout the process, a desktop and web based system is implemented to:
FMS created this secure web site using Visual Studio .NET and Microsoft SQL Server. A Microsoft Access administrative interface also assists with the process. When a candidate is assigned, the interviewer is emailed information on the student using our Total Access Emailer program.
The personalized email directs them to the web site to accept or decline the assignment. If they accept, they can upload their interview details online.
A variety of SQL Server Reporting Services reports let administrators monitor all the activity and jump in when help is needed.
Best wishes to all who apply!
Founded in 1986, FMS is a privately held, small business. Our clients include businesses of all sizes, non-profits, and local and federal government agencies. Our developers serve many local clients in the Mid-Atlantic, Washington DC metropolitan area. We also have clients across the country from California to Massachusetts, and Alaska to Florida, in addition to our international clients. Many of our custom solutions are deployed around the world with language localization support.
With our experience, extensive code library, and tested processes, FMS offers great solutions at very competitive prices. Email or call us at 703-356-4700 to learn more about our consulting services and how our staff of full-time professionals can help you. FMS is located in Tysons Corner in Northern Virginia, just outside of Washington, DC.