Welcome to the second day of Excel training for our Learner Support facilitators!! Your friendly ITEs will be guiding you through your workshop topics. Have some fun while learning more about Excel and some other fab tools!
Training Menu
| Time | Session | Description | Skills and tools |
|---|---|---|---|
| Day 2 9:00–9:30 | Ice breaker | Let's see what you can remember? | Blooket Sheet refresher |
| Day 2 9:30-0: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 using a bit of AI and a lot of fun. | Blooket Excel template Google sheets |
Remember: The criteria for the Excel Badge are as follows:
Please make sure that you can do ALL of the items below. If you can't do it, please ask your friendly ITE for support. 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)
- Resize columns and rows.
- Zoom in and out
- Select a cell, copy and paste the cell content or move it.
- Select a range of cells, copy and paste the cell content or move them.
- Open a recently used document.
- Print a document - fit an 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.
- 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 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.
Activity 1: Reading Log exploration- Show and do
In this exercise, you will apply basic formatting, adjust column widths, and use formulas to calculate averages and counts.
- Download the Reading Log Activity.xlsx file and rename it to (blank sheet with basics)
LS-Readers-yourname.xlsx and save in your POE folder.
Table Headers : - Insert a row above the column headers and type in Reading log-Term 2.
- Highlight column A1 to F1 and merge and center.
- Set the table header in row 1 to font size 20pts
- Fill Row 1 headers with blue colour (A1 to F1)
- Row 2: Set the Column Headers to font size 18pt.
- Fill Row 2 headers with light blue colour (A2 to F2)
- Bold Row 1 and 2 (Headers)
- Wrap Row 2 cells where the text does not fit.
- Highlight columns A to F and double-click between
column letters to auto-fit, or drag the column sides to fit the text.
Names in Column A: - Select all cells with names in Column A (e.g. A3: A17... where names appear).
- Set font size to 16pt and make bold
- Centre columns A to E
- Create all Borders around the table
Adjust column width - Highlight columns and double-click between column letters to auto-fit, or set a width that makes data clear.
Add Today’s Date - Click on cell A19
- Type: =TODAY() and press Enter. What happens?
- Format as Long Date (Home > Number group > dropdown > Long Date).
Create Formulas - In A20, type Stats
- In A21 type Total Learners:
- In B21 type the formula =COUNT(B3:B17)
- In A22 - type Average Days Present:
- IN B22 type the formula = AVERAGE(E3:E17)
- In A23 type Average Reading Level
- In B23 type =AVERAGE(D3:D17).
Format Painter - Click on cell A2
- Go to the Home tab at the top of the Excel window.
- In the Clipboard group, click on the Format Painter icon (paintbrush).
- Move to cell A19, click and drag your mouse down to A23.
- Release the mouse, What happens?
Repeat for B1 to B21–B23 - Click on cell B1 to select it.
- Go to the Home tab, then click on Format Painter.
- Click and drag over B21 to B23.
- Release your mouse to apply the formatting.
- Save your spreadsheet
Activity 2: Create your own learner log or learner sheet
Use your own data to create your own spreadsheet, according to your requirements.
See some examples:
Activity 3: Gamification with - Blooket
Let's start by letting you experience what Blooket is and testing how much you've learned so far. The facilitator will explain the rules of the game.
Some questions:
- Which app did you enjoy more? Flippity, Kahoot or blooket?
- What can Blooket do that Kahoot can't?
Explore some Blookets
- Create your Blooket account using your Gmail address.
- Go to Blooket.com
- Explore some of the games on your own. Click to see the questions and answers. Is it suitable for your learners?
