Microsoft Access 2016 Graded Project , Integrating Word, Excel, And Data Into Powerpoint , Integrating Word, Access, And Excel Project , Advanced Pc Applications Final Graded Project 

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 1/19

Instructions

Create a Database

1. Start Access and create a Blank database, naming it “Inventory.”
2. On the Home tab, click View and then name the new table “Inventory.”
3. In Design view, change the field name ID to Item ID and verify that it’s data type AutoNumber and

has been selected as the primary key.
4. In Design view, add the remaining fields and corresponding data types:

Field Name Data Type Description

Item Name Short Text

Category Short Text Appliances, Electronics, Jewelry, Other

Manufacturer Short Text

Model Short Text

Serial Number Short Text

Purchase Date Date/Time (Short Date)

Purchase Price Currency

2 people liked this 0 discussions

Graded Project: Microsoft Access 2016

READING ASSIGNMENT
Your project must be submitted as a Microsoft Access document (.accdb). The 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 (######00)
Your email address

Note: If you have more than 10 attachments, you’ll need to WinZip all of the project’s associated files along with all
documentation using the WinZip software program.

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!

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 2/19

Merchant ID Number

Online Purchase Yes/No

Credit Card Purchase Yes

/No

Warranty Type Short Text Store, Manufacturer, Other

Warranty Length Short Text

Repair Yes/No

Repair Date Date/Time (Short Date)

Comments Short Text

5. Save and then close the Inventory table.
6. Create a second table in Design view. Name the table “Merchants.”
7. Add the following fields and corresponding data types. Be sure Merchant ID is the primary key:

Field Name Data Type Description

Merchant ID AutoNumber

Merchant Name Short Text

Address Short Text

City Short Text

State Short Text

Zip Short Text

Email Hyperlink

Website Hyperlink

Telephone Short Text

Fax Short Text

8. Save and then close the Merchants table.
9. Create a relationship by linking the Merchant ID in the Inventory table to the Merchant ID in the

Merchants table. Be sure to enforce referential integrity.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 3/19

Create Forms and Populate the Database

1. Create a Merchants form that looks similar to the figure below.

2. Create an Inventory form that looks similar to the figure below.

3. Use the Merchants form to populate the appropriate sections in the Merchants table with the
records listed below.

Merchant Records

Merchant ID 1

Merchant Name Electronics Mart

Address 65 Resister Ave.

City Blankston

State PA

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 4/19

Zip 18454

Email emart@blanknet.com

Website www.emart.com

Telephone (570) 555-1111

Fax (570) 555-1112

Merchant ID 2

Merchant Name Appliances Inc.

Address 2020 Mechanics Road

City Blankston

State PA

Zip 18454

Email n/a

Website n/a

Telephone (570) 555-1234

Fax (none)

Merchant ID 3

Merchant Name Stuff Mart

Address 721 Frengburg St.

City Shopville

State NY

Zip 10022

Email custserv@stuffmart.com

Website www.stuffmart.com

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 5/19

Telephone (212) 555-5432

Fax n/a

Merchant ID 4

Merchant Name Phones and More

Address 21 Framer Circle

City Klossville

State PA

Zip 19019

Email callus@phonesandmore.com

Website www.phonesandmore.com

Telephone (612) 555-9876

Fax n/a

Merchant ID 5

Merchant Name Jewelry Warehouse

Address 24 Karat Street

City Platoid

State NY

Zip 00050

Email info@jewelware.com

Website www.jewelware.com

Telephone (609) 555-3344

Fax (609) 555-3345

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 6/19

Merchant ID 6

Merchant Name Crazy John’s Computers

Address 456 Enterprise St.

City Wynnsville

State CO

Zip 18888

Email crazy@merchandizing.net

Website www.merchandizing.net/crazy

Telephone (301) 555-9080

Fax n/a

Merchant ID 7

Merchant Name Collector’s Emporium

Address 256 Antiques Ave.

City Oldensurg

State PA

Zip 18999

Email findit@collectibles.net

Website www.collectibles.net

Telephone (570) 555-1608

Fax (570) 555-1609

4. Use the Inventory form to populate the appropriate sections in the Inventory table with the records
listed below.

Inventory Records

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 7/19

Item ID 1

Item Name GameBox

Category Electronics

Manufacturer Super

Model GB928

Serial Number R729-382

Purchase Date 2/1/2017

Purchase Price $599.00

Merchant ID 1

Online Purchase No

Credit Card Purchase Yes

Warranty Type Manufacturer

Warranty Length 2 years, parts only

Repair No

Repair Date (none)

Comments packaged with one free game control

Item ID 2

Item Name Smart TV

Category Electronics
Manufacturer Super

Model 4200

Serial Number 1930456

Purchase Date 2/20/2017

Purchase Price $499.00

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 8/19

Merchant ID 1
Online Purchase No
Credit Card Purchase Yes
Warranty Type Manufacturer

Warranty Length 90 days, parts only

Repair No
Repair Date (none)

Comments (none)

Item ID 3

Item Name Laptop

Category Electronics

Manufacturer Deluxe

Model SuperFast

Serial Number 879603-109-345

Purchase Date 2/27/2017

Purchase Price $899.00

Merchant ID 3
Online Purchase No
Credit Card Purchase Yes
Warranty Type Manufacturer

Warranty Length 1 year, parts and labor

Repair Yes

Repair Date 6/1/2017

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/re… 9/19

Comments keyboard replaced

Item ID 4

Item Name Bluetooth Headset

Category Electronics

Manufacturer Wireless

Model BT54910

Serial Number 345-896-000

Purchase Date 2/22/2017

Purchase Price $99.00

Merchant ID 4

Online Purchase Yes

Credit Card Purchase Yes
Warranty Type Manufacturer

Warranty Length 12 months, parts only

Repair No
Repair Date (none)
Comments (none)

Item ID 5

Item Name Ink Jet Printer

Category Electronics

Manufacturer Pro

Model U750

Serial Number 555639870

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 10/19

Purchase Date 1/15/2017

Purchase Price $49.00

Merchant ID 6
Online Purchase Yes
Credit Card Purchase Yes
Warranty Type Manufacturer

Warranty Length 90 days, parts and tech support

Repair No
Repair Date (none)
Comments (none)

Item ID 6

Item Name Refrigerator

Category Appliances

Manufacturer Wonderlux

Model Ice Age 2000

Serial Number 2567590

Purchase Date 4/5/2017

Purchase Price $999.00

Merchant ID 2
Online Purchase No
Credit Card Purchase Yes

Warranty Type Manufacturer/store

Warranty Length 2 years, parts and labor/5 years, refrigeration parts

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 11/19

Repair No
Repair Date (none)
Comments (none)

Item ID 7

Item Name Washing Machine

Category Appliances
Manufacturer Wonderlux

Model CL900

Serial Number 90050221

Purchase Date 6/4/2017

Purchase Price $625.00

Merchant ID 2
Online Purchase No
Credit Card Purchase Yes
Warranty Type Manufacturer
Warranty Length 1 year, parts and labor
Repair No
Repair Date (none)
Comments (none)

Item ID 8

Item Name Clothes Dryer

Category Appliances
Manufacturer Wonderlux

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 12/19

Model DR199

Serial Number 199502211

Purchase Date 6/4/2017

Purchase Price $700.00

Merchant ID 2
Online Purchase No
Credit Card Purchase Yes
Warranty Type Manufacturer
Warranty Length 1 year, parts and labor
Repair No
Repair Date (none)
Comments (none)

Item ID 9

Item Name Dishwasher

Category Appliances

Manufacturer Washomatic

Model DW19

Serial Number 195-763984

Purchase Date 8/12/2017

Purchase Price $475.00

Merchant ID 3
Online Purchase No
Credit Card Purchase Yes

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 13/19

Warranty Type Manufacturer
Warranty Length 1 year, parts and labor
Repair No
Repair Date (none)
Comments (none)

Item ID 10

Item Name Smart Phone

Category Electronics

Manufacturer EasyPhone

Model 17S

Serial Number 567-39QR4512

Purchase Date 1/30/2017

Purchase Price $799.00

Merchant ID 4
Online Purchase No
Credit Card Purchase Yes
Warranty Type Manufacturer

Warranty Length 1 year, parts only

Repair No
Repair Date (none)
Comments (none)

Item ID 11

Item Name Heart Pendant on Gold Chain

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 14/19

Category Jewelry

Manufacturer GoldPlus

Model n/a

Serial Number n/a

Purchase Date 2/11/2017

Purchase Price $599.00
Merchant ID 5
Online Purchase No
Credit Card Purchase Yes

Warranty Type n/a

Warranty Length n/a

Repair No
Repair Date (none)

Comments 24 karat gold, 18″ serpentine link chain

Item ID 12

Item Name Engagement Ring

Category Jewelry

Manufacturer Jewelserv

Model n/a
Serial Number n/a

Purchase Date 2/12/2017

Purchase Price $2,500.00

Merchant ID 5

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 15/19

Online Purchase No
Credit Card Purchase Yes
Warranty Type n/a
Warranty Length n/a
Repair No
Repair Date (none)

Comments Appraisal in safety deposit box

Item ID 13

Item Name Super Hero #1 Comic Book

Category Collectibles

Manufacturer Funny Publishing May 1976 (publisher)

Model n/a
Serial Number n/a

Purchase Date 5/25/2017

Purchase Price $39.00

Merchant ID 7
Online Purchase Yes
Credit Card Purchase Yes
Warranty Type n/a
Warranty Length n/a
Repair No
Repair Date (none)

Comments 9.4 Comic Book Grading

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 16/19

Item ID 14

Item Name Super Hero #6 Comic Book

Category Collectibles

Manufacturer Funny Publishing November 1976 (publisher)

Model n/a
Serial Number n/a
Purchase Date 5/25/2017

Purchase Price $67.00

Merchant ID 7
Online Purchase Yes
Credit Card Purchase Yes
Warranty Type n/a
Warranty Length n/a
Repair No
Repair Date (none)

Comments 9.2 Comic Book Grading

Query the Database

1. Create a select query that retrieves the Item Name, Purchase Date, Purchase Price, and Online
Purchase fields from the Inventory table for items purchased online.

a. Have the select query sort the results in chronological order by purchase date.
b. Be sure to format the Datasheet view so that all field names and data are displayed entirely.
c. Save the query, naming it “Online Purchases,” and then close the query.

2. Create a select query that retrieves the Merchant Name from the Merchants table and the Item
Name, Category, Manufacturer, and Purchase Date from the Inventory table for appliances.

a. Have the select query sort the results in alphabetical order by merchant name.
b. Be sure to format the Datasheet view so that all field names and data are displayed entirely.
c. Save the query, naming it “Appliance Purchases,” and then close the query.

Create Reports

1. Create a tabular report using the Online Purchases query.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 17/19

a. Sort the report data by purchase date.
b. Print Preview your report and adjust formatting as necessary, making sure all data are

displayed on one page, as shown in the figure.

c. Save the report, naming it “Online Purchases,” and then close the report.

2. Create a tabular report using the Appliance Purchases query.
a. Reduce field widths so that all fields are displayed in portrait orientation.
b. Move the Page 1 of 1 footer so that it’s centered below the report data.
c. Delete the record count and the summary line below the Merchant Name data.
d. Group the report data by merchant name.
e. Sort the report data by purchase date.
f. Print Preview your report and adjust formatting as necessary, making sure all data are

displayed on one page, as shown in the figure.

g. Save the report, naming it “Appliance Purchases,” and then close the report.

Scoring Guidelines

Rubric

SKILL/GRADING
CRITERIA

EXEMPLARY
(4)

PROFICIENT
(3)

FAIR
(2)

POOR
(1)

NOT
EVIDENT

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 18/19

(0)

Create tables Tables with
correct field
names and
types have
been created.

Tables with
mostly
correct field
names and
types have
been
created.

Tables
with some
correct
field
names
and types
have been
created.

Tables
without
correct
field
names
and/or
types have
been
created.

No
attempt
has been
made to
create
tables.

Create forms Forms
corresponding
to tables have
been created.

N/A N/A An attempt
has been
made to
create
forms, but
they don’t
correspond
to the
tables.

No
attempt
has been
made to
create
forms.

Perform data
entry

All the
designated
records have
been entered
with minimal
errors.

Most of the
designated
records have
been entered
with minimal
errors.

Some of
the
designated
records
have been
entered
with
minimal
errors.

Few of the
designated
records
have been
entered
with
minimal
errors.

No
attempt
has been
made to
perform
data
entry.

Create a select
query

A select query
with the
designated
fields and
correct criteria
has been
created.

A select
query with
correct
criteria and
some of the
designated
fields has
been
created.

A select
query with
correct
criteria
and few of
the
designated
fields has
been
created.

A select
query that
doesn’t
contain the
correct
criteria has
been
created.

No
attempt
has been
made to
create a
select
query.

Sort select
query results

A select query
with the
correct sort
for the
designated
field has been
created.

A select
query with
the correct
sort for the
wrong field
has been
created.

A select
query with
the wrong
sort has
been
created.

A filter has
been
applied to
query
results to
provide a
sort.

No
attempt
has been
made to
sort query
results.

Format
Datasheet view

All the field
names and
field data are
completely
displayed in
select query
Datasheet
view.

Some of the
field names
and field data
are
completely
displayed in
select query
Datasheet
view.

Few of the
field
names
and field
data are
completely
displayed
in select
query
Datasheet
view.

An attempt
has been
made to
format
Datasheet
view.

No
attempt to
format
Datasheet
view has
been
made.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-microsoft-access-2016/objectives/create-a-home-inventory-database-that-can-be-referred-to-in-of/r… 19/19

Create a report A formatted
report with
grouping and
sorting has
been created.

A report with
grouping and
sorting that’s
missing
formats has
been
created.

A
formatted
report with
missing
grouping
and
sorting has
been
created.

Minimal
effort has
been made
to group,
sort, and
format a
report.

No
attempt to
create a
report has
been
made.

Submission Checklist

Before submitting your project, make sure you’ve correctly completed the following steps:

Create, save, and name an Access database.
Create tables with appropriate field names and corresponding data types.
Create formatted forms that correspond to tables.
Use forms to populate a database with records.
Create a select query using fields from one table.
Create a select query using fields from multiple related tables.
Designate query criteria for select query results.
Designate a sort order for select query results.
Format select query Datasheet view to completely display field names and field data.
Create a report.
Sort and group a report.
Edit a report format.

2/25/2020lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 1/8

Instructions
Follow the instructions below to complete your presentation.

Create the Presentation Outline

2 people liked this 0 discussions

Graded Project: Integrating Word, Excel, and Other Data
into PowerPoint

READING ASSIGNMENT
You’ll upload five files for this graded project:

1. Project Outline x
2. Homelessness Statistics.xlsx
3. Impoverished Hungry x
4. Sociology Project.pptx
5. Sociology Project.mp4

Your project must be submitted as a Word document ( x, )*. 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 (######00)
Your email address

Note: If you have more than 10 attachments, you’ll need to WinZip all of the project’s associated files along with all
documentation using the WinZip software program.

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!

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 2/8

1. Start Word and create a new blank document.

2. Display the document in Outline view and type the outline shown in the figure, being sure to place

topics at the indicated level.
3. Save the document, naming it Project Outline.
4. Close the document.

Create a Spreadsheet and a Chart

1. Start Excel and create a new blank workbook.
2. Enter data as shown in the figure.
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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 3/8

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 in the figure. 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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 4/8

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.

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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 5/8

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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 6/8

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

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 7/8

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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-excel-and-other-data-into-powerpoint/objectives/create-a-presentation-for-a-sociolog… 8/8

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.

2/25/2020lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 1/10

Instructions

Create the Clients Database

1. Start Access and create a new Blank database named “Clients.”
2. Name the new table “Clients,” and then display it in Design view.
3. Edit the ID field to be Client ID. 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

Company Name Short Text

First Name Short Text

Last Name Short Text

Job Title Short Text

Address Short Text

City Short Text

0 people liked this 0 discussions

Graded Project: Integrating Word, Excel, and Access
2016

READING ASSIGNMENT
Your project must be submitted as a Word document ( x, )*. 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 (######00)
Your email address

Note: If you have more than 10 attachments, you’ll need to WinZip all of the project’s associated files along with all
documentation using the WinZip software program.

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!

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 2/10

State Short Text

Zip Short Text

5. Save and then close the Clients table.
6. Create a Clients form that looks similar to the figure below.

7. Use the Clients form to populate the Clients table with the records listed below.

Client Records

Client ID 1

Company Name Martinez Development Company

First Name Chris

Last Name Martinez

Job Title President

Address 160 Egret Way

City Any Town

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 3/10

State FL

Zip 33441

Client ID 2

Company Name General Construction

First Name Tom

Last Name Lewis

Job Title Manager

Address 1336 Ocean Parkway

City Any Town

State FL

Zip 33442

Client ID 3

Company Name Ace Contractors

First Name Terrell

Last Name Jackson

Job Title Operator

Address 14998 Atlantic Ave.

City Any Town
State FL

Zip 33434

Client ID 4

Company Name Major Paving Company

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 4/10

First Name Avery

Last Name Collins

Job Title President

Address 2201 Congress Road

City Any Town
State FL
Zip 33441

Client ID 5

Company Name Best Builders

First Name Pat

Last Name Rivera

Job Title Owner

Address 1 Builder Way

City Any Town
State FL

Zip 33443

8. Close the Clients database.

Create a Letterhead

1. Start Word and create a new Blank document.
2. Type “ABC Engineering Company” and then press Enter.
3. Type “1552 Carbondale Road” and then insert a bullet character.
4. Type “Any Town, FL 33334” and then press Enter.
5. Format the first line of the letterhead as Verdana 16-point bold and center the paragraph.
6. Format the second line of the letterhead as Verdana 12-point italic and center the paragraph.
7. Format the last, blank paragraph as Times New Roman 12-point with No Spacing paragraph style.

Your letterhead should look similar to the figure.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 5/10

8. Save the document, naming it “Letterhead.”

Create the Estimates Letter

1. With the insertion point in the blank paragraph below the letterhead, type the text shown in the
figure below, inserting merge fields where indicated.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 6/10

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 7/10

2. On the File tab, click Save As and then save the document with the name “Estimates.”

Embed an Excel Worksheet Object

1. With the insertion point in the second blank paragraph after “. . . costs for three scenarios:”, insert
an Excel worksheet object to embed a new spreadsheet.

2. Enter data as shown in the figure below. Center and bold column labels and format Site data to
display commas with 0 decimal places.

3. Format cells C3 through F4 as Currency with 0 decimal places.
4. Enter formulas in column C to calculate Equipment costs as 15 times the site size.
5. Enter formulas in column D to calculate the Labor costs as 10 times the site size.
6. Enter formulas in column E to calculate the Overhead and Profit (O & P) as 0.25 times the sum of

equipment and labor costs.
7. Use a function in a formula to calculate the total costs in column F for each scenario.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 8/10

8. Size the worksheet object so just the cells with data are displayed, as shown in the figure.

Merge Field Data

1. Use the appropriate command to merge the field data and create a document containing the
individual letters.

2. Save the merged document, naming it “Merged Estimates.” Your first letter should look similar to
the figure below.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-in… 9/10

Scoring Guidelines

Rubric

Skill/Grading
Criteria

Exemplary
(4)

Proficient
(3)

Fair
(2)

Poor
(1)

Not
Evident

(0)

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.

Create a
letterhead

Letterhead
text has
been
formatted
as specified
and
includes a
special
character.

Letterhead
text has
most
specified
formats
applied and
includes a
special
character.

Some
letterhead
formats
have been
applied with
or without a
special
character.

Text has
been
entered
without any
formats or
special
character.

No attempt
has been
made to
create the
letterhead.

Type
document

text

The
specified
letter has
been
correctly
typed with
correct
spacing.

The
specified
letter has
been typed
with few
mistakes.

The
specified
letter has
been typed
with many
mistakes.

The
specified
letter has
been typed
with
numerous
mistakes
and
incorrect
spacing.

No attempt
to type the
letter has
been made.

Insert merge
cells

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
contains
few merge
fields.

The letter
contains
text in place
of the
merge
fields.

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

Create an
embedded

spreadsheet
object

A new
spreadsheet
object with
correct
formatting
and
formulas
has been
embedded
in the letter.

A new
spreadsheet
object with
mostly
correct
formatting
and
formulas
has been
embedded
in the letter.

A new
spreadsheet
object with
incorrect or
no data has
been
embedded
in the letter.

A
spreadsheet
with correct
formatting
and
formulas
has been
created and
then linked
to the letter.

No attempt
to create a
new
spreadsheet
object has
been made.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-integrating-word-access-and-excel/objectives/construct-a-mail-merge-to-send-the-same-company-i… 10/10

Merge field
data

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.

Submission Checklist
Before submitting your project, make sure you’ve correctly completed the following:

Create a database with a table and a corresponding form.
Populate a database table by using a form.
Type and format text in a Word document.
Apply Word styles.
Use the Save As command on the File tab.
Perform the mail merge process by selecting an existing database as the data source.
Insert merge fields in a Word letter.
Insert a new Excel worksheet object in a Word document.
Enter and format worksheet cell data.
Create formulas to calculate values in a worksheet.
Create formulas that use functions to calculate values in a worksheet.
Size a worksheet object to display only specified cells.
Merge field data with actual data to create individual letters.

2/25/2020lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 1/14

Retailers Database
Follow the steps below to create the Retailers database.

Click to download the files you’ll need to complete this graded project.

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.

0 people liked this

0 discussions

Graded Project: Advanced PC Applications

READING ASSIGNMENT
Your project must be submitted as a Word document ( x, )*. 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 (######00)
Your email address

Note: If you have more than 10 attachments, you’ll need to WinZip all of the project’s associated files along with all
documentation using the WinZip software program.

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!

http://lessons.pennfoster.com/pdf/584808_Practice%20Files.zip

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 2/14

6. Create a new table named “Sales Reps” and then 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 corresponding data types:

Field Name Data Type

First Name Short Text

Last Name Short Text

Job Title Short Text

10. Save and then close the Sales Reps table.
11. Create a Retailers form that looks similar to the figure

below.

12. Create a Sales Reps form that looks similar to the figure.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 3/14

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

Retailer ID 2

Store Name Everything Bait Shop

Address 1336 Ocean Parkway

City Any Town

State PA

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 4/14

Zip 16755

Retailer ID 3

Store Name Major Sporting Goods

Address 14998 Atlantic Ave.

City Any Town
State PA

Zip 16759

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

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

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 5/14

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

Sales Rep ID 5

Retailer ID 3

First Name Turner

Last Name Ward

Job Title Store Manager

15. Format Table Datasheet view for the Retailers and Sales Reps table, adjusting column widths as
appropriate.

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

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 6/14

17. Run the query and save it as Contacts.
18. Close the query and any open tables and forms.
19. Close the Retailers database.

Hook Results Spreadsheet
Follow the steps below to create the Hook Results spreadsheet.

1. Start Excel and create a new blank workbook.
2. Enter data as shown in the figure below.

a. Merge and center titles as shown.
b. Format cell titles and labels as bold where indicated.
c. Display borders around all the cells with data.
d. Change the spreadsheet orientation to landscape to accommodate the wide columns on one

sheet of paper.

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

4. Format the % Caught with Table values as a percent with one decimal place.
5. Insert a Column Chart of type 2-D Clustered Column that charts data in cells A4 through E6.
6. Change the title to Fish Caught by Hook Brand.
7. Change the Chart Style to Style 11, so that your chart looks similar to the figure.

8. Be sure the chart is sized appropriately and positioned under the data.
9. Save the workbook, naming it “Hook Results.”

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 7/14

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.

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 in the figure 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.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 8/14

10. Be sure that you’ve formatted the indicated text 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.

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

12. Save the document, naming it “Lodge Lunch.”
13. Use the appropriate command to merge the field data and create a document containing the

individual letters.
14. Scroll through the letters and be sure 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.

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

Event Presentation
Follow the steps below to create the Event Presentation.

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 text so that your slide looks similar to the figure

below.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-to/… 9/14

4. Add a new slide with a Content with Caption layout (slide 2) and then insert the Table Hook
picture, a data file for this Graded Project. Add text and size the image so that slide 2 looks similar
to the figure.

5. Add a new slide with a Title and Content layout (slide 3) and add text as shown in the figure.

6. Add a new slide with a Title and Content layout (slide 4) and add text as shown in the figure below.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-t… 10/14

7. Add a new slide with a Title and Content layout (slide 5). Edit the title and paste the chart from the
Hook Results spreadsheet so that the slide looks similar to the figure below.

8. Add a new slide with a Title and Content layout (slide 6) and add content so that the slide looks
similar to the figure. Refer to the Hook Results spreadsheet to get the figure for the first bullet (Hint:
The average should be about 35 percent). Insert an online picture of the same trout (if possible)
used in the Lodge Letter.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-t… 11/14

9. Apply the Wind transition to all the slides.
10. Apply the Wipe animation to each of the bullet items on slides 3, 4, and 6.
11. Save the presentation, naming it “Sales Presentation,” 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)

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

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

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

A query has
been created
with only one
table.

No attempt
has been
made to
create the
query.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-t… 12/14

defined
relationship.

defined
relationship.
defined
relationship.

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

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 file
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 layout

A
presentation
in the
specified
theme with
some of the
slides in the
correct layout

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

No attempt
has been
made to
create a
presentation.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-t… 13/14

has been
created.
has been
created.

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.

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
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.
Edit a chart title.

2/25/2020 lms.pennfoster.edu | HSE754: Advanced PC Applications

https://lms.pennfoster.edu/nodes/graded-project-advanced-pc-applications/objectives/prepare-for-a-promotional-event-to-introduce-a-new-product-t… 14/14

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.