Momahmoses/nigeria-education-dashboard

||Streamlit dashboard for Nigeria Ministry of Education with interactive maps, enrollment trends and policy impact simulation. # National Education Performance Dashboard A live Streamlit dashboard used by Nigeria's Ministry of Education, replacing 47 Excel reports with interactive analytics, maps, and a policy what-if simulator. ## Problem Nigeria's Ministry of Education has WAEC results, school census data, teacher ratios, and budget data, all in separate Excel files, never combined. Policymakers make decisions blind. ## Quick Start ```bash pip install -r requirements.txt # Generate education data (37 states × 50 schools × 10 years) python src/data/generate_data.py # Launch dashboard streamlit run src/dashboard/app.py ``` ## Dashboard Tabs ### 1. State Overview - Bar chart of WAEC pass rates by state (color-coded: red → green) - Top 5 and bottom 5 states highlighted for action - Drill down to individual schools per state ### 2. Trends (2015–2024) - Select any state → see 10-year WAEC trend - Annotated: policy change markers, year labels - Shows North-South performance gap widening/closing ### 3. Correlation Explorer What actually drives WAEC performance? ``` Teacher qualification score: r = +0.72 ← strongest driver Infrastructure score: r = +0.41 Student-teacher ratio: r = -0.38 Budget per student (NGN): r = +0.19 ← weak! Budget ≠ results ``` ### 4. What-If Simulator *"If we increase teacher salary by 20% in the bottom 10 states, what happens?"* - Sliders: teacher salary increase, infrastructure investment, target states - Outputs: projected pass rate, additional students passing - Backed by regression coefficients from historical data ## Key Insights (from synthetic data) - North-West average pass rate: ~38% vs South-West: ~68% - Teacher qualification has 3.8x stronger effect than budget per student - Private schools outperform public by ~12 percentage points - Infrastructure investment effect plateaus above ₦30M/school ## Generated Data Structure ``` 37 states × 50 schools × 10 years = 18,500 school-year records Features: waec_pass_rate, teacher_qual …