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
- Sentrigo Offers Help for Database Patching Woes
Sentrigo Inc. released its new Hedgehog vPatch database security software product Tuesday. The product addresses patching inconsistencies that seem to affect busy Oracle database administrators (DBAs), who don't always have time to test and patch. However, users of Microsoft SQL Server database in the enterprise can take a lesson here too.
- Starfish Launches Higher Ed Retention Solution
Software provider Starfish Retention Solutions has announced the upcoming launch of its first product, Starfish Office Hours. The company said this will be the first in a series of products intended to help higher education institutions improve retention and graduation rates by aiding in the delivery of programs designed to help at-risk student populations.
- Unisys Offers Free Unified Communications Trial
Unisys announced Monday that it is offering companies a free 30-day unified communications trial using Microsoft solutions. The offer is currently available through Microsoft's sales personnel.
- New Mexico Launches Statewide eLearning Initiative
As part of its Innovative Digital Education and Learning initiative (IDEAL-NM), New Mexico is launching a statewide program to standardize on a single electronic learning platform--Blackboard--spanning K-12, higher education, adult education, and government. The initiative will also support a new statewide virtual high school.
- North Carolina Adopts Blackboard for Higher Ed
The University of North Carolina and the North Carolina Community College System have signed on with Blackboard to deploy that company's electronic learning platform across 68 individual campuses.
- Semantic Search: Could the Web Think?
Semantics is a sub-field of linguistics that focuses on meaning making in language. Therefore, the Semantic Web we're still reaching for will be based on a set of definitions, languages, and standards that can base a search on the detection of meaning and not just on a simple character string. The Semantic Web will at least be smarter than the current Web.
