Chat with us, powered by LiveChat Advanced PC Applications : Advanced PC Applications Graded Project | Gen Paper
+1(978)310-4246 credencewriters@gmail.com
  

Advanced PC
Applications Graded
Project

Advanced PC Applications : Advanced PC
Applications Graded Project

Lesson 7 Overview

This project uses the skills

you’ve acquired for Word,

Excel, PowerPoint, and Access

to

prepare for a promotional event

to introduce a new line of

fishing hooks to local retailers.

You’ll assume the role of

company president for a small fishing tackle company that’s

just getting started. For this project, you must complete the following steps:

1. Create a database of retailers for prospective shops that might carry

your hooks.

2. Create a spreadsheet with statistics and a chart.

3. Complete a mail merge letter inviting sales reps to a fishing lodge to

try out your product.

4. Produce a presentation to give at the fishing lodge.

7.1 Prepare for a promotional event to introduce a new

Advanced PC Applications (v2) : Lesson 7 : Page 1© 2020 Penn Foster
Inc.

product to local retailers
Graded Project: Advanced PC Applications

READING ASSIGNMENT

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 (584085)
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:

Go to http://www.pennfoster.edu (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!

Retailers Database

Follow the steps below to create the Retailers database.

Click to download the files (lessons.pennfoster.com/pdf/584085_Practice_

Files.zip) you’ll need to complete this graded project.

Advanced PC Applications (v2) : Lesson 7 : Page 2© 2020 Penn Foster
Inc.

1. Start Access and create a new blank database named “Retailers.”

2. Name the new table “Retailers” and then display it in Design view.

3. Edit the ID field to be “Retailer ID” and verify that it’s data type

AutoNumber and that it has been selected as the primary key.

4. In Design view, add the remaining fields and corresponding data

types:

Field Name Data Type

Store Name Short Text

Address Short Text

City Short Text

State Short Text

Zip Short Text

5. Save and then close the Retailers table.

6. Create a new table named “Sales Reps” and display it in Design view.

7. Edit the ID field to be “Sales Rep ID” and verify that it’s data type

AutoNumber and that it has been selected as the primary key.

8. Add a field named “Retailer ID” and then select the Lookup Wizard as

the Data Type.

a. Use the Wizard to select Retailers as the table for the Lookup

field.

b. Click Retailer ID as the field with the values to choose from.

c. Sort the values in Ascending order.

d. Click Finish.

9. In Design view, add the remaining Sales Reps fields and

Advanced PC Applications (v2) : Lesson 7 : Page 3© 2020 Penn Foster
Inc.

corresponding data types:

Field Name Data Type

First Name Short Text

Last Name Short Text

Job Title Short Text

10. Save and close the Sales Reps table.

11. Create a Retailers form that includes the following information:

Retailer ID

Store Name

Address

City

State

Zip

12. The form should look similar to the figure below.

Advanced PC Applications (v2) : Lesson 7 : Page 4© 2020 Penn Foster
Inc.

[An image of the Retailers form]

13. Create a Sales Reps form that includes the following information:

Sales Rep ID

Retailer ID

First Name

Last Name

Job Title

14. The form should look similar to the figure below.

Advanced PC Applications (v2) : Lesson 7 : Page 5© 2020 Penn Foster
Inc.

[An image of the Sales Rep form ]

15. Use the Retailers form to populate the Retailers table with the records

listed below.

Retailers Records

Retailer ID 1

Store Name Fishing World

Address 160 Trout Circle

City Any Town

State PA

Zip 16754

Advanced PC Applications (v2) : Lesson 7 : Page 6© 2020 Penn Foster
Inc.

Retailer ID 2

Store Name Everything Bait Shop

Address 1336 Ocean Parkway

City Any Town

State PA

Zip 16755

Retailer ID 3

Store Name Major Sporting Goods

Address 14998 Atlantic Ave.

City Any Town

State PA

Zip 16759

