Tags: Excel

All Categories (1-20 of 43)

  1. 2008-Ahmed_Mohameden-Solving initial-value second order ordinary differential equations on an Excel spreadsheet

    06 Apr 2023 | Teaching Materials | Contributor(s):

    By Ahmed Mohameden

    NA

    This paper presents a friendly method of solving initial-value second order differential equations (DEs) analytically on a MS Excel© workbook.

    https://qubeshub.org/publications/4009/?v=1

  2. ABO Blood Group Frequencies

    14 Jan 2015 | | Contributor(s):: John R. Jungck, Jennifer A. Spangenberg

    This resource has been updated - find the current version here: https://qubeshub.org/qubesresources/publications/756An Excel workbook in which students can calculate blood type frequencies through different approaches (Hardy-Weinberg, quadratic formula, and the EM algorithm).  The...

  3. ABO Blood Group Frequencies

    11 Sep 2018 | Teaching Materials | Contributor(s):

    By John R Jungck1, Jennifer A. Spangenberg2

    1. Interdisciplinary Science Learning Center at the University of Delaware 2. Beloit College

    An Excel workbook in which students can calculate blood type frequencies through different approaches (Hardy-Weinberg, quadratic formula, and the EM algorithm). The workbook shows the formulas used...

    https://qubeshub.org/publications/756/?v=1

  4. Birthday Problem and Class Phenotypic Probabilities

    13 Jan 2015 | | Contributor(s):: John R. Jungck, Annelise L. Myers, Jennifer A. Spangenberg

    This resource has been updated - find the current version here: https://qubeshub.org/qubesresources/publications/774An Excel sheet that allows students to input class data about various phenotypic features and then calculates the probability of other people having the same...

  5. Birthday Problem and Class Phenotypic Probabilities

    11 Sep 2018 | Teaching Materials | Contributor(s):

    By John R Jungck1, Jennifer Spangenberg2, Annelise L. Myers2

    1. Interdisciplinary Science Learning Center at the University of Delaware 2. Beloit College

    An Excel workbook exploring two related applications, the Birthday Problem and Class Phenotypic Probabilities. Students enter their own phenotypes into the workbook.

    https://qubeshub.org/publications/774/?v=1

  6. Cleaning Biodiversity Data: A Botanical Example Using Excel or RStudio

    16 Jul 2020 | Teaching Materials | Contributor(s):

    By Michelle Gaynor

    University of Florida

    Access and clean an open source herbarium dataset using Excel or RStudio.

    https://qubeshub.org/publications/1964/?v=1

  7. Confidence Intervals Tutorial

    23 Aug 2018 | Teaching Materials | Contributor(s):

    By Claudia Neuhauser1, David Phillip Schladt1

    University of Minnesota

    Numbers Count Excel resource

    https://qubeshub.org/publications/754/?v=1

  8. Confidence Intervals Tutorial

    09 Sep 2019 | Teaching Materials | Contributor(s):

    By Claudia Neuhauser1, David Phillip Schladt2

    1. University of Houston 2. University of Minnesota

    Numbers Count Excel resource

    https://qubeshub.org/publications/754/?v=2

  9. Decoding, Critiquing, and Creating a Graph from the Ground Up

    28 Feb 2018 | Teaching Materials | Contributor(s):

    By Kiersten Nicole Newtoff1, HHMI BioInteractive

    Montgomery College

    Students decipher a published graph with little supplemental information and are given more details in pieces before producing a new graph that displays the data more effectively and is easier to...

    https://qubeshub.org/publications/376/?v=1

  10. ESTEEM Session materials

    Collections | 14 Jun 2017 | Posted by Anton E Weisstein

    https://qubeshub.org/community/groups/summer2017/collections/resources-for-monday-sessions

  11. ESTEEM Session materials

    Collections | 07 May 2018 | Posted by Hayley Orndorf

    https://qubeshub.org/community/groups/summer2018/collections/resources-for-tuesday-sessions

  12. EvolSeq

    11 Sep 2018 | Teaching Materials | Contributor(s):

    By Tony Weisstein1, John R Jungck2

    1. Truman State University 2. Interdisciplinary Science Learning Center at the University of Delaware

    An Excel worksheet that simulates the molecular evolution of DNA sequences.

    https://qubeshub.org/publications/776/?v=1

  13. Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel

    02 Sep 2021 | Teaching Materials | Contributor(s):

    By Marina McLeod1, Jennifer Olson1, Wendy Houston1

    Everett Community College

    In this activity, students use real water chemistry data and descriptive statistics in Excel to examine primary productivity in an urban estuary of the Salish Sea. They will consider how actual...

    https://qubeshub.org/publications/2747/?v=1

  14. Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel

    29 Jan 2023 | Teaching Materials | Contributor(s):

    By Kristin Byrd

    Tarrant County College

    In this activity, students use real water chemistry data and descriptive statistics in Excel to examine primary productivity in an urban estuary of the Salish Sea. They will consider how actual...

    https://qubeshub.org/publications/3643/?v=1

  15. Global Temperature Change in the 21st Century: An Introduction to Global Climate Models and Graphing in Excel (Adapted for Non-Majors)

    28 May 2020 | Teaching Materials | Contributor(s):

    By Tamara Basham

    Collin County Commuity College District

    Students link human behavior in various climate change scenarios to predicted temperature outcomes at both local (their assigned Latitude) and global (Latitudinal trends) scales. This adaptation is...

    https://qubeshub.org/publications/1865/?v=1

  16. Introduction to Stochastic Modeling

    Collections | 11 Jul 2017 | Posted by Anton E Weisstein

    https://qubeshub.org/community/groups/summer2017/collections/resources-for-monday-sessions

  17. Investigating Evidence for Climate Change (Project EDDIE)

    18 Feb 2020 | Teaching Materials | Contributor(s):

    By Melissa Hage

    Oxford College of Emory University

    This multi-part activity allows students to discover the relationships between CO2 and temperature and how these variables have changed over time using real-world data.

    https://qubeshub.org/publications/1756/?v=1

  18. Island Biogeography Regression

    Collections | 09 Jun 2017 | Posted by Anton E Weisstein

    https://qubeshub.org/community/members/1514/collections/esteem-materials

  19. Luria-Delbruck

    11 Sep 2018 | Teaching Materials | Contributor(s):

    By Tony Weisstein1, John R Jungck2, Doug Green3

    1. Truman State University 2. Interdisciplinary Science Learning Center at the University of Delaware 3. Saint Michael's College

    These two workbooks model the evolution of phage resistance in a bacterial population under two alternative hypotheses.

    https://qubeshub.org/publications/777/?v=1

  20. Michaelis-Menten Enzyme Kinetics

    11 Sep 2018 | Teaching Materials | Contributor(s):

    By Tony Weisstein

    Truman State University

    In this simulation, equations used in enzyme kinetics (Michaelis-Menten, Eadie-Hofstee, Dixon, and Lineweaver-Burk) are modeled under various conditions.

    https://qubeshub.org/publications/778/?v=1