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
- Whiteboard , marker and duster
- vedio clip
- 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.