Topic outline

  • General


    Objective: Enable MoE staff and partners to confidently use digital tools for collecting, managing, and communicating EiE data, even in low-resource settings

    Unit 4: Data Visualization & Reporting in Microsoft Tools

    • Creating charts and graphs in Excel
    • Designing summary tables for reports
    • Preparing visual briefs for coordination meetings
    • Hands-on: Create a one-page visual summary from an EiE dataset, and explore AI support for better visuals

    • Charts and Graphs

    • Summary Tables

      • Introduction

        Designing summary tables for reports: To make data more manageable it is often useful to present the data using a summary table. Readers see summarised data rather than have to make sense of the raw data. 

        See the example below.


      • Activity: 

        Let’s see if we can recreate this table in MS Word. 

    • Visual Briefs

      • Introduction

        In this unit we will investigate how to present data in a visual way that can be used to communicate complex information that can be understood at a glance. These charts and visuals can be used for coordination meetings and for reporting.

        Besides Excel there are various digital tools that can make visualisation relatively easy. Investigate the popular tool, Canva, and try out a dedicated AI that turns text into graphics, using the links below below.


        Resources

      • Example:

          

    • Hands on Activity

      • Instructions
        • Create a one-page visual summary from the EiE dataset below.
        • Explore AI support for better visuals, or use a package like Canva.
        • Use the assignment upload tool below to submit your assignment.

    • Credits