*Microsoft Excel: Simple Addition Formulas to Calculate Totals*:
---
*Lesson Topic:*
*Using Addition Formulas in Microsoft Excel to Calculate Totals*
*Level:* Cambridge Stage 6
*Subject:* ICT
*Duration:* 45 minutes
---
*Objective:*
Learners will be able to *use simple Excel formulas (e.g., =A1+B1, =SUM(A1:A5))* to calculate
totals in a spreadsheet.
---
*Lesson Outline*
*1. Introduction (10 min)*
*Content:*
- Introduction to Microsoft Excel interface (cells, columns, rows).
- What is a formula?
- When and why we use addition formulas.
*Teacher Activities:*
- Show sample Excel file.
- Demonstrate a basic formula like `=A1+B1`.
*Student Activities:*
- Open Excel.
- Identify cells and type sample numbers.
---
*2. Mediation and Assimilation (20 min)*
*Content:*
- Manual addition: `=A1+B1+C1`
- AutoSum function: `=SUM(A1:A3)`
*Teacher Activities:*
- Demonstrate both methods.
- Explain difference between manual and SUM function.
- Walk around to support students.
*Student Activities:*
- Enter numbers in cells.
- Try both methods.
- Ask questions.
---
*3. Mastery and Consolidation (15 min)*
*Content:*
- Apply formulas to a simple shopping list or marks table.
*Teacher Activities:*
- Provide practice file or worksheet.
- Assign task: total prices or scores using formulas.
*Student Activities:*
- Complete exercise using formulas.
- Save and submit work.
---
*Resources:*
- Computers with Excel
- Sample Excel practice file
- Projector or board for demo
---
*Assessment:*
- Observation during task
- Check if totals are correct using formulas
- Oral questions at the end
---
Let me know if you want this as a PDF or lesson handout.