User:Mina Bhatta Real teaching lesson plan 10

Subject : computer science	School; Shree mahendra Basic School
Class: 6	Period: 5
Unit : 8	Time : 45 minutes
Topic: main parts of MS-Excel	Number of student: 30

Objective:

At the end of lesson , student will able to Understand:

• The main component of MS Excel.

• Provide an overview of essential tools and feature with in excel.

Teaching materials:

• laptop
• marker and duster

Teaching Learning activity:

• Begin by explaining the significance of Microsoft Excel in data management and analysis.
• Outline the key components to be covered.

Excel Interface Overview

• Use Microsoft Word to showcase screenshots or diagrams of the Excel interface.
• Point out the Ribbon, Cells, Columns, Rows, and Tabs to give students a visual understanding.

Navigating Excel Worksheets

• Explain how to navigate through worksheets using Microsoft Word.
• Highlight the importance of understanding the layout for efficient data manipulation.

Data Entry and Formatting

• Demonstrate data entry in Excel through Word, focusing on basic formatting options.
• Emphasize the importance of consistent formatting for clarity.

Basic Formulas and Functions

• Use Word to illustrate examples of basic formulas such as SUM, AVERAGE, and COUNT.
• Discuss common functions and their applications. 6. *Cell Referencing
• Explain cell referencing using Word, illustrating both relative and absolute references.
• Provide scenarios where each type of referencing is appropriate.

Charts and Visualizations

Utilize Word to display visuals of different chart types in Excel.

Discuss when to use specific charts based on the nature of the data.

Q&A and Hands-on Practice

• Encourage students to ask questions.
• Allocate time for hands-on practice, allowing students to explore the concepts discussed.

Wrap-up and Assignment

• Summarize key takeaways from the lesson.
• Assign a simple task for students to apply what they've learned, encouraging independent exploration.