Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

Table of Contents

Lesson Plan............................................................................................. 2

Solution for Ch 8 Homework (Hands-On Exercises in Chapter)......... 4

Capstone Exercise for Ch 8(End of Chapter Capstone Exercise)...... 7

Solution for Capstone Exercise............................................................. 8

Homework Handout for next class period (Ch 9).................................11

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

Materials NeededDescription of Document Name of Document Location of Files

Solution to Homework Hands-on Exercises forExcel Chapter 8

chap8_ho1_suv_solution.xlsx chap8_ho2_gss_solution.xlsx chap8_ho3_optimization_solution.xlsx

Exploring Excel 2007

Chapter 8 Folder on

Instructor Resource Disk

orwww.prenhall.com

/grauer

Capstone Exercise for Excel Chapter 8 ExplOffice2007_ExcelCh8CE.docx

Solution forCapstone Exercise forExcel Chapter 8

ExcelCh8CE_solution.xlsxExcelCh8CE_formulas_solution.xlsx

Homework Handout for Excel Chapter 9 ExplOffice2007_ExcelCh9HW.docx

Answer Key for MyITLab Excel Chapter 8

AnswerKey_MyITLab_Excel_Chap_8

Class Run-Down1. Have students turn in homework assignments.2. Talk about chapter using discussion questions listed below. 3. Demonstrate Excel 2007.4. Direct students to the MyITLab site to complete the following:

a. Excel Chapter 8 Pre-Testb. Study Planc. Excel Chapter 8 Post-Test

5. Have students complete Capstone Exercise for Excel Chapter 8.6. Give students Homework Handout for next class period.

Learning ObjectivesAt the end of this lesson students should be able to:

Create a one-variable data table.

Create a two-variable data table.

Define forecasting.

Solve problems with Goal Seek.

Use Scenario Manager.

Load the Solver add-in.

Solve problems with Solver.

Discussion Questions What types of situations can Goal Seek help you solve?

2

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

How does Goal Seek differ from Solver? What is Scenario Manager and how does it help? Why is forecasting something people in business want? How

accurate is the data?

Additional Web ResourcesFrom Microsoft Office Online for Excel 2007:

Load the Solver Add-In Add, change, or clear conditional formats Create scenarios for what-if analyses

Demonstrate how to: Use functions and formulas. Create one-variable data table. Create two-variable data table. Insert a function and use Goal Seek. Use conditional formatting. Define cell names. Create scenarios. View scenarios. Use Scenario Summary. Create a Scenario PivotTable report. Install Solver and enter cell formulas. Set target, set adjustable cells, and enter constraints. Solve the problem. View and print the report.

3

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

chap8_ho1_suv_solution.xlsx

4

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

chap8_ho2_gss_solution.xlsx

5

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

chap8_ho3_optimization_solution.xlsx

6

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision MakingStudent Name: _________________ Section: ______

Due Date: _____________ 00 Points Possible Points Earned: ________

Objectives Prepare reports using Goal Seek, Scenario Manager and Solver presenting various

requested information.

Preparation & Helpful Information Read Chapter 8 – “What-If Analysis: Using Spreadsheets for Decision Making” located in

the Microsoft Office 2007 Professional book. Check each step before continuing; it is easy to skip one when you hurry. If you are not familiar with Excel, allow yourself extra time for the exercises. Read this assignment sheet first before you complete any assignments. Many times there

will be additional instructions not included in your book.

InstructionsDesignate one disk for your Excel assignments, as these files take up a lot of space.

TASK 1: Read Excel Chapter 8, pages 000-000.

TASK 2: Complete Capstone Exercise: Graduate Assistant on page 00.

TASK 3: Print the spreadsheet.

TASK 4: Print the formulas.

When you complete your assignment, do the following:Turn in your assignment to your instructor.

7

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

ExcelCh8CE_solution.xlsx

8

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

ExcelCh8CE_solution.xlsx

9

Excel Chapter 8 – What-If Analysis: Using Spreadsheets for Decision Making

ExcelCh8CE_formulas_solution.xlsx

10

Exploring Office 2007 Excel Chapter 9 HOMEWORK

Student Name: _________________ Section: ______

Due Date: _____________ 00 Points Possible Points Earned: ________

Learning ObjectivesAt the end of this lesson students should be able to:

Track changes.

Enable simultaneous changes by multiple users.

Save workbooks in different formats.

Send a workbook by e-mail.

Copy data to Word and PowerPoint.

Finalize documents.

Prepare workbooks for distribution.

Understand Excel options.

Work with Quick Access Toolbar.

Insert add-ins.

Assignment Read Chapter 9 – “Collaboration and Workbook Distribution: Sharing, Distributing,

and Excel Options” pages 000-000. Complete the three Hands-on Exercises in the chapter.

When your assignment is complete, do the following:

Turn in the following printouts to your instructor:□“chap9_ho1_sharing_solution.xlsx” printout.

This should look similar to Figure 0.00 on page 000.

□“chap9_ho1_sharing_solution.xls” printout.This should look similar to Figure 0.00 on page 000.

□“chap9_ho1_sharing_solution.pdf” printout.This should look similar to Figure 0.00 on page 000.

□“chap9_ho1_word_solution.docx” printout.This should look similar to Figure 0.00 on page 000.

□“chap9_ho1_powerpoint_solution.pptx” printout.This should look similar to Figure 0.00 on page 000.

□“chap9_ho2_housing_solution.xlsx” printout.This should look similar to Figure 0.00 on page 000.

□“chap9_ho3_options_solution.xlsx” printout.This should look similar to Figure 0.00 on page 000.

11

Exploring Office 2007 Excel Chapter 9 HOMEWORK

12