Entrance Announcement
MICTE 2080
2080 Magh 07

Please contact us

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

Jump to navigation Jump to search

User:Saroj Neupane Real Teaching Lesson Plan 27 (view source)

Revision as of 01:18, 8 February 2024

102 bytes removed ,  8 February
m
no edit summary
VisualWikitext
No edit summary
mNo edit summary
Line 20: Line 20:
</div>
</div>
==Specific Objectives==
==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==
==Teaching Materials==
*Computers with Microsoft Excel installed
*Computers with Microsoft Excel installed
*Projector or interactive whiteboard
*Projector or interactive whiteboard
*https://drive.google.com/file/d/18lh0WNIdNngc5lvK-UAHCvO4bBRKDqd4/view?usp=sharing
*Slides


==Teaching Learning Activity==
==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.
*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.
*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.
*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 ==
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


===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.


__notoc__
__notoc__
Saroj Neupane
165

edits

Retrieved from "https://icted.org.np/index.php/Special:MobileDiff/4596"

Navigation menu