Glow in the dark widget jpg

Lesson 6 Overview

In this lesson, you'll use the

skills you’ve acquired for

Word, Excel, and PowerPoint

to prepare

for a sales meeting. You’ll

assume the role of Director

of Sales. For this project,

you’ll

complete a memo, a

spreadsheet with sales figures and a chart, and a presentation that

integrates spreadsheet data.

6.1 Construct a memo, a spreadsheet, and a presentation for a sales meeting Computer Applications Graded Project Files

READING ASSIGNMENT

Computer Applications Graded Project Files (lessons.pennfoster.com/pd

f/584807_Practice%20Files.zip) Computer Applications

Computer Applications (v1) : Lesson 6 : Page 1© 2020 Penn Foster Inc.

http://lessons.pennfoster.com/pdf/584807_Practice Files.zip
READING ASSIGNMENT

Each element of your project must be submitted in the correct file format. The Microsoft Word portion must be uploaded as a .docx or .doc; the Microsoft Excel portion must be uploaded as a .xlsx or .xls; and, the Microsoft Powerpoint portion must be uploaded as a .pptx or .ppt file. Your project will be individually graded by your instructor and therefore may take up to five to seven days to grade. Be sure that each of your files contains the following information:

Your name Your student ID number The exam number Your email address

Note: If you have more than 10 attachments, you’ll need to collect all of your files into a compressed folder. To do this, follow these instructions based on your operating system:

Windows: Select the files you want to compress, right-click and select Send to. . . and then Compressed (zipped) folder Mac: Select the files you want to compress, control-click and select Compress

To submit your graded project, follow these steps:

Log in to your student portal. Click on Take Exam next to the lesson you’re working on. Find the exam number for your project at the top of the Project Upload page. Follow the instructions provided to complete your exam.

Be sure to keep a backup copy of any files you submit to the school!

Instructions

Memo

Computer Applications (v1) : Lesson 6 : Page 2© 2020 Penn Foster Inc.

1. Start Word and create a new blank document.

2. Create a memo for the sales meeting as shown in the figure below,

using the following formats:

a. The company name should be in Arial 20-point, bold, purple

font.

b. The memo headings and text should be in Times New Roman,

12-point font, with left-aligned tab stops set to 1 inch.

c. Replace Your Name Here with your name.

d. The body text should be in Times New Roman, 12-point font,

with bold text where indicated.

[An image of a memo for a sales meeting.]

3. Save the document as Meeting Memo.

Spreadsheet and Chart

1. Start Excel and create a new blank workbook.

Computer Applications (v1) : Lesson 6 : Page 3© 2020 Penn Foster Inc.

[An image of a formatted summer

sales worksheet.]

2. Enter data as shown in the figure, using the following formats:

a. The company name should be in Arial, 20-point, bold, purple

font.

b. The Summer sales title should be in 16-point font.

c. The company name and Summer sales titles should be

merged and centered.

d. Column headings should be bold, and month headings right-

aligned.

e. The sales figures should be in Currency cell style with no

decimal places.

f. Formulas that use functions should be used for calculated

totals.

g. Cells B8 through E8 should be formatted in the Total cell style.

3. Save the worksheet as Summer Sales.

4. Create a column chart based on cells A4 through D7 that looks

similar to the figure below.

Computer Applications (v1) : Lesson 6 : Page 4© 2020 Penn Foster Inc.

a. Select the 2-D Column Stacked Column style.

b. After the chart is created, add data labels as shown in the

figure.

c. Edit the chart title as shown in the figure.

[An image of column chart based on cells A4 through D7 of the summer sales

worksheet.]

5. Save the modified workbook. Your final spreadsheet should look

similar to the figure below.

Computer Applications (v1) : Lesson 6 : Page 5© 2020 Penn Foster Inc.

[An image of the modified summer sales workbook.]

Presentation

1. Start PowerPoint and create a new blank presentation.

2. Change the theme of the presentation to Crop or another

appropriate style if you don’t have Crop.

