For this assignment, you are answering a request for information in a memo. The request was for census date to help Waterworld business decide if a new waterpark will be worth investing in. They have asked for the census data for three cities where they are planning future activity. These three cities are Ann Arbor, MI, Jackson, MI, and Grand Rapids, MI.

You will then want to search for each of those cities and census 2010 2020. This will give you the numbers that are needed to work through the memo and give the final recommendation.

Directions for the Table:

1. On a new document, insert a new table that is 1x1.
2. Skip a line and insert a table that is 4 x 4.

Insert your information (Arial 12).

3. Add the sources below the table (Arial 10).
4. Delete the blank line between the two tables to join them.
5. Format the size of the cells and the alignment of the content.

Sample:

Table 1 Population of ------------------------------
	2010	2020	Change
City 11	0000000	000000	+ / - 0000
City 22	00000000	000000	+ / - 000
City 33	0000000	00000000	+ / - 000000

Source ¹Author. (year) Name of the website. Retrieved Mon. ##, #### from http://-------------

²Author. (year) Name of the website. Retrieved Mon. ##, #### from http://-------------

³Author. (year) Name of the website. Retrieved Mon. ##, #### from http://-------------

Directions for Line Graph:

1. On a new document, insert a new table that is 3 x 20.
2. Decide on a unit for counting population and put it in the left-hand column (Arial 10). The number range needs to be greater than the numbers of the highest or lowest population total. Remember to keep the units between lines the same number. Right justify these numbers and hide the left border. Use the tab function to add as many rows as you need.
3. Type 2010 under the first column divider, 2020 under the second column divider, and 2030 under the last column divider (Arial 10).

Adjust the columns by putting the cursor over the vertical line and waiting until the cursor turns into a double arrow to drag the line left or right.

5. Insert the line to represent the population. Go to insert shapes and choose a line. Put the cursor over the 2010 line at the point where the population total is, hold down on the mouse and move it to the spot for the population in 2020. Use the line selector to choose the color of the lines. Make a short line under the table and label it with the city as a key (Arial 10). Repeat for all three cities.
6. Insert the line to represent the projected growth in population. Go to insert shapes and chose a line. Put the cursor over the spot where that city is in 2020 and then make a straight line off that point to 2030. Change the line to a dotted line.
7. Add the figure number and title under the line graph (Arial 12).

Directions For the Memorandum:

1. Set up a memorandum like the sample below. Notice the heading and subtitles are all caps.

Sample

MEMORANDUM

TO: First Last

FROM: First Last

DATE: Month ##, ####

SUBJECT: Subject

The introduction to the memorandum starts 2-lines down from the heading. The body is written in block format. Here the background to the situation is presented, the ultimate question that needs to be answered is presented, the criteria by which the question should be evaluated, and what the future goal of the project is.

FINDINGS

In this section, the census data for 2010 and 2020 are presented in one prose table for all three cities, and in a line graph, the numbers for 2010 and 2020 are extended to 2030 with a projection line.

CONCLUSION

In this section, the three cities are evaluated by the criteria set up in the first section.

RECOMMENDATION

In this section, the recommendation for what option the business should select is stated, then the what, when, and how for the project are detailed.

2. Complete the email heading:

• Put the persons name who requested the information in the TO.
• Put your name in the FROM.
• Put the date in the DATE.
• Write a specific SUBJECT, such as Census data for --------------- project

3. Write the introduction section. For paragraph 1, start by telling the background on the project. Who requested the information? For what purpose? What is the essential question that needs to be answered? For paragraph 2, explain the parameters and /or criteria by which the project will be judged?
4. Skip a line and add the subtitle for FINDINGS.
5. Start this section by explaining what three cities you chose and why.
6. The next paragraph is a lead-in paragraph. It tells where and how the population data for the cities was found. Then it introduces table 1. Sentence one gives the purpose of the table. Sentence two tells how the table is organized. Sentence three tells what conclusions can be drawn from the table.
7. Insert table 1 here. Make sure the title is above the table and the source information is below the table. It should be centered on the page.
8. Write the third paragraph for this section. This paragraph is a lead-in to the line graph. Tell what the purpose of the line graph is. Tell how it is organized. Tell what conclusions can be drawn from it.
9. Insert line graph here. Make sure the title is below the line graph.
10. Skip a line and add the subtitle for CONCLUSIONS.
11. Start this section by reminding the reader what is being looked for and how it will be recognized when it is found. The next paragraphs can start with a criterion and an explain of how well each city matches that criterion. Or there can be three paragraphs with each one introducing a city, and then the discussion that follows would explain how well each criterion was met.
12. The concluding paragraph ranks the three cities and explains the ranks.
13. Skip a line and add the subtitle for RECOMMENDATIONS.
14. Start the section by repeating the question that needed to be answered and then give the answer to that question. The following sentences should explain who, what, when, how to implement the recommendation. This explanation is sometimes presented in a list.
15. Revise the memorandum to make sure the content is complete, and the sentences are grammatically correct.
16. Check the overall memorandum for a good balance of white space and text.