Miscellaneous scripts to automate administrative tasks in academia
⭐ the project to show your appreciation. :arrow_upper_right:
Miscellaneous scripts to automate administrative tasks in academia.
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.py is a CLI to process pre-downloaded output of Banner systems enrollment reports (SWRCGSR) into editable .xlsx files.
process_enrollment.py Name_Of_Downloaded_SWRCGSR_File.txt
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.
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.
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.