Lesson Blueprint - Integrating Word, Excel, and PowerPoint ...



|Lesson Blueprint |

|Marquee 2010 |

|Application: Word, Excel, and PowerPoint |

|Lesson: 44 |

|Integrating Programs: Word, Excel, and PowerPoint |

|Activities |

|3.4 Editing a Linked Object |

|3.5 Embedding and Editing a Word Table in a PowerPoint Presentation |

|Text Page Numbers: 128-132 |

|Learning Objectives |

|- Edit a linked object |

|- Embed a Word table in a PowerPoint presentation |

|- Edit an embedded object |

|END-OF-SECTION EXERCISES |

|Skills Review |

|Begins on page 133 |

|Review 1 Export a PowerPoint presentation to Word as slides; save and close Word document; edit the slides in PowerPoint; reopen |

|Word document and update link to PowerPoint; save, print, and close Word document |

|Review 2 Copy a chart in Excel and link it to a slide in a PowerPoint presentation; resize chart in PowerPoint; save presentation; |

|print slide containing chart; edit Excel worksheet, save and print Excel worksheet, update link in PowerPoint presentation. |

|Review 3 Copy a table in Word and embed it into a slide in a PowerPoint presentation; resize and reposition table in PowerPoint; |

|edit table in PowerPoint; print slide containing table; apply transition and sound scheme to all slides; run, save, and close |

|presentation |

|ESTIMATED TIMES |

|Lecture/Demonstration: 15-20 minutes - flexible |

|Section tutorials: 20-30 minutes |

|End-of-Section Exercises: 30-45 minutes |

|Student file(s) needed for entire section |

|Activities: NPCDivPres.pptx |

|WEOutline.docx |

|WERevDoc.docx |

|WERevChart.xlsx |

|WEGenDistTable.docx |

|WEPrevDistTable.docx |

| |

|Skills Review: FCTVactions.pptx |

|NPCEnroll.pptx |

|NPCEnrollChart.xlsx |

|NPCContacts.docx |

|Equipment Check |

|No equipment check is required. |

|PowerPoint Presentation Available: Marquee10_Presentation_Integrating3_WordExcelPowerPoint.ppt, Activities 3.4–3.5 |

|LECTURE/DEMOSTRATION NOTES |

|Students learn to edit a linked object in PowerPoint and work with embedded tables copied from Word to PowerPoint. |

| |

|Lesson Lead-In Discussion |

|In the previous lesson students learned to share data between Excel and PowerPoint by linking the chart in PowerPoint to Excel. In |

|this lesson students integrate data by copying and embedding a Word table. Remind students that in the first Integrated section |

|they learned that when you embed an object the data exists in both the source and destination programs. By embedding the object |

|into PowerPoint, you can edit the contents using the tools of the source program. For example, a person might be more comfortable |

|working with tables in Word than in PowerPoint. The table can be created in Word, embedded into a PowerPoint presentation, and then|

|edited in PowerPoint using Word’s table menu and toolbars. |

| |

|If you have access to a computer connected to a video display projector or are teaching students in a computer lab, demonstrate the|

|following tasks: |

|- Have on disk or another storage medium the files created in the last lesson, IntegratedPPT.pptx and IntegratedExcel.xlsx. |

|- Start Excel and open IntegratedExcel.xlsx. |

|- Click the Sheet1 tab where the data exists and change the values as shown below: |

| |

|[pic] |

| |

|- Click the Chart1 tab to see the new grades reflected in the chart. |

|- Save the revised chart and then exit Excel. |

|- Start PowerPoint and open IntegratedPPT.pptx. Click the Update Links button at the message box indicating the file contains links|

|to other objects. |

|- Navigate to the last slide in the PowerPoint presentation and point out that the chart reflects the new data. |

|- Start Microsoft Word. |

|- Create the table shown below. To save time you can create the table in advance and save it. (Note: The bottom row is not bolded |

|like the others on purpose—you want to show later how to edit an embedded object.) |

| |

| |

| |

|[pic] |

| |

|- Select the table and then copy it to the clipboard. |

|- Switch to PowerPoint. Insert a new slide at the end of the presentation. Use the Title Only layout and type the title Program |

|Credits. |

|- Embed the Word table to the slide (click the Paste button arrow, click Paste Special, click Microsoft Office Word Document Object|

|in the As list box of the Paste Special dialog box, and then click OK). |

|- Resize and position the table as shown below. |

| |

|[pic] |

| |

|- Switch to Word and close the document without saving. Exit Word. |

|- At PowerPoint, double-click the table to edit the embedded object. |

|- Point out to students that Word’s Menu bar and toolbars are now active. Emphasize Word’s horizontal and vertical ruler bars exist|

|in the edited object window. |

|- Select the four cells below the header row in the third column (Terms Offered) and change the shading to White (Shading button in|

|the Table Styles group of the Table Tools Design tab). |

|- Select the last row of the table and make the font bold. |

|- Select all cells in the table and make the font italic. |

|- Click outside the table to deselect the embedded object. |

| |

|[pic] |

| |

|- Save and close IntegratedPPT.pptx. |

|- Exit PowerPoint. |

| |

|Wrap-Up Class Discussion Topics |

|Depending on time available, consider the following topic: |

| |

|Ask students to summarize the three main methods for sharing data between programs in the Microsoft Office suite that they have |

|learned in the Integrated sections. Mention that specialized features in Access (such as OfficeLinks) and PowerPoint (such as Send |

|To) can be set aside for this discussion. Write the methods on the board as they are discussed. If you prefer, write the three |

|methods on the board and ask students to provide the examples of when to use each method. |

|- Copy and Paste: Use when data will not be updated and will need little editing in the destination program. |

|- Copy and Paste Special as a Linked Object: Use when data will be updated frequently. |

|- Copy and Paste Special as an Embedded Object: Use when data will not be updated frequently but editing using the source program’s|

|tools is preferred. |

|Teaching Hints |

|Pages 126-129: Review the differences among pasting, linking, and embedding. These functions are useful with any software |

|application. |

|Extra Tips for Students |

|If students finish this lesson early, suggest they use any extra time for studying for the final exam. |

|Possible Work for Advanced Students |

|Have advanced students create a drawing using Microsoft Paint (such as a logo) and then use Copy and Paste Special to paste the |

|drawing to a new slide in PowerPoint. Have students answer the following questions: |

|Is it an embedded object, meaning you can edit the drawing using Paint tools within PowerPoint? |

|What other drawing programs outside PowerPoint could be used to create artwork to use in a PowerPoint presentation? |

|Can objects created in any of these other drawing programs be linked to PowerPoint? |

|Instructor’s Notes |

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

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

Google Online Preview   Download