Excel Fundamentals for South African High School Teachers

14-Day Email Course Framework

Course Overview

A practical Excel course designed for South African high school teachers, delivered in 15-minute daily lessons, via email. Each lesson focuses on real classroom and administrative tasks teachers face daily.

Target Audience

High school teachers in South Africa who need to use Excel for:

• Student grade tracking and analysis

• Attendance monitoring

• Budget planning for classroom activities

• Creating reports for school administration

• Organizing parent contact information

Course Structure (14 Days)

Week 1: Excel Basics

• Day 1: Getting Started - Interface and Basic Navigation

• Day 2: Creating Your First Teacher Spreadsheet

• Day 3: Entering and Editing Data Efficiently

• Day 4: Basic Formatting for Professional Look

• Day 5: Saving, Opening, and File Management

• Day 6: Introduction to Formulas and Basic Calculations

• Day 7: Week 1 Review and Practice Exercise

Week 2: Practical Applications

• Day 8: Creating Grade Books and Student Trackers

• Day 9: Using Functions for Grade Calculations

• Day 10: Charts and Graphs for Student Performance

• Day 11: Data Sorting and Filtering

• Day 12: Creating Templates for Recurring Tasks

• Day 13: Printing and Sharing Your Work

• Day 14: Course Review and Next Steps

Reminder: Starting tomorrow, you'll receive one lesson daily between 07:00 and 08:00 SAST. You're on your way to becoming a tech fundi! Enjoy.