User:Saroj Neupane Real Teaching Lesson Plan 27

Subject: Computer Science

Class:9

Time:45 Minutes

Number of Students: 40

Unit:4

Topic:Basic Concept of Microsoft Excel

Period: 2nd

School: Shree Okhreni Secondary School

Specific Objectives

• At the end of the class students will understand the basic concepts of Microsoft Excel, including creating, navigating, and formatting workbooks and worksheets.

Teaching Materials

• Computers with Microsoft Excel installed
• Projector or interactive whiteboard
• https://drive.google.com/file/d/18lh0WNIdNngc5lvK-UAHCvO4bBRKDqd4/view?usp=sharing

Teaching Learning Activity

Introduction (5 minutes)

• Begin by discussing the importance of Microsoft Excel in organizing and analyzing data.
• Introduce key terms: workbook, worksheet, cell, column, row.
• Explain the concept of a workbook containing multiple worksheets and how it is a powerful tool for various tasks.

Activity 1: Creating a Workbook (10 minutes)

• Demonstrate how to open Microsoft Excel and create a new workbook.
• Guide students through the process of adding and renaming worksheets within the workbook.
• Teach basic keyboard shortcuts for efficient navigation (e.g., Ctrl + arrow keys).

Activity 2: Data Entry and Formatting (15 minutes)

• Show how to enter data into cells, emphasizing the importance of organizing information logically.
• Demonstrate basic formatting options, such as changing font styles, sizes, and cell alignment.
• Introduce cell formatting tools like borders, shading, and text color.

Activity 3: Basic Formulas (10 minutes)

• Introduce simple Excel formulas like SUM, AVERAGE, and COUNT.
• Provide examples and guide students through creating basic formulas.
• Emphasize the use of cell references in formulas for dynamic calculations.

Closure (5 minutes)

• Summarize the key points covered in the lesson: workbooks, worksheets, basic formatting, and simple formulas.
• Encourage students to practice what they've learned and explore more advanced features outside of class.
• Provide resources for further learning, such as online tutorials or Excel documentation.

Assessment

• Assign a small project or exercise for homework to reinforce the concepts learned in class.
• Assess students based on their ability to create a workbook, format data, and use basic formulas correctly.