Exp19_Word_Intro_CapAssessment_Research
Project Description:
As you near graduation from college, you plan to apply to various graduate schools. You have prepared a draft of a statement of purpose that you will include in an application packet to each university to which you apply. You modify the statement of purpose so that it is attractive and error free. In addition, you include such items as a table, picture, header, footer, and footnote, formatting text in columns where appropriate. Finally, you use mail merge to prepare personalized copies.
Steps to Perform:
StepInstructionsPoints Possible
1Start Word. Download and open the file named Exp19_Word_AppCapstone_IntroAssessment_Research.docx. Grader has automatically added your last name to the beginning of the filename.0
2Apply the Slice document theme. Select all text in the document, and change the font to Bookman Old Style. Change the font size to 12. Adjust the right and left margins to 1.5".9
3Insert a header (select Edit Header). Type Adams in the left section of the header. Insert a right-aligned page number, selecting Plain Number. Close the header.0
4Insert a manual page break before the second paragraph on the second page, beginning with On behalf of the faculty and staff.2
5Select all text that displays before the newly inserted page break and double-space the selected text. Remove any paragraph spacing from the selected text.6
6Move to the beginning of the document and press ENTER. Remove the First line indent from the newly inserted blank paragraph. At the new paragraph, type Statement of Purpose and apply bold formatting to the title. Center the title.6
7A footnote enables you to clarify or expound on a statement in the body of the document without cluttering the document with more text. Unlike a footer, a footnote only displays on the page in which it is cited.
In the second paragraph on the first page, place the insertion point after the period at the end of the sentence that ends with by the University of Arizona. Insert a footnote that reads The Three Minute Thesis Competition is open to all academic disciplines at the university. (include the period).6
8Modify the Footnote style, changing the font to Bookman Old Style and the font size to 12.5
9Change the word sophomore in the first sentence on the first page to student.2
10Insert a footer (select Edit Footer) and type 2022 Fall in the footer space. Change the footer font to Bookman Old Style and change the footer font size to 12. Close the footer.0
11Newsletters are often formatted in columns, as is the one that is included in this document. By using section breaks, you can format each section independently of others.
Select all text on pages 4 and 5 and format it in two columns. Insert a Continuous section break before the words On behalf of the faculty and staff at the top of the fourth page.5
12Click before the newly inserted section break at the top of the fourth page and change the column setting to One. Type Welcome to the College of Business and press ENTER twice. Select Welcome to the College of Business and apply the Title style. Reduce the font size to 22. Center the newsletter title.7
13Add a bottom border with a weight of 1 1/2 to the text Welcome to the College of Business.4
14Pictures and graphics are often included in newsletters, adding interest and style. Even so, those objects should be incorporated relatively seamlessly with surrounding text, requiring that you wrap text appropriately and size graphics so they are attractive but not overbearing.
Place the insertion point before the words The College of Business at the beginning of the second body paragraph on the fourth page. Insert the University.JPG picture, downloaded with this project. Change the picture style to Reflected Rounded Rectangle. Resize the picture height to 1" and select Square text wrapping.5
15Place the insertion point after the period ending the first paragraph on the second page (ending in upon graduation). Press ENTER. Remove the First line indent. Insert a 2-column by 6-row table. Change the width of the second column to 1".5
16Type Course in the top left cell and press TAB. Type Grade in the next cell on the first row. Press TAB. Complete the table as shown below:
Course Grade
Int. Microeconomics A
Int. Macroeconomics B
Public Finance B
Business Calculus A
Contemporary Economics A6
17Insert a row above the first row in the table. Merge all cells in row 1 and type Major Courses Completed in row 1. Apply Align Center alignment to row 1. Apply a table style of Grid Table 4 - Accent 6 (row 4, column 7 under Grid Tables). Center the table horizontally.9
18Add a caption below the table. The caption should read Table 1: Major Courses Completed at the University of Arizona. (Do not include the period.) Center the caption.5
19Create a custom watermark to display at a diagonal, with the text Copy in Blue (column 8 in Standard colors). 3
20Check spelling and grammar in the document. Correct the misspelling of analyzed and the hyphenation of first-time. If the check does not suggest a change for first time, manually correct it in the second to last paragraph in the left column on page 5, changing first time to first-time. Ignore all other grammatical and clarity concerns.2
21Replace the dash dividing the words organization and Fortune 500 in the first paragraph on the fourth page with an Em Dash symbol.3
22Select the paragraph beginning with I hope you will accept the challenge on the last page (including the paragraph mark). Apply shading of Red, Accent 6, Lighter 60% to the selected paragraph.3
23Begin a mail merge, selecting recipients from an existing list—Graduate_Schools.xlsx, using Sheet1$. Sort the data source in ascending order by University and filter to select only those universities with an Area equal to W.0
24Replace [University Name] in the first paragraph on the third page with the merge field of University. Be sure to include the brackets with text to be replaced. Ensure that a space precedes and follows the newly inserted University placeholder. Preview the results and then finish the merge, choosing to edit individual documents and merging all records.0
25Select the entire merged document and copy it. Switch to Exp19_Word_AppCapstone_IntroAssessment_Research, move the insertion point to the end of the document, and insert a manual page break. At the top of the new page, paste the copied text. The original document to which you pasted the merged data now contains 15 pages. Save Exp19_Word_AppCapstone_IntroAssessment_Research and close all open documents without saving.7
26Save Exp19_Word_AppCapstone_IntroAssessment_Research. Close all other open files without saving. Submit Exp19_Word_AppCapstone_IntroAssessment_Research as directed.0
Total Points100