Course Computer Applications
Microsoft Office 2016 allows people to create documents, spreadsheets,
presentations, and databases. This course will teach you how to use
three popular tools from the MS Office Suite— MS Word, MS Excel, and
MS PowerPoint. In this course, you’ll learn how to use MS Word 2016 to
create and edit text documents, insert figures and tables, and format
pages for a variety of uses. You’ll then learn how to use MS Excel to
organize and format data, including charts, formulas, and more complex
tables. Next, you’ll learn how to use MS PowerPoint to create and
deliver slide shows. Finally, you’ll complete a computer applications
graded project, which will test the skills acquired in Word, Excel, and
PowerPoint.
Course Objectives
Demonstrate a high level of inquiry, analytical, and problem-solving
skills
Computer Applications © 2020 Penn Foster (v1) : Page 1
Inc.
Demonstrate effective quantitative skills
Demonstrate computer and information literacy
Demonstrate job-specific technical and professional skills
Demonstrate effective written and interpersonal communication skills
Identify how to create various Microsoft Word documents
Write a sound Microsoft Word 2016 letter
Identify how to create various Microsoft Excel documents
Produce a thorough Microsoft Excel 2016 spreadsheet
Identify the basic skills needed to use Microsoft PowerPoint
Create a well-constructed memo, spreadsheet, and presentation
Computer Applications © 2020 Penn Foster (v1) : Page 2
Inc.
Computer Applications : Computer
Applications Graded Project
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) © 2020 Penn Foster : Lesson 6 : Page 1
Inc.
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) © 2020 Penn Foster : Lesson 6 : Page 2
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) © 2020 Penn Foster : Lesson 6 : Page 3
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 rightaligned.
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) © 2020 Penn Foster : Lesson 6 : Page 4
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) © 2020 Penn Foster : Lesson 6 : Page 5
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) © 2020 Penn Foster : Lesson 6 : Page 6
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) © 2020 Penn Foster : Lesson 6 : Page 7
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) © 2020 Penn Foster : Lesson 6 : Page 8
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) © 2020 Penn Foster : Lesson 6 : Page 9
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) : © 2020 Penn Foster Lesson 6 : Page 10
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) : © 2020 Penn Foster Lesson 6 : Page 11
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) : © 2020 Penn Foster Lesson 6 : Page 12
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) : © 2020 Penn Foster Lesson 6 : Page 13
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) : © 2020 Penn Foster Lesson 6 : Page 14
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
Ap
resentation
in the
specified
theme with 9
slides in the
correct
layouts has
been created.
Ap
resentation
in the
specified
theme with
most of the
slides in the
correct
layouts has
been created.
Ap
resentation
in the
specified
theme with
some of the
slides in the
correct
layouts has
been
created.
Ap
resentation
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) : © 2020 Penn Foster Lesson 6 : Page 15
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) : © 2020 Penn Foster Lesson 6 : Page 16
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) : © 2020 Penn Foster Lesson 6 : Page 17
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) : © 2020 Penn Foster Lesson 6 : Page 18
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) : © 2020 Penn Foster Lesson 6 : Page 19
Inc.
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 dropdown
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) : © 2020 Penn Foster Lesson 6 : Page 20
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) : © 2020 Penn Foster Lesson 6 : Page 21
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) : © 2020 Penn Foster Lesson 6 : Page 22
Inc.