Course Outline

Module 1: Introduction to Mobile Data Collection and ODK Ecosystem

• ICT refresher
• Mobile data collection systems architecture
• Mobile-based data collection tools, techniques, and platforms
• ODK ecosystem
• ODK XLSForm syntax for survey authoring
• Connecting ODK Collect to the Server
• Connecting to your own Aggregate Server
• Connecting to a Google Drive Account
• Collect Menus, Settings, and Security Explained
• Case Study: A nonprofit organization successfully implemented ODK for a community health survey, increasing data collection efficiency by 40%.

Module 2: Using Offline Maps with ODK Collect

• Offline Maps Overview
• Getting Map Tile Sets
• Transferring offline tilesets to devices
• Selecting offline tilesets
• Advanced Use and Best Practices
• Android Debug Bridge with Collect
• Improving Location Performance
• Projecting ODK to another Screen
• Case Study: A field research team utilized offline maps in ODK Collect for a remote survey, improving accuracy in location data despite limited internet connectivity.

Module 3: ODK Aggregate Installation and Administration

• Installation on Digital Ocean (Recommended)
• Installation on Tomcat
• Installation on Amazon Web Services (AWS)
• Installation on Google Cloud
• Installation on Microsoft Azure
• Installation on a Virtual Machine
• Backing Up ODK Aggregate
• Backup Forms and Restore them
• PostgreSQL Backup and Restore
• MySQL Backup and Restore
• Data Submissions in Aggregate
• Filtering Submissions
• Visualizing Submissions
• Exporting Submissions
• Publishing Submissions
• Using Google Earth to visualize geographic data
• Administering ODK Aggregate
• Permissions Explained
• Preferences Explained (Google APIs and Enketo Configuration)
• Case Study: A government agency streamlined its data collection process by effectively administering ODK Aggregate, resulting in faster reporting times and improved data integrity.

Module 4: ODK Briefcase and ODK Central

• ODK Briefcase
• Pull and push forms from ODK Servers
• Export Data from forms
• Decrypt encrypted forms
• Backup forms
• Working both with command line and offline
• ODK Central
• Using the Sandbox
• Installing ODK Central on Digital Ocean
• Configuring DKIM
• Using custom mail server
• Using custom SSL Certificate
• Command Line Tools
• User accounts and management
• Role-based user permissioning
• Organizing users, permissions, and forms
• Form and submission upload and management
• Automatic, encrypted off-site data backups to Google Drive
• REST API for integration and extensibility
• Case Study: A research institution enhanced its data security and management by adopting ODK Central, allowing for seamless collaboration among researchers while safeguarding sensitive information.

Module 5: Form Building and Management

• XLS Form
• XLSForm Online
• XLSForm Offline
• pyxform
• Form Operators and Functions
• Operators
• Functions
• Logging Enumerator Behaviour
• Launching External Apps
• Case Study: A local government project improved its data collection quality by implementing structured forms using XLSForm, leading to more reliable community feedback.

Module 6: Data Visualization using Tableau

• Connecting to data
• Visual Analytics
• Dashboards and Stories
• Mappings and Scatter Plots
• Calculations
• Understanding Aggregation, Granularity, and Filters
• Joining and Blending Data
• Case Study: A public health organization utilized Tableau to visualize vaccination data, resulting in targeted outreach efforts that increased vaccination rates by 25%.

Module 7: Data Visualization using Power BI

• Integrating ODK Aggregate to Power BI
• Interactive Visualizations
• Creating Dashboards
• Creating Reports
• Case Study: An educational institution adopted Power BI to analyze student performance data, enabling administrators to identify trends and implement targeted interventions.

Module 8: Exporting GPS Data for Mapping and Visualization

• Exporting GPS data from ODK Collect
• Using Google Earth to visualize geographic data
• QGIS with OpenStreetMap
• OSM Map Download for a Particular Area
• Exporting OSM File to a Shapefile
• Case Study: An environmental research project leveraged GPS data exports to create detailed maps in QGIS, significantly enhancing data analysis for habitat studies.

Module 9: OpenStreetMap (OSM) for Data Collection and Visualization

• OpenStreetMap Interface
• Search and Direction
• Toolbar
• Map Key and Map Share
• Map Note and Query Feature
• OSM Basemap and Plugins
• OpenStreetMap and Web Mapping
• Case Study: A community mapping initiative used OpenStreetMap to engage residents in urban planning, resulting in increased civic participation and better urban resource allocation.

Module 10: Analyzing and Exporting Data from ODK Aggregate

• Analyze and Export Data in Aggregate
• Importing survey data into statistical applications
• Data analysis in Excel
• Case Study: A marketing team analyzed survey data from ODK Aggregate, which led to actionable insights and an improved product launch strategy that boosted sales.