16. Use the Sales Reps form to populate the Sales Reps table with the

records listed below. Note that the Retailer ID is a lookup field and

you’ll be able to select the value from a list.

Sales Reps Records

Sales Rep ID 1

Retailer ID 2

Advanced PC Applications (v2) : Lesson 7 : Page 7© 2020 Penn Foster
Inc.

First Name Marty

Last Name Hu

Job Title Owner

Sales Rep ID 2

Retailer ID 1

First Name Chris

Last Name Tryniski

Job Title Fishing Dept. Rep

Sales Rep ID 3

Retailer ID 1

First Name Karm

Last Name Howard

Job Title Outdoor Goods Manager

Sales Rep ID 4

Retailer ID 3

First Name Liz

Last Name Bennett

Job Title Tackle Sales Rep

Advanced PC Applications (v2) : Lesson 7 : Page 8© 2020 Penn Foster
Inc.

Sales Rep ID 5

Retailer ID 3

First Name Turner

Last Name Ward

Job Title Store Manager

17. Format Table Datasheet view for the Retailers and Sales Reps table,

adjusting column widths as appropriate.

18. Create a query in Design view that displays complete contact

information in alphabetical order by store name. The tables should

already display a relationship because of the Lookup field. If not, join

the tables appropriately to run the query correctly.

[An image of the query]

19. Run the query and save it as “Contacts.”

20. Close the query and any open tables and forms.

21. Close the Retailers database.

Advanced PC Applications (v2) : Lesson 7 : Page 9© 2020 Penn Foster
Inc.

Hook Results Spreadsheet

Follow the steps below to create the Hook Results spreadsheet.

1. Start Excel and create a new blank workbook.

2. Enter the following data:

Table Trout Hooks

Fish Caught

Tournament Table Leading Brand #1 Leading Brand

#2 Leading Brand #3 % Caught with Table

Local Trout Tournament 185 126 90 130

Tri-State Annual Derby 568 445 229 330

3. Format the workbook as follows (shown in the figure below):

a. Merge and center the titles. “Table Trout Hooks” is the overall

title, and “Fish Caught” is the heading for the Table and Leading

Brand columns.

b. Format cell titles and labels as bold.

c. Display borders around all the cells with data.

d. Change the spreadsheet orientation to landscape to allow the

wide columns to be printed on one sheet of paper.

[An image of the spreadsheet with formatting applied.]

Advanced PC Applications (v2) : Lesson 7 : Page 10© 2020 Penn Foster
Inc.

4. In column F, enter formulas that use a function to calculate % Caught

with Table (fish caught with Table hook divided by the total number of

fish caught).

5. Format the % Caught with Table values as a percent with one decimal

place.

6. Insert a Column Chart of type 2-D Clustered Column that charts data

in cells A4 through E6.

7. Change the title to “Fish Caught by Hook Brand.”

8. Change the Chart Style to Style 11, so that your chart looks similar to

the figure.

[An image of the finished chart.]

9. Be sure the chart is sized appropriately and positioned under the

Advanced PC Applications (v2) : Lesson 7 : Page 11© 2020 Penn Foster
Inc.

data.

10. Save the workbook, naming it “Hook Results.”

Invitation Letter

Follow the steps below to create the Invitation Letter.

1. Start Word and create a new single-spaced (blank) document.

2. Type “Table Trout Hooks” and then press Enter.

3. Insert an online image of a trout (use “trout” as the search text) and

then press Enter.

4. Optional: You can remove the background color of your image, if

needed, by following these steps:

a. Select the image.

b. On the Picture Tools Format tab, click Color > Set Transparent

Color.

c. Click on the background color of the selected object.

5. Size the image appropriately and then center align the paragraph

containing the image.

6. Format the Table Trout Hooks text as Georgia 22-point. Your letter

should look similar to the figure.

[An image of the heading and fish image]

Advanced PC Applications (v2) : Lesson 7 : Page 12© 2020 Penn Foster
Inc.

