Report Sheets from manual and Excel tables and graphs

[robert zellmer]

I'm still getting questions about doing the data tables
in Excel and the data tables (used to be referred to as report
sheets) from the manual and what to do with each.  Here's
two scenarios and what to do in each case.   I sent something
out which was similar to this but here it goes again since I'm
still getting questions.

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 template data tables (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 data tables in the manual.
         You are just wasting time.  Then delete the blank data table in
         the template.

         It's easy enough to make your Excel sheet look like the data
         tables in the report template by simply copying the headings
         from the tables in the template into Excel.

2)  You use Excel to simply do the calculations and/or the graphs
         but transfer all the data to the report template data tables 
because
         you don't want to bother making the Excel sheets look like the
         template data tables or bother with setting the proper s.f. in 
Excel.
         In this case you can copy and paste the data from Excel one
         piece at a time to the template data tables or simply type them in.

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 3 (DRL).  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 3 data tables with at least 15 time and absorbance data pairs.  Then
you will have at least 60 calculations for each solution (at least 180 total
calculations).  This will produce a table with 90 data values for each 
solution
(at least 270 total values).  For exp 3 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-chem1220/attachments/20170621/e3d7b049/attachment.html>