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

    1193

    views

    635

    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

    570

    views

    302

    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

    1420

    views

    286

    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

    485

    views

    608

    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

    1244

    views

    1202

    downloads

    0

    comments

    1

    adaptations

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

    Keywords: mathematicsRStudioformulascomputer programming2021 BIOMEparson's problems

    795

    views

    436

    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

    593

    views

    644

    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

    1125

    views

    394

    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

    1027

    views

    347

    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.
    980

    views

    144

    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

    1443

    views

    288

    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

    552

    views

    17

    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

    1142

    views

    776

    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

    3989

    views

    1414

    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

    110

    views

    42

    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

    1211

    views

    338

    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

    23

    views

    4

    downloads

    0

    comments

    0

    adaptations

    REMNet Tutorial, Excel Part 2: Understanding Your Microbiome “Data Summary” Document 4.25.19
    Video on understanding microbiome data from the Research Experiences in Microbiomes Network
    900

    views

    358

    downloads

    0

    comments

    0

    adaptations

    SUMS4Bio - Video tutorials in math and stats for biology students
    Links to videos and pdf tutorials for core mathematical and statistical concepts used in biology

    Keywords: Probabilitystatisticsmathematicsvideoschi-squaredExcelBar Graphsline graphsScatter Plotsp-valuest-testsExponentsLogarithmsproportionsRatiosbinomialdata typessummary statisticsfrequency histogramsResources @ SUMS4BioPresentation

    1513

    views

    217

    downloads

    0

    comments

    0

    adaptations

    Cleaning Biodiversity Data: A Botanical Example Using Excel or RStudio
    Access and clean an open source herbarium dataset using Excel or RStudio.

    Keywords: Exceldata in the classroomRStudiobiodiversity informaticsnatural history collectionsHerbariaData cleaning

    2509

    views

    1111

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search