| Lesson Plan |
| Grade: |
Date: 01/12/2025 |
| Subject: Information Communication Technology ICT |
| Lesson Topic: Be able to insert cell(s), row(s) and column(s), delete cell(s), row(s) and column(s), merge cells |
Learning Objective/s:
- Insert rows, columns, and cells using menu options, right‑click, or keyboard shortcuts.
- Delete rows, columns, and cells applying the appropriate shift (left/up) options.
- Merge and unmerge cells to create and modify headings or formatted tables.
- Demonstrate efficient use of shortcuts for inserting and deleting.
- Complete a practical spreadsheet task that combines inserting, deleting, and merging operations.
|
Materials Needed:
- Computers with spreadsheet software (Excel, Google Sheets, etc.)
- Projector or interactive whiteboard
- Sample worksheet (digital or printed)
- Teacher shortcut handout
- Student practice worksheets
- Exit‑ticket slips or digital form
|
Introduction:
Begin with a quick question about how students currently organise data in spreadsheets to activate prior knowledge. Explain that today they will master the core editing tools—insert, delete, and merge—that make spreadsheets flexible. State that success will be shown by completing a realistic sales‑report task using these tools.
|
Lesson Structure:
- Do‑now (5'): Students answer three quick‑check questions on cell shifting and shortcuts.
- Teacher demo – inserting rows, columns, and cells (10'): Show menu, right‑click, and shortcut methods.
- Guided practice – inserting cells (8'): Students follow on their computers while teacher circulates.
- Demo – deleting rows, columns, and cells with shift options (10').
- Paired activity – apply insert and delete tasks to a sample sales table (10').
- Merge cells tutorial – create a centered title and discuss unmerging (7').
- Independent task – complete the full practical example (10').
- Exit ticket (5'): Write one shortcut or tip they found most useful.
|
Conclusion:
Recap the three key operations—insert, delete, merge—and highlight how they improve worksheet layout. Collect exit tickets to gauge understanding and assign a short homework: students create a new worksheet that incorporates at least two insertions, one deletion, and a merged header.
|