• Facebook
  • Twitter
  • YouTube
  • LinkedIn

TECH TEACHERS

A Collaborative Site for CAT and IT Teachers

  • Home
  • About
    • About Tech Teachers
    • About Matthew Hains
    • Donate to Tech Teachers
  • Teacher Resources
  • Buy stuff!
    • Digital Classroom Resource
    • View the Store
    • Account
    • My orders
    • Checkout
  • Contact
  • 0 items
HomeExcelExcel Functions

Excel Functions

CAT

Password generator in Excel activity

Feb 23, 2019Matthew Hains

Here is a great exercise to reinforce CONCATENATE, UPPER, RIGHT, LEFT, LOWER functions. Get your students to create their own password generator based on various factors. In the image below you can see how the […]

Excel

Secret Code messages in Excel

Feb 1, 2019Matthew Hains

Here is an activity I made using a few of the skills our CAT learners need to know. It’s a secret message decoder! Basically, numbers correspond to letters based in two sets. The task is […]

Excel

An idea in teaching Excel functions for Grade 10

Nov 28, 2018Matthew Hains

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 […]

Claire's Blog

CAT Training for Access & Excel

Sep 30, 2018Claire Smuts

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 […]

CAT

Excel Activity – COUNTIF

Jul 1, 2018Matthew Hains

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 […]

CAT

Excel Activity – SUMIF(s)

Jun 1, 2018Matthew Hains

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 […]

CAT

Excel Activity – Nested IFs (multiple IFs)

May 1, 2018Matthew Hains

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 […]

CAT

Excel Activity – IF

Apr 1, 2018Matthew Hains

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 […]

CAT

Excel Activity – HLOOKUP

Mar 1, 2018Matthew Hains

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 […]

CAT

Excel Activity – SUM

Feb 1, 2018Matthew Hains

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 […]

Posts navigation

123»

Stay connected

  • Facebook
  • Twitter
  • YouTube
  • LinkedIn

Categories

  • Matthew's Blog
  • Claire's Blog
  • Microbit tutorials
  • Guest Blogs
  • Check this out
  • CAT
  • ICT
  • Information Technology
  • Word of the Week
  • Excel
  • Excel Functions
  • P.A.T.
  • PowerPoint
  • Courses & Training
  • OneNote
  • Little Bytes
  • Delphi
  • Posters
  • Videos
  • StudyOpps Module Tests
  • Tech-Time
  • Successful teacher
  • Microbit Coding (Series)
  • Blogging Course (series)
  • HTML
  • Resources
  • Programming
  • Delphi Training Videos
  • SQL
  • Python
  • Testimonials
  • Spotlight
  • T’s & C’s
  • Shop T’s & C’s

© Matthew Hains