do you need to type reports or use Excel?

[robert zellmer]

1)  You need to type most your report using the template provided
         on Carmen.  You can write it certain parts in *PEN*, particularly
         the sample calculations.  It can be a little tedious typing in
         equations.  You can write them out and then incorporate
         them into your Word doc.  Just make sure they're organized
         and neat, certainly neat enough for someone to read it easily.

         Since you have to submit the report on line in Carmen, anything
         you write by hand will have to be incorporated into your Word
         document.  You will have to scan or take a picture (scans are
         usually better) of your written portions and incorporate it into
         the Word doc.

2)  You do not have to use Excel.  However, I would suggest learning
         how to use it.  It will come in handy later in the semester.  
There
         are a few labs which will require a lot of calculations and 
graphs.
         They will go much quicker if you use Excel.  Besides, it's a very
         useful skill to have.

3)  If you use Excel (or a similar program) you can have it do the
         calculations.  That's really the best thing to do in terms of 
saving
         time. *You will still have**to show sample calculations in the
         report. *Just printing the equations as they appear in Excel is
         not sufficient.

         If you make the Excel sheet look like the report sheet (with 
titles,
         headings, etc.) you can incorporate the Excel worksheet into Word.
         Word will read incorporate Excel worksheets fairly easily. If you
         can't figure out how to do this you can print the worksheet, 
scan it
         (or take a pic) and then incorporate this in the Word doc. You do
         not have to copy all the data over to the data sheet which is 
usually
         already in the Word template you download from Carmen.  Just
         leave the report form which is already in the template file in 
your file
         (even if blank).  You also have to make sure you have units 
(best to
         put them in the headings) and have the correct number of sig. fig.
         You can't set sig. fig. in Excel but can set the decimal places 
to get
         the correct sig. fig.  See my help files for exp 14 and how to use
         Excel on how to do this.  By they way, if you set the numbers in
         your tables to the correct number of s.f. before making the graph
         you will get the correct number of s.f. for the axes labels.

4)  If you've done your graphs in Excel just incorporate them from Excel
         into Word..  In Excel set the *margins *to *0 inches* for your 
graphs.
         Even if you intend to print a graph and scan it before putting 
it into
         Word you want to set the margins to 0 inches (it will then 
default to
         the minimum margins your printer can do, most newer printers can
         print pretty much to the edge).

         You have to be careful when you transfer them into Word since 
it often
         messes up the margins unless you transfer them in using the 
proper settings.
         Also, the default for displaying graphs is "Lanscape" mode (the 
page laying
         on it's side with the 11.5 inch side running horizontally). 
This usually gives
         the better looking graph.  Use "Landscape" mode unless we tell 
you otherwise.
         Make sure when you bring the graph into Word it stays in 
Lanscape mode.

         Look at my examples and help pages for using Excel and the 
reports and
         graphs.

         I wish I could tell you exactly how to do all of these things.  
Unfortunately there's
         lots of versions of Microsoft office and they work slightly 
differently and the
         way Word and Excel are set up are slightly different in the 
versions.  It's not hard
         to figure out though.  Just start playing around.  There are 
many sites with tutorials
         on how to use Word and Excel on the web.

Microsoft Office Training Center - Office Support 
<https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjXg6Ljk5_NAhVp3IMKHaiJCb0QFggeMAA&url=https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FOffice-Training-Center-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb&usg=AFQjCNFVwuwx6tSLDUupA2V7eYGIiCDr-w>

Microsoft Office Training | Microsoft Learning 
<https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0ahUKEwjXg6Ljk5_NAhVp3IMKHaiJCb0QFgguMAI&url=https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Flearning%2Foffice-training.aspx&usg=AFQjCNGBgKVvct8jRZM-uNp9KjGlKGudpg>

How-to tutorials - Microsoft Download Center 
<https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&cad=rja&uact=8&ved=0ahUKEwjXg6Ljk5_NAhVp3IMKHaiJCb0QFgg1MAM&url=https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fhow-to-tutorials.aspx&usg=AFQjCNFXdWDJeJHmpapN6-ty0nEqNZUAyw>

http://www.gcflearnfree.org/

             I'm sure there are tutorials on Youtube and elsewhere as well.

Dr. Zellmer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.osu.edu/mailman/private/cbc-chem1220/attachments/20160611/b0a55ee4/attachment-0001.html>