academia-admin-automation

⭐   the project to show your appreciation. ↗️

Miscellaneous scripts to automate administrative tasks in academia.

Current Scripts

1. enrollment_dashboard
2. process_enrollment
3. retrieve_enrollment

enrollment_dashboard

enrollment_dashboard.py is a Dash webapp to allow user submission of SWRCGSR data, providing a report of summary statistics and graphs as output.

The webapp is live at https://enroll.bonhamcode.com.

process_enrollment

process_enrollment.py is a CLI to process pre-downloaded output of Banner systems enrollment reports (SWRCGSR) into editable .xlsx files.

Usage

process_enrollment.py Name_Of_Downloaded_SWRCGSR_File.txt

retrieve_enrollment

retrieve_enrollment.py implements a Selenium-based approach to automatically log into Banner 9 systems, download an enrollment report (SWRCGSR), and re-format it into an editable .xlsx file.

Usage

retrieve_enrollment.py --excel

Note: prior to use, private.py must be edited to have the user's Banner username and password, as well as the filesystem location of the selenium chromedriver. info.txt must be edited to specify the terms, department codes, and other parameters for the retrieval.

Authors

These scripts are developed as academic software by Dr. Andrew J. Bonham at the Metropolitan State University of Denver. retrieve_enrollment was substantially developed in collaboration with Dr. Henc Bouwmeester. It is licensed under the GPL v3.0.