Scribd
Upload
5 views2 pages

Note

The lesson plan focuses on introducing students to Excel spreadsheets over an 80-minute session. Students will learn to identify the Excel interface, enter and edit data, apply basic formatting, use simple formulas, and create charts. The lesson includes a mix of presentation, hands-on activities, discussions, and assessments to reinforce learning.

Uploaded by

davidkwaning792
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views2 pages

Note

The lesson plan focuses on introducing students to Excel spreadsheets over an 80-minute session. Students will learn to identify the Excel interface, enter and edit data, apply basic formatting, use simple formulas, and create charts. The lesson includes a mix of presentation, hands-on activities, discussions, and assessments to reinforce learning.

Uploaded by

davidkwaning792
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Lesson Plan: ICT (Excel Spreadsheet)

Topic

Introduction to Excel Spreadsheet

Duration

80 minutes (double period)

Objectives

By the end of the lesson, students should be able to:

 Identify parts of the Excel interface (worksheet, rows, columns, cells, ribbon).
 Enter and edit data in cells.
 Apply basic formatting (bold, italics, borders, cell color).
 Use simple formulas (SUM, AVERAGE, MIN, MAX).
 Create a basic chart from data.

Teaching and Learning Materials

 Computers with Microsoft Excel installed


 Projector or whiteboard
 Sample dataset (e.g., students’ exam scores)
 Handouts summarizing Excel shortcuts

Lesson Outline

1. Introduction (10 minutes)

 Ask: “How do you calculate class averages quickly?”


 Relate answers to the usefulness of Excel spreadsheets.

2. Presentation (25 minutes)

 Demonstrate Excel interface: workbook, worksheet, rows, columns, cells.


 Show how to enter text, numbers, and edit data.
 Explain cell referencing (A1, B2, etc.).
 Introduce formulas: =SUM(A1:A5), =AVERAGE(B1:B10).

3. Class Activity (20 minutes)

 Students enter sample exam scores into Excel.


 Calculate total and average using formulas.
 Format cells (bold headings, borders, shading).
 Create a bar chart of scores.

4. Discussion (15 minutes)

 Discuss real-life uses of Excel: budgeting, data analysis, record keeping.


 Compare manual calculation vs Excel efficiency.

5. Conclusion (10 minutes)

 Recap key points.


 Assign homework: Create a personal budget spreadsheet with at least 10 items.

Assessment

 Oral questioning during class.


 Observation of practical activity.
 Short quiz on Excel formulas and formatting.

You might also like