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

    1951

    views

    353

    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

    1817

    views

    478

    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

    1375

    views

    407

    downloads

    0

    comments

    0

    adaptations

    Testing for Hardy-Weinberg Equilibrium
    Numbers Count Excel resource
    1036

    views

    488

    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

    3119

    views

    1590

    downloads

    0

    comments

    0

    adaptations

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

    views

    368

    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

    143

    views

    56

    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

    252

    views

    500

    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

    140

    views

    97

    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

    494

    views

    288

    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

    417

    views

    517

    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

    1803

    views

    2190

    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

    1356

    views

    418

    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

    1190

    views

    360

    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

    1368

    views

    415

    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

    1728

    views

    472

    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

    1531

    views

    146

    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

    191

    views

    42

    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

    1470

    views

    304

    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

    1685

    views

    856

    downloads

    0

    comments

    0

    adaptations

    Close

    Home

    Search