
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 […]
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 […]
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 […]
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 […]
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. […]
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.
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 […]
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 […]
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 […]
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 […]
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 […]
© Matthew Hains