Exp 17 help - both pre and post lab, using Excel

[Robert Zellmer]

Everyone will be doing exp 17 next week.

I have help files for exp 17.  I have both pre-lab and post-lab hints
and help.  You can find them at the "Laboratory" link (the one help
file can also be found at the "Helpful Tidbits" link).

There is both a pre-lab and post-lab on Carmen for exp 17.

Please look at the pre-lab help before going  to lab.  You are making four
solutions by mixing Cr^3+ and EDTA- resulting in different conc. of Cr^3+
in each solution. *You need a table similar to Table 17.1 on page 122 of 
the**
**manual.  You need to record the actual volumes of the Cr(NO3)2 solution**
**measured in lab. *

You want a *SINGLE table *for the time and absorbance data for the four 
solutions
on a single page.  You should have a table with 8 columns, in groups of 
two for
each solution, marked something like

soln 1 	
	soln 2
	
	soln 3 	
	soln 4 	
time (min)
	Abs
	time (min) 	Abs 	time (min) 	Abs
	time (min) 	Abs

	
	
	
	
	
	
	


This table should be big enough to record at least 15 lines of time and 
Abs data,
but you may ultimately need more lines.

You will *also need *to have space for recording the initial conc. of 
the Cr^3+ in
each soln., the conc. of the CrEDTA- product in the boiled solutions and the
absorbance values for the product in the boiled solutions.


*Laboratory* 
<http://chemistry.osu.edu/%7Erzellmer/chem1250/lab/lab_1250.htm> (see 
stuff dealing with exp 17)

*Pre and Post-lab Help for Exp 17 - (Answers to Students' Questions)* 
<http://chemistry.osu.edu/%7Erzellmer/chem1250/faq/exp17_help.txt>

*Handout for Exp. 17 - Report Tips (Data Analysis)* 
<http://chemistry.osu.edu/%7Erzellmer/chem1250/lab/exp17_tips.pdf>

I HIGHLY suggest you use Excel (or something similar) to do the data tables,
calculations and graphs.

*Exp 17 - Using MS Excel* 
<http://chemistry.osu.edu/%7Erzellmer/chem1250/lab/exp17/exp17.htm>

There are a lot of calculations (a minimum of 245).  If you make a 
mistake you
often don't realize it until you do graph 2 (zero-order plot).  Then you 
have to go
back and redo almost all the calculations.  Using Excel makes the whole 
process
easier, even if you don't make a mistake.

Dr. Zellmer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osu.edu/pipermail/cbc-chem1250/attachments/20160325/7579f18f/attachment.html>