Current OAK Projects Skip Navigation

Current OAK Projects

Approved OAK projects currently in development.
Optimization | Analytics | Knowledge
Academic Dashboards
Academic Dashboards will display courses taught, enrollments, and other important information about instruction and the curriculum in tables in Tableau for easier access and use by chairs, division directors, the Dean's office, and others.
Admission Data Warehouse
Admission reporting is currently done through a variety of Excel spreadsheets and Crystal Reports. These reports include complex logic reporting directly against the Banner database. A simplified and more robust data architecture is needed to help Admission improve their ability to create ad hoc reports and improve their ability to see trends and analyze information.
Advancement CRM
This project will provide a common platform for communication and information-sharing throughout the division. As a result, we will be able to provide better outreach and communication to our constituents which will result in higher fundraising totals and increased efficiency of external constituent relationship management. We will also be able to manage our systems in a more secure way with better security and provide a more consistent brand across events and marketing pieces. This will position us for success in the next fundraising campaign, for which preparations have already begun, as well as the ongoing development of employer partners and alumni/parent volunteers.
Banner Security Update
This project provides Banner data owners with easy access to view permissions granted to their data and to more easily manage permissions to their area's Banner data. This project also includes backup improvements to tighten our security profile and configuration changes to insure we can successfully handle the load of full class registration in fall 2016.
Faculty Load Cards
The process of documenting and confirming faculty teaching and service loads have typically involved hand-written slips of paper passed from office to office, despite the presence of nearly all needed information in Banner. This project will increase the efficiency and accuracy of information collection and verification. It will also allow for faculty office hours to be posted online, including on faculty profile pages and Moodle sites.
Identity Management
We support a wide variety of Colgate users, including university applicants, full-time staff, seasonal and casual wage staff, various types of faculty appointments, and alumni. Each of these constituents experiences their own unique life cycle within Colgate’s electronic systems: the creation of their records in the ERP system; the activation of their network, email, and other accounts; the enabling of permissions in disparate application platforms; the deactivation or transition of permissions and accounts when they leave Colgate. We seek to improve all aspects of these electronic processes.

With the proliferation of cloud-based services, we see new external systems come online each year. Many of these systems are crucial for campus operations and may contain personal, financial, or other sensitive institutional data. Our ITS help desk currently uses a few tools in order to diagnose any issues with user accounts. This includes some off-the-shelf products (desktop AD tools, GAM for Google Apps) as well as a very minimal in-house dashboard. They often need to push support tickets up to ITS analysts and administrators, the only ones empowered to diagnose some account-related issues.

This is a wide-ranging, ambitious project; we propose a significantly more usable and supportable environment for Colgate users.
Integrated Advising (AdviseStream)
There is a disconnect between academic and administrative advisers; communication only occurs after a problem arises for a student. Typically, during their Colgate career, a student will have two different academic advisers and probably multiple administrative deans. This is difficult for students to navigate.

Very little communication occurs between academic advisers and students’ professors. When problems arise, it is up the student to initiate the conversation. Unfortunately, students often do not know who to turn to first. Students miss opportunities for positive intervention because their support network is not able to put the various pieces of information together to form a comprehensive assessment of the student in times of need.

Many students report to be dissatisfied with their major and FSEM advising (based on senior exit surveys). Students have no centralized view of their activity on campus. Apart from final grades, there is no record of student successes, which makes it difficult for professors and advisers to track intellectual and personal growth over the course of a student’s Colgate career.
Online Course Catalogue
The current course catalogue is manually edited each year. Transcribing handwritten changes and the enormous amount of time required to edit and proof the catalogue are paramount concerns. Moreover, the current process is prone to errors and omissions due to the many steps and revisions required to update the catalogue.

The course catalogue on the Colgate website is manually updated each year to reflect new course information. Print versions of the catalog are derived from a master MS Word document, then imported to Adobe In Design for eventual publication. Of the many physical copies printed each year, many go unused.

New term courses and courses that have been resurrected from previous years are not included in the catalogue because these additions occur after printing. Additionally, any policy changes are not included. As a result, the printed catalog may not accurately reflect the current course offerings or policies for a term.

An electronic system which provides a dynamic source for web content, role based editing and reviewing permissions, and export options for print will increase accuracy, considerably reduce labor expenditures, promote sustainability and waste reduction, and maintain the integrity of course catalouge content.