• 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
Homefunctions

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

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

CAT

Create a password generator in Excel

Sep 12, 2017Matthew 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 […]

Matthew's Blog

Excel Functions Quick-Reference app for CAT students

Jul 25, 2015Matthew Hains

My second app is also available now for testing and feedback. I made a Reference app for Excel functions. It covers the functions we cover in Excel from Grade 10 to Grade 12 in the […]

CAT

Excel Cheat Sheet poster

Jun 2, 2015Matthew Hains

Click the pic below to download.

CAT

Excel Functions ~ Text manipulation, Nested IFs and VLOOKUP

May 26, 2014Matthew Hains

How to use Microsoft Excel functions that include Nested IFs, VLOOKUP, LEN, FIND, LEFT, RIGHT, MID, &, LEN, UPPER […]

CAT

Excel Functions ~ Text manipulation

May 12, 2014Matthew Hains

How to use Microsoft Excel functions to manipulate text like LEN, FIND, LEFT, RIGHT, MID, &, UPPER […]

CAT

CAT MS Excel exercise

Aug 31, 2013Matthew Hains

I have added an Excel spreadsheet exercise for Grade 12 but it can also be used for Grade 11 as well. I used some data from an old exam paper and modified it a bit. […]

CAT

Assessment materials added for Grade 10 CAT

Aug 27, 2013Matthew Hains

I have added two more assessments to the Tech Teachers shared folders. These are for Grade 10 CAT learners. Grade 10 Cycle Test (for next term) covering MS Word skills such as : Hyperlinks and […]

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