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.