andreabrumana/camara-ethiopia-readiness-assessment

# Camara Education Ethiopia – Schools Infrastructure & EdTech Readiness Assessment Analysis scripts developed as part of the UNV Online Volunteering assignment for **Camara Education Ethiopia / UNICEF Ethiopia**, supporting the programme *"Digital and Transferable Skills Development: Transforming in-School Learning and Transition to Earning"* (April 2026 – December 2027). --- ## Context As part of programme start-up, Camara conducted a **Schools Infrastructure and Technology Readiness Assessment** across 115 institutions in Ethiopia. The assessment covers infrastructure, ICT equipment, connectivity, power reliability, teacher capacity, and inclusion indicators. This repository contains the scripts used to clean, analyse, and visualise the collected data, producing outputs for reporting to UNICEF, the Ministry of Education (MoE), Regional Education Bureaus (REBs), and donors. --- ## Repository Structure ``` ├── 01_clean_data.py # Data cleaning and standardisation ├── 02_analyse_and_charts.py # Analysis, scoring, and chart generation ├── README.md │ ├── input/ # Raw data files (not tracked - contains personal data) ├── outputs/ # Cleaned dataset and analytical summary (not tracked) └── charts/ # Generated chart PNGs (not tracked) ``` --- ## Outputs Running the scripts produces: | Output | Description | |---|---| | `outputs/cleaned_data.csv` | Cleaned dataset, ready for Looker Studio / Power BI | | `outputs/cleaned_data.xlsx` | Same, in Excel format | | `outputs/analytical_summary.xlsx` | 5-sheet workbook: KPIs, by-region, by-hub, school matrix, data quality log | | `charts/fig1_*.png … fig10_*.png` | 10 charts covering readiness, power, connectivity, ICT, inclusion, sustainability | --- ## Setup **Requirements:** Python 3.10+ ```bash # Clone the repo git clone github.com cd camara-ethiopia-readiness-assessment # Create and act …