Welcome to our training for our Learner Support facilitators!! Your friendly ITEs will be guiding you through your workshop topics. Have some fun!
What to bring?
- Bring what you do! Your class lists, reading logs, some lesson material for next term- let's see how you can make it easier for yourself!
Training Menu
| Time | Session | Description | Skills and tools |
|---|---|---|---|
| Day 1 9:00–9:30 | Ice breaker | Getting our groove on | GoNoodle dab |
| Day 1 9:30-10:45 | Ribbon magic | Spreadsheet shortcuts and more | Spreadsheet skills Excel |
| Day 1 10:45-11:00 | Teatime | Or coffee and a snack! | Sipping |
| Day 1 11:00-12:15 | Guess the shape | Excel orientation | Spreadsheet skills Excel |
| Day 1 12:15-13:00 | Lunch | Njom Njom | Eating skills |
| Day 1 13:00-14:30 | Flippity fun | Use a spreadsheet and Flippity to create word list flashcards, word searches, matching game, arcade games | G-sheets Flippity |
| Day 1 14:30-15:00 | Happy Sheet | Forms and spreadsheets | G/MS forms --> Sheets |
| Day 2 9:00–9:30 | Ice breaker | Let's see what you can remember? | Blooket Sheet refresher |
| Day 2 9:30-10:45 | Learner data Show and do | Capturing Learner log data - Show and do (Formatting (text, dates), adjusting column width, formulas, and more) | Excel/ G-sheets |
| Day 2 10:45-11:00 | Tea break | With loads of coffee | Sippie sip |
| Day 2 11:00- 12:15 | Learner data | Capturing Learner log data . Working with your own learner data | Excel/ G-sheets |
| Day 2 12:15-13:00 | Lunch | Njom Njom | Mouths closed |
| Day 2 13:00-14:00 | Learner data | Capturing Learner log data (continue) | Excel/ G-sheets |
| Day 2 14:00-15:00 | Blooket | Let's see how much you have learned today | Blooket |
| Day 3 9:00–9:30 | Icebreaker | Design a dream intervention for your learners | 4 C's |
| Day 3 9:30-0:45 | Dream budget | You won R10000!!! Create a dream Budget for your intervention | Excel, AI, |
| Day 3 10:45-11:00 | Tea break | Stir it up! | Slurp slurp |
| Day 3 11:00- 12:15 | Dream budget | Dream budget continues | Excel |
| Day 3 12:15-13:00 | Lunch | Njammie njammie | Gobbling |
| Day 3 13:00-15:00 | Happy sheet | Capturing data using forms and sheets | Google/MS forms Google/Excel sheets |
The criteria for the Excel Badge
Please ensure that you can complete all of the items below. If you're unable to do it, please ask your friendly ITE for assistance. You have to be able to:
- Launch MS Excel
- Create a new workbook.
- Type text or numbers into a cell.
- Basic formula use (add, subtract, divide and multiply)
- Can resize columns and rows.
- Able to zoom in and out
- Able to select a cell, copy and paste or move it.
- Able to select a range of cells, copy and paste or move them.
- Open a recently used document.
- Print a document - fit entire worksheet on one page.
- Print a worksheet - fit all columns on one page.
- Save the workbook.
- Close MS Excel.
- All basic skills, including:
- Place borders around a cell or range of cells.
- Shade a cell or a range of cells.
- Can use the Autofill feature.
- Change font type, size and colour.
- Can use the following functions:
- =, SUM, AVERAGE, MAX, MIN, COUNT
- Can use the apostrophe to prevent cells from doing automatic date/time/dropped zero.
- Print/Export to PDF.
- Uses cell references instead of typing in values.
- Can sort a column, or range, numerically or alphabetically.
- Knows at least three keyboard shortcuts for MS Excel.
- Can access Help within Excel.
- Understands the differences between the various number, date, and currency formats in the ‘Number’ group on the ribbon.