Use the aftercited “how to videos” to aid you accomplished the HW
Excel: Entering a formula ‐ http://www.wisc‐online.com/Objects/ViewObject.aspx?ID=ENG5403
Excel: Locking Cell References ‐ http://www.wisc‐online.com/Objects/ViewObject.aspx?ID=ENG5503
Excel: Spreadsheet Hints ‐ http://www.wisc‐online.com/Objects/ViewObject.aspx?ID=ENG6403
Video: Create an Excel consultation ‐ http://office.microsoft.com/en‐us/excel‐help/video‐create‐an‐excel‐
table‐VA101810216.aspx?CTT=1
Video: Create a chart in Excel ‐ http://office.microsoft.com/en‐us/excel‐help/video‐create‐a‐chart‐in‐
excel‐VA102571932.aspx?pid=CH010369001&CTT=4&client=1
Solve this exaltation using Excel (suggestion: imimprint this page and morose off the addresss as you accomplished them).
Supplies are dropped from an airflatten to plant at a undeniable purpose. The accelerate of the load at extricate from the
airflatten is the accelerate of the airplane, v0x=250ft/s. The aid of the load due to lugubriousness is ay = ‐32.2 ft/s2
. The
displacement in the y address can be fix using the aftercited equation: y ‐ y0 = v0yt + 1⁄2ayt
2
. The definite lie of the
load (y) is on the cause, and y0 represents the exaltation of the flatten when the load is dropped. The moderate accelerate
in the y address (v0y) is nothing. Therefore the equation becomes: y = y0 + 1⁄2ayt
2
.
The interspace the load travels in the x address can be fix from the equation: x ‐ x0 = v0xt + 1⁄2axt
2
. The definite
lie of the load (x) is measured from the moderate lie (x0). If x0 is charmed as nothing, and if the flatten is traveling at
a true accelerate (ax is nothing), then the equation becomes: x = v0xt.
Step‐by‐step Excel Instructions:
1. Create a consultation for the moderate axioms:
i. In cell B2 put the mark “Plane exaltation:”
ii. In cell C2 put the moderate exaltation of the flatten in feet (ft): 350
iii. In cell B3 put the mark “Acceleration (g):”
iv. In cell C3 put the aid of lugubriousness in ft/s^2: ‐32.2
v. In cell B4 put the mark “Velocity:”
Page 2
vi. In cell C4 put the accelerate in ft/s: 250
vii. In cells D2, D3, and D4, attribute the expend units
2. Create a consultation for the axioms and calculations:
i. In cells B6, C6, and D6 respectively, put the marks “t”, “x”, and “y”.
ii. In cell B7, penetrate the moderate season: 0
iii. Increment the season in 1⁄2‐second intervals in shaft B, from B8 to B16.
iv. Cpenetrate all of the marks and axioms in shafts B, C, and D.
v. Penetrate the formulas to estimate 1) x in cell C7 and 2) y in cell D7.
vi. Copy the formula from C7 to C8 through C16 and from D7 to D8 through D16.
vii. Format the total in the y shaft to one decimal purpose.
3. Create detached graphs of 1) “x vs. t” and of 2) “y vs. t”. Using the “x vs. t” graph as an example:
i. Choice the x axioms (C7:C16), and then choice the “line delay markers” concoct likeness.
ii. To add the season on the tasteless axis, right‐click on the chart and chose “Select Data...”. In the “Select
Data Source” dialog box, chose “edit” for the Tasteless (Category). In the next dialog box, simply
choice (pull the mouse aggravate) the season axioms (B7:B16).
iii. Add superior perpendicular gridlines, chart inscriptions, and axis marks using the nonentitys subordinate the “Layout” tab.
Include the set-right units in the axis inscriptions and hang the perpendicular axis inscription to the tasteless.
iv. Remove the “series” marks from these two charts (Layout/legend).
v. Repeat these steps for the “y vs. t” graph.
4. Create a graph of “x and y vs. t”
i. highlighting the x and y axioms anteriorly choosing the chart likeness or by mimicking and modifying one of the
existing charts using the “Select Data...” direct.
ii. Change the train marks to discover “x” and “y” or “tasteless interspace” and “perpendicular interspace”.
iii. Add the expend chart inscription and axis marks.
5. Use gauge and blunder:
i. Change the values in the “t” shaft to individualize, by gauge and blunder, the season at which the load hits
the cause.
b. Using the “Goal Seek” tool:
i. Sight Solicit can be fix subordinate the “Data” tab, “What‐If Analysis” nonentity.
ii. To use sight solicit, unconcealed the Sight Solicit dialog box: Set cell: D16, To Value: 0, By changing cell: B16.
iii. Record your vindication in B18, then restore the spreadsheet to its moderate contour.
:
Write a beginning that explains the axioms consultations and the graphs. DO NOT advert to “cell B18” or any
other cell (When looking at the axioms consultation in a Word instrument, how can you establish cell D9?).
Memorandum
Page 3
1. Copy and paste the graphs (3) and the axioms consultations into a Word instrument. It is recommended that you paste the
axioms consultations and each graph detachedly as a Picture (Windows or Enhanced Metafile). Do not paste the axioms or
the graphs as a Graphic Object, or as an Excel Object (use “Paste Special” fix subordinate “Paste” on the Ribbon).
Use expend inscriptions or captions.
2. Explain each graph and axioms consultation. In the extract, advert to each graph and consultation using expend marks.
3. Explain the reckon (time) obtained by using the “Goal Seek” part.
4. Carefully sort the extract, axioms consultations, and charts to imimprint set-rightly (use Imprint Preview).
5. Insert page total and a header if you feel multiple pages.