Online Lectures (PodCasts) under Labs for CHM2

Labs for CHM2

Laboratory Lectures and Tutorials

Dr. Stephen Lukacs (February 2023)

Laboratory lectures and tutorials for General Chemistry 2

Evaluation of pH Titration Profiles using Excel

(February 2023) A Microsoft Excel tutorial for processing and evaluating the raw pH titration data to interpolate and determine the endpoint of the titration to 4 significant figures. Some details on creating a formal proper graph of the data are also presented including chart and axis titles.

Media Unavailable
Login or Register to Watch this Online Lecture

pH Titration Workbook for the latter PodCast

(February 2023) The Microsoft Excel Workbook for processing and evaluating the raw pH titration data to determine the endpoint of the titration.

Media Unavailable
Login or Register to Watch this Online Lecture

Excel Evaluation of Conductivity Titrations

(February 2023) A Microsoft Excel tutorial for processing and evaluating the raw conductivity/conductance titration data to interpolate and determine the endpoint of the titration to 4 significant figures. This is using the advanced LINEST function for an x3/2 polynomial linear fit to the raw data with 3 parameter, a, b, and c, output and using GOALSEEK to numerically determine the intersection of the two fits.

Media Unavailable
Login or Register to Watch this Online Lecture

Conductance Titration Worksheet for the Above

(February 2023) The Microsoft Excel Workbook for processing and evaluating the raw conductance titration data to determine the endpoint of the titration.

Media Unavailable
Login or Register to Watch this Online Lecture