Embedded Files
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 (sea level change) Excelet Activity (pdf)
Rulers and Measurement Error (errors & more errors!) 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)!
A Graphical Exploration of Periodic Trends NEW Investigate the behavior of a variety of properties for groups and periods on the periodic table of elements Student tasks are stated on each tab Interactive Google Sheets - click here
The Faint Young Sun Problem NEW Investigates the luminosity of the Sun over time Interactive Google Sheets - click here
What is pH? A measure of how acidic or basic a solution is NEW A basic introduction to pH Interactive Google Sheets - click here
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 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 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
Page updated
Google Sites
Report abuse