The subject Calculations in analytical chemistry using MS Excel is focused on complicated calculations in the field of classical and instrumental analytical chemistry.
Particular attention is paid to:
Calculation of chemical equilibrium and equilibrium concentrations of given species.
Construction of distribution diagrams for individual species in the solution (in dependence on pH, amount of added ligand etc.)
Calculations and construction of titration curves and their evaluation using various mathematic methods (including selection of the most suitable indicator).
More complex calculations in the field of instrumental analysis (e.g., peak interferences). Utilization of MS Excel in statistical evaluation of measured data.
MS Excel will be used with particular attention drawn to simulations of various effects on equilibrium concentrations, acid-base behaviour, reaction kinetics, titration curves, distribution diagrams etc. (including graphical illustration, which allows to inspect the studied effects visually).
Particular attention is paid to:
Calculation of chemical equilibrium and equilibrium concentrations of given species.
Construction of distribution diagrams for individual species in the solution (in dependence on pH, amount of added ligand etc.)
Calculations and construction of titration curves and their evaluation using various mathematic methods (including selection of the most suitable indicator).
More complex calculations in the field of instrumental analysis (e.g., peak interferences). Utilization of MS Excel in statistical evaluation of measured data.
MS Excel will be used with particular attention drawn to simulations of various effects on equilibrium concentrations, acid-base behaviour, reaction kinetics, titration curves, distribution diagrams etc. (including graphical illustration, which allows to inspect the studied effects visually).