Click here to receive your FREE subscription to Campus Technology
Case Study
Putting a Web-Enabled Database To Work at Syracuse University
8/2/2007
As Director of the Student Records Office for the College of Arts and Sciences at Syracuse, I oversee the processing of a vast mass of student data--who's who, who's where, and who's taking what course from whom. With around 1,000 first-year students in the system at any given time, along with faculty, advisors, and staff, the data presents a significant management challenge.Job One: Streamlining Registration
We have a centralized Oracle PeopleSoft system for student administration, but we needed a secondary system that we could customize to the needs of individual groups.
The first thing we needed to tackle was registration, so we created AutoReg, a custom, home-grown application based on FileMaker Pro that processes course registrations and scheduling. It's a complex task requiring the manipulation of multiple levels of data to ensure that all schedules are completed in a timely manner. AutoReg comprises a total of 35 databases, containing more than 100,000 individual records.
AutoReg streamlines what was a long, cumbersome, aggravating process. Prior to its development, the Registrar's Office performed its functions using the PeopleSoft system. They reported it took an average of 75 minutes per student to complete the registration and scheduling process. We've reduced that time to approximately 30 seconds per student for 80 percent of the first-year student population, and are working to improve the system so that we can get closer to 100 percent. This is a cost savings of approximately $10,000 each summer, along with a much better outcome, providing more students their first-choice schedules and fewer incomplete schedules.
Since we first deployed it, we've upgraded the AutoReg system in several ways. We can send PDF documents to students, faculty, and staff directly from the system. Students can receive a confirmation of their course selections via PDF, and faculty has the option of obtaining necessary information in PDF as well. This helps ensure that documents can be opened and shared, regardless of what hardware and software students and faculty are using.
Improving Advisor-Student Communications
One new capability we're especially excited about is Web Viewer, a feature that allows us to access and display Web content within a layout. Web Viewer and the 360Works SuperContainer plugin for FileMaker Pro are enabling us to enhance the AutoReg system to improve advisor and student collaboration to help boost academic achievement. Advisors conduct phone sessions over the summer with incoming students to prepare them before their arrival on campus. We previously distributed hard-copy photographs of students to advisors prior to the sessions to help provide more personalized consultations. With 1,000 new students coming in each fall, tracking student pictures and making copies for 60 different advisors took an inordinate amount of time and energy. With Web Viewer, students will be able to upload their photos to AutoReg, and their advisors will be able to view them online. The photos will also be used as part of the university's academic planning survey, which requires that students send a picture of themselves along with their responses.
Recommended Reading
- Beck Technology Donates DProfiler to Colleges, Universities
Beck Technology recently announced that it will donate its DProfiler software platform to colleges and universities for use in construction-related coursework.
- Microsoft Adds Gen 4 Datacenters for Cloud Computing
Microsoft is initiating the fourth in a series of datacenter upgrades to enable its cloud computing services, according to a Microsoft blog post Tuesday. And, like everything else in the software world, being highly modular is a good thing.
- Can You Operate as a Virtual Being?
Now that we are conducting at least a part of our business of education virtually and often meeting in virtual environments, let's explore the really big question for academics in a Web 2.0 era...
- Columbia Center To Smooth Web Operations with Collaboration Suite
A college or university without a Web site is inconceivable today, but with every site comes the challenge of managing content. Some sort of automated system is a given, but how much should the site's content management system integrate with other aspects of the campus computing infrastructure?
- IBM's Pass It Along: Mapping Memes Toward A Learning Organization
How IBM's new release is following through on old challenges... big ones.
- North Idaho College To Provide Accessible Lecture Recordings for Disabled Students
North Idaho College will be implementing a new classroom capture system as part of an effort to provide accessible education to students with disabilities. The college will be using SpeakerBox from ClearSky Systems for the lecture capture program beginning in January 2009.
