Assignment Prompt & Instructions
## Integrating Word, Excel, and Other Data into PowerPoint
Need help with doing assignment.
– ## reading_assignment_core_1.html6.zip
**## reading_assignment_core_1.html6.zip**
## Lesson_4/Section_1/reading_assignment_core_1.html
## Graded Project: Integrating Word, Excel, and Other Data into PowerPoint
You’ll upload five files for this graded project:
1. Project Outline.docx
2. Homelessness Statistics.xlsx
3. Impoverished Hungry.docx
4. Sociology Project.pptx
5. Sociology Project.mp4
To submit your graded project, follow these steps:
– Go to http://www.pennfoster.edu.
– Log in to your student portal.
– Click on Take Exam next to the lesson you’re working on.
– Follow the instructions provided to complete your exam.
Be sure to keep a backup copy of any files you submit to the school!
## Instructions
Follow the instructions below to complete your presentation.
### 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 below, being sure to place topics at the indicated level.
3. Save the document, naming it Project Outline.
4. Close the document.
###### OUTLINE TEXT
Feeding our Community
Who is Hungry?
> The Homeless
> The Elderly
> The Working Poor
> Children
Homelessness
Impoverished
The Local Kitchen Center
> Provides two hot meals a day
> Support staff counsels clients
> Volunteer positions available
> Accepts donations of nonperishables
How can our college community help?
> Holiday food drives
> Backpack program
> Permanent drop boxes for nonperishables
### Create a Spreadsheet and a Chart
1. Start Excel and create a new blank workbook.
2. Enter data as shown here:
| | | |
| — | — | — |
| | A | B |
| 1 | Local Homelessness Statistics |
| 2 | | |
| 3 | Working | 25% |
| 4 | Aged Out of Foster Care | 11% |
| 5 | Veterans | 17% |
| 6 | Other | 47% |
3. Convert the data into a pie chart. Be sure that you select a chart style that includes the percentage figures somewhere on the chart.
1. Save the workbook, naming it Homelessness Statistics.
### Create a Word Table
1. Start Word and create a new blank document.
2. Create a 2 × 4 table with the information shown here:
| | |
| — | — |
| Examples of the Impoverished Hungry |
| Children | Even with the free lunch program, many children go hungry every day. |
| Elderly | Many senior citizens are raising grandchildren and can't afford enough food. |
| Working Poor | Single parents make up a large portion of the hungry because their salaries aren't usually enough to cover the food needs of a family. |
Choose a table style similar to that shown—merge the first row of cells, and center and format the title appropriately.
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.
1. Change the theme of the presentation to Frame. Slide 1 should look similar to the figure.
2. Display slide 3, delete the text box with the bullet item placeholder, and then copy and paste the Homelessness Statistics chart.
1. 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 the figure.
2. Display slide 4, delete the text box with the bullet item placeholder, and then embed the Impoverished Hungry table.
1. 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 the figure.
2. Save the presentation, naming it Sociology Project.
3. 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.
1. 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.
1. Apply the Uncover transition to all the slides.
1. 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 the figure.
2. Save the modified presentation and then play the slide show from the beginning to check your presentation.
3. You’ll submit your presentation as a video. Export your presentation as an .mp4 video file.
4. Save the presentation again.
## Scoring Guidelines
### Rubric
| SKILL/GRADING CRITERIA | EXEMPLARY <br>(4) | PROFICIENT <br>(3) | FAIR <br>(2) | POOR <br>(1) | NOT EVIDENT <br>(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 but 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. |
| Create a spreadsheet and chart | 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 presentation 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. |
| 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. |
| Add lecture notes | 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. |
## Submission Checklist
Before submitting your project, make sure you’ve correctly completed the following:
– Create an outline with multiple levels in Word.
– Enter cell data in an Excel spreadsheet and create a pie chart from the data.
– Apply a different chart style to an Excel chart.
– Create a Word table and apply a table style.
– Merge cells in a Word table.
– Insert PowerPoint presentation slides from a Word outline.
– Reset inserted slides to the PowerPoint formatting.
– Change the layout of a specified slide.
– Apply a theme to a presentation.
– Modify slide contents by deleting existing text boxes.
– Paste an existing chart into a slide.
– Edit the data labels of a chart from within PowerPoint.
– Embed a Word table into a slide.
– Edit a Word table from within PowerPoint.
– Add lecture notes to slides.
– Apply a transition to all slides.
– Set the Advance Slide After option for all slides.
– View the slide show from the beginning.
– Export the PowerPoint presentation as a movie.
## pagestyles.css
/\*\* Bootstrap 4.3.1 **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/thirdpartylib/bootstrap-4.3.1/css/bootstrap.min.css';
/\*\* Font Awesome 5.9.0 **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/thirdpartylib/fontawesome-free-5.9.0-web/css/all.min.css';
/\*\* D2L Course Styles **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/css/styles.min.css';
/\*\* D2L Custom Styles **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/css/custom.css';
/\*\* Legacy Migration Styles **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/css/legacy.css';
## Lesson_4/Section_1/23086/58480501_hl.jpg
## Lesson_4/Section_1/23088/58480503_hl.jpg
## Lesson_4/Section_1/23090/58480505_hl.jpg
## Lesson_4/Section_1/23091/58480506_hl.jpg
## Lesson_4/Section_1/23092/58480507_hl.jpg
## Lesson_4/Section_1/23093/58480508_hl.jpg
**## reading_assignment_core_1.html6.zip**
## Lesson_4/Section_1/reading_assignment_core_1.html
## Graded Project: Integrating Word, Excel, and Other Data into PowerPoint
You’ll upload five files for this graded project:
1. Project Outline.docx
2. Homelessness Statistics.xlsx
3. Impoverished Hungry.docx
4. Sociology Project.pptx
5. Sociology Project.mp4
To submit your graded project, follow these steps:
– Go to http://www.pennfoster.edu.
– Log in to your student portal.
– Click on Take Exam next to the lesson you’re working on.
– Follow the instructions provided to complete your exam.
Be sure to keep a backup copy of any files you submit to the school!
## Instructions
Follow the instructions below to complete your presentation.
### 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 below, being sure to place topics at the indicated level.
3. Save the document, naming it Project Outline.
4. Close the document.
###### OUTLINE TEXT
Feeding our Community
Who is Hungry?
> The Homeless
> The Elderly
> The Working Poor
> Children
Homelessness
Impoverished
The Local Kitchen Center
> Provides two hot meals a day
> Support staff counsels clients
> Volunteer positions available
> Accepts donations of nonperishables
How can our college community help?
> Holiday food drives
> Backpack program
> Permanent drop boxes for nonperishables
### Create a Spreadsheet and a Chart
1. Start Excel and create a new blank workbook.
2. Enter data as shown here:
| | | |
| — | — | — |
| | A | B |
| 1 | Local Homelessness Statistics |
| 2 | | |
| 3 | Working | 25% |
| 4 | Aged Out of Foster Care | 11% |
| 5 | Veterans | 17% |
| 6 | Other | 47% |
3. Convert the data into a pie chart. Be sure that you select a chart style that includes the percentage figures somewhere on the chart.
1. Save the workbook, naming it Homelessness Statistics.
### Create a Word Table
1. Start Word and create a new blank document.
2. Create a 2 × 4 table with the information shown here:
| | |
| — | — |
| Examples of the Impoverished Hungry |
| Children | Even with the free lunch program, many children go hungry every day. |
| Elderly | Many senior citizens are raising grandchildren and can't afford enough food. |
| Working Poor | Single parents make up a large portion of the hungry because their salaries aren't usually enough to cover the food needs of a family. |
Choose a table style similar to that shown—merge the first row of cells, and center and format the title appropriately.
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.
1. Change the theme of the presentation to Frame. Slide 1 should look similar to the figure.
2. Display slide 3, delete the text box with the bullet item placeholder, and then copy and paste the Homelessness Statistics chart.
1. 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 the figure.
2. Display slide 4, delete the text box with the bullet item placeholder, and then embed the Impoverished Hungry table.
1. 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 the figure.
2. Save the presentation, naming it Sociology Project.
3. 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.
1. 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.
1. Apply the Uncover transition to all the slides.
1. 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 the figure.
2. Save the modified presentation and then play the slide show from the beginning to check your presentation.
3. You’ll submit your presentation as a video. Export your presentation as an .mp4 video file.
4. Save the presentation again.
## Scoring Guidelines
### Rubric
| SKILL/GRADING CRITERIA | EXEMPLARY <br>(4) | PROFICIENT <br>(3) | FAIR <br>(2) | POOR <br>(1) | NOT EVIDENT <br>(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 but 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. |
| Create a spreadsheet and chart | 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 presentation 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. |
| 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. |
| Add lecture notes | 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. |
## Submission Checklist
Before submitting your project, make sure you’ve correctly completed the following:
– Create an outline with multiple levels in Word.
– Enter cell data in an Excel spreadsheet and create a pie chart from the data.
– Apply a different chart style to an Excel chart.
– Create a Word table and apply a table style.
– Merge cells in a Word table.
– Insert PowerPoint presentation slides from a Word outline.
– Reset inserted slides to the PowerPoint formatting.
– Change the layout of a specified slide.
– Apply a theme to a presentation.
– Modify slide contents by deleting existing text boxes.
– Paste an existing chart into a slide.
– Edit the data labels of a chart from within PowerPoint.
– Embed a Word table into a slide.
– Edit a Word table from within PowerPoint.
– Add lecture notes to slides.
– Apply a transition to all slides.
– Set the Advance Slide After option for all slides.
– View the slide show from the beginning.
– Export the PowerPoint presentation as a movie.
## pagestyles.css
/\*\* Bootstrap 4.3.1 **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/thirdpartylib/bootstrap-4.3.1/css/bootstrap.min.css';
/\*\* Font Awesome 5.9.0 **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/thirdpartylib/fontawesome-free-5.9.0-web/css/all.min.css';
/\*\* D2L Course Styles **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/css/styles.min.css';
/\*\* D2L Custom Styles **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/css/custom.css';
/\*\* Legacy Migration Styles **/
@import '/shared/HTML-Template-Library/PennFoster/_assets/css/legacy.css';
## Lesson_4/Section_1/23086/58480501_hl.jpg
## Lesson_4/Section_1/23088/58480503_hl.jpg
## Lesson_4/Section_1/23090/58480505_hl.jpg
## Lesson_4/Section_1/23091/58480506_hl.jpg
## Lesson_4/Section_1/23092/58480507_hl.jpg
## Lesson_4/Section_1/23093/58480508_hl.jpg