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
    Spreadsheet Data Analysis Tutorial Series
    This series of self-paced tutorials show how to analyze data using a spreadsheet program.

    Keywords: Resources @ HHMI - BioInteractiveScientific ProcessStatistics and MathScientific MethodologyHigh School

    1930

    views

    346

    downloads

    0

    comments

    6

    adaptations

    Spreadsheet Tutorial 1 -- Formulae, Functions, and Averages | HHMI BioInteractive
    This introduction to spreadsheet programs describes the basic organization of a worksheet, how to organize and format your data, how to perform simple mathematical calculations, how to use built-in...

    Keywords: Resources @ HHMI - BioInteractivesummary statisticsScientific ProcessScientific MethodologyHigh School

    1788

    views

    467

    downloads

    0

    comments

    1

    adaptations

    Spreadsheet Tutorial 5: Histogram
    Generate a histogram using a variety of methods.

    Keywords: Resources @ HHMI - BioInteractiveScientific ProcessStatistics and MathScientific MethodologyHigh School

    1344

    views

    397

    downloads

    0

    comments

    0

    adaptations

    Testing for Hardy-Weinberg Equilibrium
    Numbers Count Excel resource
    1027

    views

    484

    downloads

    0

    comments

    0

    adaptations

    More In Depth Spreadsheet Management Adaptation of Data Management using NEON Small Mammal Data
    This adaptation consists of three exercises that introduce students to 1) format spreadsheet data tables, 2) carry out spreadsheet quality control, and 3) count/sort/filter data of interest in...

    Keywords: data managementspreadsheetsmammalsCapture mark-recapture

    3083

    views

    1552

    downloads

    0

    comments

    0

    adaptations

    UDL Guidelines Workbook
    A tool for analyzing a resource's alignment to CAST's Universal Design for Learning Guidelines
    1186

    views

    357

    downloads

    1

    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

    130

    views

    52

    downloads

    0

    comments

    0

    adaptations

    3-004-VanderPol-ModelingScenario
    This paper presents an electronic spreadsheet model of the Van der Pol oscillator, a well-known nonlinear second-order ordinary differential equation.

    Keywords: phase planeVan der Pol oscillatorlimit cycleRunge-Kutta methodLienard equation

    245

    views

    473

    downloads

    0

    comments

    0

    adaptations

    Database Construction and Sampling
    Creating your own database is an excellent way for students to learn the trials and tribulations of data collection and management. Construction of three simple databases using a spreadsheet is...

    Keywords: databasesdata managementdata collectiondata ethicsdata integrity

    123

    views

    81

    downloads

    0

    comments

    0

    adaptations

    Developing a community resource to find and share summer Research Experience for Undergraduates (REU) opportunities
    Instructors can use this module to introduce students to searching for and identifying summer Research Experiences for Undergraduates (REU) online, with a focus on National Science Foundation (NSF)...

    Keywords: Resources @ NSF - NCCSTSecology labField researchREUresearch experience for undergraduatesfield ecology

    481

    views

    281

    downloads

    0

    comments

    0

    adaptations

    6-068-VisualizingPredator-PreyCycles
    In this modeling scenario, we propose a gentle introduction to limit cycles using nullcline analysis and a spreadsheet graphical approach via the fourth-order Runge-Kutta method. We will be...

    Keywords: nullclinespredator-preyGeometrypredatorRunge-Kuttapreylimit cycle

    396

    views

    493

    downloads

    0

    comments

    0

    adaptations

    Working with spreadsheet-style data in Python with pandas and seaborn
    This 4-hour participatory live-coding workshop takes learners through the basics of programming in Python via the Jupyter Lab interface and culminates with exploration and visualization of...

    Keywords: datapythonopenSpreadsheetbicylepandasseabornmatplotlib

    1761

    views

    2007

    downloads

    0

    comments

    0

    adaptations

    Math and Stats in the Biology Classroom with HHMI BioInteractive
    Conquer basic math and statistics used in biology while exploring classroom-ready resources. Concepts include central tendency and variation, spreadsheet skills, graphing, and data analysis with...

    Keywords: HHMI BioInteractive

    1331

    views

    411

    downloads

    0

    comments

    0

    adaptations

    Spreadsheet Tutorial 4: t-Test
    Calculate t-values and perform t-tests using built-in functions.

    Keywords: Resources @ HHMI - BioInteractiveScientific ProcessStatistics and MathScientific Methodology

    1178

    views

    350

    downloads

    0

    comments

    0

    adaptations

    Spreadsheet Tutorial 3 - Column Graphs, Error Bars, and Standard Error of the Mean
    Generate a column or bar graph with standard error bars.

    Keywords: Resources @ HHMI - BioInteractiveScientific ProcessStatistics and MathScientific MethodologyHigh School

    1342

    views

    391

    downloads

    0

    comments

    0

    adaptations

    Spreadsheet Tutorial 2 - Autofill Data, Cell References, and Standard Deviation
    Generate a table with autofill, and use absolute cell reference to calculate variance and standard deviation.

    Keywords: Resources @ HHMI - BioInteractiveScientific ProcessStatistics and MathScientific MethodologyHigh School

    1713

    views

    463

    downloads

    0

    comments

    0

    adaptations

    The Magic of Doctopus: A quick and easy way to deliver pre-named, pre-shared Google documents directly to your students’ Google drive
    Cloud-based applications, such as Google Docs, enable authors to collaboratively write and edit documents, spreadsheets, and other products.  Such collaborations can provide powerful learning...

    Keywords: metacognitiontechnologyGoogle Doc

    1492

    views

    143

    downloads

    0

    comments

    0

    adaptations

    2022-Kalman-Improved Approaches Discrete Continuous Logistic Equation
    In the precalculus curriculum, logistic growth generally appears in either a discrete or continuous setting. These actually feature distinct versions of logistic growth, and textbooks rarely...

    Keywords: logisticcontinuousSpreadsheetPrecalculusdiscrete

    180

    views

    41

    downloads

    0

    comments

    0

    adaptations

    Modules Ready or Adaptable for Online Learning: Google Sheet
    A dynamic database of modules discoverable on QUBES that are ready or adaptable for online learning. Anyone can use or contribute to this database.

    Keywords: modulesWorksheet

    1447

    views

    298

    downloads

    0

    comments

    0

    adaptations

    Spreadsheet Tutorial 1: Adapted to Anatomy and Physiology
    Adapted the examples to Anatomy and Physiology relevant topics and implemented in BIO165L Anatomy and Physiology I Laboratory for non-majors.

    Keywords: Resources @ HHMI - BioInteractivesummary statisticsScientific ProcessScientific Methodology

    1664

    views

    830

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search