Microsoft Office 2003



Microsoft Office Integration 2007

Integrating Office 2007 Applications and the World Wide Web

A Guide to this Instructor’s Manual:

We have designed this Instructor’s Manual to supplement and enhance your teaching experience through classroom activities and a cohesive chapter summary.

This document is organized chronologically, using the same heading in red that you see in the textbook. Under each heading you will find (in order): Lecture Notes that summarize the section, Figures and Boxes found in the section, if any, Teacher Tips, Classroom Activities, and Lab Activities. Pay special attention to teaching tips, and activities geared towards quizzing your students, enhancing their critical thinking skills, and encouraging experimentation within the software.

In addition to this Instructor’s Manual, our Instructor’s Resources CD also contains PowerPoint Presentations, Test Banks, and other supplements to aid in your teaching experience.

For your students:

Our latest online feature, CourseCasts, is a library of weekly podcasts designed to keep your students up to date with the latest in technology news. Direct your students to , where they can download the most recent CourseCast onto their mp3 player. Ken Baldauf, host of CourseCasts, is a faculty member of the Florida State University Computer Science Department where he is responsible for teaching technology classes to thousands of FSU students each year. Ken is an expert in the latest technology and sorts through and aggregates the most pertinent news and information for CourseCasts so your students can spend their time enjoying technology, rather than trying to figure it out. Open or close your lecture with a discussion based on the latest CourseCast.

Table of Contents

|Chapter Objectives |1 |

|INT 2: Introduction |2 |

|INT 2: Project – Integrating Office 2007 Applications and the World Wide Web |2 |

|INT 5: Adding Hyperlinks to a Word Document |2 |

|INT 13: Embedding an Excel Chart into a Word Document |3 |

|INT 19: Viewing the Word Document in Your Browser and Saving It as a Web Page |4 |

|INT 23: Creating a PowerPoint Presentation Web Page |4 |

|INT 28: Creating a Web Page from an Access Report |5 |

|INT 38: Testing the Web Site |5 |

|End of Chapter Material |5 |

|Glossary of Key Terms |7 |

Chapter Objectives

Students will have mastered the material in Chapter One when they can:

• Integrate the Office 2007 applications to create a Web site

• Add hyperlinks to a Word document

• Embed an Excel chart into a Word document

• Add a hyperlink to a PowerPoint slide

• Create Web pages from a PowerPoint presentation

• Add a hyperlink to an Access report

• Create a Web page from an Access report

• Test a Web site in a browser

INT 2: Introduction

LECTURE NOTES

• Define and discuss Integration and the four common usages in information technology

CLASSROOM ACTIVITIES

1. Class Discussion: Ask students to write down a list of things that come to mind when they hear the term, Integration. Have them share and discuss their ideas with the class.

INT 2: Project – Integrating Office 2007 Applications and the World Wide Web

LECTURE NOTES

• Review the Makin-It Real Estate Company project

• Use Figures 1-1a through 1-1g to illustrate the tasks required to complete the project

FIGURES: 1-1a, 1-1b, 1-1c, 1-1d, 1-1e, 1-1f, 1-1g

TEACHER TIPS

Make sure the four files from Figure 1-1 are accessible to the students. They will need a Word document, an Excel workbook, a PowerPoint presentation, and an Access database. The inside back cover of the book gives instructions for downloading the data files for students.

CLASSROOM ACTIVITIES

1. Class Discussion: Ask students to identify various types of documents that could be used to create Web sites for businesses and write their ideas on the board.

INT 5: Adding Hyperlinks to a Word Document

LECTURE NOTES

• Define home page and hyperlink

• Review the three hyperlinks in the project

• Use Figure 1-2 to illustrate starting Word, open an existing document, and save the document with another name

• Use Figure 1-3 to illustrate inserting a table into a Word document

• Use Figures 1-4 through 1-7 to remove the table border, view gridlines, and AutoFit the table contents

• Use Figure 1-8 to illustrate inserting text for hyperlinks

• Define and discuss the Insert Hyperlink feature

• Use Figure 1-9 to create a hyperlink to PowerPoint Web pages

• Use Figure 1-10 to illustrate inserting the remaining hyperlinks

FIGURES: 1-2, 1-3, 1-4, 1-5, 1-6, 1-7, 1-8, 1-9, 1-10

