felixomondi538-alt/Survey-design-Portfolio

Two validated XLSForm survey designs for ODK/Kobo Collect, demonstrating skip logic, validation rules, consent-gated flow, and bilingual (English/Kiswahili) labels. # Survey Design Portfolio (ODK / Kobo Collect) **Felix Omondi Otieno** — LinkedIn · felixomondi538@gmail.com · Kisumu, Kenya Two sample survey designs in **XLSForm** format the spreadsheet-based standard used by ODK Collect, KoboToolbox, and SurveyCTO to build digital data collection forms. Both forms are modeled on the type of fieldwork I've done professionally (health facility auditing, disability needs assessment) and both have been validated against the actual XLSForm specification, not just formatted to look correct. ## Forms included ### 1. SRH Facility Service Audit Form Modeled on the kind of routine facility audit I conduct as a Data Auditor. Demonstrates: - **Skip logic (`relevant`)** — follow-up questions on discrepancy details and escalation only appear when relevant (e.g., escalation notes only show if a finding is flagged high-risk) - **Validation (`constraint`)** — discrepancies found cannot exceed records reviewed, enforced at the point of data entry rather than caught later in cleaning - **Nested conditional logic** — a two-level skip: discrepancy details depend on discrepancies being found; escalation notes depend on that finding being flagged high-risk - **Bilingual labels** — English and Kiswahili, with proper ISO language codes (`en`, `sw`) ### 2. Disability Needs Baseline Household Survey Modeled on the baseline survey work I did with B&M Consult / Light for the World Kenya. Demonstrates: - **Consent-gated flow** — the entire survey is conditional on informed consent being given first, not collected as an afterthought - **Multi-level branching** — disability type, assistive device questions, and access-to-services questions all cascade logically based on earlier answers - **`select_multiple` with skip logic** — barriers to accessing services only appear if the household reports no access ## Why these design choices Both forms were deliberately kept realistic rather than maximalist a small number of well-justified skip-logic and validatio …