LABORATORY EXERCISE TWO

• TO WRITE A LAB REPORT IN MS WORD
• TO CREATE A GRAPH IN EXCEL
• TO INSERT AN EXCEL GRAPH INTO MS WORD
• TO PERFORM DATA ANALYSIS
• TO SUBMIT A LAB REPORT USING DIGITAL DROPBOX

PROCEDURE:

• OPEN A WORD DOCUMENT AND BEGIN YOUR PAPER
  YOU SHOULD INCLUDE THE ITEMS BELOW
  (SEE THE GENERIC GUIDELINE FOR THE FORMAT).

• title page
• the objectives (above)
• the data (below)
• your excel graph (inserted in the word document)
• your conclusion/discussion of the activity

• OPEN AN EXCEL DOCUMENT AND GRAPH
  VELOCITY VS TIME (which means graph velocity on
  the y-axis and time on the x-axis)

• First (original) graph of your data
• enter your data in columns, first column x-axis values, second column y-axis values
• drag to select the data and then click the chart icon.
• Select (xy) scatter
• select scatter with data points connected by smooth lines
• select next
• enter titles and labels for your graph
• deselect "show legend"
• click "finish"
• drag graph to where you wish it to appear on your page
• Second (Analysis) graph of your data
  • If the graph appears linear FIT A LINEAR TRENDLINE
    • click a data point on the graph to select
    • select chart->add trendline --> select linear --> select options-->select show equation and R-squared-->ok
    • translate the excel equation to a functional relationship of your variables

     

Data:

A.

Time(sec)	2.0	2.5	3.0	3.5	4.0	4.5	5.0	5.5
Velocity(m/s)	70	60	50	45	32	30	22.8	14.5

B.

Pressure(N/m^2)	1218	845	609	487	405	305	202	153
Volume(m^3)	2.0	3.0	4.0	5.0	6.0	8.0	12.0	16.0

 

• If the graph does not appear linear
  • regraph as instructed and follow the procedure above
    • Try a second graph of Pressure Vs (1/Volume) -- pressure on the y-axis
  • translate the Excel equation to the functional relationship of your variables
    • -do this by substituting for x, y, m, and b (remember you graphed 1/V, not V this time!)
      
      example: if excell equation is y = 30 x + 10 when you graph force Vs 1/distance, your functional relationship would be F = (30/d) + 10

COPY AND PASTE YOUR EXCEL GRAPHS INTO YOUR
WORD DOCUMENT

FINISH YOUR REPORT AND SUBMIT IT USING Moodle

---

hfish
5/20/09
©2001