Lesson Plan

• Describe how numeric display formats affect visual representation without changing the underlying data.
• Apply decimal‑place, currency, and percentage format codes in spreadsheet or database cells.
• Demonstrate selecting cells and using the Format Cells dialog to set the desired numeric format.
• Evaluate the impact of different format codes on data readability and reporting.

• Projector and screen
• Computer lab with spreadsheet software (Excel/Google Sheets)
• Sample data worksheet (printed and digital)
• Handout of common format codes
• Whiteboard and markers

Start with a quick question: “How would you show a price of 2500 in a report so it looks professional?” Review that formatting changes only the appearance, not the stored value. Explain that by the end of the lesson students will be able to control decimal places, add currency symbols, and display percentages correctly.

1. Do‑now (5') – Students examine a printed table of numbers and discuss which formats improve readability.
2. Mini‑lecture (10') – Explain decimal places, currency symbols, and percentage formats; demonstrate format‑code syntax on the projector.
3. Guided practice (15') – In pairs, students open a spreadsheet, enter sample values and apply the appropriate format codes using the Format Cells dialog. Teacher circulates to support.
4. Independent worksheet (10') – Complete the practice exercises from the source notes, recording the displayed results.
5. Quick check (5') – Whole‑class review of answers; clarify misconceptions about underlying data.
6. Exit ticket (5') – Write one sentence describing what happens to the stored value when a cell is formatted as a percentage.

Recap that numeric formatting changes only how numbers appear, reinforcing the four key format categories. Collect exit tickets to gauge understanding, and assign homework: create a small sales data set and apply at least three different numeric formats, bringing screenshots to the next lesson.