Lab Items CHM 109 F 2009
Kinetics lab spreadsheet template
0. You may find it easiest to right-click the link and use "Save Target As..." to save the file to your computer. Then open the file from Excel and proceed as indicated below. Remember to save a copy frequently (or set auto-save with a short turnover time) to avoid loosing your work.
1. This is setup to calculate concentrations from the absorbances that you enter. Enter your absorbance values in the appropriate cell, hit enter, and the concentration should appear in the adjacent cell.
2. Then plot your time vs. conc. graphs (for trials 1-9) and obtain the rates from the slopes.
3. Enter the rate values under the "Summary of Results" section.
4. Use the appropriate formulas (from the fx pull down?) to obtain the rate averages and standard deviations and average temperatures on the right side of this section. These are the values you should use to solve for x, y, and k. (Note: In lecture I referred to the exponents as m and n. It doesn't really matter what variable letters you assign to the exponents, as long as you avoid using k.)
Kinetics extra advice for data analysis (Word format) If your computer works like mine, you will need to do a Save Target As..., and save the document to your computer to be able to see the figure.
Equilibrium lab partial template
Enzyme Kinetics Lab partial template You will need to fill in the equation to convert A420 into benzoquinone concentration. Remember that the Lambert-Beer Law values for a and b for this experiment are given on p. 3 of the lab exercise. If you don't understand how to do the conversion, look back at the 1st kinetics lab or equilibrium lab spreadsheets.