HomeworkAssignmentM-

This repository includes a deterministic Python workflow for analyzing grad_program_exit_survey_2024.xlsx (Qualtrics export) and ranking MAcc core courses by average benefit rank.

What the analysis does

The script (scripts/analyze_exit_survey.py) automatically:

1. Reads the Qualtrics workbook directly from .xlsx XML contents.
2. Uses the second workbook row (question text) to locate the MAcc core rank-order question columns.
3. Extracts the course name from each rank-order column header.
4. Skips Qualtrics metadata rows and processes only real response rows.
5. Converts rank values to numeric values.
6. Computes per-course average rank and response count.
7. Sorts courses by:
   • average rank ascending (lower is better), then
   • course name alphabetical for deterministic tie-breaking.
8. Writes deterministic outputs to outputs/:
   • macc_core_course_rankings.csv
   • macc_core_course_rankings.md
   • macc_core_course_rankings.svg (horizontal bar chart)

Local run

python scripts/analyze_exit_survey.py

GitHub Actions automation

Workflow file: .github/workflows/analyze-exit-survey.yml

It runs automatically on:

• manual dispatch,
• pushes to main that touch the survey or analysis files,
• weekly schedule (0 6 * * 1).

The workflow uploads generated outputs as build artifacts.