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

    1915

    views

    342

    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

    1775

    views

    466

    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

    1329

    views

    394

    downloads

    0

    comments

    0

    adaptations

    Testing for Hardy-Weinberg Equilibrium
    Numbers Count Excel resource
    1023

    views

    478

    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

    3071

    views

    1537

    downloads

    0

    comments

    0

    adaptations

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

    views

    352

    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

    127

    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

    242

    views

    468

    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

    119

    views

    80

    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

    480

    views

    279

    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

    389

    views

    468

    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

    1754

    views

    1916

    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

    1325

    views

    407

    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

    1175

    views

    344

    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

    1335

    views

    387

    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

    1710

    views

    454

    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

    1475

    views

    139

    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

    176

    views

    39

    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

    1437

    views

    295

    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

    1660

    views

    827

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search