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

    626

    views

    345

    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

    4300

    views

    1681

    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

    2835

    views

    1279

    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

    1222

    views

    849

    downloads

    0

    comments

    0

    adaptations

    Comparing Primary and Secondary Forest in a Preserve in Plano Texas: A Forest Ecology Course-based Undergraduate Research Experience (CURE) for Non-Majors and Lower-Level Majors
    An activity that can be conducted as an online or field exercise in which students develop and test their hypotheses about how forest stand characteristics differ between two forest types.

    Keywords: forest ecologyecologycourse-based undergraduate research experienceUsing Excel

    2036

    views

    621

    downloads

    4

    comments

    0

    adaptations

    Cleaning Biodiversity Data: Excel
    Access and clean an open source polar bear dataset using Excel.

    Keywords: data in the classroombiodiversity informaticsData cleaning

    2802

    views

    992

    downloads

    0

    comments

    1

    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

    694

    views

    878

    downloads

    0

    comments

    0

    adaptations

    The nose knows: How tri-trophic interactions and natural history shape bird foraging behavior. An introduction to statistical analysis in animal behavior research
    Students investigate the role of olfaction and infochemicals on bird foraging behavior through two different quantitative activities where they generate hypotheses, create figures, conduct data...

    Keywords: Resources @ ESA - TIEEforagingfmnanimal behaviorbehavioral ecologyDIGtrophic cascades

    1652

    views

    2377

    downloads

    0

    comments

    0

    adaptations

    COVID-19 educational module | Department of Mathematics
    This resource is a module you can use to teach your students the basics of epidemic behavior using a model geared specifically to Covid-19. Students can address key questions using pre-designed...
    1115

    views

    441

    downloads

    0

    comments

    0

    adaptations

    Examining human impacts on tusk evolution in elephants using authentic research data
    In this activity students explore and analyze real, authentic research data paired with HHMI’s “Selection for Tuskless Elephants” video in a hands-on investigation of human impacts on elephant...
    2589

    views

    5382

    downloads

    0

    comments

    1

    adaptations

    Kinetics of a Highly Conserved Enzyme - Carbonic Anhydrase
    This module contains exercises designed to introduce students to graphical representation of biological data. Students will explore the fundamental principles of enzyme kinetics including...

    Keywords: Excelintroductory biologycell biologygraphingslopeQuantitative reasoningdata visualizationquantitative biologyinterdisciplaryquantitative skillscorrelationenzyme functionInterpreting GraphsMichaelis-Mentenenzyme kineticsEnzyme activityenzyme inhibitionLinear and nonlinear analysisNIQBC2. Data and GraphsC4. mathematical modelsenzyme-substrateNIQB Interdisciplinary Quantitative Reasoningcarbonic anhydrase

    137

    views

    244

    downloads

    0

    comments

    0

    adaptations

    The Edge Effect
    This module has students venturing outdoors to take a 50m transect and collect abundance data on plants utilizing quadrats in both edge and interior environment. Mathematically the goals of this...

    Keywords: statisticsecologydata analysisExcelintroductory biologygraphingp-valuest-testsQuantitative reasoninghypothesis testingsample sizestatistical testsinterdisciplinarystatistical analysisCommunity Ecologyspecies diversityvariationdiversity indexvinterpret dataNIQBShannon diversity indexC3. Statistical AnalysisC6. Quantitative Languageedge effect

    566

    views

    434

    downloads

    0

    comments

    0

    adaptations

    Quantifying Bacterial Growth in the Guts and Hemolymph of Fruit Flies: Mathematical Modeling and Data Interpolation/Extrapolation
    In this activity, students will analyze raw data obtained from an experiment that explores the effect of overexpressing the Ssk protein in order to strengthen the intestinal barrier and prevent...

    Keywords: graphingexponential growthlinear modelsqbccinterpolationConcepts in Statistics and Precalculus Understanding exponential rates and linear slopesExtrapolation

    2098

    views

    351

    downloads

    0

    comments

    0

    adaptations

    Flow regime and the National Ecological Observatory Network (NEON) wadeable stream sites
    This resource uses discharge data from three of NEON's wadeable stream sites to illustrate how streams can differ in their flow regimes using graphical analysis of annual hydrographs.

    Keywords: NEONstreamsstreamflow

    132

    views

    23

    downloads

    0

    comments

    0

    adaptations

    Using Regression Models to Examine the Effect of Carbon Dioxide on Fluid pH
    In this activity students will use statistics and regression models to explore the effects of carbon dioxide on blood pH by measuring pH changes that occur over time as carbon dioxide reacts with...

    Keywords: BiochemistryphysiologyAnatomyGeneral BiologyChoosing modelsCreate graphsInterpret graphsConcepts in Statisticscreate modelsmake predictions

    402

    views

    148

    downloads

    0

    comments

    0

    adaptations

    Graphing and mapping patterns of air quality in Los Angeles, California through an environmental justice lens.
    Air quality is an environmental issue that impacts everyone in Los Angeles. This activity presents current popular press articles about air pollution and environmental justice and maps and graphs...
    1670

    views

    739

    downloads

    0

    comments

    0

    adaptations

    Understanding Fish Habitat Selection Using Snorkel Surveys
    Identifying the habitat selection patterns of aquatic species is necessary for protecting threatened and endangered native fishes, as well as for producing satisfying and exciting sport fisheries....

    Keywords: fishfisheriesstreamshabitatRiver Field Studies NetworkResource Selection

    428

    views

    352

    downloads

    0

    comments

    0

    adaptations

    Mosquito Vector Ecology of the East Coast using NEON
    This data module examines the relationship between mosquito vector ecology and climate across the east coast of the United States. The module is designed to merge core concepts in ecology with...
    1548

    views

    3833

    downloads

    0

    comments

    0

    adaptations

    Investigating Evidence for Climate Change (Project EDDIE)
    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.

    Keywords: Excelclimate changeGlobal Temperature Changeco2ice core data

    1590

    views

    906

    downloads

    0

    comments

    1

    adaptations

    Modification of "The Effect of Climate Change on Butterfly Phenology" module by Linton et al.
    This is a modification of the Linton et al. module in TIEE Volume 13. Students use data from digitized museum records of butterfly specimens in a modification with no homework (lab/workshop format)...

    Keywords: ExcelResources @ ESA - TIEEclimate changefmnphenologynatural history collectionsDIGbutterflyinterspecific interactions

    1992

    views

    1737

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search