Penn foster student lms login

Advanced Applications

Create the Presentation Outline

2 people liked this 0 discussions

Graded Project: Integrating Word, Excel, and Other Data into PowerPoint

READING ASSIGNMENT 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

Your project must be submitted as a Word document (.docx, .doc)*. Your project will be individually graded by your instructor and therefore will take up to a few weeks to grade.

Be sure that each of your files contains the following information:

Your name Your student ID number The lesson number (######00) Your email address

Note: If you have more than 10 attachments, you’ll need to WinZip all of the project’s associated files along with all documentation using the WinZip software program.

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!

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 2/8

1. Start Word and create a new blank document. 2. Display the document in Outline view and type the outline shown in the figure, being sure to place

topics at the indicated level. 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 the figure. 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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 3/8

4. 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 in the figure. 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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 4/8

5. Change the theme of the presentation to Frame. Slide 1 should look similar to the figure. 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 the figure.

8. Display slide 4, delete the text box with the bullet item placeholder, and then embed the Impoverished Hungry table.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 5/8

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 the figure.

10. Save the presentation, naming it Sociology Project. 11. 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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 6/8

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 the figure.

15. Save the modified presentation and then play the slide show from the beginning to check your presentation.

16. You’ll submit your presentation as a video. Export your presentation as an .mp4 video file. 17. Save the presentation again.

Scoring Guidelines

Rubric

SKILL/GRADING CRITERIA

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.

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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 7/8

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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 8/8

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.