Assignments on Class 14 Integrating PowerPoint with Other Office Apps

 Assignments on Class 14

Integrating PowerPoint with Other Office Apps

Assignment 1: Embedding an Excel Chart

Task:

1. Create an Excel file containing sales data for a fictional company.
2. Generate a bar chart representing the sales data.
3. Embed this chart in a new PowerPoint slide.

Solution Steps:

1. Create the Excel File:
• Open Excel and enter the following sales data:

Month	Sales ($)
January	5000
February	7000
March	6000
April	8000

2. Generate the Bar Chart:
• Select the data range.
• Go to the Insert tab, click on Bar Chart, and select the preferred style.
• Adjust the chart title to "Monthly Sales Data".
3. Embed the Chart in PowerPoint:
• Copy the chart (Ctrl + C).
• Open PowerPoint and create a new slide.
• Paste the chart (Ctrl + V) and choose Keep Source Formatting to maintain the original design.

---

Assignment 2: Linking a Word Document

Task:

1. Write a brief report in Word summarizing the sales data you created in Assignment 1.
2. Link this report to a new PowerPoint slide.

Solution Steps:

1. Create the Word Document:
• Open Word and write a summary like this:

Sales Report:

In the first quarter of the year, the company has seen steady growth in sales.

- January: $5000

- February: $7000

- March: $6000

- April: $8000

• Save the document as "Sales_Report.docx".
1. Link the Document in PowerPoint:
• Open PowerPoint and create a new slide.
• Copy the text from the Word document (Ctrl + C).
• In PowerPoint, paste the text using Paste Special > Paste Link.
• This will create a link to the Word document, ensuring updates are reflected in the PowerPoint presentation.

---

Assignment 3: Copy-Pasting Data with Formatting

Task:

1. Copy a formatted table from the Excel file created in Assignment 1 and paste it into a PowerPoint slide, ensuring the formatting is preserved.

Solution Steps:

1. Copy the Table from Excel:
• Open the Excel file and select the sales data table.
• Copy the table (Ctrl + C).
2. Paste with Formatting in PowerPoint:
• In PowerPoint, create a new slide.
• Use the Paste Options drop-down to select Keep Source Formatting.
• The table will appear in the PowerPoint slide, maintaining the original Excel formatting.

---

Additional Assignments

Assignment 4: Creating a Presentation with Integrated Content

Task: Create a PowerPoint presentation that includes:

1. An embedded Excel chart showing the sales data.
2. A linked Word document summarizing the sales figures.
3. A slide that includes a formatted table of sales data copied from Excel.

Solution Steps:

1. Follow the steps from Assignments 1 and 2 to embed the chart and link the Word document.
2. Additionally, create a new slide and copy the sales data table from Excel into PowerPoint, ensuring to select Keep Source Formatting.
3. Organize the slides to create a coherent flow.

---

Summary

These assignments allow students to practice the integration of PowerPoint with other Office applications. They will gain hands-on experience in embedding charts, linking documents, and copying formatted data, which are essential skills for creating professional presentations.

NEXT->