7. Start the mail merge process.

8. When you select recipients, use an existing list, select the

Retailers.accdb database you created earlier, and then select the

Contacts query.

9. Type the text shown below, inserting merge fields and leaving a blank

paragraph where indicated. You’ll need to Match Fields when you

insert the AddressBlock field code so that you can match the

Company to the Store Name field.

March 30, 20xx

¶

<<AddressBlock>>

¶

Are you as excited as I am about the opening day of Trout Season? In

preparation for the Big Day, I invite you to join me at the Local Fishing

Lodge for a morning of fishing followed by a catered lunch on April 8, 20xx

at 7:30 am. You will get to experience firsthand the difference a Table trout

hook makes.

¶

As <<Job_Title>> at <<Store_Name>>, I know you want to make the best

fishing tackle available to your customers. Table trout hooks hook more

trout. Just look at the results from two recent tournaments:

¶

Advanced PC Applications (v2) : Lesson 7 : Page 13© 2020 Penn Foster
Inc.

¶

¶

Please RSVP by emailing me at [email protected] and let me

know if you would like to bring a guest. Looking forward to personally

meeting with you.

¶

Tight lines,

¶

¶

¶

¶

Your name here

President

10. Your letter should look like the figure below.

Advanced PC Applications (v2) : Lesson 7 : Page 14© 2020 Penn Foster
Inc.

[An image of the typed letter.]

11. Be sure that you’ve formatted the date and Table trout hooks name as

bold and used your name in the closing. If the email address isn’t

automatically formatted as a hyperlink, then click Insert > Hyperlink

to format it.

12. In the second blank paragraph after “. . . two recent tournaments:”

paste a copy of the chart from the Hook Results spreadsheet. Size

the chart appropriately, so that it looks similar to the figure.

Advanced PC Applications (v2) : Lesson 7 : Page 15© 2020 Penn Foster
Inc.

[An image of the chart inserted in the letter.]

13. Save the document, naming it “Lodge Lunch.”

14. Use the appropriate command to merge the field data and create a

document containing the individual letters.

15. Scroll through the letters and check that the content requires only one

page. If the chart is so big that your letter requires two pages, then

close the merged document without saving it and resize the chart in

the Lodge Lunch document before performing the merge again.

Repeat this process until you produce letters that will print on one

page each.

16. Save the merged document, naming it “Merged Lodge Letter.”

Event Presentation

Follow the steps below to create the Event Presentation.

Advanced PC Applications (v2) : Lesson 7 : Page 16© 2020 Penn Foster
Inc.

1. Start PowerPoint and create a new blank presentation.

2. Change the Theme of the presentation to Wood Type or another

appropriate style if you don’t have Wood Type.

3. Verify slide 1 is in Title Slide layout and then enter the following text:

Title: Table Trout Hooks

Subtext: Bring home dinner!

4. Your slide should look similar to the figure below.

[An image of the title slide with text inserted]

5. Add a new slide with a Content with Caption layout (slide 2) and then

insert the Table Hook.jpg picture, the data file you downloaded for this

graded project. Add the following text and size the image so that slide

2 looks similar to the figure.

Title: The Table Trout Hook

The patented design of the Table trout hook combines

sharpness, ability to penetrate, and strength to offer a top rate

product for putting dinner on the table.

Advanced PC Applications (v2) : Lesson 7 : Page 17© 2020 Penn Foster
Inc.

[An image of slide 2 with text and image added.]

6. Add a new slide with a Title and Content layout (slide 3) and add the

following text.

Title: Table Trout Hook Design

The double feature has been tournament tested with

overwhelmingly positive response.

Pro and weekend fishers alike will see immediate results with the

double hook and curved shank.

The hook is made of carbon steel for strength and a black nickel

finish for durability.

7. Format the title and text (as a bullet list) as shown in the figure.

Advanced PC Applications (v2) : Lesson 7 : Page 18© 2020 Penn Foster
Inc.

