ICTED-WIKI

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.
Retrieved from "https://icted.org.np/index.php?title=User:Saroj_Neupane_Real_Teaching_Lesson_Plan_28&oldid=5055"