3. Verify that slide 1 uses Title Slide layout and then enter text so that

your slide looks similar to the figure below.

Computer Applications (v1) : Lesson 6 : Page 6© 2020 Penn Foster Inc.

[An image of the title slide layout.]

4. Add a new slide 2 with a Blank layout, insert a table, and then add

the sales data from the Summer Sales workbook. Size the table so

that slide 2 looks similar to the figure below.

Computer Applications (v1) : Lesson 6 : Page 7© 2020 Penn Foster Inc.

[An image of a new powerpoint slide with a table containing the sales data from the

summer sales workbook.]

5. Add a new slide 3 with a Blank layout and then insert a Stacked

Column chart. Add the Summer sales data, format the title, and

add the data labels to each column. Size the chart so that slide 3

looks similar to the figure below.

Computer Applications (v1) : Lesson 6 : Page 8© 2020 Penn Foster Inc.

[An image of a new powerpoint slide with a stacked column chart containing the sales

data from the summer sales workbook.]

6. Add a new slide 4 with a Picture with Caption layout and add

content so that the slide looks similar to the figure below. Insert the

Glow in the Dark Widget.jpg, a data file for this graded project.

Computer Applications (v1) : Lesson 6 : Page 9© 2020 Penn Foster Inc.

[An image of a picture with caption layout powerpoint slide with the Glow in the Dark

Widget image.]

7. Add three more Picture with Caption layout slides to introduce the

Lime Doodad, Buttercup Gizmo, and Black Widget products. Their

corresponding image files are data files for this graded project.

Your slides should look similar to the following figures.

Computer Applications (v1) : Lesson 6 : Page 10© 2020 Penn Foster Inc.

[An image of a picture with caption layout powerpoint slide with the Lime Doodad

image.]

[An image of a picture with caption layout powerpoint slide with the Buttercup Gizmo

Computer Applications (v1) : Lesson 6 : Page 11© 2020 Penn Foster Inc.

image.]

[An image of a picture with caption layout powerpoint slide with the Black Widget

image.]

8. Add a new slide with a Title and Content layout and add text so that

the slide looks similar to the figure below.

Computer Applications (v1) : Lesson 6 : Page 12© 2020 Penn Foster Inc.

[An image of a title and content layout powerpoint slide with discussion text.]

9. Add a new slide with a Title Only layout. Insert text and a clip art

picture that thanks employees for their hard work (use “thank you”

as the search text when searching for the image). Size and position

the picture to look similar to the figure below.

Computer Applications (v1) : Lesson 6 : Page 13© 2020 Penn Foster Inc.

[An image of a title only layout slide with inserted text and clip art.]

10. Apply the Page Curl transition to all the slides.

11. Apply the Grow & Turn animation to each of the bullet items on

slide 8.

12. Save the presentation as Fall Meeting, and then play the slide

show from the beginning to check your presentation.

Scoring Guidelines

Rubric

Skill/Grading Criteria

Exemplary (4)

Proficient (3)

Fair (2)

Poor (1)

Not Evident (0)

Computer Applications (v1) : Lesson 6 : Page 14© 2020 Penn Foster Inc.

Create a memo

A memo with all appropriate formatting, including tab stops, and accurate text, has been created.

A memo with most of the correct content and formatting has been created.

A memo with most of the correct content and some of the correct formatting has been created.

A memo with little or no formatting and inaccurate content has been created.

No attempt has been made to create a memo.

Create a spreadsheet

All cell data is correctly formatted and the calculations use formulas with functions.

Cell data is correctly formatted and some calculations use formulas with functions.

Some cell data is correctly formatted and some calculations use formulas with functions.

Some cell data is present with little or no formatting or use of formulas for calculation.

No attempt to create a spreadsheet has been made.

Create a chart

A column chart based on the correct data, the specified style, and the correct labels has been created.

A column chart based on the correct data, the specified style, but without the correct labels has been created.

A column chart based on the correct data, with an unspecified style, and the correct labels has been created.

A chart has been created without the correct data, specified style, or labels.

