An adapted module from HHMI Spreadsheet Tutorials using amylase data for students to gain data analysis and excel skills
General biology students learn about hydrolysis reactions, role of starch, enzymes, and genes when studying macromolecules. They do not, however, often make connections between the enzymes responsible for hydrolysis and the genes responsible for the production of hydrolytic enzymes. Furthermore, students tend not to appreciate the impact of specific environments on the presence and/or copy number of specific nucleic acids and proteins. This module seeks help students to make these connections while addressing two distinct learning goals, one that is content-based and one that is develops quantitative competency in freshman biology students.
Learning Goals for "Amylase Copy Number and Diet;
- To understand amylase enzyme function and the role the amylase gene copy number might play in conferring a selective advantage for an organism in high-starch and low-starch environments.
- To develop students' science process skills by teaching students how to utilize descriptive statistics such as mean, median, and standard deviation and how to evaluate histograms.
- Amylase_Diet.pptx(PPTX | 143 MB)
- Amylase_Instructor.docx(DOCX | 149 KB)
- Amylase_studenthandoutAnalysis_RO.docx(DOCX | 156 KB)
- Amylase_studenthandoutGenerate_RO.docx(DOCX | 152 KB)
- Bar Chart_Histogram.docx(DOCX | 95 KB)
- Salivary_Amylase_DataBlank.xlsx(XLSX | 13 KB)
- Salivary_Amylase_DataFilled.xlsx(XLSX | 20 KB)
- Spreadsheet Data Analysis Tutorials | HHMI BioInteractive
- Diet and the evolution of human amylase gene copy number variation | Nature Genetics
This introduction to spreadsheet programs describes the basic organization of a worksheet, how to organize and format your data, how to perform simple mathematical calculations, how to use built-in mathematical functions, and how to select and...
Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.
Generate a histogram using a variety of methods.
- License terms
Cite this work
Researchers should cite this work as follows:
Data from Perry, G.H., Dominy, N.J., Claw, K.G., Lee, A.S., Fiegler, H., Redon, R., Werner, J., Villanea, F.A., Mountain, J.L., Misra, R. and Carter, N.P., 2007. Diet and the evolution of human amylase gene copy number variation. Nature genetics, 39(10), pp.1256-1260.
A random number generator in EXCEL was used to select the subsamples from the larger data set that was available in the supplement of the Perry et al. (2007) paper.