Excelets

Developer's Guide to Excelets with links to over 240 interactive spreadsheets including Chemical Excelets, MatSci Excelets, and Astro Excelets plus mathematical modeling - my old PGCC site is down, you can get to a new site, under development: 

https://sites.google.com/view/excelets

A few of my favorite Excelets  (right click and save as Excel file):

Investigating the Height of a Stack of Cookies (good first modeling activity) Excelet Activity (pdf)

Beer's Law Simulator (multivariable simulation and error analysis)   Excelet Activity (pdf)

Chesapeake Bay Inundator Excelet Activity (pdf)

Rulers and Measurement Error Excelet

Looking for online collaboration activities and data pooling ideas done in Google Sheets, see Data Pool in the Cloud  ____________________________________________________________________

New interactive GSheets spreadsheets  (In Google Sheets or Docs - go to File > Make a copy...)

Climate Change Sheetslets - a NEW set exploring climate change concepts!

• The Interactive Features in Google Sheets   NEW   See the interactive features in action, great for first time users    For the GSheet - click here

• The Google Sheets Checkbox This is a "how to" interactive Google Sheets - click here

• Collaborative Crowdsourcing Eye-ball Curve Fitting    On this GSheets spreadsheet, try to fit the line to the data by changing the slope and/or y-intercept (you have editing capability in only the yellow cells)!  

• Histogram Behavior    NEW  Explore the behavior of two histograms, 100 random numbers and the normal distribution     Interactive Google Sheets - click here

• Can a non-linear system appear to be a linear system?     Explores the behavior of the quadratic and exponential decay functions       Interactive Google Sheets - click here

• Is this data really linear?   Examines data with and without curvature, introduces residuals to examine goodness-of-fit, and addresses influence of random error        Interactive Google Sheets with data analysis - click here

• Investigating Types of Errors   NEW    Examines systematic and random errors        Interactive Google Sheets - click here       Revision of Excelet that goes with paper - click here

• Exploring the Behavior of Main Sequence Stars    Takes a data analysis tour of variables considered for main sequence stars Interactive Google Sheets - click here

• Moving Average - A Data Smoothing Method     Explores the moving average as a method of reducing noise or scatter in data  Interactive Google Sheets - click here

• Moving Average II - Set it up yourself    NEW    Examines doing the moving average in the spreadsheet without using the trendline option Interactive Google Sheets - click here

• Standard Deviation of the...     Explores the running standard deviation of the sample and population of 200 randomly generated numbers.   Interactive Google Sheets - click here

• Desmos' Penny Circle Activity:  Enhanced Analysis     Extends the analysis of the Penny Circle activity by Desmos.  Interactive Google Sheets - click here Desmos’ Penny Circle Activity:  Enhanced Analysis and Data Pooling (GDoc) - click here       Desmos’ Penny Circle Activity:  Get Packing (GDoc) - click here

• Desmos' Penny Circle Activity II:  Data Pooling     Examine and discuss the variation of class data    Interactive Google Sheets - click here

• Inscribing a circle in a square in a circle in a square    Some fun with circles and squares plus a little basic geometry    Interactive Google Sheets - click here

• Translation of Data     Examines horizontal and vertical translations of data for linear systems   Interactive Google Sheets - click here

• Folding a Ribbon in Half:  The Half-life Concept      An introduction to half-life using the (1/2)^n idea    Interactive Google Sheets - click here

• Radioisotope Thermoelectric Generator (RTG):  Using Radioactive Decay Heat to Generate Electrical Power      GDoc activity - click here        Interactive Google Sheets - click here    

• Radioisotope Thermoelectric Generator: II  Examining Thermal Power over Time and Radioisotope Selection    GDoc activity - click here Interactive Google Sheets - click here

• Discovering Beer’s Law by a Simulation-based Laboratory with links to all spreadsheets and docs needed and a video for students on how to use the PhET sim used - click here  (from PhET)    Pairs well with the Beer's Law Simulator (see above) as follow up!

• Calibration of a Plastic Pilsner Glass GDoc activity - click here Interactive Google Sheets - click here

• Approaching Equilibrium from the Forward and Backward Directions Interactive Google Sheets - click here

• Making Predictions   ...and Your Model is Evolving or Changing! Interactive Google Sheets - click here

• The Radioactive Decay of Potassium-40 (branching decay) Interactive Google Sheets - click here

• The Influence of the Half-life of Carbon-14 on Age Determination   (how half-life influences age) Interactive Google Sheets - click here

• How does Sample Contamination Influence the Carbon-14 Age    (conceptual & graphical approach) Interactive Google Sheets - click here

• How can you detect a mixture of radioisotopes? Interactive Google Sheets - click here

• Building a Multivariable Model for Planetary Temperature and Examining the Error updated Interactive Google Sheets - click here

• Build an Oreo Cookie from its Components:  Regular, Thins, Double-stuf, Mega-stuf, or Triple Double-stuf Oreo    (shows multivariable approach) Interactive Google Sheets - click here

• Modeling Population Growth   Interactive Google Sheets - click here

• Determining the Volume of a Tumor Measuring M&M peanut candies, serving as similar-sized tumor surrogates   Interactive Google Sheets - click here

• Determining the Volume of a Tumor II:  Computation and Compression Interactive Google Sheets - click here