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 work, I could get a few people working together with me online and we could maybe make a cool functions … Read moreAn idea in teaching Excel functions for Grade 10

CAT Training for Access & Excel

The Gauteng Department of Education presented teacher training in term 3, covering the most complicated concepts in Access & Excel. The training files and videos are available online. Please note there are also offline downloadable videos available that have an interactive player. YouTube playlist: Files & Offline videos

Excel Activity – COUNTIF

Each month I will create a new super-duper Excel activity that you can give to your students to practice with. I will cover the Functions needed as per CAPS requirements. There is a Questions worksheet and an Answers worksheet in each workbook. The teacher can choose to hide the Answers worksheet if they don’t want … Read moreExcel Activity – COUNTIF

Excel Activity – SUMIF(s)

Each month I will create a new super-duper Excel activity that you can give to your students to practice with. I will cover the Functions needed as per CAPS requirements. There is a Questions worksheet and an Answers worksheet in each workbook. The teacher can choose to hide the Answers worksheet if they don’t want … Read moreExcel Activity – SUMIF(s)

Excel Activity – Nested IFs (multiple IFs)

Each month I will create a new super-duper Excel activity that you can give to your students to practice with. I will cover the Functions needed as per CAPS requirements. There is a Questions worksheet and an Answers worksheet in each workbook. The teacher can choose to hide the Answers worksheet if they don’t want … Read moreExcel Activity – Nested IFs (multiple IFs)

Excel Activity – HLOOKUP

Each month I will create a new super-duper Excel activity that you can give to your students to practice with. I will cover the Functions needed as per CAPS requirements. There is a Questions worksheet and an Answers worksheet in each workbook. The teacher can choose to hide the Answers worksheet if they don’t want … Read moreExcel Activity – HLOOKUP

Rock Paper Scissors – Excel style

While I’ve been working on the various Excel activities, I designed a Rock Paper Scissors game in Excel to show how to use nested IFs. It is quite useful to teach logical structure, If-Then-Else statements and also includes the AND function. I thought it might make a nice challenge for some of your students! Note … Read moreRock Paper Scissors – Excel style