Task 1. Calculate the three-month attendance for each facility.
Task 2. Calculate reporting completeness for each facility.
Task 3. Which facility has the highest three-month attendance, and which has the lowest?
Task 4. Recommend one chart for monthly trends, one for facility comparisons, and one visual for reporting completeness.
Task 5. Write three sentences describing the results without unsupported claims.
Task 6. Identify two actions a district manager could take.
Task 7. Sketch a dashboard, or build one in Power BI or Excel, with a total attendance card, a monthly trend, a facility comparison, a completeness visual, the reporting period, and a data-source note.
Suggested assessment answers
Excel alternative for learners without Power BI Desktop
Use Excel if you do not have Power BI Desktop
Not every learner has a Windows computer. The same ideas can be practised in Excel: totals and percentages, PivotTables where supported, PivotCharts or ordinary charts, a worksheet that arranges charts and summary cells, and a short written interpretation. Excel will not reproduce every Power BI feature. Phone learners can study the demonstrations and complete the calculations in a compatible spreadsheet. Some dashboard-building tasks are easier on a computer.
Module 5 completion checklist
You have learned the foundations of health data visualisation and dashboard design: how to organise indicators, choose visuals, and communicate findings that can support a decision.
Next: Module 6, Monitoring, Evaluation and Health Programme Performance. It connects these skills with programme indicators, results frameworks, routine data quality assessments, MEAL and reporting.