School infrastructure assessment tool for Malawi with cascading selects, auto-calculations, and multilingual support
# Malawi School Infrastructure & Learning Conditions Assessment
A mobile data collection tool for assessing school infrastructure, WASH facilities, teaching materials, and teacher deployment in Malawian primary and secondary schools.
## Quick Overview
- **Platform:** Kobo Toolbox / ODK
- **Form Version:** v1.0.0
- **Languages:** English, Chichewa
- **Schools in Database:** 6,500+
## Key Features
| Feature | What It Does |
|---------|--------------|
| Cascading Selects | Select a division, then only see schools in that division |
| Repeat Groups | Add multiple classrooms, teachers, and subjects |
| Auto-Calculations | Student-teacher ratio, WASH score, infrastructure score |
| Real-Time Alerts | Warnings when conditions exceed national standards |
| GPS & Photos | Evidence of school visits |
| Chichewa Language | Full support for local language |
## How to Deploy
### 1. Upload to Kobo Toolbox
1. Go to
kf.kobotoolbox.org
2. Click **New** → **Upload XLSForm**
3. Select `forms/malawi_school_assessment_v1_0_0.xlsx`
4. Click **Deploy**
### 2. Upload School List
1. Open your project
2. Click **MEDIA** tab
3. Upload `external_data/schools_malawi.csv`
### 3. Test the Form
- **Web:** Click the **WEB** tab
- **Mobile:** Download Kobocollect from Google Play
## Folder Structure