Lesson Plans
Lesson Plan Template
Lesson Title: Place the lesson title here ie Excel’s Vlookup function
Target Audience: Who is this lesson for? Faculty at La Roche
How does it: Into the course; with the objectives – One of several objects for working with excel to create electronic grade sheets; module in the training course for creating an electronic grade sheet
Prerequisites: What assumptions are you making? What skills are needed to complete this? The learner knows how to construct a basic spreadsheet (enter labels and data); add formulas and functions (total the grades and calculate percentages)
Approximate Time: 30 minutes
|
Student Objectives: |
Content Outline |
Instructional Methods |
Materials |
Evaluation/Assessment |
|
Place the learner objectives here After reading this help guide, the faculty will be able to correctly construct a table array and enter the vlookup function |
General outline of content Introduction to vlookup and hlookup function Syntax requirements Example explanations Practice/demo |
What will the teacher do?What will the learner’s do Lesson on vlookup- Example demonstration on help guide- Practice lessons
|
What materials are needed? Access to Excel Sample worksheet file Practice exercises
|
How will you know the learners met the objective? Faculty will show me their spreadsheet with the vlookup feature working properly |