Lesson Plan

• Explain why wrapping text is important for readability and layout in spreadsheets.
• Demonstrate how to apply and remove wrap text using the toolbar or menu in Excel, Google Sheets, and LibreOffice Calc.
• Apply manual line breaks and adjust row height to ensure all content is visible.

• Computer lab with spreadsheet software (Excel, Google Sheets, LibreOffice Calc).
• Projector or interactive whiteboard.
• Sample worksheet with long text entries.
• Handout of step‑by‑step instructions.
• Keyboard for Alt+Enter / Option+Return shortcuts.

Begin with a quick visual of a truncated cell on the screen to spark curiosity. Ask learners how they currently handle long entries and link to prior knowledge of cell formatting. Explain that by the end of the lesson they will be able to wrap text so every entry is fully visible.

1. Do‑now (5’) – Students view a worksheet with wrapped and unwrapped cells and note differences.
2. Mini‑lecture (10’) – Explain purpose of wrap text and locate the command in different programs.
3. Guided demonstration (12’) – Live demo applying wrap, adjusting row height, using Alt+Enter for manual breaks.
4. Hands‑on practice (15’) – Pupils apply wrap to their own sample sheet, troubleshoot row‑height issues, work in pairs.
5. Check for understanding (8’) – Quick quiz on steps and common issues; teacher reviews answers.

Recap the three key steps for wrapping text and the shortcuts for manual line breaks. Students complete an exit ticket describing how they would fix a cell that does not auto‑adjust. Assign homework to create a small report using wrapped text and bring it to the next class.