Instructions have been attached. This project uses 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 thatintegrates spreadsheet data.
© PENN FOSTER, INC. 2016
Don't use plagiarized sources. Get Your Custom Essay on
Computer applications assignment
Just from $13/Page
Graded Project
Computer Applications
© PENN FOSTER, INC. 2016 PAGE 1COMPUTER APPLICATIONS
Graded Project
INTRODUCTION 2
INSTRUCTIONS 2
SCORING GUIDELINES 10
SUBMITTING YOUR PROJECT 13
INTRODUCTION
CONTENTS
© PENN FOSTER, INC. 2016 PAGE 2COMPUTER APPLICATIONS
Graded Project
COMPUTER APPLICATIONS
INTRODUCTION
This project uses 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.
INSTRUCTIONS
MEMO
1. Start Word and create a new blank document.
2. Create a memo for the sales meeting as shown in Figure 1,
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.
Figure 1
3. Save the document as Meeting Memo.
© PENN FOSTER, INC. 2016 PAGE 3COMPUTER APPLICATIONS
Graded Project
3. Save the worksheet as Summer Sales.
4. Create a column chart based on cells A4 through D7 that looks similar to Figure 3.
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.
SPREADSHEET AND CHART
1. Start Excel and create a new blank workbook.
2. Enter data as shown in
Figure 2
, 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 Arial 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.
Figure 2
© PENN FOSTER, INC. 2016 PAGE 4COMPUTER APPLICATIONS
Graded Project
5. Save the modified workbook. Your final spreadsheet should look similar to
Figure 4
.
Figure 3
Figure 4
© PENN FOSTER, INC. 2016 PAGE 5COMPUTER APPLICATIONS
Graded Project
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 Figure 5.
Figure 5
Figure 6
4. Add a new slide 2 with a Blank layout and then add sales data from the Summer
Sales workbook as a linked object. Size the spreadsheet object so that slide 2
looks similar to Figure 6.
© PENN FOSTER, INC. 2016 PAGE 6COMPUTER APPLICATIONS
Graded Project
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 Figure 7.
Figure 7
Figure 8
6. Add a new slide 4 with a Picture with Caption layout and add content so that the
slide looks similar to Figure 8. Insert the Glow in the Dark Widget , a data file
for this graded project.
© PENN FOSTER, INC. 2016 PAGE 7COMPUTER APPLICATIONS
Graded Project
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 Figures 9, 10,
and 11.
Figure 9
Figure 10
© PENN FOSTER, INC. 2016 PAGE 8COMPUTER APPLICATIONS
Graded Project
8. Add a new slide with a Title and Content layout and add text so that the slide looks
similar to
Figure 12
.
Figure 11
Figure 12
© PENN FOSTER, INC. 2016 PAGE 9COMPUTER APPLICATIONS
Graded Project
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.
Figure 13
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 Figure 13.
© PENN FOSTER, INC. 2016 PAGE 10COMPUTER APPLICATIONS
Graded Project
SCORING GUIDELINES
RUBRIC
SKILL/
GRADING
CRITERIA
EXEMPLARY
(4)
PROFICIENT
(3)
FAIR
(2)
POOR
(1)
NOT
EVIDENT
(0)
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 format-
ting has been
created.
A memo with
most of the
correct con-
tent and some
of the correct
formatting has
been created.
A memo
with little
or no for-
matting and
inaccurate
content
has been
created.
No attempt
has been
made to cre-
ate a memo.
Create a
spread-
sheet
All cell data is
correctly for-
matted and the
calculations use
formulas with
functions.
Cell data is cor-
rectly formatted
and some cal-
culations use
formulas with
functions.
Some cell data
is correctly
formatted and
some calcu-
lations 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 with-
out 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 cre-
ated without
the correct
data, speci-
fied 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 lay-
outs has been
created.
A presentation
in the specified
theme with
most of the
slides in the
correct lay-
outs has been
created.
A presentation
in the spec-
ified theme
with some of
the slides in
the correct
layouts has
been created.
A presen-
tation 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.
(Continued)
© PENN FOSTER, INC. 2016 PAGE 11COMPUTER APPLICATIONS
Graded Project
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 appropri-
ately 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.
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 rec-
reated 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 appropri-
ate 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 transi-
tion to any of
the slides.
Apply
animations
The Grow
& Turn ani-
mation has
been applied
to each
bullet item
separately.
The Grow &
Turn anima-
tion 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.
© PENN FOSTER, INC. 2016 PAGE 12COMPUTER APPLICATIONS
Graded Project
SUBMISSION CHECKLIST
Before submitting your project, make sure you’ve correctly completed the following:
q Enter text in Word.
q Set tab stops.
q Apply formatting to text in Word.
q Enter and format data in Excel.
q Merge and center cells in Excel.
q Change the decimals displayed by numbers in Excel.
q Create a 2-D Column chart in the Stacked Column style.
q Modify the data labels of the chart.
q Change the layout of the specified slides.
q Apply a theme to the presentation.
q Add nine slides of different layouts to the presentation.
q Insert and format a table in a slide.
q Create and format a chart in a slide.
q Insert existing picture files into slides.
q Insert a clip art image from the Internet into a slide.
q Apply a transition to all slides.
q Apply an animation to bullet points separately.
q View a slide show from the beginning.
© PENN FOSTER, INC. 2016 PAGE 13COMPUTER APPLICATIONS
Graded Project
SUBMITTING YOUR PROJECT
Each project is individually graded and therefore could take approximately 5–7 business
days to grade. You will submit three files for this project:
1. Meeting Memo x
2. Summer Sales.xlsx
3. Fall Meeting.ppt
Make sure the following information is in the heading of each file:
O Your name
O Your email address
O Your student number
O Course name and number
O Project number (58480700)
Follow this procedure to submit your assignment online:
1. Go to http://www.pennfoster.edu and log in to your student portal.
2. On your student portal, click on Exam.
3. In the box provided, enter the examination number.
The number for this exam is 58480700.
4. Click Submit.
5. On the next screen, enter your email address.
(Note: This information is required for online submission.)
6. If you wish to tell your instructor anything specific regarding this assignment,
enter it in the Comments.
7. Attach your file or files as follows:
a. Click on the first Browse box.
b. Locate the file you wish to attach.
c. Double-click on the file.
d. To attach the additional files, click on the next Browse box
and repeat steps b and c. Repeat until all files are uploaded.
8. Click Submit.
Be sure to keep a backup copy of any files you submit to the school!
http://www.pennfoster.edu
© PENN FOSTER, INC. 2016 PAGE 14COMPUTER APPLICATIONS
Graded Project
