Fair Early-Warning Pipeline for Student Dropout Prediction
An end-to-end, fair, and explainable machine learning pipeline built on Databricks to predict student dropout risk. This pipeline transforms raw student data into actionable risk assessments for academic advisors.
Winner Feature: Built for non-technical advisors via natural language generation of
reason_textand robust Platt Calibration for statistically sound intervention tiers.
The pipeline is implemented natively in Databricks using a 6-notebook structure mapping to the Medallion Architecture:
- Bronze (
01_bronze_layer): Idempotent ingest of raw data using Unity Catalog. - Silver (
02_silver_layer): Feature engineering (grade_delta,financial_stress_index,engagement_score). - Model Training (
03_model_training): XGBoost classification vs Logistic Regression baseline, complete with Platt scaling to calibrate output probabilities and logged via MLflow. - Fairness Audit (
04_fairness_audit): Comprehensive intersectional fairness audit to establish demographic parity across vulnerable demographic variables. - SHAP Explainability (
05_shap_explainability): TreeExplainer calculation to identify the top 3 global and localized factors driving attrition risk. - Gold (
06_gold_table): Curated table featuring human-readablereason_textstrings generating plain-English intervention insights directly from SHAP values.
- Jargon-Free Explainability (
reason_text): We abstract away complex SHAP value arrays into clean, advisor-ready sentences (e.g. "Grade fell 2.3pts; 67% non-completion; debt outstanding."). - Statistically Defensible Interventions (Platt Calibration): Rather than arbitrary risk thresholds, our model applies Platt Scaling to calibrate probability scores. A
0.85score is true 85% risk, allowing for accurate mapping to High/Medium/Low priority tiers. - Intersectional Fairness: Marginal fairness checks easily conceal systemic bias against highly vulnerable subgroups (e.g. low-income female students). We conduct granular intersectional parity tests.
- A Databricks workspace
- ML Runtime (version 13.3 LTS ML or higher recommended)
xgboostandshappython packages installed on the cluster.
Upload the 6 notebooks from the /notebooks sequence to a Databricks Workspace folder and execute them chronologically:
01_bronze_layer.py02_silver_layer.py03_model_training.py04_fairness_audit.py05_shap_explainability.py06_gold_table.py
The final actionable dataset is produced in the Unity Catalog table:
SELECT student_id, risk_score, intervention_tier, reason_text
FROM gold.at_risk_students
WHERE intervention_tier IN ('HIGH', 'MEDIUM')
ORDER BY risk_score DESC;Built for a 24-hour hackathon.