Python

Level 2 of 3

Intermediate Level

Prerequisites

Python Beginner level (or equivalent): variables, conditions, loops, lists, dictionaries and functions. Learners are asked to complete a short entry task to confirm readiness.

Duration

8 weeks · 100 guided hours · 6 modules. Taught live by an instructor — online or in person.

By the end of this level you can

  • Read, transform and write CSV, JSON, text and Excel files
  • Write programs that handle errors and bad data without crashing
  • Organise a project into modules and manage packages in a virtual environment
  • Fetch and use data from web APIs, including working offline with cached data
  • Automate a real repetitive office task and track the code in Git and GitHub

Modules

  1. 1Module 1 · 16 h · 3 lessonsFiles and Structured Data in Python
  2. 2Module 2 · 14 h · 3 lessonsError Handling and Defensive Programming
  3. 3Module 3 · 14 h · 3 lessonsModules, Packages and Virtual Environments
  4. 4Module 4 · 18 h · 3 lessonsWorking with Web APIs
  5. 5Module 5 · 20 h · 4 lessonsAutomating Everyday Office Tasks with Python
  6. 6Module 6 · 18 h · 3 lessonsPython Intermediate Project Studio

Intermediate level project

Beneficiary Data Cleaner and Report Generator

For a fictional NGO running a food-distribution programme, build a tool that reads raw registration data (CSV), validates and de-duplicates it, and produces a clean dataset plus an Excel summary by location and household size.

Deliverables

  • A Python project with at least three modules and a requirements.txt
  • Clean output CSV and an Excel summary workbook generated by the program
  • A validation log listing rejected rows and the reason for each
  • A GitHub repository with a README and meaningful commit history

Assessed on

  • Correct validation and de-duplication against the supplied test data
  • Graceful handling of malformed rows, missing files and wrong encodings
  • Clear project structure and reproducible setup (venv + requirements.txt)
  • Commit history showing incremental, well-described work
  • Responsible handling of personal data (no real names or phone numbers committed)

All levels are taught live by an instructor — online or in person — see registration options.