Entrance Announcement
MICTE 2080
2080 Magh 07

Please contact us

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

From ICTED-WIKI
Jump to navigation Jump to search
VisualWikitext
(Created page with "<div style="column-count: 2; column-gap: 20px;"> {| class="wikitable" |Subject: Computer Science |- | Class:9 |- |Time:45 Minutes |- |Number of Students: 40 |- |Unit:4 |- |Topic:Essential Statistical Functions in Microsoft Excel |- |Period: 2nd |- |School: Shree Okhreni Secondary School |- |} </div> Objective: Participants will learn how to use essential statistical functions in Excel for data analysis and summarization. Materials Needed: Computers with Excel insta...")
 
 
(2 intermediate revisions by one other user not shown)
Line 18: Line 18:
|-
|-
|}
|}
</div>  
</div>
Objective:
Participants will learn how to use essential statistical functions in Excel for data analysis and summarization.


Materials Needed:
== Specific Objectives ==


Computers with Excel installed
* At the end of the class participants will learn how to use essential statistical functions in Excel for data analysis and summarization.
Projector or screen for demonstration
Sample datasets for practice exercises
Agenda:


Introduction (5 minutes):
== Teaching Materials ==


Briefly introduce the importance of statistical functions in Excel for data analysis.
* Computers with Excel installed
Emphasize that these functions are fundamental tools for summarizing and understanding numerical data.
* Projector or screen for demonstration
Overview of Data (5 minutes):
* Sample datasets for practice exercises


Discuss the importance of understanding the dataset before applying statistical functions.
== Teaching Learning Activity ==
Introduce a sample dataset or use a pre-prepared dataset to work with during the session.
1. SUM Function (8 minutes):


Explain the purpose of the SUM function for adding up numerical values.
=== Introduction (5 minutes): ===
Demonstrate how to use the SUM function on a set of numbers.
Show how to use AutoSum for quick calculations.
Practice Exercise - SUM (5 minutes):


Participants will practice using the SUM function on a provided set of numbers.
* Briefly introduce the importance of statistical functions in Excel for data analysis.
2. AVERAGE Function (8 minutes):
* Emphasize that these functions are fundamental tools for summarizing and understanding numerical data.Overview of Data (5 minutes):


Explain the importance of finding the average in data analysis.
* Discuss the importance of understanding the dataset before applying statistical functions.
Demonstrate how to use the AVERAGE function on a set of numbers.
* Introduce a sample dataset or use a pre-prepared dataset to work with during the session.
Discuss variations like AVERAGEIF for conditional averaging.
Practice Exercise - AVERAGE (5 minutes):


Participants will practice finding the average using a different set of numbers.
=== 1. SUM Function (8 minutes): ===
3. MIN and MAX Functions (8 minutes):


Explain the significance of identifying the minimum and maximum values in a dataset.
* Explain the purpose of the SUM function for adding up numerical values.
Demonstrate how to use the MIN and MAX functions.
* Demonstrate how to use the SUM function on a set of numbers.
Discuss scenarios where these functions are useful.
* Show how to use AutoSum for quick calculations.
Practice Exercise - MIN and MAX (5 minutes):


Participants will practice finding the minimum and maximum values in a dataset.
* Participants will practice using the SUM function on a provided set of numbers.
4. PERCENTAGE Calculation (8 minutes):


Discuss scenarios where percentages are useful in data analysis.
=== 2. AVERAGE Function (8 minutes): ===
Demonstrate how to perform percentage calculations using basic examples.
Show the application of the percentage format.
Practice Exercise - Percentage Calculation (5 minutes):


Participants will practice calculating percentages based on given scenarios.
* Explain the importance of finding the average in data analysis.
5. COUNT Function (8 minutes):
* Demonstrate how to use the AVERAGE function on a set of numbers.
* Discuss variations like AVERAGEIF for conditional averaging.


Explain the COUNT function for counting cells with numerical values.
* Participants will practice finding the average using a different set of numbers.
Introduce COUNTA for counting non-empty cells.
Demonstrate COUNTIF for counting cells based on a specific condition.
Practice Exercise - COUNT (5 minutes):


Participants will practice using COUNT functions on different sets of data.
=== 3. MIN and MAX Functions (8 minutes): ===
Q&A and Recap (5 minutes):


