Weather Statistics
Project Description:
In the following project, you will modify a document prepared for publication in one or more journals related to weather statistics in the United States. Climate change, or global warming, is suspected by some to be a factor in the change in injuries and fatalities related to natural disasters and weather trends. The document and related table will be combined with a data source in a mail merge operation to send to selected journal editors.
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_a1.docx. | 0.000 |
| 2 | Insert a column at the right of the 10-Year Average column in the table. Add the following data in the new column, beginning in row 2:
64 |
6.000 |
| 3 | Type 30-Year Average in the fourth cell on row 1. Insert a new row at the top of the table, merge cells in the new row, and type U.S. Natural Disaster Statistics. Format the first row with Align Center alignment. | 8.000 |
| 4 | Align Center all entries in the second, third, and fourth columns from row 2 through the last row in the table. | 7.000 |
| 5 | Delete the Winter row. | 6.000 |
| 6 | Add a row below the last row in the table. Type Total in the first cell of the new row. Insert a formula in the second, third, and fourth columns of the new row to total all values above. | 9.000 |
| 7 | Apply Grid Table 5 Dark – Accent 5 table style to the table (fifth row, sixth column under Grid Tables). Select the table. Select a pen color of Blue, Accent 5, Darker 50%. Apply the color to Outside Borders. | 9.000 |
| 8 | Bold all entries in row 2. Shade row 2 with Blue-Gray, Text 2, Lighter 40%. | 7.000 |
| 9 | Select row 2 and apply a Single solid line, 1 1/2 pt., Accent 1 (second row, second column under Theme Borders) border style to the outside borders of the selected row. | 8.000 |
| 10 | Change the format of the formula in the second cell of the last row (total for Year 2015) to #,##0. | 7.000 |
| 11 | Start a Mail Merge using the Step-by-Step Mail Merge Wizard. The document type is Letters and you will use the Current document. Use Sheet1 of w03_grader_a1_datasource.xlsx as the data source. Sort the recipients by State in ascending order. | 12.000 |
| 12 | Replace the bracketed Address Block with the Address block field, using the default settings. Replace the bracketed Journal Name with data from the Journal Name field. Preview the letters. | 8.000 |
| 13 | Adjust the address block so that it is single spaced with no spacing before or after paragraphs. Format the journal name in the last line of the document in italics. | 7.000 |
| 14 | Complete the merge, merging all records. | 6.000 |
| 15 | Save the merged document as exploring_w03_grader_a1_end.docx and close the document. Close exploring_w03_grader_a1.docx without saving the document. Exit Word. Submit exploring_w03_grader_a1_end.docx as directed. | 0.000 |
| Total Score | 100.000 |