BOXES:

1. BTW: Web Pages. Review the information on Web pages and Office 2007.

2. BTW: Hyperlinks. Review information on hyperlinks, note that hyperlinks can link to both external and internal locations.

3. Other Ways: Encourage your students to explore other ways to insert a table into a Word document.

4. Other Ways: Encourage your students to explore other ways to create a hyperlink.

CLASSROOM ACTIVITIES

1. Class Discussion: Ask students why a table should be used instead of just typing in text or using tabs. Discuss the benefits of using a table to insert text and graphics so they line up appropriately, versus using tabs or just trying to line them up. Which would make the Web page more visually appealing?

LAB ACTIVITIES

1. Have students search the Internet for examples of home pages. Encourage them to find and click examples of text and image hyperlinks. Have students make a list of the URLs for both the home pages and the linked pages.

INT 13: Embedding an Excel Chart into a Word Document

LECTURE NOTES

• Define Object Linking and Embedding (OLE), source object, destination document, paste special and source program

• Discuss the steps to start Excel and open an existing workbook

• Use Figures 1-11 through 1-15 to illustrate embedding an Excel chart into a Word document

• Use Table 1-1 to review the three copy methods used in Office 2007

• Use Figures 1-16 through 1-18 to illustrate changing the size of an embedded object

• Review the steps to quit Excel

FIGURES: 1-11, 1-12, 1-13, 1-14, 1-15, 1-16, 1-17, 1-18

BOXES:

1. BTW: Embedded Objects. Review the information on embedded objects and the advantages of using Microsoft Office 2007.

2. BTW: Objects. Review the information on objects and the advantage of the Paste Special feature.

3. BTW: Resizing. Review the information on resizing.

4. Other Ways: Encourage your students to explore other ways to embed charts into documents.

TEACHER TIPS

You can create a hyperlink quickly without having to use the Insert Hyperlink dialog box by dragging selected text or pictures from a Word document or by dragging a Web address or hyperlink from some Web browsers. … You cannot drag drawing objects, such as Shapes, to create hyperlinks. To create a hyperlink for a drawing object, select the object, right-click, and then click Hyperlink on the shortcut menu.

CLASSROOM ACTIVITIES

1. Quick Quiz:

1) What is the difference between the source document and the destination document? (Answer: A source object is where the object comes from, the destination document is where the object is going to)

2. Class Discussion: When you use the Paste command to paste an object, the object becomes part of the destination document and only can be edited using features of the destination application. When you use the Paste Special command to embed an object, the object becomes part of the destination document but can be edited using features of the source application. When would you use Paste Special instead of Paste? Why?

LAB ACTIVITIES

1. Have students add a graphic to a document and distort the graphic by changing the size but not locking the aspect ratio. Ask them to write a brief paragraph describing what happened.

INT 19: Viewing the Word Document in Your Browser and Saving It as a Web Page

LECTURE NOTES

• Use Figures 1-19 through 1-23 to review adding a button to the Quick Access Toolbar and previewing the Web page

• Review the steps to save a document with a new name

• Use Figure 1-24 to illustrate previewing the Web page

• Review the steps to reset the Quick Access Toolbar and quit Word

FIGURES: 1-19, 1-20, 1-21, 1-22, 1-23, 1-24

BOXES:

1. BTW: Web Page Formatting. Review the information on Web page formatting and Word.

2. BTW: Web Programming Languages. Review the information on Web programming languages.

TEACHER TIPS

The Web toolbar is not available in Microsoft Office PowerPoint 2007, Microsoft Office Word 2007, or Microsoft Office Excel 2007. The Address box is now called the Location box, and it displays Uniform Resource Locators (URL) (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet. For example: .) or other paths. If you use it often enough, you can add the Location box to the Quick Access Toolbar. Other commands that were on the Web toolbar that you can add to the Quick Access Toolbar as well are the Back and Forward buttons.

CLASSROOM ACTIVITIES

1. Project to Assign: Using Figure 1-24, ask the students to identify changes they could make to the Web page to improve its appearance. Have students make a list of their suggestions or if they choose, they can create a page with the same information presented in a different format or with different graphics or charts.

INT 23: Creating a PowerPoint Presentation Web Page

LECTURE NOTES

• Discuss and review PowerPoint presentations and the ability to save as a Web page

