This activity requires students to submit a project that they have completed in the live Office 2013 environment. Students must download the starting files available below, and then follow the instructional steps to finish the project. Students must then upload the project file for automatic grading. Detailed feedback and grades on the submitted project are then made available via the myitlab gradebook and submission report screen.

Word Chapter 3 GRADER PROJECT – 25 points –

due today at 11:59 p,m

 

after 3 hours from now.

 

through this website: http://www.pearsonmylabandmastering.com/northamerica/myitlab/

Attachments:

Click here to place an order  for a similar  paper  and have exceptional work done by our team and get A+results

June 1, 2016

[Address Block]

Dear [FirstName],

It is my pleasure to welcome you to the Sports Medicine Clinicof Conwaywhere 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!

Click here to place an order  for a similar  paper  and have exceptional work done by our team and get A+results

Attachments:

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	Instructions	Points Possible
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
10	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
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	100.000

Click here to place an order  for a similar  paper  and have exceptional work done by our team and get A+results

Attachments:

First Name	Last Name	Credentials	Street Address	City	State	Zip	Days Working	Salary
Justin	Ebert	M.S., ATC	34234 S. Callie Place	Conway	AR	72032	Monday-Friday	$68,000
Karen	Rakowski	ATC, PT	98234 E. Shepherd Lane	Conway	AR	72032	Monday-Friday	$65,000
Mike	Salat	M.S., ATC	2342 W. Cardinal Street	Conway	AR	72032	Monday-Thursday	$65,000

Click here to place an order  for a similar  paper  and have exceptional work done by our team and get A+results