<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
I'm still getting questions about doing the data tables (report <br>
sheets) in Excel or the report form from the manual and what to <br>
do with each. Here's three scenarios and what to do in each case.<br>
I sent something out which was similar to this but here it goes<br>
again. <br>
<br>
1) You use Excel to make the data tables and do the calculations <br>
in the tables (and graphs when necessary). If you make the
<br>
Excel sheets look like the report sheets (headings, units, <br>
correct s.f., readable, etc.) you can simply transfer them
into<br>
your Word document from the template. There is no need<br>
to copy all the data over to the report sheet from the
manual.<br>
You are just wasting time. You should include the blank
report<br>
sheet provided in the manual in your document (scan it or
take<br>
a picture of it). We will grade the Excel report sheet
(form).<br>
Again, if you can't figure out how to transfer them into
your<br>
Word doc directly from Excel print them out and scan them
(or<br>
take a pic) and include this into the Word doc. Make sure<br>
a scanned page or a picture are clear and readable. Then<br>
ask me or the TA at some point (read my Excel instructions)<br>
so you can learn how to transfer tables and graphs to Word.<br>
<br>
2) You use Excel to simply do the calculations and/or the graphs <br>
but transfer all the data to the report sheet because you
don't <br>
want to bother making the Excel sheets look like the report
<br>
sheet or bother with setting the proper s.f. in Excel. In
this <br>
case you fill in the report sheet from the manual, scan it
or take<br>
a picture and include it in the report. Also, include the
Excel<br>
sheet, even though it's not formatted correctly. We will
grade<br>
the report sheet in the report since it's filled in. We
want the<br>
Excel sheet so we can see what you've done and what numbers<br>
you used for the calculations and/or graphs. The Excel
sheet<br>
does not have to be formatted correctly in this case (i.e.
doesn't<br>
have to have correct s.f., units, etc.) since we will be
grading your<br>
report form from the manual.<br>
<br>
3) You can also make tables in Word. If you make the table in Word<br>
just make sure it has all the features described above for Excel<br>
tables. However, I don't know if you make a table in Word if
you<br>
can make a graph.<br>
<br>
You do not have to use Excel (or similar program) for graphs.
However, <br>
if you don't, you need to use actual graph paper with lots of grid
lines. <br>
The notebook pages won't suffice. Doing it "freehand" on a piece of
<br>
printer paper will receive zero points. If doing it on graph paper
you will <br>
need to use a ruler if making a linear best-fit line. If you need
the slope <br>
you will need to do calculations by hand for each and every best-fit
line <br>
using points from the line and show those calculations. Then of
course<br>
you would need to scan this graph (or take a picture) and include it
in<br>
your Word doc.<br>
<br>
When using Excel to do best-fit lines (curves) you should print the
<br>
equation for the line and the R<sup class="moz-txt-sup"><span
style="display:inline-block;width:0;height:0;overflow:hidden">^</span>2</sup>
(correlation coefficient) values. If it is<br>
a linear fit and you need the slope you will use the slope produced
by Excel.<br>
However, you need to show a sample calculation for slope using
points from<br>
one of the best-fit lines. <br>
<br>
I will warn you now about exp 17. If you don't use Excel or a
similar program <br>
it will take you a very long time to process the data. You will
have 4 data tables <br>
with at least 15 time and absorbance data pairs. Then you will have
at least <br>
60 calculations for each solution (at least 240 total
calculations). This will produce <br>
a table with 90 data values for each solution (at least 360 total
values). For exp 17<br>
you have to make the data tables using Excel anyway. Also, if you
make a<br>
calculation error (which you don't often realize until you do the
second graph, the<br>
zero-order graph) it is much easier to fix it using Excel (assuming
you've programed<br>
your Excel tables to do the calculations) than to redo all the
calculations by hand. <br>
<br>
Dr. Zellmer
</body>
</html>