Sample lesson plans

Topic: Using Excel

Author: Orawan Wangsombat


Date: 14^th of October 2004


Time: 30 minutes


Materials needed: Microsoft Excel
Teacher level: expert


Student level: beginner


Learning styles/intelligences supported:

• 
  Mastery learning style
  
• 
  Intrapersonal
  
• 
  Visual-spatial
  
• 
  Logical-mathematical
  

Why technology is used in this lesson:

• 
  To help calculate budgets and create charts and tables from numeric data
  
• 
  To save time
  

Overview:
Excel is a program that is usually used to calculate and create charts and tables from numeric data.


Objectives:
By the end of the lesson, workshop participants will be able to:

• 
  Create columns and rows
  
• 
  Calculate numbers by using formulas
  
• 
  Create charts and tables
  

Training content:


Warm-up activities/review:

• 
  Ask reasons to use Excel for grading
  

Instructions:

• 
  Create columns and rows
  
• 
  Types the names of each column
  
• 
  Type students’ names in each row
  
• 
  Enter data
  
• 
  Enter formulas
  
  • 
    In the Total points column, type a formula: =SUM(cell:cell)
    

For example: =SUM(B4:G4)

• 
  In the Average column, type a formula: =cell/number
  

For example: =G4/3


Follow-up activities:

• 
  Enter formulas
  
  • 
    In the Total points column, type a formula: =SUM(cell:cell)
    

For example: =SUM(B4:G4)

• 
  In the Average column, type a formula: =cell/number
  

For example: =G4/3

• 
  Create Charts or tables from the data