Materials Contributed through SERC-hosted Projects
Serial Dilution: Tracking Bacterial Population Size and Antibiotic Resistance part of Spreadsheets Across the Curriculum:General Collection:Examples
Serial dilution allows estimation of a range of bacterial population sizes. Percent resistance can be calculated by culturing bacteria on both antibiotic-free and antibiotic-containing media and comparing the results. In this Spreadsheet Across the Curriculum module, students explore the quantitative concepts of ratios and percentages and then apply those concepts to build Excel sheets that calculate bacterial population size and percent resistance.