Exp 15 help, graphs, etc.
robert zellmer
zellmer.1 at osu.edu
Mon Jun 13 23:07:54 EDT 2016
I guess some of you have started your reports for exp 15 since
I've received questions about it.
I have a help file. You will find it by going to the following link,
*Helpful Tidbits for 1220*
<http://www.chemistry.ohio-state.edu/%7Erzellmer/chem1220/faq/faq_1220.htm>
and then clicking on the link for exp 15,
*Exp 15 - Help for Exp 15*
<http://chemistry.osu.edu/%7Erzellmer/chem1220/faq/exp15.txt>
While this mostly helps with the report it does have some info
about lab itself, as does the "Laboratory" link.
I also have an example of the data tables and graphs for exp 15,
*Exp 15 - Example of Data Tables and Graphs Using MS Excel*
<http://chemistry.osu.edu/%7Erzellmer/chem1220/lab/exp15.pdf>
These are simply examples. It doesn't show how to do them. Please
note a couple of things:
1) You can use Excel to do the calculations and make the data
tables. Program in the proper equations and let Excel do the
calculations for you (of course you can do them by hand and
just input the values). You can then import the tables into
the Word doc you get from the template on Carmen.
2) Parts A and B are both in H2O as solvent and are graphed as
*ONE *set of data. Make them one set of data in Excel. There
should be a smooth curve fit. It shouldn't be a straight line in
this case (or for the mixed solvent).
Part C is a separate set of data and should be a separate
line. Again,
use a non-linear best-fit line.
3) Do *NOT *draw the lines by hand. There is NO need to. If you have
decent data *Excel *should be able to do a pretty good job at
putting
a smooth curve "through" your points. You should NOT have a wavy
line. You should use a "scatter" graph with no lines and then
fit the
points with a trend line. Use a non-linear best-fit line. Look
at the
curve I used for the fit. If you have good data it should look
something
like the data and lines on my example so an exponential fit
like what
I used should work. If a different type of best-fit curve work
better
use it, as long is it gives a nice smooth fit (doesn't appear
"wavy").
4) If you have a point which seems to be out of place you should
include
it on the graph but not in the trend line fit. You do this by
plotting all the
"good" points as one set of data and the "bad" point as a
separate data
set. Then you can have Excel draw the trend line for the
"good" points.
5) Note what is plotted on the x and y axes on graph 2 and the
direction
of curvature for the 2nd graph in my example. You should have that
same curvature. If you don't (it looks more like graph 1)
you've likely
graphed mole fraction on the y-axis vs. temp. on the x-axis
(reversed
from what you should have).
Also, someone asked about the "Points to Consider" on page 25. These
are there to help you with some of the things you should discuss in the
Results/Discussion section. I've also got some things in the "Exp 15
Help File"
about this section.
Dr. Zellmer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osu.edu/pipermail/cbc-chem1220/attachments/20160613/5157dbe5/attachment.html>
More information about the cbc-chem1220
mailing list