[An image of the formatted slide 3.]

8. Add a new slide with a Title and Content layout (slide 4) and add text

as follows:

Title: Name Recognition

Hook-a-Permit promotion gave a Table hook to the first 250 in-

person Trout permit purchases.

Local Trout Tournament sponsor with every angler receiving a

free Table hook.

Tri-State Annual Trout Derby sponsor is providing more than

2,000 Table hooks.

Advanced PC Applications (v2) : Lesson 7 : Page 19© 2020 Penn Foster
Inc.

[An image of the completed slide 4.]

9. Add a new slide with a Title and Content layout (slide 5). Use the

same text as Slide 1 for the title, but combined. Edit the title and paste

the chart from the Hook Results spreadsheet so that the slide looks

similar to the figure below.

Advanced PC Applications (v2) : Lesson 7 : Page 20© 2020 Penn Foster
Inc.

[An image of the formatted slide 5.]

10. Add a new slide with a Title and Content layout (slide 6) and add

content as follows. Refer to the Hook Results spreadsheet to get the

figure for the first bullet.

Title: Conclusion

35% of tournament trout have been caught with Table hooks

Competitive wholesale prices

Customer support and satisfaction guaranteed

Free setup of in-store displays

Place your order today and get a free shipping discount

11. Insert a picture of the same trout (if possible) used in the Lodge

Letter. The slide should look similar to the figure.

Advanced PC Applications (v2) : Lesson 7 : Page 21© 2020 Penn Foster
Inc.

[An image of the completed slide 6.]

12. Apply the Wind transition to all the slides.

13. Apply the Wipe animation to each of the bullet items on slides 3, 4,

and 6.

14. Save the presentation, naming it “Sales Presentation,” and then play

the slide show from the beginning to check your work.

Scoring Guidelines

Rubric

SKILL/GRADING
CRITERIA

EXEMPLARY
(4)

PROFICIENT
(3)

FAIR
(2)

POOR
(1)

NOT
EVIDENT

(0)

Advanced PC Applications (v2) : Lesson 7 : Page 22© 2020 Penn Foster
Inc.

Create a
database

Correct field
names and
field types
have been
used to
create a table
and form.

Mostly
correct field
names and
field types
have been
used to
create a table
and form.

Some correct
field names
and field
types have
been used to
create a table
and form.

An attempt
has been
made to
create a
table and
form.

No attempt
has been
made to
create a
database
with a table
and form.

Populate a
database

All the
records have
been entered
with no
errors.

Most of the
records have
been entered
with no
errors.

Some
records have
been entered
and there are
errors.

There are a
few records
but they may
not contain
the correct
data.

No attempt
has been
made to
populate the
database.

Create a
database query

The query
criteria
include
correct fields
and sort, and
the tables
have a
defined
relationship.

The query
criteria
include
mostly
correct fields
and sort, and
the tables
have a
defined
relationship.

The query
criteria
include some
fields without
a sort, and
the tables
have a
defined
relationship.

A query has
been created
with only
one table.

No attempt
has been
made to
create the
query.

Create a
spreadsheet

A
spreadsheet
with correct
data,
formatting,
and formulas
has been
created.

A
spreadsheet
with mostly
correct data,
formatting,
and formulas
has been
created.

A
spreadsheet
with some
correct data,
formatting,
and formulas
has been
created.

A
spreadsheet
with
formulas that
don’t use
functions
has been
created.

No attempt
to create a
spreadsheet
has been
made.

Create a chart

A column
chart of the
correct type
and style with
the
appropriate
title has been
created.

A column
chart of the
correct type
with the
appropriate
title has been
created.

A column
chart with the
appropriate
title has been
created.

A chart of
any type has
been
created.

No attempt
has been
made to
create a
chart.

Type document
text

The specified
letter has
been typed
correctly with
correct
spacing,
formatting,
and online
image.

