| Lesson Plan |
| Grade: |
Date: 25/02/2026 |
| Subject: Information Communication Technology ICT |
| Lesson Topic: Be able to enhance a spreadsheet including text colour, cell colour, bold, underline, italic, shading |
Learning Objective/s:
- Apply text colour, cell colour, bold, italic, underline, and shading to improve spreadsheet readability.
- Demonstrate the use of keyboard shortcuts for common formatting actions.
- Evaluate a data set and select appropriate formatting to highlight key information.
- Create a professionally formatted sales report using multiple enhancement techniques.
|
Materials Needed:
- Computer lab with spreadsheet software (Excel or Google Sheets)
- Projector and screen
- Sample data worksheets (digital)
- Teacher’s demonstration file
- Handout of keyboard shortcuts and formatting checklist
- Whiteboard and markers
|
Introduction:
Begin with a quick question: “How does formatting help you read data faster?” Review students’ prior experience with basic cell entry, then state that by the end of the lesson they will be able to format spreadsheets professionally and use shortcuts to work efficiently.
|
Lesson Structure:
- Do‑now (5'): Students open a plain worksheet and note which parts look difficult to read.
- Mini‑lecture (10'): Explain why formatting matters; demonstrate toolbar icons and shortcuts for text colour, bold, italic, underline, cell colour, and shading.
- Guided demonstration (15'): Teacher formats a sample sales table step‑by‑step, modelling each enhancement and shortcut.
- Pair practice (10'): Learners apply the same techniques to a new data set, using the checklist; teacher circulates to support.
- Exit ticket (5'): Students answer two quick questions on the checklist to confirm mastery.
|
Conclusion:
Recap the key formatting tools and how they improve data presentation. Collect exit tickets to gauge understanding, and remind students to practice the shortcuts at home. Assign a homework task: format a personal budget spreadsheet using all the techniques learned.
|