Materials Contributed through SERC-hosted Projects
Understanding Acid-Base Titrations using Microsoft Excel part of National Numeracy Network:Teaching Resources:Quantitative Writing:Examples
pH is a concept that gives many students difficulty after even several exposures from different perspectives in different classes. In this exercise, students will gain experience with acid-base titrations. Using an Excel spread sheet with embedded graphs, students will be able to carry out model titrations using "virtual" solutions of chosen molarity, visualizing the outcomes as they unfold. The titration exercises will be introduced and described through text that will help students understand the relationships playing out before their eyes.
How Sweet Is Your Tea? -- Practical experience with solutions and concentration part of Spreadsheets Across the Curriculum:General Collection:Examples
This Spreadsheets Across the Curriculum activity is an exercise to introduce the concept of concentration as a ratio as well as the idea of using Excel spreadsheets to solve quantitative problems. Students calculate, first with a calculator, then with an Excel spreadsheet, the amount of solute and solvent required to prepare several simple solutions. They learn to estimate if their calculations are resaonable. At the end of the module, students will have developed an Excel template that will facilitate the calculations for any simple solution.
Calibrating a Pipettor part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum activity. In advance of an actual lab activity, students virtually simulate the calibration of a laboratory micropipettor. QL: Accuracy and precision.