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 set sub-types of numeric data including percentage, number of decimal places
Learning Objective/s:
  • Describe the purpose of numeric sub‑types in a database.
  • Identify the appropriate sub‑type (Integer, Decimal, Floating‑point, Percentage) for given data.
  • Set a Percentage sub‑type and define its decimal places using design view in Access or Base.
  • Configure a Decimal (fixed‑point) sub‑type with a specific number of decimal places.
  • Apply the correct sub‑type to ensure accurate data entry and calculations.
Materials Needed:
  • Computer lab with Microsoft Access or LibreOffice Base installed.
  • Projector and screen for demonstration.
  • Worksheet with practice scenarios.
  • Sample database file for hands‑on activity.
  • Whiteboard and markers.
 Introduction:
Today we’ll explore how the way numbers are stored affects calculations and reports. Building on your previous work with basic field types, you will learn to choose the right numeric sub‑type for percentages and fixed‑decimal values. By the end of the lesson you will be able to set these sub‑types correctly and explain why they matter.
Lesson Structure:
  1. Do‑Now (5') – Quick quiz on integer vs. decimal fields.
  2. Mini‑lecture (10') – Explain numeric sub‑types, show comparison table.
  3. Demonstration (15') – Live setting of a Percentage sub‑type in Access; adjust format property.
  4. Guided practice (15') – Students follow worksheet steps to set a Percentage field with one decimal place.
  5. Demonstration (10') – Setting a Decimal (fixed‑point) sub‑type for monetary values.
  6. Paired activity (15') – Students configure a “Tax Rate” field with two decimal places and test calculations.
  7. Check for understanding (5') – Exit ticket: write the stored value for a 12.5% entry.
  8. Recap & Homework (5') – Summarise key steps and assign creation of a small table using mixed numeric sub‑types.
Conclusion:
To recap, we examined how numeric sub‑types control storage, display and validation, and practiced setting Percentage and Decimal fields. Your exit ticket shows you can identify the stored value behind a displayed percentage. For homework, create a simple product table that uses Integer IDs, Decimal prices, and Percentage discount fields, documenting the steps you took.