Plan for Excel 2007 Sessions 1 and 2

Plan for Excel 2007 Sessions 1 and 2 - The homework is to...

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

View Full Document Right Arrow Icon
Plan for Excel 2007 Sessions 1 and 2 (February 10 and February 17) Session 1: February 10 1. Discuss plan for Excel 2007 Sessions 2. Ensure all students are familiar with Excel 2007 For those new to Excel 2007, it is strongly recommended that the you read, study, and use Excel 2007 as described in the web pages and .pdf documents listed in the “For Those New to Excel” sections of the following documents on BlackBoard in the Course Documents section: 1. Excel 2007–WebPages,Videos,References-Microsoft.com 2010-02-05.doc 2. The two documents contain hyperlinks to the web pages, etc. Click on the name of the document or web page or video and the webpage or document or video will open. 3. Discuss motivation for and use of the following Excel 2007 functions: A. Cell References B. Charts C. Conditional Formatting D. Formulas E. Functions F. Pivot Tables 4. Assign homework using these functions to ensure students know how to use them.
Background image of page 1

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

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

Unformatted text preview: The homework is to be done in teams of 2 or 3 students. Session 2: February 18 1. Review functions discussed on February 10 2. Discuss motivation for and use of the following Excel 2007 functions: A. Scenarios B. Goal Seek C. Solver 3. Assign Individual Homework using all of the Excel functions discussed in Sessions 1 and 2, so students can demonstrate they know how to use them. 485d02d90869d2308fb789760a7a2ecd79459ff0.doc 1 of 2 3/3/2011 7:06 a3/p3 Plan for Excel 2007 Sessions 1 and 2 (February 10 and February 17) Readings and References The links to the readings for these two sessions can be found in: Excel 2007 Webpages & Documents-Duke U & Tufts U 2010-02-05.doc Links to additional references, web pages, and videos can be found in: Excel 2007WebPages,Videos, References-Microsoft.com 2010-02-05.doc Both are posted on Blackboard in the Course Documents section. 485d02d90869d2308fb789760a7a2ecd79459ff0.doc 2 of 2 3/3/2011 7:06 a3/p3...
View Full Document

Page1 / 2

Plan for Excel 2007 Sessions 1 and 2 - The homework is to...

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