Assignments for Chem 3020:

[Back to Chem3020 home]

 Spreadsheet Assignment # (click on the assignment link to view each assignment):

#

 Description / Link
1 Gravimetric Chloride Calculations and Report
2 Titration  of Unknown Acid Report
3 Sorting Data
4 Body Mass Index Plot
5 First-Order Kinetics
6 Ligand Binding - Oxygen & Hemoglobin
7 Plotting dx2-y2 Orbital Model in Two Dimensions
8 Linear Regression - Standard Curve of Absorbance Data for Dye Analysis
9 Non-linear Trend Line - Fitting K-42 Decay Data
10 Non-linear Calibration Curve - Atomic Absorption for Mg
11 Linear Regression - Arrhenius Equation
12 Hyperbolic (non-linear) Data Fit - Enzyme Kinetics
12b Linearized Data Fits for Enzyme Kinetics: Lineweaver-Burke & Scatchard Plots
13 Plotting Two Sets of x,y-Data on the Same Chart
14 Re-iterative Calculations or Successive Approximations for Weak Acids
15 Colorimetric Titration
16 Using a Derivative to Determine the Endpoint of an Acid-Base Titration
17 Using Gran's Plot to Determine the Endpoint of an Acid-Base Titration
18 Using the Ratio of [A-]/[HA] to Determine the Endpoint of an Acid-Base Titration
19 Quality Assurance Graph Report - Results Outside of Specifications
20 Sorting to Find Maximum and Minimum Values - Writing a Macro Program
21 Matrix Operations - Simultanious Cobalt, Nickel, and Copper by UV/VIS
22 Matrix Operations - Titanium and Vanadium in Steel
23 Database Functions Using Spreadsheet Software