1.W_CH03_EXPV1_H1_Instructions.docx2.w03_grader_h1_datasource.docx 3.exploring_w03_grader_h1.docxOffice 2013 – myitlab:grader – Instructions
Exploring – Word Chapter 3: Homework Project 1
Sports Medicine Clinic
Project Description:
In the following project, you will revise a table that is to be used as a data source in a mail merge. As the
business manager for Sports Medicine Clinic, you will send letters of welcome to three newly hired physical
therapists. The letters will be combined with a data source to produce letters that can be sent to the new
employees.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Download and open the file named exploring_w03_grader_h1.docx.
0.000
2
Split column 1 of the table into two columns, placing the first name in the first column and the
last name in the next. Cell 1 of row 1 should include the text First Name, and cell 2 of row 1
should include Last Name. (Hint: Uncheck the option to Merge cells before split.)
9.000
3
Insert three columns after the Street Address column, for City, State, and Zip, from left to
right, typing the column headings in the first row of the new column.
8.000
4
Populate each cell in the City column with Conway. Each cell in the State column should
contain AR, and each cell in the Zip column should include 72032.
7.000
5
Create a new row at the end of the table. Type the word Average in the eighth cell on the
last row.
7.000
6
Insert a new row at the top of the table, merge cells in the new row, and type New
Employees. Align Center the text in the new row.
8.000
7
Create a formula in the last cell on the last row to average the Salary column. (Hint: In the
Formula dialog box, remove the suggested function, but leave the =, and paste an Average
function, indicating that the average should include the numbers Above.) Format the average
as $#,##0.00;($#,##0.00), which is different from the entries in the column above.
9.000
8
Apply a table style of Grid Table 6 Colorful – Accent 6 (sixth row, seventh column under Grid
Tables). Bold all entries in row 2, and remove bold from each employee’s first name in column
1 of rows 3, 4, and 5.
8.000
9
Select a pen color of Green, Accent 6, and a double line style (seventh selection under Line
Style). Brush the border dividing the first row from the second, so that the border displays as
a double line, and press ESC.
8.000
Click the Border Styles arrow and select Border Sampler. Click to sample the new border
dividing the first and second rows, and brush it along the bottom border of the table. Press
ESC.
8.000
10
Updated: 04/30/2013
1
W_CH03_EXPV1_H1_Instructions.docx
Office 2013 – myitlab:grader – Instructions
Step
Exploring – Word Chapter 3: Homework Project 1
Points
Possible
Instructions
11
Sort the data in the table (but do not include the header or total rows) by Last Name in
ascending order.
7.000
12
Start a Mail Merge using the Step-by-Step Mail Merge Wizard. You will use the current letter as
the starting document. The recipient information is derived from
w03_grader_h1_datasource.docx.
7.000
13
Replace the bracketed placeholders in the letter, Address Block, FirstName, and DaysWorking,
with fields from the data source. Use default settings for the Address block.
7.000
14
Complete the merge, merging all records with the data source, resulting in three letters. Save
the merged letters as exploring_w03_grader_h1_end.
7.000
15
Close exploring_w03_grader_h1_end.docx. Close exploring_w03_grader_h1.docx without
saving it. Exit Word. Submit exploring_w03_grader_h1_end.docx as directed.
0.000
Total Score
Updated: 04/30/2013
2
100.000
W_CH03_EXPV1_H1_Instructions.docx
Office 2013 – myitlab:grader – Instructions
Exploring – Word Chapter 3: Homework Project 1
Sports Medicine Clinic
Project Description:
In the following project, you will revise a table that is to be used as a data source in a mail merge. As the
business manager for Sports Medicine Clinic, you will send letters of welcome to three newly hired physical
therapists. The letters will be combined with a data source to produce letters that can be sent to the new
employees.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Download and open the file named exploring_w03_grader_h1.docx.
0.000
2
Split column 1 of the table into two columns, placing the first name in the first column and the
last name in the next. Cell 1 of row 1 should include the text First Name, and cell 2 of row 1
should include Last Name. (Hint: Uncheck the option to Merge cells before split.)
9.000
3
Insert three columns after the Street Address column, for City, State, and Zip, from left to
right, typing the column headings in the first row of the new column.
8.000
4
Populate each cell in the City column with Conway. Each cell in the State column should
contain AR, and each cell in the Zip column should include 72032.
7.000
5
Create a new row at the end of the table. Type the word Average in the eighth cell on the
last row.
7.000
6
Insert a new row at the top of the table, merge cells in the new row, and type New
Employees. Align Center the text in the new row.
8.000
7
Create a formula in the last cell on the last row to average the Salary column. (Hint: In the
Formula dialog box, remove the suggested function, but leave the =, and paste an Average
function, indicating that the average should include the numbers Above.) Format the average
as $#,##0.00;($#,##0.00), which is different from the entries in the column above.
9.000
8
Apply a table style of Grid Table 6 Colorful – Accent 6 (sixth row, seventh column under Grid
Tables). Bold all entries in row 2, and remove bold from each employee’s first name in column
1 of rows 3, 4, and 5.
8.000
9
Select a pen color of Green, Accent 6, and a double line style (seventh selection under Line
Style). Brush the border dividing the first row from the second, so that the border displays as
a double line, and press ESC.
8.000
Click the Border Styles arrow and select Border Sampler. Click to sample the new border
dividing the first and second rows, and brush it along the bottom border of the table. Press
ESC.
8.000
10
Updated: 04/30/2013
1
W_CH03_EXPV1_H1_Instructions.docx
Office 2013 – myitlab:grader – Instructions
Step
Exploring – Word Chapter 3: Homework Project 1
Points
Possible
Instructions
11
Sort the data in the table (but do not include the header or total rows) by Last Name in
ascending order.
7.000
12
Start a Mail Merge using the Step-by-Step Mail Merge Wizard. You will use the current letter as
the starting document. The recipient information is derived from
w03_grader_h1_datasource.docx.
7.000
13
Replace the bracketed placeholders in the letter, Address Block, FirstName, and DaysWorking,
with fields from the data source. Use default settings for the Address block.
7.000
14
Complete the merge, merging all records with the data source, resulting in three letters. Save
the merged letters as exploring_w03_grader_h1_end.
7.000
15
Close exploring_w03_grader_h1_end.docx. Close exploring_w03_grader_h1.docx without
saving it. Exit Word. Submit exploring_w03_grader_h1_end.docx as directed.
0.000
Total Score
Updated: 04/30/2013
2
100.000
W_CH03_EXPV1_H1_Instructions.docx
Office 2013 – myitlab:grader – Instructions
Exploring – Word Chapter 3: Homework Project 1
Sports Medicine Clinic
Project Description:
In the following project, you will revise a table that is to be used as a data source in a mail merge. As the
business manager for Sports Medicine Clinic, you will send letters of welcome to three newly hired physical
therapists. The letters will be combined with a data source to produce letters that can be sent to the new
employees.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Download and open the file named exploring_w03_grader_h1.docx.
0.000
2
Split column 1 of the table into two columns, placing the first name in the first column and the
last name in the next. Cell 1 of row 1 should include the text First Name, and cell 2 of row 1
should include Last Name. (Hint: Uncheck the option to Merge cells before split.)
9.000
3
Insert three columns after the Street Address column, for City, State, and Zip, from left to
right, typing the column headings in the first row of the new column.
8.000
4
Populate each cell in the City column with Conway. Each cell in the State column should
contain AR, and each cell in the Zip column should include 72032.
7.000
5
Create a new row at the end of the table. Type the word Average in the eighth cell on the
last row.
7.000
6
Insert a new row at the top of the table, merge cells in the new row, and type New
Employees. Align Center the text in the new row.
8.000
7
Create a formula in the last cell on the last row to average the Salary column. (Hint: In the
Formula dialog box, remove the suggested function, but leave the =, and paste an Average
function, indicating that the average should include the numbers Above.) Format the average
as $#,##0.00;($#,##0.00), which is different from the entries in the column above.
9.000
8
Apply a table style of Grid Table 6 Colorful – Accent 6 (sixth row, seventh column under Grid
Tables). Bold all entries in row 2, and remove bold from each employee’s first name in column
1 of rows 3, 4, and 5.
8.000
9
Select a pen color of Green, Accent 6, and a double line style (seventh selection under Line
Style). Brush the border dividing the first row from the second, so that the border displays as
a double line, and press ESC.
8.000
Click the Border Styles arrow and select Border Sampler. Click to sample the new border
dividing the first and second rows, and brush it along the bottom border of the table. Press
ESC.
8.000
10
Updated: 04/30/2013
1
W_CH03_EXPV1_H1_Instructions.docx
Office 2013 – myitlab:grader – Instructions
Step
Exploring – Word Chapter 3: Homework Project 1
Points
Possible
Instructions
11
Sort the data in the table (but do not include the header or total rows) by Last Name in
ascending order.
7.000
12
Start a Mail Merge using the Step-by-Step Mail Merge Wizard. You will use the current letter as
the starting document. The recipient information is derived from
w03_grader_h1_datasource.docx.
7.000
13
Replace the bracketed placeholders in the letter, Address Block, FirstName, and DaysWorking,
with fields from the data source. Use default settings for the Address block.
7.000
14
Complete the merge, merging all records with the data source, resulting in three letters. Save
the merged letters as exploring_w03_grader_h1_end.
7.000
15
Close exploring_w03_grader_h1_end.docx. Close exploring_w03_grader_h1.docx without
saving it. Exit Word. Submit exploring_w03_grader_h1_end.docx as directed.
0.000
Total Score
Updated: 04/30/2013
2
100.000
W_CH03_EXPV1_H1_Instructions.docx
First
Name
Justin
Last
Name
Ebert
Credentials
Karen
Rakowski
ATC, PT
Mike
Salat
M.S., ATC
M.S., ATC
Street
Address
34234 S.
Callie
Place
98234 E.
Shepherd
Lane
2342 W.
Cardinal
Street
City
State
Zip
Days
Working
MondayFriday
Salary
Conway
AR
72032
$68,000
Conway
AR
72032
MondayFriday
$65,000
Conway
AR
72032
MondayThursday
$65,000
June 1, 2016
[Address Block]
Dear [FirstName],
It is my pleasure to welcome you to the Sports Medicine Clinic of Conway where we offer the
finest care to athletes and active people in the central region of Arkansas. Our reputation is
built on the experience and training of highly skilled Physical Therapists and Athletic trainers
like you. As you can see from the following table, you are in good company.
Name
Credentials
Street Address
Days Working
Salary
Mike Salat
M.S., ATC
2342 W. Cardinal
Street
Monday-Thursday
$65,000
Justin Ebert
M.S., ATC
34234 S. Callie
Place
Monday-Friday
$68,000
Karen Rakowski
ATC, PT
98234 E. Shepherd
Lane
Monday-Friday
$65,000
The demand for our services has exceeded our abilities in the past year, so our administration
has gladly invested an average salary of $66,000 in the clinic so that we can hire the best
Physical Therapists around. We are eager to see you in the clinic [DaysWorking] to work with
patients and consult with doctors.
If you have any questions about the employment resources available at the Sports Medicine
Clinic, please don’t hesitate to ask. Again, we look forward to seeing you in three weeks!
Sports Medicine Clinic of Conway
2349 W. Main Street
Conway, AR 72032
(987) 555-9654

Purchase answer to see full
attachment




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.