# Penn Foster 584805 – Integrating Word, Excel, and Other Data into PowerPoint – Solution includes Project Outline.docx, Homelessness Statistics.xlsx, Impoverished Hungry.docx, Sociology Project.pptx, Sociology Project.mp4 – With Screenshots – Perfect Solution – Instant Delivery

Lab Price = \$19
Payment methods

Problem Statement
Integrating Word,
Excel, and Other Data into PowerPoint
© PENN FOSTER, INC. 2016 INTEGRATING WORD, EXCEL, PAGE 1
AND OTHER DATA
INTO POWERPOINT
INTRODUCTION 2
INSTRUCTIONS 2
SCORING GUIDELINES 7
SUBMISSION CHECKLIST 9
INTRODUCTION
CONTENTS
© PENN FOSTER, INC. 2016 INTEGRATING WORD, EXCEL, PAGE 2
AND OTHER DATA
INTO POWERPOINT
INTEGRATING WORD, EXCEL, AND
OTHER DATA INTO POWERPOINT
INTRODUCTION
This project involves creating a presentation for a sociology class. You’ll assume the role
of a student. For the presentation, you’ve been asked to report on the hunger situation of
the people in the vicinity of your college. In your presentation, you’ll suggest a way your
college can help provide food for the hungry. For this project, you’ll complete and upload
an outline, a PowerPoint presentation based on the outline (uploaded as a video file), a
table of statistics, and a spreadsheet with statistics and a chart.
INSTRUCTIONS
CREATE THE PRESENTATION OUTLINE
1. Start Word and create a new blank document.
2. Display the document in Outline view and type the outline shown
in Figure 1, being sure to place topics at the indicated level.
Figure 1
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 3
AND OTHER DATA
INTO POWERPOINT
3.
Convert the data into a pie chart similar to Figure 3. Be sure that you select a chart style that includes the percentage figures somewhere on the chart.
3.
Save the document, naming it Project Outline.
4.
Close the document.
CREATE A SPREADSHEET AND A CHART
1.
Start Excel and create a new blank workbook.
2.
Enter data as shown in Figure 2.
Figure 2
Figure 3
4.
Save the workbook, naming it Homelessness Statistics.
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 4
AND OTHER DATA
INTO POWERPOINT
3.
Save the document, naming it Impoverished Hungry.
4.
Close the document.
CREATE THE PRESENTATION
1.
Start PowerPoint and create a new blank presentation.
2.
Use the appropriate command to add slides from the Project Outline document.
3. Delete the first slide, which isn’t part of the presentation, and then reset the remaining slides to match the PowerPoint presentation formatting.
4. Change the layout of the first slide to Title Slide layout.
5.
Change the theme of the presentation to Frame. Slide 1 should look similar to Figure 5.
CREATE A WORD TABLE
1.
Start W
ord and create a new blank document.
2.
Create a 2 × 4 table with the information shown in Figure 4. Choose a table style similar to that shown, merge the first row of cells, and center and format the title appropriately.
Figure 4
Figure 5
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 5
AND OTHER DATA
INTO POWERPOINT
6.
Display slide 3, delete the text box with the bullet item placeholder
, and then copy and paste the Homelessness Statistics chart.
7.
The chart data labels need to be read from a distance. Format text in each label to 20 point. Size and position the chart so that your slide looks similar to Figure 6.
Figure 6
8.
Display slide 4, delete the text box with the bullet item placeholder
, and then embed the Impoverished Hungry table.
9.
The table text is too small to be seen from a distance. Edit the table from within PowerPoint to display 16 point text. Size and position the table so that your slide looks similar to Figure 7.
Figure 7
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 6
AND OTHER DATA
INTO POWERPOINT
10.
Save the presentation, naming it Sociology Project.
1
1. Add the following lecture notes to slide 3, Homelessness:
The issues related to homelessness are complex.
Working homeless individuals hold a job but may not be making enough to afford housing.
Homelessness can occur when a child in foster care turns 18 and doesn’t have the needed support to transition to independent living.
Veterans can suffer from mental illness, poor health, disabilities, or a combination of any of these.
Other problems that increase risk of homelessness are related to mental illness, domestic violence, disability, poor physical health, and substance abuse.
12.
Add the following lecture notes to slide 6, How can our college community help?:
Our college campus community can help reduce hunger for those in need. The Backpack program may be especially popular on a college campus because this effort fills school backpacks with nonperishable nutritious snacks and school supplies for elementary students.
13.
Apply the Uncover transition to all the slides.
14.
Set the presentation to advance the slide show after 5.00 seconds and apply this option to all slides. In Slide Sorter view, your presentation should look like Figure 8.
Figure 8
15. Save the modified presentation and then play the slide show from the beginning to check your presentation.
16.
Y
ou‘ll submit your presentation as a video. Export your presentation as an .mp4 video file.
17.
Save the presentation again.
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 7
AND OTHER DATA
INTO POWERPOINT
SCORING GUIDELINES
RUBRIC
EXEMPLARY (4)
PROFICIENT (3)
FAIR
(2)
POOR
(1)
NOT
EVIDENT (0)
Create an outline
An outline with all the correct content and levels has been created.
An outline with most of the correct content and levels has been created.
An outline with most of the correct content has been created without multiple levels.
The
content for the outline has been typed but the correct styles aren’t present.
No attempt has been made to
create an outline.
The specified spreadsheet and chart have been created.
Cell data is correct, but the pie chart doesn’t display percentage values.
Cell data is correct, but the wrong chart type has been used to create a chart.
Cell data isn’t entirely correct, and a chart hasn’t been created.
No attempt to create a spreadsheet with a chart has been made.
Create a Word table
A Word table with the correct content, and formatting has been created.
A Word table with the correct content, and mostly correct formatting has been created.
A Word table with correct content is lacking merged cells, and most of the specified formats.
Content is present but isn’t in a Word table.
No attempt to create a Word table has been made.
Create a presen-
tation based on a Word outline
A presentation with slides based on the Word outline has been created and reset to the PowerPoint formatting, and specified theme and slide layouts were applied.
A presentation with slides based on the Word outline has been created and reset to the PowerPoint formatting, but the specified theme or slide layouts weren’t applied.
A presentation with slides based on the Word outline has been created but not reset to the PowerPoint formatting or formatted with the specified theme and slide layouts.
N/A
No attempt has been made to create a presentation from a Word outline.
(Continued)
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 8
AND OTHER DATA
INTO POWERPOINT
Paste an Excel chart into a slide and edit it
The specified Excel chart has been pasted into slide 3, and data labels have been made larger.
The specified Excel chart has been pasted into slide 3, but data labels are unchanged.
The specified Excel chart has been inserted as an object in the presentation.
The chart has been recreated in the presentation by inserting a new chart.
No attempt has been made to add a chart to the presentation.
Embed a Word table
The specified Word table has been embedded into slide 4, and text has been formatted larger.
The specified Word table has been embedded into slide 4, but the text remains in the original size.
The specified Word table has been linked or inserted in a way that’s not embedded.
The table has been recreated in the presentation by inserting a new table.
No attempt has been made to add a table to the presentation.
Correct lecture notes appear for slides 3 and 6.
Correct lecture notes appear for slides 3 and 6 with some typos.
Lectures notes for slide 3 and 6 exist but aren’t typed as specified.
N/A
No attempt has been made to add lecture notes to the presentation.
Apply transition options
The Uncover transition and the Advance Slide option set to 5 have been applied to all slides.
The Uncover transition and the Advance Slide option set to 5 have been applied to at least one slide.
Only one of the transition options has been set for at least one slide.
The wrong transition or incorrect Advance Slide time has been applied.
No attempt has been made to apply a transition or Advance Slide time to any of the slides.
The presentation has been exported as a video
The presentation has been exported to the .mp4 format.
N/A
N/A
The presentation has been exported to the wrong format.
No attempt has been made to export the presentation to a different format.
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 9
AND OTHER DATA
INTO POWERPOINT
SUBMISSION CHECKLIST
Before submitting your project, make sure you’ve correctly completed the following: q Create an outline with multiple levels in Word. q Enter cell data in an Excel spreadsheet and create a pie chart from the data. q Apply a different chart style to an Excel chart. q Create a Word table and apply a table style. q Merge cells in a Word table. q Insert PowerPoint presentation slides from a Word outline. q Reset inserted slides to the PowerPoint formatting. q Change the layout of a specified slide. q Apply a theme to a presentation. q Modify slide contents by deleting existing text boxes. q Paste an existing chart into a slide. q Edit the data labels of a chart from within PowerPoint. q Embed a Word table into a slide. q Edit a Word table from within PowerPoint. q Add lecture notes to slides. q Apply a transition to all slides. q Set the Advance Slide After option for all slides. q View the slide show from the beginning. q Export the PowerPoint presentation as a movie.
© PENN FOSTER, INC. 2016 INTEGRATING W ORD, EXCEL, PAGE 10
AND OTHER DATA
INTO POWERPOINT
1.
Project Outline.docx
2.
Homelessness Statistics.xlsx
3.
Impoverished Hungry
.docx
4.
Sociology Project.ppt
5.
Sociology Project.mp4
Make sure the following information is in the heading of each document/file/particular cell:
O O
O O
O O
O O
Course name and number
O O
Project number (584805)
1.
Go to http://www.pennfoster.edu.
2.
3.
Click on Take Exam next to the lesson you’re working on.
4.
Be sure to keep a backup copy of any files you submit to the school!

Relevant Material
Screenshots

Instructions
* If you want to purchase multiple products then click on “Buy Now” button which will give you ADD TO CART option.Please note that the payment is done through PayPal.
* You can also use 2CO option if you want to purchase through Credit Cards/Paypal but make sure you put the correct billing information otherwise you wont be able to receive any download link.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please wait for atleast 8 hours for a response from our side. Afterall, we are humans.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.