Lesson Plan

Resources → Subject Notes → Information Communication Technology ICT → Notes
Lesson Plan
Grade: Date: 25/02/2026
Subject: Information Communication Technology ICT
Lesson Topic: Be able to use a single criterion, or multiple criteria to sort data into ascending or descending order
Learning Objective/s:
  • Describe the purpose and benefits of sorting data in a database.
  • Apply sorting by a single criterion in ascending or descending order using database software.
  • Apply sorting by multiple criteria to achieve hierarchical ordering.
  • Identify common sorting pitfalls and how to resolve them.
  • Evaluate sorted query results and export them correctly.
Materials Needed:
  • Computer lab with database software (e.g., Microsoft Access or LibreOffice Base)
  • Projector and screen
  • Sample database files (Employees, Products, Orders)
  • Worksheet with practice tasks
  • Printed handout of sorting steps and key points
  • Internet access for reference videos (optional)
 Introduction:
Begin with a quick question: How many of you have ever looked for the highest sales figure in a spreadsheet? Today we’ll build on your prior experience with tables to sort records efficiently. By the end of the lesson you will know how to sort by one field or by several fields, and you’ll be able to spot common errors. Success will be measured by completing the practice activities correctly.
Lesson Structure:
  1. Do‑Now (5') – Students answer the opening question on a sticky note and share examples of when sorting helped them.
  2. Mini‑lecture (10') – Explain ascending vs descending, single‑criterion sort steps; demonstrate on projector.
  3. Guided practice (12') – Students sort the sample “Students” table by Score descending; teacher circulates and checks.
  4. Multi‑criterion demo (10') – Show sorting the “Products” table by Category (Asc) then Price (Desc); discuss hierarchy.
  5. Independent activity (15') – Learners complete worksheet tasks (sorting by Last Name, Department/Salary, Orders query) and record observations.
  6. Pitfalls discussion (5') – Review common issues (text vs numeric, leading spaces) and how to fix them.
  7. Exit ticket (3') – Students write one tip they will use when sorting data.
Conclusion:
To recap, we explored why sorting is essential, how to sort by one or multiple fields, and how to avoid typical errors. For the exit ticket, share one sorting tip you’ll apply in future work. For homework, export a sorted query from the sample database and write a brief reflection on the process.