Courses & Training
Macros in Excel Workshop
The workshop below has come and gone, but don’t despair! See this post—> A new addition to CAPS is the use of macros, specifically in Excel. I will be presenting a 1-hour workshop to familiarise […]
Month: Nov 2018
Excel
An idea in teaching Excel functions for Grade 10
I was just thinking if something like this would work. Just a thought, an idea on how I could reinforce the teaching and practice of functions with the Grade 10’s. If enough people think this could […]
Matthew's Blog
OneNote notebooks for Grade 10 and 11 CAT
I created class notebooks for my Grade 10 and Grade 11 Computer Applications Technology classes using Microsoft OneNote. This is in conjunction with MS Teams. You may have seen my YouTube preview video I did […]
Matthew's Blog
Using OneNote for your CAT class
I have decided to use Teams and OneNote exclusively for CAT and have put together my first Notebook for my Grade 10 class for next year. This video is an overview what it looks like. […]
Little Bytes
Find and Highlight your name : Little Bytes by Matt Hains
Receiving a document with lots of names for schedules etc. is easier to process if you can readily find your name and automatically highlight it rather than manually trying to do it.
Matthew's Blog
Interactive IEB CAT SAGs file for teachers and learners
I took the new IEB Computer Applications Technology Subject Assessment Guidelines (CAT SAGs as we know them) and thought of a way I could present them in a more interactive and useful manner that a […]
Matthew's Blog
Awesome Excel tip #4
Hiding cells and unhiding cells to view particular sorts of data for calculations can be a real pain. But with grouping and toggling between open and closed states, it becomes super easy to close or […]
CAT
Simple macros in Excel Part 2 of 2
This is part 2 of 2 of macros in Excel. Here we actually create the macros and assign them to buttons. A macro is nothing more than a recorded set of keystrokes or instructions that […]
CAT
Simple macros in Excel Part 1 of 2
This is part one of 2 of macros in Excel. In this part we basically set the platform using RANDBETWEEN and conditional formatting . Nothing fancy here but it’s a nice exercise, similar to the […]
CAT
Grade 10 Excel Activity – different idea
Here is an idea I had and it proved to be a successful one. I gave my Grade 10’s an Excel activity to do in class. This time, I decided to try something different. I […]