background [prelab assignment (40 points); due at the beginning of lab]
This laboratory activity is based on investigations 1 and 2 in your AP chemistry lab manual; thus, it provides some relevant background for the following prelab questions and this laboratory activity. Investigation 1 is about Beer's law, while investigation 2 is about the calibration curve, which is a reflection of Beer's law.
1. run Beer's law simulation (select "Beer's law" icon): turn "on" light source by clicking on red button and select "absorbance" radio button for the detector. investigate: ___; record values of absorbance and value of the variable of interest. [10 points]
- the effect of path length on absorbance
- use ruler to measure path length
- change path length by selecting yellow double arrow at the bottom on the sample container using the mouse, hold mouse left click button, then move to simulate varying path length
- the effect of concentration on absorbance
- use mouse to move concentration slider to simulate varying concentration
- the effect of wave length on absorbance: select "variable" radio button on wave length panel, then simulate the absorption spectrum by using mouse to move the wave length slider from the far right to the left.
- select Co(NO3)2 in solution drop-down menu
- select K2CrO4 in solution drop-down menu
- qualitatively, sketch / label absorption spectrum for Co(NO3)2 and K2CrO4. how does the spectrum differ / similar ?
- what is the relationship between the solution's color and color of the incident light ? what is the rationale / basis of this relationship ?
2. briefly, describe the following [6 points; 2 points / item]
Beer's law; include relationship between absorption and % transmission
standard or calibration curve, and its application / use
3. run Beer's law simulation; include screen shot of completed simulation (i.e. your screen shot shows the filled-in standard curve, intensity of the unknown sample, & your calculations to determine [unknown]). trouble-shooting FAQ. [5 points]
4. sketch a data table (i.e. not calculations) for this lab containing entries for all required experimental measurements (i.e. review purpose & content of lab report) [4 points]
5. spectroscopy [10 points]
a. define / describe spectroscopy;
b. what is the basis of (i) infared, (ii) ultraviolet, and (iii) visble- light spectroscopy as it relates to energy levels associated with bond vibration, molecule rotation, and electrons in the molecule ?
c. what is the use / applications of (i) infared, (ii) ultraviolet, and (iii) visble- light spectroscopy ?
6. describe the syntax / protocol in using MS Excel to generate the calibration curve, i.e. make a graph and find the equation that describes the graph.. as appropriate, include sketches / screen shots to clarify your response and use in-text citation.put a copy of your answer to this question in your lab NB
7. MSDS data on copper (II) nitrate [5 points]
8. review below "methods" section prior to lab; otherwise, you might be "lost" during the lab, since you won't know how to use the colorimeter; because, this issue won't be addressed during the prelab session (due to shorter block period)
generate a standard (or calibration) curve
compare the determination of the concentration of Cu2+ in an unknown sample (range: 25 - 250 mM) using an algebraic- versus graphical- method in conjunction with the preceding calibration curve.
fulfill various aspects of the NGSS science & engineering standards; including computational thinking / (cs) computer science
aqueous solution of copper (II) nitrate
- 250 mM; dilute to generate known [Cu(NO3 )2 ] - to be used to generate the calibration curve
- unknown [Cu(NO3 )2 ]
colorimeter (a "cheap" spectrophotometer)
water; beakers; test tubes; micropipets; tissue paper
methods - use of probe device - record in your lab notebook, since you will use the colorimeter in a subsequent lab [see vodcast (alternative link); may use your smart phone during lab to access the link]. remainder of lab methods = student design.
content of the lab report [36 points]
data analysis [15 points]
figure 1: standard curves using Excel: include all wavelengths, i.e. colors, and equation & R2 value of the "best" color to use in the analysis
figure 2: based on preceding graph, using the "best" color (to analyze the data) and graph paper, do a "free-hand" drawing of the graph
determination of the [Cu2+ ] in your sample - show your work using both methods
- algebraic method: use results of Excel output in figure 1
- graphical method: use graph in figure 2 and draw imaginary lines to connect the value of the absorbance (on the vertical axis) to the graph then to the value of the concentration (on the horizontal axis).
statistical analysis of class data
discussion [9 points]
is there a difference in the determination of [Cu2+ ] using both methods described in the purpose ? Support your conclusion based on statistics
what is the rationale of choosing a specific wavelength of light for your determination of [Cu2+ ] ? [hint: see prelab question 1 in the below cdf based simulation]
rationalize why blue light has the lowest absorbance by the Cu2+ solution
error analysis (in regards to a cuvette containing the sample) [6 points]
how could the presence of fingerprints on the cuvette affect your determination of [Cu(NO3)2] ? elaborate / justify your answer.
when would the volume of the sample in the cuvette affect your determination of [Cu(NO3)2] ? elaborate / justify your answer.
supplemental questions: in regards to figure 1 on p. 26 in the AP chem student lab manual, [6 points]
justify the validity of the equation associated with the figure using Beer's law
if the concentration in the left test tube is 75 µM, then what is the concentration in the right test tube ? justify your answer.
Beer's law: derivation / regression analysis [calculus based presentation]
for Excel 2007 tutorials to analyze the calibration curve, see vodcast (@ lab / stats tab)
spectroscopy: visible / UV ; IR
simulations (requires cdf player plugin): guided inquiry into exploring the considerations to select the wavelength to use in the Beer's law lab.
caveats in using Excel for statistics (optional); e.g.
The risks of using spreadsheets for statistical analysis. 2013. (IBM promo)
On the accuracy of statistical procedures in Mircosoft Excel 2010. 2011.
Using Excel for statistical analysis 2010
Statistical analysis using Microsoft Excel 2008
Using Excel for Statistical Data Analysis - Caveats 2007
counter - point: value of using Excel (optional); e.g.
Bridging the Gap between Instructional and Research Laboratories: Teaching Data Analysis Software Skills through the Manipulation of Original Research Data. 2016
Teaching Fundametnal Skills in Microsoft Excel to First-Year Students in Quantitative Analysis. 2015
Review of Advanced Excel for Scientific Data Analysis; 3rd ed. 2012
JCE articles (optional):
statistics: abstract & text & (original) supplement