Lesson Plan : How to use formulas in Excel
Teacher Name: | Andres Peña |
Grade: | College/University |
Subject: | Other |
Topic: | How to use formulas in Excel |
Content: | The purpose of this lecture is to explain how to use formulas in Excel. |
Goals: | - To explain how to open formula builder - To do an example of how to insert a new function using formula builder - To explain the parts of formula builder - To do an example of how to insert a function without using formula builder |
Objectives: | - The audience will be able to open formula builder - The audience will be able to use SUM, COUNT and MAX functions - The audience will be able to use formulas using short cuts. |
Materials: | - Computer - Microsoft Excel - Video beam |
Introduction: | Explain the lecture topic and to a brief introduction about formulas functionality in Excel. |
Development: | - Explain the use of formula builder functionality - Explain the sections of formula builder |
Practice: | - To make and addition of a range of cells using SUM function - To find the largest number of a range of cells using MAX function - To count the numbers of a range of cells using COUNT function |
Accommodations: | |
Checking For Understanding: | To ask for questions |
Closure: | |
Evaluation: | |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |