You have invested in a new housing
development for the Joliet, Illinois area. |
|
|
|
|
You
call it the Fox River Delight
community, and have the Post Office assign its own zip code, 60434. |
|
Now,
for the Joliet Planning Commission, you are requested to estimate the
educational level of its planned 6,000 residents. |
|
Follow
the instructions below to satisfy their requirement. |
|
Note:
data are shown for Joliet, and for the Chicago area (Chicago MSA -
Metropolitan Statistical Area) |
|
|
|
Your Name |
|
|
|
|
|
|
Spreadsheet Project |
ZIP |
Elem |
AttendHS |
GradHS |
AttendColl |
GradColl |
Total |
Percentage |
|
60431 |
642 |
1299 |
4144 |
4462 |
3163 |
|
60432 |
2566 |
2662 |
3044 |
1981 |
426 |
|
60433 |
1153 |
2253 |
3697 |
2538 |
766 |
|
60435 |
2850 |
4715 |
11316 |
8885 |
6025 |
|
60436 |
1022 |
1931 |
3806 |
2634 |
1250 |
|
Average |
|
|
|
|
|
|
MSA |
485699 |
672780 |
1390419 |
1359716 |
1324873 |
|
|
|
1 |
Enter the above info in a
new spreadsheet. |
|
2 |
Save as SSProj |
|
3 |
Insert your new Zip Code,
60434, under the row for 60433. |
|
4 |
Fill in your estimate so
your (approximately) 6,000 residents are divided across the educational
categories shown. |
|
5 |
Use the SUM function to
compute total population for each Zip Code, including the new one. Also total the MSA numbers. |
6 |
Use the AVERAGE function
to calculate the average population for each educational
category. |
|
7 |
Format the average to 2
decimal places. |
|
8 |
Under percentage, create
a formula to compute each zip code's percentage of the Chicago MSA's
population. |
|
9 |
Format the result as a
percentage. |
|
10 |
Adjust the column width
so you can display at least 6 decimal points under Percent. |
|
11 |
Center all items in the
average row, |
|
12 |
Bold all items in the
average row. |
|
13 |
Add a border around the
Average row. |
|
14 |
Change the font size of
ZIP to 14. |
|
15 |
Create a header which
centers your name and right-justifies today's date. |
|
16 |
Create a footer which
prints the page number on the left and the words "Why look down
here?" on the right. |
|
17 |
Create a pie chart
showing educational level for the Chicago MSA population. Include labels in a
legend and title the chart. |
18 |
In landscape mode, print
the spreadsheet with graph on one page. Be sure gridlines are off. |
|
19 |
Print a second copy of
the spreadsheet showing formulas. |
|
|
|
|
|
|
|
|
|
|