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

    1178

    views

    630

    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

    560

    views

    299

    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-WeinbergExcelResources @ ESTEEMblood type frequencies

    1389

    views

    278

    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

    480

    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

    1236

    views

    1194

    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

    788

    views

    435

    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

    578

    views

    625

    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

    1113

    views

    392

    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

    1017

    views

    344

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

    views

    143

    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

    1431

    views

    286

    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

    1133

    views

    766

    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

    1198

    views

    333

    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

    3952

    views

    1398

    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

    106

    views

    42

    downloads

    0

    comments

    0

    adaptations

    1-137-SheepGraze-ModelingScenario
    In this activity, students will apply graphical analysis (such as phase lines) to determine the long-term predictions of a differential equation model for pasture grass using two different formulas...

    Keywords: herbivoreplantphase linesbifurcationoverexploitationsheepgraze

    186

    views

    183

    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
    888

    views

    357

    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

    1489

    views

    215

    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

    2485

    views

    1106

    downloads

    0

    comments

    0

    adaptations

    Global Temperature Change in the 21st Century: An Introduction to Global Climate Models and Graphing in Excel (Adapted for Non-Majors)
    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...

    Keywords: ExcelResources @ ESA - TIEEecology labclimate changeenvironmental scienceglobal changehuman-environmental interactionsSimple Linear Regressionhuman impactsinclusive pedagogy-FMN

    1236

    views

    1503

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search