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
- California Community Colleges Partner with Waterfall Mobile on Statewide Emergency Notification Coverage
The Foundation for California Community Colleges (FCCC) has awarded a statewide emergency alert notification contract to Waterfall Mobile. The contract establishes Waterfall's AlertU as an approved technology through the official non-profit foundation for the California Community College (CCC) system office. Through this partnership, individual colleges may directly implement emergency communication services, eliminating lengthy technology evaluation and RFP processes.
- King's College and ASU Add e2Campus for Improved Emergency Notifications
King's College and Arizona State University have switched to Omnilert's e2Campus for emergency notification. Omnilert also has introduced a new program called the ENS Conversion Service that allows schools to bulk upload data from their previous emergency notification system into e2Campus at no charge.
- Saint Joseph Builds Out Wireless Network in Multi-year Upgrade
Saint Joseph's University has begun deploying a Meru Networks wireless local area network across its Philadelphia campus as part of a multi-year effort to bring wireless coverage to every building on campus.
- Vista Ramp Up Is Happening Now, Study Says
Organizations may have been slow to adopt Microsoft Windows Vista, but expect that to change by late 2008 to 2009, according to a Forrester Research report by Benjamin Gray et al., published last week.
- Talisma Launches New Version of CRM with Built-in Application Management
Talisma Corp. announced version 8.0 of its constituent relationship management (CRM) application for higher education. The new release includes application management, a revamped user interface, two-way text messaging, personalized Web portals, and an ADA-compliant Web client, among other enhancements.
- Bringing Composers into Classrooms Through Skype
Two Pennsylvania teaching colleagues with an interest in music and technology are bringing remote experts into classrooms at almost no cost, using Skype's free videoconferencing technology.
