User:Saroj Neupane Real Teaching Lesson Plan 28

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.