Advanced PC Access

dani82rose

accesssecondgradedproject.pdf

Home >Computer Science homework help >Advanced PC Access

Integrating Word, Excel, and Data into PowerPoint Project

Advanced PC Applications : Integrating Word, Excel, and Data into PowerPoint Project

Lesson 4 Overview

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.

4.1 Create a presentation for a sociology class about how your college can help provide food for the hungry using given information and data 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

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.

[An image of an outline shown in Outline view]

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

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.

[An image of a pie chart showing Local Homelessness Statistics data]

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 here:

Examples of the Impoverished Hungry

Children Even with the free lunch program, many children go hungryevery day.

Elderly Many senior citizens are raising grandchildren and can't affordenough 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.

[An image of a title slide for a Feeding our Community project]

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.

[An image of a slide showing a chart and chart data labels]

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.

[An image of a slide with a table resized so text can be seen easily

from a distance]

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.

[An image of slides shown in Slide Sorter view]

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

58411000