The specified
letter has
been typed
with few
mistakes.

The specified
letter has
been typed
with many
mistakes and
doesn’t
contain most
of the
specified
formats.

The
specified
letter has
been typed
with
numerous
mistakes,
incorrect
spacing, and
lacks an
image.

No attempt
to type the
letter has
been made.

Advanced PC Applications (v2) : Lesson 7 : Page 23© 2020 Penn Foster
Inc.

Insert merge
fields

The letter
contains all
the correct
merge fields
in the correct
positions.

The letter
contains
most of the
correct
merge fields
in the correct
positions.

The letter
doesn’t
contain an
AddressBlock
merge field
and other
merge fields
are missing.

The letter
contains text
in place of
the merge
fields.

No attempt
has been
made to
place merge
fields or
typed
placeholders
at the
designated
positions.

Merge field
letters

Database
merge fields
have been
merged to
create a
document
with
individual
letters.

Database
merge fields
are being
previewed in
the letter.

N/A N/A

No attempt
has been
made to
merge fields
and create a
document
containing
individual
letters.

Create a
presentation

A
presentation
in the
specified
theme with
six 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 six
slides in
varying
layouts has
been
created.

No attempt
has been
made to
create a
presentation.

Insert an image
from the
computer

A data file
image has
been
inserted,
sized, and
positioned.

A data file
image has
been inserted
and sized,
but without
optimal
positioning.

A data file
image has
been inserted
without sizing
or
positioning.

An image
other than
that
specified has
been
inserted.

No attempt
to insert an
image has
been made.

Paste an Excel
chart

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

The specified
Excel chart
has been
pasted into
slide 5 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.

Advanced PC Applications (v2) : Lesson 7 : Page 24© 2020 Penn Foster
Inc.

Insert an online
picture

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

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

N/A

An image
unrelated to
the topic has
been
inserted.

No attempt
has been
made to
insert a clip
art image.

Apply a
Transition

The Wind
transition has
been applied
to all slides.

The Wind
transition has
been applied
to more than
one slide.

The Wind
transition has
been applied
to only one
slide.

The wrong
transition
has been
applied to
the
presentation.

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

Apply
Animations

The Wipe
animation has
been applied
to each bullet
item
separately on
slides 3, 4,
and 6.

The Wipe
animation
has been
applied to all
the bullet
items
together on
slides 3, 4,
and 6.

A different
animation
has been
applied to
each bullet
item
separately on
at least one
slide.

A different
animation
has been
applied to all
the bullet
items
together on
at least one
slide.

No attempt
has been
made to
apply an
animation.

Submission Checklist

Before submitting your graded project, make sure you’ve done all the

required tasks.

Create a database with multiple tables and a Lookup field table.

Create forms corresponding to database tables.

Populate a database table by using forms.

Create a query based on two related tables.

Specify a sort in a database select query.

Create a spreadsheet and apply formatting, including merge and

center, to cells.

Use a function in a formula to calculate a value.

Create a Column chart of type 2-D Clustered Column.

Advanced PC Applications (v2) : Lesson 7 : Page 25© 2020 Penn Foster
Inc.

Edit a chart title.

Change a chart style.

Type and format text in a Word document.

Insert, size, and position an online clip art image.

Create a mail merge document using an existing database query as a

data source.

Insert merge fields, including an AddressBlock, in a Word letter.

Match fields in an AddressBlock merge field.

Paste an Excel chart in a Word document.

Merge field data with actual data to create individual letters.

Create a PowerPoint presentation.

Apply a theme to a presentation.

Insert an existing image into a slide and then size and position it.

Paste an Excel chart into a slide.

Refer to a spreadsheet for content to add to a slide.

Insert an online clip art image into a slide and then size and position it.

Apply a transition.

Apply animations separately to bullet items on a slide.

Advanced PC Applications (v2) : Lesson 7 : Page 26© 2020 Penn Foster
Inc.

  • 58411300
error: Content is protected !!