Lesson Plan

• Describe why adjusting row height and column width is essential for data visibility and professional presentation.
• Demonstrate how to use drag, Auto‑Fit, and specific size options to modify column width and row height.
• Apply wrap text, merge cells, and shrink‑to‑fit tools to ensure all cell content and formulas are fully visible.
• Evaluate a worksheet for hidden or truncated data and correct sizing errors before printing.

• Projector and screen
• Computer with spreadsheet software (Excel/Google Sheets)
• Sample worksheet handout
• Whiteboard and markers
• Printed checklist for sizing verification

Begin with a quick demo of a truncated spreadsheet to spark curiosity. Review students’ prior experience with basic cell formatting. Explain that today they will master sizing techniques so every piece of data and formula is clearly visible, which will be the success criteria for the lesson.

1. Do‑Now (5'): Students examine a printed sheet with hidden data and note problems.
2. Direct Instruction (10'): Teacher models dragging, Auto‑Fit, and setting exact widths/heights.
3. Guided Practice (15'): Whole‑class activity adjusting a shared worksheet using the three methods.
4. Tool Exploration (10'): Quick demo of Wrap Text, Merge Cells, and Shrink‑to‑Fit, followed by pair work applying each tool.
5. Independent Task (10'): Students complete the five‑step practice activity on their own computers.
6. Check for Understanding (5'): Exit ticket – students write one tip for ensuring all content is visible.

Recap the key sizing strategies and highlight common pitfalls to avoid. Collect exit tickets to gauge understanding, and remind students to use the printed checklist when preparing reports. For homework, ask them to create a mini‑inventory sheet and ensure all columns and rows are optimally sized for printing.