Fill This Form To Receive Instant Help
Homework answers / question archive / New Perspectives Word 2016 | Modules 5–7: SAM Capstone Project 1a Addams Opera Company COMPLETING A REPORT AND PERFORMING A MAIL MERGE GETTING STARTED ? Open the file NP_WD16_CS5-7a_ FirstLastName _1
New Perspectives Word 2016 | Modules 5–7: SAM Capstone Project 1a
Addams Opera Company
COMPLETING A REPORT AND PERFORMING A MAIL MERGE
GETTING STARTED
?
Open the file
NP_WD16_CS5-7a_
FirstLastName
_1.docx
, available for
download from the SAM website.
?
Save the file as
NP_WD16_CS5-7a_
FirstLastName
_2.docx
by changing the
“1” to a “2”.
o
If you do not see the
.docx
file extension
in the Save As dialog box, do not
type it. The program will add the file extension for you automatically.
?
To complete this Project, you will also need to download and save the following
support files from the SAM website:
o
Support_NP_WD16_CS5-7a_Audience.xlsx
o
Support_NP_WD16_CS5-7a_Revenue.xlsx
o
Support_NP_WD16_CS5-7a_Notice.docx
?
With the file
NP_WD16_CS5-7a_
FirstLastName
_2.docx
still open, ensure that
your first and last name are displayed in the footer.
o
If the footer does not display your name, delete the file and download a
new copy from the SAM website.
PROJECT STEPS
1
You are creating a form letter with an enclosed report to send to members of the
Addams Opera Company Foundation, an organization supporting opera in
Providence, Rhode Island.
To add interest to the document, apply the
Lines (Simple)
style set, which
formats headings using an underline.
1.
In the first body paragraph of the letter, in the sentence beginning “Your
continuing support...” and ending “...eastern New England.”, use the Thesaurus
to replace the word “fineness” with a synonym that starts with the letter “e”.
2.
Format the list of Board of Directors members and their roles (beginning
“Jonathan Colucci” and ending “Member at large”) by setting a left tab stop at
2.5"
using the
4____
solid line leader option to make the list easier to read.
3.
On page 3, accept or reject the tracked changes as follows:
a.
In
the
first paragraph after the heading “Strategic Highlights”, accept the
change.
b.
In the bulleted item beginning “La Boheme”, reject the change.
c.
Accept the remaining changes in the document.
4.
Turn on Track Changes and display
All Markup
for review. On page 4, apply the
Heading 1
style to the heading “Financial Highlights”.
5.
On page 4, after the “Addams Opera Company” heading, apply
italic
to the
three paragraphs containing the name “Ryan Edwards”, Ryan’s position and
title, and the organization’s web address.
6.
Turn off Track Changes. Read the first comment in the document, and then
continue editing as follows:
a.
Use
Microsoft
Excel to open the workbook
Support_NP_WD16_CS5-
7a_Audience.xlsx
, available for download from the SAM website.
b.
In the New Patrons worksheet,
copy cells A2:B6
.
c.
Return to the file
NP_WD16_CS5-7a_
FirstLastName
_2.docx
, and then
move the insertion point to where Ryan’s comment instructs you to insert
the audience data.
d.
Use the Paste Special feature to embed the worksheet selection in the
Word document as a
Microsoft Excel Worksheet Object
because the
data in the source file is unlikely to change.
e.
Modify the embedded worksheet by changing the number in cell B5 to
13,000
to use accurate data.
7.
Read the next comment in the document, and then continue editing as follows:
a.
Use Microsoft Excel to open the workbook
Support_NP_WD16_CS5-
7a_Revenue.xlsx
, available for download from the SAM website.
b.
In the Operating Revenues worksheet,
copy the 3-D pie chart
.
c.
Return to the file
NP_WD16_CS5-7a_
FirstLastName
_2.docx
, and then
move the insertion point to where Ryan’s comment instructs you to insert
the chart.
d.
Link the chart to the document using the destination theme because the
data in the source file is likely to change.
8.
Delete all of the comments in the document because they are no longer
needed, and then display
No Markup
for review.
9.
Create and apply a new style as follows to draw attention to text:
a.
On page 4, apply the font color
Lavender, Accent 4, Darker 50%
(8
th
column, 6
th
row of the Theme Colors palette) to the “Special Programs”
heading.
b.
Change the character spacing of the “Special Programs” heading to
Expanded
by
1.5 pt.
c.
Save the formatting of the “Special Programs” heading as a new style
using
Notes
as the name.
d.
Apply the new
Notes
style to the “Addams Opera Company” heading.
2
On page 4, convert the four paragraphs describing the educational efforts
(beginning “Adult programs” and ending “15,400”) to a table with two columns
by separating the text at each tab.
10.
Insert a new header row at the beginning of the table, and then enter the text
shown in bold in Table 1 below.
Table 1: Header Row
Educational Program
2018
11.
Insert a column to the left of the “2018” column, and then enter the text shown
in bold in Table 2 below.
Table 2: New Column
Header row
2017
Row 2
2
Row 3
3
Row 4
6
Row 5
10,000
12.
Format the header row using
bold
for the text and
Lavender, Accent 4,
Lighter 60%
(8
th
column, 3
rd
row of the Theme Colors palette) for the shading.
13.
In the paragraph after the
table
, format the word “Notice” as a hyperlink that
targets the document
Support_NP_WD16_CS5-7a_Notice.docx
, available for
download from the SAM website.
14.
At the beginning of page 4, select the first word in the paragraph before the
chart (“The”), and then insert a bookmark using
Revenue
as the name.
15.
In the second paragraph on page 1, in the sentence beginning “As shown in...”
and ending “...endowment support.”, format the text “chart” as a hyperlink
linked to the “Revenue” bookmark.
16.
On page 2, move the insertion point to the blank paragraph before the page
break
, and then insert a table of contents as follows:
a.
Insert a custom table of contents.
b.
In the Table of Contents Options dialog box, change the TOC level of the
Notes style to
2
.
c.
In the Table of Contents Options dialog box and Table of Contents tab,
accept all other defaults, and then finish inserting the table of contents in
the document.
17.
On page 1, start a mail merge, and then select
Letters
as the type of main
document. Next, type a new recipient list as follows:
a.
Customize the columns by deleting the
Company Name
,
Country or
Region
, and
Work Phone
fields.
b.
After the
E-mail Address
field, add a new field using
Production
as the
name.
c.
Enter the recipient information shown in bold in Table 3 below.
d.
Save the data source using a name of your choice.
Table 3: Recipient Information
Title
Ms.
First Name
Emma
Last Name
Vogel
Address Line 1
1190 Pine Street
Address Line 2
Apt. 202
City
Providence
State
RI
ZIP Code
02904
Home Phone
(401) 555-1227
Email Address
vogel@mail.cengage.ne
t
Production
La Traviata
18.
At the beginning of the letter, delete “[INSIDE ADDRESS]”, but not the
paragraph mark, and then insert the eight merge fields shown in Figure 1 on the
next page. Include the paragraph marks, punctuation, and spaces between the
merge fields as shown.
Figure 1: Merge Fields for the Inside Address
19.
In the greeting line, delete “[TITLE]”, and then insert the Title merge field. Next,
delete “[LAST NAME]”, and then insert the Last_Name merge field.
20.
In the paragraph after the greeting line, delete “[PRODUCTION]”, and then
insert the Production merge field.
21.
In the paragraph that begins “You will soon...”, delete “[EMAIL ADDRESS]”, and
then insert the Email_Address merge field.
22.
Complete the mail merge as instructed in the lettered steps below. You will
merge to a new document and then copy the contents of the merged file to the
bottom of your original document, so that all of your assignment appears in the
same file.
a.
Finish and merge all records to a new document.
b.
In the new document
Letters1.docx
, which contains the merged form
letter, press
CTRL+A
to select all contents in the document, and then
copy the merged form letter to the Office Clipboard.
c.
In the file
NP_WD16_CS5-7a_
FirstLastName
_2.docx
, move the
insertion point to the blank paragraph at the end of the document, insert
a page break, and then paste the merged form letter into the main
document.
d.
To remove the extra blank page at the end of your main document, delete
the section break. Verify that the pasted merged form letter appears on
pages 5–8 of the file
NP_WD16_CS5-7a_
FirstLastName
_2.docx
, and
then turn off the preview of the mail merge results if the preview is on.
Close the new, merged document without saving it.
Your document should look like the Final Figure on the following pages. Save your
changes, close the document, and then exit Word. Follow the directions on the SAM
website to submit your completed project.
Note: When opening your Graded Summary report for this Project, you may be prompted
to Select From “Office Address List”. Select
No
in the dialog box to view your report.
Already member? Sign In