Excel Chapter 9 – Templates, Styles, Web, and Macros: Worksheet References, File Linking, and Auditing Formulas

Table of Contents

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

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

Capstone Exercise for Ch 9(End of Chapter Capstone Exercise)...... 6

Solution for Capstone Exercise............................................................. 7

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

Excel Chapter 9 – Collaboration and Workbook Distribution: Sharing, Distributing, and Excel Options

Materials NeededDescription of Document Name of Document Location of Files

Solution to Homework Hands-on Exercises forExcel Chapter 9

chap9_ho1_sharing_solution.xlsx chap9_ho1_sharing_solution.xlschap9_ho1_sharing_solution.pdfchap9_ho1_word_solution.docxchap9_ho1_powerpoint_solution.pptxchap9_ho2_housing_solution.xlsxchap9_ho3_options_solution.xlsx

Exploring Excel 2007

Chapter 9 Folder on

Instructor Resource Disk

orwww.prenhall.com

/grauer

Capstone Exercise for Excel Chapter 9 ExplOffice2007_ExcelCh9CE.docx

Solution forCapstone Exercise forExcel Chapter 9

ExcelCh9CE_solution.xlsxExcelCh9CE_solution_formulas.xlsx

Homework Handout for Excel Chapter 10 ExplOffice2007_ExcelCh10HW.docx

Answer Key for MyITLab Excel Chapter 9

AnswerKey_MyITLab_Excel_Chap_9

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 9 Pre-Testb. Study Planc. Excel Chapter 9 Post-Test

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

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.

2

Excel Chapter 9 – Collaboration and Workbook Distribution: Sharing, Distributing, and Excel Options

Understand Excel options.

Work with Quick Access Toolbar.

Install add-ins.

Discussion Questions What different formats can you choose from to save your

workbook? When would each be used? How does a digital certificate help you secure your workbook? What is the purpose of add-ins? What add-ins are included with

Excel 2007? Why would simultaneous changes by multiple users be helpful?

What problems could be caused?

Additional Web ResourcesFrom Microsoft Office Online for Excel 2007:

Save a workbook in another file format Get or create your own digital ID Customize the Quick Access Toolbar

Demonstrate how to: Track changes. Enable simultaneous changes by multiple users. Save a workbook in different formats. Send a workbook by e-mail. Copy data to Word and PowerPoint. Finalize documents. Prepare workbooks for distribution. Add a digital certificate. Mark a workbook as final. Change Excel options. Add and remove items from the Quick Access Toolbar. Install, use, and remove add-ins

3

Excel Chapter 9 – Collaboration and Workbook Distribution: Sharing, Distributing, and Excel Options

chap9_ho1_sharing_solution.xlsx

4

Excel Chapter 9 – Collaboration and Workbook Distribution: Sharing, Distributing, and Excel Options

chap9_ho1_sharing_solution.xlsx

5

Excel Chapter 9 – Collaboration and Workbook Distribution: Sharing, Distributing, and Excel Options

Student Name: _________________ Section: ______

Due Date: _____________ 00 Points Possible Points Earned: ________

Objectives Collaborate with other individuals to prepare a summary report presenting various totals

and other requested information and distributing the workbook in various formats.

Preparation & Helpful Information Read Chapter 9 – “Collaboration and Workbook Distribution: Sharing, Distributing, and

Excel Options” 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 9, pages 000-000.

TASK 2: Complete Capstone Exercise: jeans jane’s designer clothing 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

6

Excel Chapter 9 – Collaboration and Workbook Distribution: Sharing, Distributing, and Excel Options

ExcelCh9CE_solution.xlsx

7

Excel Chapter 9 – Collaboration and Workbook Distribution: Sharing, Distributing, and Excel Options

ExcelCh9CE_solution.xlsx

8

Exploring Office 2007 Excel Chapter 10 HOMEWORK

Student Name: _________________ Section: ______

Due Date: _____________ 00 Points Possible Points Earned: ________

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

Work with existing templates, themes, and styles.

Use styles for advanced formatting.

Create a template.

Create a web page.

Create web queries.

Work with macros.

Create macro buttons.

Understand the basics of VBA.

Assignment Read Chapter 10 – “Templates, Styles, Web, and Macros: Worksheet References,

File Linking, and Auditing Formulas” 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:□“chap10_ho1_styles_solution.xlsx” printout.

This should look similar to Figure 0.00 on page 000.

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

□“chap10_ho1_world_template_solution.xltx” printout.This should look similar to Figure 0.00 on page 000.

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

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

□“chap10_ho2_stock_solution.htm” printout.This should look similar to Figure 0.00 on page 000.

□“chap10_ho3_macros_solution.xlxm” printout.This should look similar to Figure 0.00 on page 000.

9