Lesson Plan - 2 - DeLisle 1 John DeLisle CIMT 301 Lesson...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
DeLisle 1 John DeLisle CIMT 301 Lesson Plan #2 Microsoft Excel Grades 9-12 Time allotted: 70 minutes Background: The purpose of this lesson is, for students to become familiar with the IF function of Microsoft Excel 2007. Students have been instructed in a prior class how to format the spreadsheet; this includes font, font color, boarders, text size, and the use of the format painter. Objectives: 1. Given an exercise, students will demonstrate the use of the IF and VLOOKUP functions with 70% accuracy. (CA.7.2.2, CA.7.4.3, Cognitive) Materials: 1. Computer 2. Microsoft Excel 2007 3. “Exploring Microsoft Excel 2007 ”, by Grauer, Hulett, Krebs, Lockley, Mulbery, Scheeren. 4. IF function handout 5. Overhead projector Procedures: 1. Introduction and Motivation 1. The teacher will quiet the class and introduce the IF function of Microsoft Excel 2007. 1. The teacher will ask the students if there is a way to determine the difference between two answers and insert a formula corresponding to the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Lesson Plan - 2 - DeLisle 1 John DeLisle CIMT 301 Lesson...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online