Lesson Plan

Resources → Subject Notes → Information Technology IT → Notes
Lesson Plan
Grade: Date: 17/01/2026
Subject: Information Technology IT
Lesson Topic: Create spreadsheet structures (page setup, headers)
Learning Objective/s:
  • Describe page layout settings and their impact on printed spreadsheets.
  • Configure headers and footers to include key information such as page numbers and dates.
  • Apply repeat rows/columns and scaling options to ensure data readability across pages.
  • Protect header rows while allowing data entry in other cells.
  • Evaluate a spreadsheet’s print preview to verify proper formatting.
Materials Needed:
  • Computer with spreadsheet software (e.g., Excel or Google Sheets)
  • Projector or interactive whiteboard
  • Sample workbook for demonstration
  • Handout with step‑by‑step checklist
  • Print‑preview screenshots
  • Worksheet for student practice
 Introduction:
Begin with a quick question: How many times have you printed a spreadsheet only to see data cut off or misaligned? Review the previous lesson on basic data entry and formatting, then explain that today’s success criteria include setting up page layout and creating functional headers so the printed report is clear and professional.
Lesson Structure:
  1. Do‑now (5'): Students examine a poorly formatted printed sheet and note issues. (5')
  2. Teacher demonstration (10'): Open a new workbook, show the Page Layout tab, set orientation, paper size, and margins. (10')
  3. Scaling & print area (8'): Adjust scaling to “Fit to Page,” define the print area, and set repeat rows/columns. (8')
  4. Headers & footers (10'): Insert page number, date, and custom text; format the header row for readability. (10')
  5. Protection & review (7'): Lock header cells, protect the worksheet, and check the print preview. (7')
  6. Guided practice (15'): Students replicate the steps on their own workbook while the teacher circulates to provide support. (15')
Conclusion:
Recap the key steps for setting up page layout and creating effective headers. Ask each student to write one tip they will use next time they print a spreadsheet as an exit ticket. Assign homework to design a printable sales report using the techniques practiced today.