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 to write a formula with functions that will help decipher the code and figure out what the sentence says.
This is a starting point for you, the teacher. I expect you to make it better and take it further!
If you like the font I used (see the screenshots), it’s called ‘Top Secret’ and you can download it here.
The activity consists of the following skills
- Data validation message (when cell is selected)
- Named ranges
- ISBLANK function
- NESTED IF statements
- Conditional formatting using icon sets
- CONCAT function