No attempt to create a chart has been made.

Create a presentation

A presentation in the specified theme with 9 slides in the correct layouts has been created.

A presentation in the specified theme with most of the slides in the correct layouts has been created.

A presentation in the specified theme with some of the slides in the correct layouts has been created.

A presentation with fewer than 9 slides in varying layouts has been created.

No attempt has been made to create a presentation or fewer than 9 slides without some required content have been created.

Insert Excel data as a

linked object into slide 2

The specified cell data has been pasted as a linked Excel Worksheet object into slide 2 and appropriately sized.

The specified cell data has been pasted as an Excel Worksheet object without linking.

The specified cell data has been copied and pasted as a PowerPoint table or embedded.

An attempt has been made to paste some cell data into the presentation.

No attempt has been made to add Excel spreadsheet data to the presentation.

Computer Applications (v1) : Lesson 6 : Page 15© 2020 Penn Foster Inc.

Paste an Excel chart into slide 3

The specified Excel chart has been pasted into slide 3 and appropriately sized and positioned.

The specified Excel chart has been pasted into slide 3 but not sized or positioned.

The specified Excel chart has been recreated in the presentation by using the Insert Chart command.

The chart has been inserted as an Excel Worksheet Object and displays the entire worksheet.

No attempt has been made to add a chart to the presentation.

Insert data file images

Images have been inserted as specified.

Most of the specified images have been inserted.

Some of the specified images have been inserted.

Few of the specified images have been inserted on any slide.

No attempt has been made to add specified images to the presentation.

Insert a clip art image

into slide 9

An appropriate clip art image has been inserted on slide 9 and appropriately sized and positioned.

An appropriate clip art image has been inserted on slide 9 but may not be sized or positioned appropriately.

N/A N/A

No attempt has been made to add an appropriate clip art image.

Apply a transition

The Page Curl transition has been applied to all slides.

The Page Curl transition has been applied to two or more slides.

The Page Curl transition has been applied to one slide only.

The wrong transition has been applied.

No attempt has been made to apply a transition to any of the slides.

Apply animations

The Grow & Turn animation has been applied to each bullet item separately.

The Grow & Turn animation has been applied to all the bullet items together.

A different animation has been applied to each bullet item separately.

A different animation has been applied to all the bullet items together.

No attempt has been made to apply an animation.

Submission Checklist

Before submitting your project, make sure you’ve correctly completed

the following:

Computer Applications (v1) : Lesson 6 : Page 16© 2020 Penn Foster Inc.

Enter text in Word.

Set tab stops.

Apply formatting to text in Word.

Enter and format data in Excel.

Merge and center cells in Excel.

Change the decimals displayed by numbers in Excel.

Create a 2-D Column chart in the Stacked Column style.

Modify the data labels of the chart.

Change the layout of the specified slides.

Apply a theme to the presentation.

Add nine slides of different layouts to the presentation.

Insert and format a table in a slide.

Create and format a chart in a slide.

Insert existing picture files into slides.

Insert a clip art image from the Internet into a slide.

Apply a transition to all slides.

Apply an animation to bullet points separately.

View a slide show from the beginning.

What to Submit

You will submit three files for this project:

1. Meeting Memo.docx

2. Summer Sales.xlsx

3. Fall Meeting.ppt

Be sure to keep a backup copy of any files you submit to the school!

Computer Applications (v1) : Lesson 6 : Page 17© 2020 Penn Foster Inc.

Key Points

READING ASSIGNMENT

Key Points

Default tab spacing in Word is set at every half inch.

You use the Tab Selector to set left, center, and right tabs, as well

as decimal and bar tabs, and first line and hanging indents.

You can use the Font Color box to quickly apply theme or standard

colors to text.

The default alignment for text in an Excel worksheet is bottom-left

of the cell and the default for numbers is bottom-right of the cell.

You can visual represent data in Excel using a variety of chart

types and their subtypes, as well as creating a combination chart

by using more than one chart type in your chart.

The default currency format in Excel includes the dollar sign ($) and