Open the floor for questions and address any concerns or difficulties participants may have encountered.
* Explain the significance of identifying the minimum and maximum values in a dataset.
Recap the key points covered in the session.
* Demonstrate how to use the MIN and MAX functions.
Conclusion:
* Discuss scenarios where these functions are useful.


Encourage participants to explore and apply these functions to their own datasets.
* Participants will practice finding the minimum and maximum values in a dataset.
Provide additional resources or tutorials for continued learning.
 
=== 4. PERCENTAGE Calculation (8 minutes): ===
 
* Discuss scenarios where percentages are useful in data analysis.
* Demonstrate how to perform percentage calculations using basic examples.
* Show the application of the percentage format.
 
* Participants will practice calculating percentages based on given scenarios.
 
=== 5. COUNT Function (8 minutes): ===
 
* Explain the COUNT function for counting cells with numerical values.
* Introduce COUNTA for counting non-empty cells.
* Demonstrate COUNTIF for counting cells based on a specific condition.
 
* Participants will practice using COUNT functions on different sets of data.
 
=== Q&A and Recap (5 minutes): ===
 
* Open the floor for questions and address any concerns or difficulties participants may have encountered.
* Recap the key points covered in the session.
 
=== Conclusion: ===
 
* Encourage participants to explore and apply these functions to their own datasets.
* Provide additional resources or tutorials for continued learning.
 
== Assessment ==
 
* Assess the student based on their classroom actvities and performance.
 
[[Category: Lesson Plan]]
__notoc__
[[Category: BICTE]]

Latest revision as of 03:36, 12 March 2024

Subject: Computer Science
Class:9
Time:45 Minutes
Number of Students: 40
Unit:4
Topic:Essential Statistical Functions in Microsoft Excel
Period: 2nd
School: Shree Okhreni Secondary School

Specific Objectives

  • At the end of the class participants will learn how to use essential statistical functions in Excel for data analysis and summarization.

Teaching Materials

  • Computers with Excel installed
  • Projector or screen for demonstration
  • Sample datasets for practice exercises

Teaching Learning Activity

Introduction (5 minutes):

  • Briefly introduce the importance of statistical functions in Excel for data analysis.
  • Emphasize that these functions are fundamental tools for summarizing and understanding numerical data.Overview of Data (5 minutes):
  • Discuss the importance of understanding the dataset before applying statistical functions.
  • Introduce a sample dataset or use a pre-prepared dataset to work with during the session.

1. SUM Function (8 minutes):

  • Explain the purpose of the SUM function for adding up numerical values.
  • Demonstrate how to use the SUM function on a set of numbers.
  • Show how to use AutoSum for quick calculations.
  • Participants will practice using the SUM function on a provided set of numbers.

2. AVERAGE Function (8 minutes):

  • Explain the importance of finding the average in data analysis.
  • Demonstrate how to use the AVERAGE function on a set of numbers.
  • Discuss variations like AVERAGEIF for conditional averaging.
  • Participants will practice finding the average using a different set of numbers.

3. MIN and MAX Functions (8 minutes):

  • Explain the significance of identifying the minimum and maximum values in a dataset.
  • Demonstrate how to use the MIN and MAX functions.
  • Discuss scenarios where these functions are useful.
  • Participants will practice finding the minimum and maximum values in a dataset.

4. PERCENTAGE Calculation (8 minutes):

  • Discuss scenarios where percentages are useful in data analysis.
  • Demonstrate how to perform percentage calculations using basic examples.
  • Show the application of the percentage format.
  • Participants will practice calculating percentages based on given scenarios.

5. COUNT Function (8 minutes):

  • Explain the COUNT function for counting cells with numerical values.
  • Introduce COUNTA for counting non-empty cells.
  • Demonstrate COUNTIF for counting cells based on a specific condition.
  • Participants will practice using COUNT functions on different sets of data.

Q&A and Recap (5 minutes):

  • Open the floor for questions and address any concerns or difficulties participants may have encountered.
  • Recap the key points covered in the session.

Conclusion:

  • Encourage participants to explore and apply these functions to their own datasets.
  • Provide additional resources or tutorials for continued learning.

Assessment

  • Assess the student based on their classroom actvities and performance.
Retrieved from "https://icted.org.np/index.php?title=User:Saroj_Neupane_Real_Teaching_Lesson_Plan_28&oldid=5055"