Advanced criteria in Excel logic functions
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form questionnaire is being analysed. A closed question required respondents to select 3 of…
productivity through technology
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form questionnaire is being analysed. A closed question required respondents to select 3 of…
Yet another “helper” script for marking CAT PAT‘s! I was modifying one of the Excel marking rubrics and to test that I had linked up all the calculations correctly with…
There are a few super-handy timesaving tricks in Microsoft Excel for when your data is not quite the way you need it to be. The Text to Columns and the…
How do you decide how your data should be arranged in terms of rows and columns? And what to do when you need to put a column of data in…
The standard method for copy-pasting or moving (cut-pasting) an entire Worksheet in a Workbook is clunky and slow. I discovered a far more efficient method by accident! The standard method…
This was a truly esoteric question in the NSC P1 Prelim 2020. I was not aware of this setting: I have never seen this before and have also never felt the need to…
So you have created a form in Excel with nifty Check Box Controls. Looks real purrrty! But how do you determine how many check boxes have been selected? Here follows…
This little gem finds its way into Matric finals over and over again. It takes some practice to get your head around the logic, so let’s begin! Your standard IF…
Previous step: Phase 2 Questionnaire Once you have administered your PAT questionnaire (25 responses for Grade 12), you must capture and analyze the data. You can create the Microsoft Excel…
Possibly the most advanced function in the CAT curriculum, Excel’s VLOOKUP (and HLOOKUP for that matter) is something that can easily be mastered with practice. Imagine the following scenario: you…