User:Saroj Neupane Real Teaching Lesson Plan 27: Difference between revisions

Latest revision as of 03:36, 12 March 2024

Subject: Computer Science
Class:9
Time:45 Minutes
Number of Students: 40
Unit:5
Topic:Basic Concept of Microsoft Excel
Period: 2nd
School: Shree Okhreni Secondary School

Specific Objectives

At the end of the class students will be able to
1. Define workbook,worksheet and cell.
2. Format the cells and use SUM, AVERAGE and COUNT function for calculation.

Teaching Materials

Computers with Microsoft Excel installed
Projector or interactive whiteboard
Slides

Teaching Learning Activity

Begin a class by discussing about the MS Excel and importance of Microsoft Excel in organizing and analyzing data
Introduce key terms: workbook, worksheet, cell, column, row.

Demonstrate how to open Microsoft Excel and create a new workbook.
Guide students through the process of adding and renaming worksheets within the workbook

Demonstrate how to enter data into cells and basic formatting options, such as changing font styles, sizes, and cell alignment.
Introduce cell formatting tools like borders, shading, and text color.

Introduce simple Excel formulas like SUM, AVERAGE, and COUNT and dmonstrate it with examples and allows students to practice in thier computers.
Guide the students to entry data in cell ,formatting and working with formulas.
Summarize the key points covered in the lesson: workbooks, worksheets, basic formatting, and simple formulas.
Encourage students to ask questions.

Evaluation

What is workbook and worksheet?
Enter these data in cell in column A and find sum and average by using SUM and Average function ? Also count the numbers of data entry?

Data: (20,25,30,35,40,,45,50,55)

Homework

1. Define workbook,worksheet and cell in MS Excel?

2. What is SUM function? How it works explain with example.

................................ ........................................... ..........................................

Student Teacher Subject Teacher Supervisor

@@ Line 9: / Line 9: @@
 |Number of Students: 40
 |-
-|Unit:4
+|Unit:5
 |-
 |Topic:Basic Concept of Microsoft Excel
@@ Line 20: / Line 20: @@
 </div>
 ==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.
+*At the end of the class students will be able to
+*#Define workbook,worksheet and cell.
+*#Format the cells and use SUM, AVERAGE and COUNT function for calculation.
 ==Teaching Materials==
 *Computers with Microsoft Excel installed
 *Projector or interactive whiteboard
-*https://drive.google.com/file/d/18lh0WNIdNngc5lvK-UAHCvO4bBRKDqd4/view?usp=sharing
+*Slides
 ==Teaching Learning Activity==
-===Introduction (5 minutes)===
+*Begin a class by discussing about the MS Excel and  importance of Microsoft Excel in organizing and analyzing data
-*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.
+*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)===
+*Demonstrate how to enter data into cells and basic formatting options, such as changing font styles, sizes, and cell alignment.
-*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 and dmonstrate  it with examples and allows students to practice in thier computers.
-*Introduce simple Excel formulas like SUM, AVERAGE, and COUNT.
+*Guide the students  to entry data in cell ,formatting and working with formulas.
-*Provide examples and guide students through creating basic formulas.
+*Summarize the key points covered in the lesson: workbooks, worksheets, basic formatting, and simple formulas.
-*Emphasize the use of cell references in formulas for dynamic calculations.
+*Encourage students  to ask questions.
+==Evaluation==
+#What is workbook and worksheet?
+#Enter these data in cell in column A  and find sum and average by using SUM and Average function ? Also count the numbers of data entry?
+Data: (20,25,30,35,40,,45,50,55)
+== Homework ==
+. Define workbook,worksheet and cell in MS Excel?
+. What is  SUM function? How it works explain with example.
+'''................................                                                     ...........................................                                                           ..........................................'''
-===Closure (5 minutes)===
+Student Teacher                                                                 Subject Teacher                                                                                Supervisor
-*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.
+[[Category: Lesson Plan]]
 __notoc__
+[[Category: BICTE]]