How is this course delivered?

This is a tutor-led course delivered live online, taught in English (Uganda). Your tutor guides you through the curriculum live rather than leaving you to self-study pre-recorded videos.

Will I get a certificate?

Yes. You'll receive a data literacy & spreadsheets for analysis certificate after completing the course requirements.

What do I need to know before I start?

You should have: Completion of Course:Computer & Internet Literacy for the AI Age; Basic computer and internet skills.

How long does the course take, and what does it cost?

The course runs for 4 weeks and costs UGX 450,000. Paying for one programming course also unlocks 25% off your next one.

What do I need to have ready to join?

You'll need: Laptop or desktop computer; Microsoft Excel or Google Sheets; Internet access; Google account; KoboToolbox account; Android phone or tablet for optional KoboCollect field practice.

Can I get help if I get stuck?

Yes. Enrolled students can book one-on-one tutor sessions any time through Get Help, in addition to regular class time.

Programming Upper Secondary · University · General PublicData Literacy & Spreadsheets for Analysis

Machine Learning

Upper Secondary · University · General Public

Data Literacy & Spreadsheets for Analysis

Duration

4 weeks

Investment

UGX 450,000

Certificate

Included

Teaching

Live online

Enroll in this tutor-led course Get Help

Program Introduction

Build practical data literacy and spreadsheet analysis skills using Microsoft Excel or Google Sheets. Learners work with Uganda-, East Africa- and Africa-relevant datasets to assess data quality, clean records, apply formulas and functions, create pivot tables, visualise trends, collect survey data with Google Forms and KoboToolbox, and communicate evidence clearly.

Key Features & Benefits

• Beginner-friendly data literacy • Hands-on Excel and Google Sheets practice • Ugandan and East African datasets • Data cleaning and quality checks • Pivot tables, charts and dashboards • Survey design with KoboToolbox and Google Forms • Basic statistics and trend analysis • Capstone analysis and presentation

Real-World Applications

• SACCO and cooperative reporting • Local market and produce price analysis • SME sales, stock and expense tracking • NGO monitoring, evaluation and reporting • Agriculture crop-yield and rainfall analysis • Survey and field-data management • Education and research data analysis • Public-sector and community-programme reporting

Course outline and learning expectations

This is a tutor-led course. The outline shows what your tutor will cover; teaching materials and examinations are provided directly to enrolled students.

Data LiteracyExcel Course UgandaGoogle Sheets Course UgandaSpreadsheet AnalysisData Analysis UgandaData CleaningPivot TablesData VisualisationSpreadsheet DashboardsKoboToolboxGoogle FormsBasic StatisticsEast Africa Digital SkillsAfrica Data SkillsSACCO Data AnalysisAgricultural Data Analysis

Teaching format

Live online

Teaching language

English (Uganda)

Intended learners

Upper Secondary · University · General Public

What you will learn

Assess data for accuracy, completeness, consistency, relevance, bias and missing values
Organise, format, sort and filter datasets in Excel and Google Sheets
Use spreadsheet formulas and functions for common calculations and checks
Summarise and explore data with pivot tables
Identify duplicates, correct common errors and standardise inconsistent records
Create clear charts and simple dashboards for data storytelling
Design basic surveys and collect data using Google Forms and KoboToolbox
Calculate and interpret averages, percentages, trends and seasonality
Analyse a real or simulated African dataset and present evidence-based findings

Modules

1
Data quality and data literacy
Evaluate what makes data trustworthy using practical Ugandan and African examples.
AccuracyCompletenessConsistencyTimelinessRelevanceBiasMissing dataSACCO recordsMarket datasets
2
Spreadsheet foundations and formulas
Structure, enter and calculate data correctly in Excel and Google Sheets.
Workbook and sheet structureRows, columns and rangesData typesCell referencesFormattingSorting and filteringSUMAVERAGECOUNTIF
3
Functions and pivot tables
Use common functions and pivot tables to answer practical questions from tabular data.
COUNTIFSUMIFAVERAGEIFText functionsDate functionsLookup basicsPivot-table fieldsGroupingFilteringSummaries
4
Cleaning Ugandan datasets
Prepare market and organisational records for reliable analysis.
Duplicate removalBlank cellsInconsistent spellingDate and number formatsValidation rulesError checksMarket-price records
5
Charts, dashboards and data storytelling
Turn analysis into clear visual summaries for decision-making.
Choosing suitable chartsTitles and labelsAxes and scalesKPI summariesDashboard layoutComparisonsTrendsPresenting findings
6
Surveys and data collection
Create simple digital forms and move collected responses into a spreadsheet.
Survey objectivesQuestion designGoogle FormsKoboToolboxData validationInformed consentPrivacy basicsExporting responses
7
Basic statistics, trends and seasonality
Interpret common descriptive measures using agriculture and market examples.
MeanMedianModePercentagesRates of changeTrendsSeasonalityCrop yieldRainfallProduce prices
8
Capstone analysis and presentation
Analyse a real or simulated dataset and communicate useful findings.
Define an analysis questionPrepare the datasetApply formulas and pivot tablesBuild a dashboardInterpret resultsPresent recommendationsSuggested project: 12-month local-market produce-price dashboard