Week 3: Data Analysis and Visualization

🎯 Objectives

• Perform basic data analysis using spreadsheets.
• Utilize KoboToolbox's built-in reporting features.

📘 Introduction

Analyzing collected data is crucial for informed decision-making. It is a complex and broad field. This week, you'll learn to perform basic analysis and visualize data using spreadsheets.

📄 Learning Materials

• Data analysis with Spreadsheet tool: https://www.youtube.com/watch?v=_g5roKHj95o
• Note: Aalthough this video is focused on Microsoft Excel, the same techniques apply to Google Spreadsheets or LibreOffice Calc.
• Export and Report Data from KoboToolbox: https://www.youtube.com/watch?v=Vo9IbQvm8Rg
• Pivot tables in Excel: https://www.youtube.com/watch?v=dvbLrwD2SpA . It is a powerful tool to analyze tabular data like the one produced through KoboToolbox.
• Note: Aalthough this video is focused on Microsoft Excel, the same techniques apply to Google Spreadsheets or LibreOffice Calc.

📝 Activities

1. Data Cleaning: Use Excel (or a different tool) to clean and organize your exported data.
2. Basic Analysis: Create pivot tables and charts to summarize data.