T003
H.W#1 is in the photo that has been uploaded (couple of pictures for one question)
Homework 2
Assignment:
(Use the following Olympic data for this assignment.)
| OLYMPICS | ||
| 100 meter free-style Olympic Gold Medal Swimming Records (seconds) | ||
| Year | Men | Women |
| 1896 | 82.20 |
|
| 1900 | 62.80 |
|
| 1904 | 73.40 |
|
| 1908 | 65.60 |
|
| 1912 | 63.40 | 82.20 |
| 1920 | 61.40 | 73.60 |
| 1924 | 59.00 | 72.40 |
| 1928 | 58.60 | 71.00 |
| 1932 | 58.20 | 66.80 |
| 1936 | 57.60 | 65.90 |
| 1948 | 57.30 | 66.30 |
| 1952 | 57.40 | 66.80 |
| 1956 | 55.40 | 62.00 |
| 1960 | 55.20 | 61.20 |
| 1964 | 53.40 | 59.50 |
| 1968 | 52.20 | 60.00 |
| 1972 | 51.11 | 58.59 |
| 1976 | 49.99 | 55.65 |
| 1980 | 50.40 | 54.79 |
| 1984 | 49.80 | 55.92 |
| 1988 | 48.63 | 54.93 |
| 1992 | 49.02 | 54.64 |
| 1996 | 48.74 | 54.50 |
| 2000 | 48.30 | 53.83 |
| 2004 | 48.17 | 53.84 |
| 2008 | 47.21 | 53.12 |
Enter the data above in an Excel spreadsheet, place it on the first worksheet and label the worksheet “OlympicDataâ€. Create twoadditional worksheets, labeled “PolyTrend†and “ExpTrendâ€. On each of those worksheets, create an XY chart from the data to illustrate the information graphically. Ensure that your charts are labeled with a title and legends for the x and y-axis. Use three different ordersof polynomials in creating trend lines on the “PolyTrend†worksheet. On the “ExpTrend worksheet, create an exponential trend line. Remember to make the information look presentable.
Homework 3 ()
Assignment:
You are the plant engineer and the plant manager has asked you to do an analysis of the utility bills and make a presentable report from the information. The data is required to evaluate cost saving improvements you are considering for the plant by improving energy and water usage:
| ELECTRIC | Use | Use | Demand | Demand | TOTAL | |
|
|
|
KWH | $ | KW | $ | $ |
| JAN | 2012 | 208,120 | $6,565 | 798 | $6,464 | $13,029 |
| FEB | 2012 | 302,400 | $10,121 | 819 | $6,634 | $16,755 |
| MAR | 2012 | 273,000 | $10,374 | 756 | $6,124 | $16,498 |
| APR | 2012 | 193,200 | $8,767 | 651 | $5,273 | $14,040 |
| MAY | 2012 | 291,100 | $10,377 | 546 | $4,423 | $14,800 |
| JUN | 2012 | 391,100 | $10,238 | 525 | $4,262 | $14,500 |
| JUL | 2012 | 296,100 | $13,575 | 735 | $7,445 | $21,020 |
| AUG | 2012 | 407,400 | $16,902 | 798 | $8,091 | $24,993 |
| SEP | 2012 | 420,000 | $18,574 | 798 | $8,025 | $26,599 |
| OCT | 2012 | 348,600 | $17,613 | 756 | $7,634 | $25,247 |
| NOV | 2012 | 199,500 | $9,739 | 588 | $4,663 | $14,402 |
| DEC | 2012 | 239,400 | $10,121 | 672 | $5,269 | $15,390 |
|
|
|
|
|
|
|
|
| TOTALS |
|
3,569,920 | $142,966 | 8,442 | $74,307 | $217,273 |
(Note: the dollar information on this table is set to the dollar value, no cents)
-When you enter this table into your spreadsheet, you will need to enter formulas for the Total $ column (Yellow) and Totals row (Green).
| NATURAL GAS | ||||
|
|
|
MMBTU | Cost $ | $/MMBTU |
| JAN | 2012 | 189 | $1,218.00 | $6.44 |
| FEB | 2012 | 215 | $1,297.00 | $6.03 |
| MAR | 2012 | 71 | $412.00 | $5.80 |
| APR | 2012 | 18 | $142.00 | $7.89 |
| MAY | 2012 | 2 | $22.00 | $11.00 |
| JUN | 2012 | 4 | $44.00 | $11.00 |
| JUL | 2012 | 3 | $44.00 | $14.67 |
| AUG | 2012 | 3 | $44.00 | $14.67 |
| SEP | 2012 | 3 | $44.00 | $14.67 |
| OCT | 2012 | 58 | $601.00 | $10.36 |
| NOV | 2012 | 76 | $820.00 | $10.79 |
| DEC | 2012 | 84 | $940.00 | $11.19 |
|
|
|
|
|
|
| TOTALS |
|
726 | $5,628.00 | $7.75 |
(Note: the dollar information on this table is set to the cents value)
-When you enter this table into your spreadsheet, you will need to enter formulas for the $/MMBTU column (yellow) and Totals row (green).
| WATER | SEWAGE | TOTAL | WATER | SEWAGE | |||
|
|
|
Cubic | $ | $ | $ | $/CGAL | $/CGAL |
|
|
|
Gallons |
|
|
|
|
|
| JAN | 2012 | 374 | $59.00 | $64.00 | $123.00 | $0.16 | $0.17 |
| FEB | 2012 | 432 | $67.00 | $73.00 | $140.00 | $0.16 | $0.17 |
| MAR | 2012 | 640 | $86.00 | $106.00 | $192.00 | $0.13 | $0.17 |
| APR | 2012 | 1,079 | $144.00 | $179.00 | $323.00 | $0.13 | $0.17 |
| MAY | 2012 | 1,148 | $154.00 | $192.00 | $346.00 | $0.13 | $0.17 |
| JUN | 2012 | 729 | $98.00 | $122.00 | $220.00 | $0.13 | $0.17 |
| JUL | 2012 | 820 | $110.00 | $137.00 | $247.00 | $0.13 | $0.17 |
| AUG | 2012 | 640 | $68.00 | $77.00 | $145.00 | $0.11 | $0.12 |
| SEP | 2012 | 540 | $78.00 | $91.00 | $169.00 | $0.14 | $0.17 |
| OCT | 2012 | 720 | $98.00 | $120.00 | $218.00 | $0.14 | $0.17 |
| NOV | 2012 | 990 | $129.00 | $165.00 | $294.00 | $0.13 | $0.17 |
| DEC | 2012 | 850 | $113.00 | $142.00 | $255.00 | $0.13 | $0.17 |
|
|
|
|
|
|
|
|
|
| TOTALS |
|
8,962 | $1,204.00 | $1,468.00 | $2,672.00 | $0.13 | $0.16 |
(Note: the dollar information on this table is set to the cents value)
-When you enter this table into your spreadsheet, you will need to enter formulas for the Total $ column (yellow), Water $/CGAL column (light blue), Sewage $/CGAL column (grey), and Totals row (green).
Enter the three tables above in an Excel spreadsheet, place them on the first worksheet and label the worksheet Bills. Create three additional worksheets, labeled Electric, Gas, and Water. On each of those worksheets, link the related information from the first worksheet to a table on the appropriately labeled worksheet and then create a chart to illustrate the information graphically. Make sure that your charts are labeled with a title and legends for the x and y-axis. Use three different types of charts (1 chart for each page). Your goal is to make the information look presentable.
Homework 4 ()
Assignment:
This exercise consists of a list of tasks for a home yard project. Working in Microsoft Project, you will create the task list, including summary tasks and their sub-tasks, create links between tasks and their predecessors. Set a start date for your project of February 28, 2014. Enter the following tasks, including the duration, where specified. Tasks with unspecified duration are summary tasks and the rest are sub-tasks. When completed save the file and submit the file via Canvas.
ID: Task List: Duration: Predecessors:
1 Preparation
2 Get trash bags 5 min
3 Pick up trash 15 min 2
4 Put gas in the equipment 5 min
5 Get the hedge clippers 5 min
6 Do the work
7 Trim weeds 30 min 3,4
8 Mow front yard 45 min 3,4
9 Edge sidewalk 15 min 3,4
10 Trim Hedge 30 min 5
11 Mow back yard 30 min 8
12 Clean up
13 Bag grass 30 min 7,9,10,11
14 Bundle trash 15 min 7,9,10,11
15 Haul trash 45 min 13,14
Saving/Naming Your File:
When you save your file make sure that your name and the project number are included in it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Formation for questions 2&3
Formatting:
Text Size: All of the main text in this assignment needs to be set in 10 or 12-point size. Please resist the temptation to mix and match point sizes. If you doubt your applications intentions, just select all of your text and insure that it is in 10 or 12-point size. Your titles, legends and labels can be different sizes.
Margins: The right and left side can be set for ½†(0.5) margins. Set the top and bottom margins to one (1â€). The only text that ends up on the outside of the one-inch margin is the page number.
&nb