two decimal places. Negative numbers are shown with a minus

sign (-) preceding the dollar sign.

The default Title Slide layout in PowerPoint contains a main title

and a subtitle in a smaller font.

Common objects inserted in a PowerPoint slide include a table,

chart, SmartArt Graphic, local pictures, online pictures, and videos.

Similar to other Office applications, you can quickly create bulleted

lists using the Bullets and Numbering buttons in the Paragraph

section of the Home Ribbon.

Computer Applications (v1) : Lesson 6 : Page 18© 2020 Penn Foster Inc.

What You Need to Know Before Submitting Your Computer

Applications Graded Project

VIDEO STUDY MATERIAL

Watch this video for tips on how to save the files, and what files need to be submitted for grading.

Watch this video for tips on how to save the files, and what files need to

be submitted for grading.

Brightcove Video Title (players.brightcove.net/1642697353001/default_d

efault/index.html?videoId=6109280236001)

Lesson 6 Review

Self-Check

1. You created a help document for other employees in your

department. You submitted it to your boss who loved it. Included in her

comments is to add a document title that readers can easily see. Which

of the following is the most common method for formatting a document

title?

a. Typing the title in all capital letters.

b. Applying a larger font size to the title text.

c. Applying italics to the title text.

d. Changing the font color to red.

2. How do you center a title over a number of columns in Excel?

Computer Applications (v1) : Lesson 6 : Page 19© 2020 Penn Foster Inc.

https://players.brightcove.net/1642697353001/default_default/index.html?videoId=6109280236001
a. Select the title text and click the Center button in the Alignment

section on the Home Ribbon.

b. Select the row cells in the columns you want to center the title over

and then click the Merge & Center button in the Alignment section of

the Home Ribbon.

c. Select the cell containing the title and click the Center button in the

Alignment section on the Home Ribbon.

d. Select the cell containing the title and from the Cell Styles drop-

down list in the Styles section on the Home Ribbon, select one of the

Heading or Title styles.

3. On which PowerPoint ribbon do you find the themes to apply to your

slides?

a. Design

b. Home

c. Slide Show

d. View

4. You are creating a PowerPoint presentation showcasing a variety of

new products your company is releasing soon. Which of the following

layout slides would work well for this application?

a. Content with Caption

b. Comparison

c. Picture with Caption

d. Two Content

Self-Check Answer Key

Computer Applications (v1) : Lesson 6 : Page 20© 2020 Penn Foster Inc.

1. Applying a larger font size to the title text.

Explanation: The default header and title styles are set with a larger

font size than body text styles.

Reference: Section 6.1

2. Select the row cells in the columns you want to center the title over

and then click the Merge & Center button in the Alignment section

of the Home Ribbon.

Explanation: The two methods for centering text across columns

include merging and centering over a selection. To merge, select

the cells you want to merge and then click the Merge & Center

button. To center over a selection, use the Center Across

Selection feature available in the Format Cells dialog box.

Reference: Section 6.1

3. Design

Explanation: You can apply a theme or color scheme, or format the

slide background from the Design Ribbon.

Reference: Section 6.1

4. Picture with Caption

Explanation: The Picture with Caption layout gives you space for a

photograph of your product, plus an area for the product's name,

and any product highlights you want to include.

Reference: Section 6.1

Computer Applications (v1) : Lesson 6 : Page 21© 2020 Penn Foster Inc.

Flash Cards

1. Term: Word

Definition: A graphical word processing program created by Microsoft

that you can use to author documents

2. Term: Excel

Definition: A graphical program created by Microsoft that you can use

to enter and display data in table form, as well as perform mathematical

calculations on that data

3. Term: PowerPoint

Definition: A graphical program created by Microsoft that you can use

to create slide show presentations

Computer Applications (v1) : Lesson 6 : Page 22© 2020 Penn Foster Inc.

Lesson 6 Overview
Instructions
Memo
Spreadsheet and Chart
Presentation
Scoring Guidelines
Rubric
Submission Checklist
What to Submit
Key Points