Student Spotlight: Streamlining Campus Safety Compliance

Six UIC students standing in a conference group in front of a wall screen that reads

This spring, students from UIC’s Information and Decision Sciences (IDS) Consulting Practicum teamed up with the Office of Preparedness and Response to tackle a high-impact project improving campus safety.

Their mission? Modernize and automate how UIC tracks Campus Security Authorities (CSAs) — mandatory crime reporters who play a key role in ensuring compliance with the federal Clery Act.

The Challenge

UIC previously used a manual and time-consuming process to update over 40 CSA lists—each tied to a different university unit. Every year, staff had to comb through 30,000+ employee records, match them with reference data, and update each list by hand.

The Solution

The student team designed a secure, automated system that:

Pulls employee data directly from secure emails,
Adds critical information like a CSA identifier and CSA training completion status,
Organizes it into 40+ separate Google Sheets, each maintained by a designated Clery Act Liaison,
Provides Liaisons with real-time access to manage their rosters.
AI integration enables reporting, data visualizations, and centralized data manipulation

The Impact

Now, with the click of a button, the entire system updates monthly. Liaisons can instantly view or revise their employee lists, and administrators get a live dashboard showing all active CSAs, making training and compliance tracking faster and more accurate.

Project Team

Tani Agboola

BIo

Daniel Galinski

BIo

Miguel Guerrero

BIo

Rohan Saini

BIo

Ethan Zhang

BIo

Teaching Assistants:

Shobhit Gopalakrishnan

BIo

Parth Kanani

BIo

kjn;lknkl'

	Retrieve Secure HR Employee Data Automatically access updated HR rosters from secure email.
	Import Data via User-Friendly Interface Seamlessly upload the data into the system with one click.
	Append CSA Status and Reference Information Match records with existing data to flag current CSAs.
	Distribute to 40+ Unit-Specific Rosters Organize employee records by department or unit for each Clery Act Liaison.
	Enable Real-Time Google Sheet Access for Liaisons Each Liaison can access and manage their assigned roster live.
	Liaisons Update CSA Statuses as Needed Add or remove CSA designations at any time.
	Dashboard Automatically Reflects Updates University administrators see a live view of all CSAs and their training status.
	Integrate AI Genie for Advanced Reporting and Analysis AI Genie by Shobhit enhances the system with AI-powered reporting, visualizations, and data manipulation capabilities.