Clearing ALL checkboxes in an Excel workbook
Yet another “helper” script for marking CAT PAT‘s! I was modifying one of the Excel marking rubrics and to test…
Excel’s Text to Columns command
There are a few super-handy timesaving tricks in Microsoft Excel for when your data is not quite the way you…
Transpose-pasting data in Microsoft Excel
How do you decide how your data should be arranged in terms of rows and columns? And what to do…
Copy-paste and moving Excel worksheets
The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered…
Adding up Check Boxes in Excel
So you have created a form in Excel with nifty Check Box Controls. Looks real purrrty! But how do you…
Nested IF Statements in Excel
This little gem finds its way into Matric finals over and over again. It takes some practice to get your…
Phase 2 Excel data capture
Previous step: Phase 2 Questionnaire Once you have administered your PAT questionnaire (25 respondents for Grade 12), you must capture…
Conquering Excel’s VLOOKUP
Possibly the most advanced function in the CAT curriculum, Excel’s VLOOKUP (and HLOOKUP for that matter) is something that can…
Excel functions you need to know for CAT
The following table lists all the Microsoft Excel functions that you will learn in your three years of CAT (DBE curriculum). The…
Shortcuts for marking CAT practical assessments
This is a collection of literal and figurative shortcuts that I find invaluable when marking practical assessment files (Word documents,…