Skip to content

LSS Green Belt Certification Project: Developed a web application automating faculty schedule emails from Excel files, reducing email time from 6 minutes to 10 seconds (~97%). Implemented monitoring for email success/failures, enhanced data entry processes to reduce errors, and designed a user-friendly interface for easy use by administrative staff

Notifications You must be signed in to change notification settings

esana1/ASU-Faculty-Schedule-Automation-Python

Repository files navigation

ASU Faculty Schedule Automation

Introduction

Developed a web application for automating the emailing of faculty schedules, significantly improving efficiency and accuracy in administrative processes.

Features

  • Automated email delivery of faculty schedules from Excel files.
  • Monitoring features to track email delivery success and failures.
  • Enhanced data entry processes and validation checks to reduce errors.
  • User-friendly interface for easy operation by administrative staff.

Impact

  • Reduced email sending time from 6 minutes to 10 seconds (~97% reduction).
  • Decreased errors in email delivery through improved data validation.
  • Streamlined administrative tasks, saving valuable time for staff.

Technologies Used

  • Python
  • Flask
  • Pandas
  • SQL
  • HTML/CSS
  • Bootstrap

Installation and Usage

  1. Clone the repository:
    git clone https://github.com/username/ASU-Faculty-Schedule-Automation.git
  2. Navigate to the project directory:
    cd ASU-Faculty-Schedule-Automation
  3. Install dependencies:
    pip install -r requirements.txt
  4. Run the application:
    python app.py

Contributors

License

This project is licensed under the MIT License - see the LICENSE file for details.

Contact

For any questions or feedback, please contact Ehtesham Sana.

About

LSS Green Belt Certification Project: Developed a web application automating faculty schedule emails from Excel files, reducing email time from 6 minutes to 10 seconds (~97%). Implemented monitoring for email success/failures, enhanced data entry processes to reduce errors, and designed a user-friendly interface for easy use by administrative staff

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published