• Use Figure 1-25 to illustrate starting PowerPoint and open an existing presentation

• Use Figure 1-26 to illustrate adding text for a hyperlink into a PowerPoint presentation

• Use Figure 1-27 to review inserting a hyperlink into a PowerPoint presentation

• Use Figure 1-28 to review the procedures for adding and removing a button from the Quick Access Toolbar and viewing the Web page in your browser

• Review the steps to save the PowerPoint presentation as a Web page

• Discuss the steps to remove a button from the Quick Access Toolbar, quit PowerPoint, and close your browser

FIGURES: 1-25, 1-26, 1-27, 1-28

BOXES:

1. BTW: Keeping Links Fresh. Review the information on keeping links fresh.

2. BTW: Web Page Publishing. Review the information on Web page publishing.

3. BTW: Outline. Review the information on the Outline pane.

4. BTW: Viewing Web Pages. Review the information on viewing Web pages.

5. Other Ways: Encourage your students to explore other ways to add text for a hyperlink.

6. Other Ways: Encourage your students to explore other ways to insert a hyperlink.

CLASSROOM ACTIVITIES

1. Class Discussion: Have students compare and contrast adding text for a hyperlink in PowerPoint with inserting text for hyperlinks into a Word document as described on page INT 11.

INT 28: Creating a Web Page from an Access Report

LECTURE NOTES

• Define and discuss Access database reports

• Use Figure 1-29 to start Access and open an existing database

• Use Figures 1-30 through 1-36 to illustrate creating a report using the Report wizard

• Use Figures 1-37 through 1-42 to illustrate adding a hyperlink to a report and changing the text background color

• Use Figures 1-43 through 1-45 to illustrate saving the report and viewing it in your browser

• Discuss and review the importance of editing documents for better Web readability

• Review the steps to close your browser and quit Access

FIGURES: 1-29, 1-30, 1-31, 1-32, 1-33, 1-34, 1-35, 1-36, 1-37, 1-38, 1-39, 1-40, 1-41, 1-42, 1-43, 1-44, 1-45

CLASSROOM ACTIVITIES

1. Quick Quiz:

1) What is one of the common purposes of data access pages? (Answer: For viewing records of a database via a company intranet or the World Wide Web)

2. Projects to Assign: Using Figure 1-36, ask the students to identify changes to the data access page that will increase its readability. Have students make a list of their suggestions on the board and vote on the ones that will increase its readability the most. Compare Figure 1-36 to Figure 1-42 and discuss the changes.

INT 38: Testing the Web Site

LECTURE NOTES

• Discuss the need to test the Web site and verify hyperlinks

• Use Figure 1-46 to illustrate testing the Web site

• Review the steps to verify the hyperlinks

• Discuss the steps to quit e-mail and close your browser

FIGURE: 1-46

CLASSROOM ACTIVITIES

1. Group Activity: Break students into small groups and ask them to discuss and compile a written list of opinions on the features demonstrated and how comfortable they feel with creating these Web pages and data access pages. Have each group share their opinions with the class.

1. End of Chapter Material

▪ Learn It Online is a series of online student exercises that test your knowledge of chapter content and key terms.

▪ Apply Your Knowledge is a student assignment that helps you to reinforce the skills and apply the concepts you learned in this chapter.

▪ Extend Your Knowledge is a student assignment that challenges you to extend the skills you learned in this chapter and to experiment with new skills. You may need to use Help to complete the assignment.

▪ Make It Right is a student assignment that requires you to analyze a presentation and correct all errors and/or improve the design.

▪ In the Lab (Lab): In the Lab is a series of student assignments that ask you to design and/or create a presentation using the guidelines, concepts, and skills presented in this chapter. The assignments are listed in order of increasing difficulty.

▪ Cases and Places is a series of student assignments where you apply your creative thinking and problem solving skills to design and implement a solution.

Glossary of Key Terms

• destination document (INT 13)

• gridlines (INT 9)

• home page (INT 6)

• HTML (INT 23)

• hyperlink (INT 6)

• Insert Hyperlink feature (INT 11)

• Object Linking and Embedding, (OLE) (INT 13)

• outline (INT 27)

• Paste Special (INT 13)

• source object (INT 13)

• source program (INT 13)

Top of Document

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download