Phase 2 Excel data capture
« Previous step: Phase 2 Questionnaire Once you have administered your PAT questionnaire (25 responses for Grade 12), you must…
Mastering Excel’s VLOOKUP() function
Possibly the most advanced function in the ICT and CAT curricula, Excel's VLOOKUP is something that can easily be mastered…
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…
Shortcuts for marking CAT practical assessments
This is a collection of literal and figurative shortcuts I find invaluable when marking practical assessment files (Word documents, Excel…
ODBC MySQL Data connection in Excel
After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up,…
Phase 2 “additional data”
It is vitally important to note that the requirements around the data collected for the Grade 12 PAT changed in…