<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I have help files for exp 6. Look at the class web page (not
Carmen). <br>
Look at "Helpful Tidbits" and the "Laboratory" links. You will find
several <br>
files and a good bit of help for this exp and what you should do
with the <br>
graphs. I will go over in class what you would do in Part A for
determining<br>
the heat capacity of the coffee cup. I also describe this at the
"Laboratory"<br>
link. The TAs will discuss some of this as well in lab.<br>
<br>
I also have examples of what your graph should look like, both
before <br>
and after you've drawn your lines and added the text for T_i and T_f<br>
and time-of-addition. There's two ways to draw the lines and add<br>
textboxes.<br>
<br>
You can use Excel for exp 5 to plot the points using a scatter
graph, not<br>
a line graph. You should have it draw lots of grid lines.<br>
<br>
Excel has drawing and text box functions. You can draw a line and<br>
manipulate it to get a best-fit line as if you drew it by hand
(probably even<br>
better). You can add text to the graph. Usually the functions are
found<br>
under "Insert".<br>
<br>
You can use Excel to do the whole graph except for the lines and
text labels.<br>
Print the graph and draw the lines in by hand and add the labels for
T_i<br>
and T_f. <br>
<br>
While it can be done, it is not easy to do trend lines for this data
and get<br>
them to come out correctly. I won't go into explaining why or how
to<br>
overcome that. It's not necessary to have Excel do trend lines for
these<br>
graphs. Just draw them in some way, as described above.<br>
<br>
For exp 6 graphs you want the <b>temperature </b>on the <b>y-axis
</b>and you want to <br>
put that on the <b>LONG side </b>of your <b>graph paper</b>.
That means if you are using <br>
<b>Excel </b>you need to tell it to put things in <b>PORTRAIT </b>mode.
The default in<br>
Excel is Landscape, which is usually the better graph mode.
However, for this<br>
exp you want it in <b>PORTRAIT</b> mode. See my help files where
I've explained<br>
this. You want to spread out your axes as much as possible,
especially the<br>
temp. axis since that's more accurate than your time. You need lots
of grid lines<br>
because you will be reading the Ti and Tf from the graph. If you do
this correctly<br>
you will be able to gain 1 s.f. for Ti and Tf obtained from your
graphs. Set the<br>
margins to zero inches all around and if Excel complains tell it to
ignore it.<br>
<br>
I often get a lot of questions about the mass of NaOH in part B.
You<br>
calculate the mass of NaOH from the volume of NaOH (10.00 mL) and<br>
the density (given in the data analysis section on page 49 of the
manual). <br>
<br>
<a
href="http://chemistry.osu.edu/%7Erzellmer/chem1250/faq/exp6_excel.txt"><b>Exp
6 - Using Excel for Exp 6</b></a><br>
<br>
<a
href="http://chemistry.osu.edu/%7Erzellmer/chem1250/lab/exp6_partA_graph.pdf"><b>Exp
6 - Example of a decent graph</b></a><br>
<br>
<a
href="http://chemistry.osu.edu/%7Erzellmer/chem1250/lab/exp6_partA_finished.pdf"><b>Exp
6 - Example of a decent finished graph with best-fit lines</b></a><br>
<br>
<br>
Dr. Zellmer
</body>
</html>