User:Ram baduwal Real Teaching Lesson Plan 26

Subject: Computer science

Topic: MS Excel

Time: 45 minutes

Number of student: 25

Class: 9

Period: 5th

School: Shree Okhreni Secondary School

Specific Objectives:

1. Understand the basics of Microsoft Excel.
2. Learn to navigate and work with cells, rows, and columns.
3. Create a simple spreadsheet for data entry and basic calculations.

Teaching Aids:

1. Computers with Microsoft Excel installed
2. Projector and screen
3. Handouts with basic Excel shortcuts and tips

Classroom Activities:(35 min )

• Briefly introduce Microsoft Excel and its significance in organizing data and performing calculations.
• Discuss real-world applications of spreadsheets in various fields.

Overview of Excel Interface

• Open Excel and explain the main components of the interface:

1. Ribbon
2. Cells, rows, and columns
3. Worksheets and workbooks
4. Formula bar

Data Entry and Formatting

• Demonstrate how to enter data into cells.
• Explain formatting options, including changing font styles, cell alignment, and cell borders.
• Discuss the importance of clear and organized data presentation.

Basic Formulas

• Introduce basic Excel formulas such as SUM, AVERAGE, and COUNT.
• Guide students in creating simple formulas for calculating totals and averages.

Cell Referencing

• Explain the concept of cell referencing (relative and absolute).
• Demonstrate how to copy formulas to multiple cells.

Charts and Graphs

• Briefly introduce the creation of charts/graphs from data.
• Show how to select data and choose appropriate chart types.

Practice Time

• Allow students to practice what they have learned by creating a basic spreadsheet with data, formatting, and formulas.
• Walk around to provide assistance and answer questions.

Review and Q&A

• Recap the key points covered in the lesson.
• Encourage students to ask questions and seek clarification.

Conclusion:(5min)

• Microsoft Excel serves as a versatile and indispensable tool for data organization, analysis, and visualization. Its user-friendly interface and powerful functionalities make it an essential skill for effective information management.

Evaluation:(5min)

• Informally assess students during the practice session.
• Review homework assignments for understanding and application of Excel skills.