Project Details

High-Level Requirements

  • Automate the workload analysis process for Dr. Raab, reducing manual calculations.
  • Take in CSV files and produce a color-coded analysis of faculty workload.
  • Ensure a user-friendly interface for faculty workload analysis.

Envisioned Solution

The solution is to create a computer application that automates workload analysis. The application will:

  • Take in CSV files with class data.
  • Parse the specific data fields required for workload calculations.
  • Feed the data into an algorithm that outputs a color-coded sheet of the expected teaching workload for faculty.
  • Simplify the process by turning complex CSV data into an easy-to-read analysis.

Technologies

Python

Python is used for its flexibility and robust libraries to handle data processing and algorithm development.

Pandas

Pandas is a powerful data analysis library in Python, ideal for reading, processing, and manipulating the CSV files efficiently.