You are here: Home / Resources / Browse Resources

Open. Adaptable. Free.

Resources created by our members and partners.

The QUBES platform hosts hundreds of teaching materials, reference materials, and cloud-based software free to use and adapt using open Creative Commons licenses.

Text Search:
Applied Filters
    REMNet Tutorial, Excel Part 3: Organizing Your Microbiome Data 5.3.19
    Video on organizing microbiome using Excel from the Research Experiences in Microbiomes Network

    Keywords: ExcelVideoMicrobiology Educationmicrobiomesresearch in the classroomREMNeturban microbiomes

    1229

    views

    652

    downloads

    0

    comments

    0

    adaptations

    MS Excel Refresher - Lizards, iguanas, and snakes! Oh my! | Data Nuggets
    This resource, a MS Excel refresher, extends the level for this Data Nugget. Students are given an Excel workbook with the data and asked to graph and calculate diversity using Excel functions...

    Keywords: Resources @ Data NuggetsspreadsheetsRestoration EcologyUsing Excelgraphing in Excelformulas in ExcelApplied ecology

    584

    views

    314

    downloads

    0

    comments

    0

    adaptations

    ABO Blood Group Frequencies
    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...

    Keywords: Hardy-Weinbergblood type frequencies

    1450

    views

    293

    downloads

    0

    comments

    0

    adaptations

    Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel
    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...

    Keywords: statisticsecologydataExcelgraphingBiochemistryOceanographymarine ecosystemsmarine ecologydescriptive statisticslong-term datasetsmarineMicrosoft Excelmarine biologyplanktonOutliersMarine ScienceqbccUsing ExcelphytoplanktonCreate graphsInterpret graphsConcepts in Statisticslarge datasetexplaining statisticsusing statisticsPacific NorthwestSalish Seaprimary productivitywater chemistryestuarygraphing in Excelformulas in Excelchlorophylltime-series plotsocean

    512

    views

    691

    downloads

    0

    comments

    0

    adaptations

    Exploring Marine Primary Productivity with Descriptive Statistics and Graphing in Excel
    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...

    Keywords: statisticsecologydataExcelgraphingBiochemistryOceanographymarine ecosystemsmarine ecologydescriptive statisticslong-term datasetsmarineMicrosoft Excelmarine biologyplanktonOutliersMarine ScienceqbccUsing ExcelphytoplanktonCreate graphsInterpret graphsConcepts in Statisticslarge datasetexplaining statisticsusing statisticsPacific NorthwestSalish Seaprimary productivitywater chemistryestuarygraphing in Excelformulas in Excelchlorophylltime-series plotsocean

    1273

    views

    1268

    downloads

    0

    comments

    1

    adaptations

    Island Biogeography
    This Excel workbook demonstrates the principles of the MacArthur-Wilson theory of Island Biogeography. It allows the user to define the mainland species pool, area of the island, and distance of...

    Keywords: Logarithmsspecies richnessIsland biogeographyExponential FunctionsMacArthur-Wilson Theorypower functions

    45

    views

    6

    downloads

    0

    comments

    0

    adaptations

    LearnR Apps
    Presentation on using the LearnR software in teaching. Presented at the 2021 BIOME Institute

    Keywords: mathematicsRStudioformulascomputer programming2021 BIOMEparson's problems

    801

    views

    440

    downloads

    0

    comments

    0

    adaptations

    RAT ATTACK! Population growth
    This module contains exercises focused on the use and interpretation of density independent and density dependent population growth models. Students build logistic and exponential growth models in...

    Keywords: modelingecologyExcelintroductory biologygraphingQuantitative reasoningdata visualizationinterdisciplinaryexponential growthlogistic growthdata managementInterpreting Graphspopulation modelingNIQBC2. Data and GraphsC4. mathematical modelsnonlinear models

    607

    views

    736

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 6: Making Microbiome Column Charts 5.3.19
    Video on creating column charts in Excel from the Research Experiences in Microbiomes Network

    Keywords: ExcelVideoMicrobiology Educationmicrobiomesresearch in the classroomREMNeturban microbiomes

    1148

    views

    419

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 5: Making Heat Maps 4.26.19
    Video on making heat maps in Excel from the Research Experiences in Microbiomes Network

    Keywords: ExcelVideoMicrobiology EducationMicrobiome researchresearch in the classroomREMNeturban microbiome

    1050

    views

    365

    downloads

    0

    comments

    0

    adaptations

    Critical Zone Science Part II
    As part of our effort to model the redwood forest water budget, we used the InTeGrate Unit 5.2 to put numbers to pathways.
    995

    views

    153

    downloads

    0

    comments

    0

    adaptations

    Promoting Climate Change Literacy for Non-majors: Implementation of an atmospheric carbon dioxide modeling activity as an inquiry-based classroom activity
    Students who are directly involved in scientific activities develop a deeper understanding and appreciation of both scientific knowledge and the scientific process. This understanding is critically...

    Keywords: modelingExcelquantitativeclimate changeEnvironmental Biologyatmospheric carbon dioxide

    1457

    views

    289

    downloads

    0

    comments

    0

    adaptations

    BioGrapher
    BioGrapher is an Excel front-end for the AT&T GraphViz graphical visualization and layout package (http://www.graphviz.org/).

    Keywords: network theorygraph theoryphylogenetic trees

    576

    views

    21

    downloads

    0

    comments

    0

    adaptations

    Operon
    This Excel workbook models lac operon function in a partial diploid E. coli. The user chooses the bacterial genotype and the sugars present in the surrounding medium: the workbook then determines...

    Keywords: Lac OperonE. coli

    35

    views

    4

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 4: Focusing on Taxonomy 4.26.19
    Video on analyzing microbiome data in Excel from the Research Experiences in Microbiomes Network

    Keywords: The Analysis of Biological DataExcelVideoMicrobiology Educationteaching with technologymicrobiomesSwirlresearch in the classroomREMNeturban microbiomes

    1174

    views

    801

    downloads

    0

    comments

    0

    adaptations

    Linear Regression (Excel) and Cellular Respiration for Biology, Chemistry and Mathematics
    Students typically find linear regression analysis of data sets in a biology classroom challenging. These activities could be used in a Biology, Chemistry, Mathematics, or Statistics course. The...

    Keywords: statisticsmathematicsdata analysisdatalinear regressionbiologyonlinegraphinglinear equationsQuantitative reasoningassessmentcollege algebracellstatistical analysisregressionOERAlgebrachemistryModelscorrelationSimple Linear RegressionMicrosoft Excellab activityexperimentCellular ProcessesATPqbccUsing Excelmanipulate equationsCellular and Molecular BiologyConcepts in Statisticsoxidationline of best fitexplaining statisticsusing statisticsCellular RespirationPredictionsRespirationgraphing in ExcelLinear CorrelationExothermic Reactioncreate scatter plotAdenosine Triphosphate (ATP)germinating peasPre-lab activityStudent activityHybridCollecting DataR-squareRegression ModelFunctionDependent VariablesIndependent VariablesLinear EquationLinear Equation in two variablescreate graphcreate equationcreate regressioncreate plotinterpret regressioninterpret data

    4075

    views

    1487

    downloads

    0

    comments

    0

    adaptations

    A first lesson in mathematical modeling for biologists: Rocs
    Using a fictitious population of Rocs, a mythical species of giant raptor, students accomplish two broad objectives: 1) they undertake the process of building a first mathematical model of a...

    Keywords: population ecologypopulation modelingdiscrete generationpopulation management

    1229

    views

    345

    downloads

    0

    comments

    0

    adaptations

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

    Keywords: ExcelSpreadsheet

    117

    views

    46

    downloads

    0

    comments

    0

    adaptations

    Biological Cellular Automata Laboratory (BioCA Lab)
    This Excel module includes both linear cellular automata and 2D cellular automata. The original 3 rules for survival, death, and birth are implemented in this module, but users with some Excel...

    Keywords: cellular automata

    53

    views

    6

    downloads

    0

    comments

    0

    adaptations

    javaFOODWEB
    More than 100 food web matrices (multiple predators/prey Excel worksheets) are included with the javaFOODWEB tool.

    Keywords: niche spacesCommunity Ecologyfood webspredator-prey interactionsMatricestrophic chain

    47

    views

    16

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search