User:Mina Bhatta Real teaching lesson plan 13

Subject: Computer science	Number of students; 30
Class: 6	Period: 5th
Unit: 8	Time:45minutes
Topic: essential statistical function in excel	School: Shree Mahendra Basic School

Objective:

• 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:

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

• 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

• 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

• 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

• 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 Calculate

• 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

• 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

• 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 actvites and performance.