Educator. Author. Speaker. Teacher ICT Development. M.Ed. MOS. MIEE.
I have redone all my Excel posters and added some new ones too! This set now has 55 Excel functions that your students can learn and use in their work. All posters are high-quality, printable up A3 and look great when laminated. Each poster has a function explanation, layout example, a screenshot example and a … Read more
Definitely a time saver and a neat feature called Flash Fill! In Excel, you can suggest a pattern and then use the Flash Fill tool to learn from that pattern and continue on down a column. See the video below how it works.
Here is a nice exercise to toy around with for your Grade 11 and Grade 12 students. Use Excel with nested IF statements, random numbers and a simple macro to create an automatic “Rock, Paper, Scissors” Game. You will need to unlock the worksheets to see how I put it together. It could even be … Read more
One of the parts of my job that I thoroughly enjoy is creating content that teaches people how to do things with software. At my school, I am very fortunate to have the role of helping teachers develop themselves professionally in Information and Communication Technology. During a recent training session, I had the opportunity to … Read more
Here is a video recording of the Macros in Excel workshop that I ran (in Feb 2019) for teachers needing to learn about macros as they were being added to the Computer Applications Technology curriculum. It was a lot of fun and I think all the participants enjoyed it too! If you are interested in … Read more
I was given an hour to do some basic training for our staff at my school – before the start of our new Term. I love creating content and training teachers! So, I created some content covering some basic skills that I thought teachers could make use of and I put it into an online … Read more
Here is a short 40-mark assessment you can use for your Grade 10’s. It covers Word and Excel basics. In Excel it has graph creation, sorting and filtering. In Word it has bullet formatting, indenting and converting text to tables. Feel free to use it for your classes.
I was busy with Excel and about to generate random numbers the same way I usually did using the RAND function. All of a sudden a new Function popped up that I had not seen before! After a few minutes of playing…it made perfect sense to use the RANDARRAY function for the generating of random … Read more
I used to use a macro I found online to duplicate a worksheet based on a list of names. It is very easy to do, using a macro, but I found an even easier way! I use an add-in for Excel called Kutools and it makes using Excel even easier! Check out the video below to see … Read more