Report Sheets from manual and Excel tables and graphs
robert zellmer
zellmer.1 at osu.edu
Fri Jan 12 12:34:40 EST 2018
I'm still getting questions about doing the data tables (report
sheets) in Excel or the report form from the manual and what to
do with each. Here's three scenarios and what to do in each case.
I sent something out which was similar to this but here it goes
again.
1) You use Excel to make the data tables and do the calculations
in the tables (and graphs when necessary). If you make the
Excel sheets look like the report sheets (headings, units,
correct s.f., readable, etc.) you can simply transfer them into
your Word document from the template. There is no need
to copy all the data over to the report sheet from the manual.
You are just wasting time. You should include the blank report
sheet provided in the manual in your document (scan it or take
a picture of it). We will grade the Excel report sheet (form).
Again, if you can't figure out how to transfer them into your
Word doc directly from Excel print them out and scan them (or
take a pic) and include this into the Word doc. Make sure
a scanned page or a picture are clear and readable. Then
ask me or the TA at some point (read my Excel instructions)
so you can learn how to transfer tables and graphs to Word.
2) You use Excel to simply do the calculations and/or the graphs
but transfer all the data to the report sheet because you don't
want to bother making the Excel sheets look like the report
sheet or bother with setting the proper s.f. in Excel. In this
case you fill in the report sheet from the manual, scan it or take
a picture and include it in the report. Also, include the Excel
sheet, even though it's not formatted correctly. We will grade
the report sheet in the report since it's filled in. We want the
Excel sheet so we can see what you've done and what numbers
you used for the calculations and/or graphs. The Excel sheet
does not have to be formatted correctly in this case (i.e. doesn't
have to have correct s.f., units, etc.) since we will be
grading your
report form from the manual.
3) You can also make tables in Word. If you make the table in Word
just make sure it has all the features described above for Excel
tables. However, I don't know if you make a table in Word if you
can make a graph.
You do not have to use Excel (or similar program) for graphs. However,
if you don't, you need to use actual graph paper with lots of grid lines.
The notebook pages won't suffice. Doing it "freehand" on a piece of
printer paper will receive zero points. If doing it on graph paper you
will
need to use a ruler if making a linear best-fit line. If you need the
slope
you will need to do calculations by hand for each and every best-fit line
using points from the line and show those calculations. Then of course
you would need to scan this graph (or take a picture) and include it in
your Word doc.
When using Excel to do best-fit lines (curves) you should print the
equation for the line and the R^2 (correlation coefficient) values. If
it is
a linear fit and you need the slope you will use the slope produced by
Excel.
However, you need to show a sample calculation for slope using points from
one of the best-fit lines.
I will warn you now about exp 17. If you don't use Excel or a similar
program
it will take you a very long time to process the data. You will have 4
data tables
with at least 15 time and absorbance data pairs. Then you will have at
least
60 calculations for each solution (at least 240 total calculations).
This will produce
a table with 90 data values for each solution (at least 360 total
values). For exp 17
you have to make the data tables using Excel anyway. Also, if you make a
calculation error (which you don't often realize until you do the second
graph, the
zero-order graph) it is much easier to fix it using Excel (assuming
you've programed
your Excel tables to do the calculations) than to redo all the
calculations by hand.
Dr. Zellmer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osu.edu/pipermail/cbc-chem1250/attachments/20180112/7eb7f22a/attachment.html>
More information about the cbc-chem1250
mailing list