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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- word excel free download
- word excel free download 2017
- word excel 2013 free download
- word excel spreadsheet free
- excel embedded powerpoint open file
- link excel to powerpoint table
- lesson 11 analyzing word choice
- excel and word cost
- word excel free download windows 10
- convert word excel to pdf
- buy word excel and powerpoint
- lesson plans template word document