Assessments That Don’t Suck: Creative PAT Ideas That Still Meet the IEB Standards
Ruval Gouws
, , , , , , , , , , , , , , , , , , , , , , , , , , , Blog, ruvalblog
Assessments That Don’t Suck: Creative PAT Ideas That Still Meet the IEB Standards
Let’s be honest—by the time we reach Term 2 and learners hear “PAT,” half the class has already mentally checked out. For many learners, the Practical Assessment Task (PAT) feels like a never-ending mountain of Word reports, Excel sheets, and Access databases that somehow manage to drain the joy out of CAT. But what if I told you the PAT doesn’t have to suck?

As a CAT teacher, I’ve learned that the secret to a successful PAT lies in relevance, creativity, and learner agency. Yes, we still need to stick to the IEB guidelines (and we do!), but that doesn’t mean we can’t have some fun along the way.

Step 1: Make the Topic Matter

Step 1 illustration Pick a topic that means something to your learners. Instead of another dry survey on “transport methods” or “favourite foods,” challenge your learners to create a solution to a real-world problem.

Here are a few themes:

  • School Improvement Projects – e.g., “How can we reduce waste at our school?” or “Should we switch to a 4-day school week?”
  • Local Impact Studies – e.g., “How load shedding affects small businesses in Mbombela”
  • Tech Trends – e.g., “Are learners using AI responsibly in their schoolwork?”

Give learners a voice in choosing the topic. A simple class vote can do wonders for buy-in.

Step 2: Gamify the Data

Step 2 illustration Data collection shouldn’t feel like a chore. Teach learners to create engaging surveys using Google Forms or Microsoft Forms, and show them how to use branching logic to make questions interactive.

Bonus: It helps them analyse data with purpose later in Excel.

Want to take it further? Turn the PAT into a class competition:

  • Best survey design
  • Most creative chart
  • Most insightful conclusion

Step 3: Guide, Don’t Dictate

Step 3 illustration Learners often get stuck in the report-writing phase. Provide them with scaffolding:

  1. Templates for Word reports
  2. A checklist for sections (Introduction, Methodology, Data Analysis, Conclusion, etc.)
  3. Examples of previous high-scoring PATs (anonymised, of course)

I create a shared Google Drive folder with everything learners might need, and set up weekly milestones with small submission deadlines. It helps prevent the last-minute panic.

Step 4: Bring It to Life

Step 4 illustration The PAT shouldn’t end as a static report on your desktop. Ask learners to present their findings—whether through a poster, a quick video summary, or a mock Shark Tank pitch where they “sell” their research.

This reinforces:

  • Presentation skills (hello, LO & Life Skills crossover!)
  • Digital literacy
  • A sense of purpose

You could even invite other teachers to the presentations—learners love showing off.

Step 5: Keep the Standards, Lose the Boredom

Step 5 illustration We’re not reinventing the wheel. The IEB PAT has clear outcomes: data collection, data analysis, Word processing, referencing, etc. All of that can still be done creatively. What changes is how we frame the task—and how much ownership we allow learners to take.

Final Thought: The PAT can be more than just a tick-box exercise. It can be the moment learners realise how powerful digital tools can be—and how they can use them to tell stories, solve problems, and change their world.

Let’s make PATs matter. And let’s make them memorable.

– Ruval Gouws | CAT Teacher, Creative Educator, PAT Enthusiast
“We don’t just teach tech. We teach how to think with tech.”

(0) Comments
Excel for CAT: CONVERT
Matt Hains
Blog
Excel for CAT: CONVERT

Many teachers focus on Excel’s basic functions like SUM, AVERAGE, and IF, but one underrated function that can make data handling more powerful and real-world applicable is CONVERT. This function allows users to convert values between different measurement units—making it a practical tool in finance, science, and engineering.

The CONVERT() function is especially useful when working with temperature, weight, distance, and time conversions. Since students often work with various data sets in different units, understanding how to switch between them quickly can be a game-changer.

Why Teach CONVERT()?

  1. Brings real-world relevance – Students interact with different measurement units daily, from weather forecasts (Celsius vs Fahrenheit) to weight measurements in kilograms vs pounds.
  2. Enhances problem-solving skills – Using a function like CONVERT introduces logical thinking in solving real-life conversion problems.
  3. Reduces errors in manual conversions – Instead of memorising formulas, students can automate unit changes with accuracy.

How to Introduce CONVERT() in Class

Start by showing the basic syntax:

=CONVERT(number, from_unit, to_unit)
  • number: The value you want to convert
  • from_unit: The unit of the original value
  • to_unit: The unit you want to convert to

The best way to demonstrate this is through real-life scenarios that students can relate to.

1. Converting Temperature: Celsius to Fahrenheit

Ask students: Have you ever wondered how weather reports in the US differ from those in South Africa?

Example:

=CONVERT(25, "C", "F")

This converts 25°C to Fahrenheit. The output will be 77°F.

Classroom Activity:
Give students a list of city temperatures in Celsius and ask them to convert them to Fahrenheit using Excel.

Variation: Extend this by converting Fahrenheit to Kelvin or vice versa.

2. Converting Weight: Kilograms to Pounds

Scenario: Imagine you are shopping online for weights at an international store that only lists weights in pounds (lbs), but you need them in kilograms.

Example:

=CONVERT(10, "kg", "lbm")

This converts 10 kg to pounds (approx. 22.05 lbs).

Classroom Activity:
Provide a mock online shopping spreadsheet with product weights in kg and ask students to convert them to lbs.

Variation: Convert grams to ounces for cooking-related data.

3. Converting Distance: Kilometres to Miles

Scenario: A student is training for an international marathon and needs to convert distances from km to miles.

Example:

=CONVERT(5, "km", "mi")

This converts 5 km to miles (~3.11 mi).

Classroom Activity:
Provide a list of marathon distances in km and ask students to convert them into miles.

Variation: Convert cm to inches for height-related comparisons.

4. Converting Time: Days to Years

Scenario: How old are you in years if you have lived for 5,000 days?

Example:

=CONVERT(5000, "day", "yr")

This converts 5,000 days to years (about 13.7 years).

Classroom Activity:
Ask students to calculate:

  • Their own age in days and convert it into years.
  • The time left until they turn 21 in both days and years.

Variation: Convert hours to minutes or seconds for a speed calculation exercise.

The CONVERT function is simple but incredibly powerful, bridging the gap between classroom learning and real-world application. By incorporating practical exercises around temperature, weight, distance, and time, students will better understand the importance of Excel beyond just number crunching.

(0) Comments
All Excel functions
admin
, Resources
All Excel functions

Here is a list of all the Excel functions as of September 2023

For Computer Applications Technology students, I have highlighted all the necessary functions to learn (red text). Note that I have also highlighted some functions that may not necessarily be required by CAPS but are incredibly useful and easier to use than other older functions. Using certain newer functions can replace using the older ones and are accepted when used to find a solution in Excel.

Click any function name for further information.

I’ve made a PDF of this that you can download, at the bottom of the table. Read More “All Excel functions”

(0) Comments