Developer's Guide to Excelets: Dynamic and Interactive Visualization with "Javaless" Applets

 Examples of Excelets Instructions Mathematical Modeling Assessment Chemical Excelets (for general chemistry) MatSci Excelets (for materials science) Astro Excelets (for intro astronomy)

Excelets
are interactive Excel spreadsheets or simulations of mathematical models.  The user changes a variable and the spreadsheet changes in numerical, graphical, and/or even symbolic form (equations).  Through the use of numerical experimentation and "what if" scenarios, we have a powerful learning tool for students using readily available off-the-shelf software.  All of this is done computationally with no use of programming, no macros or Visual Basics for Applications, VBA.  The use of VBA adds another level of sophistication via programming and also possible security concerns.  An Excelet with or without VBA resembles a "Javaless" applet.  It is assumed that users of this guide are experienced with the use of Excel.  If you need to gain this experience, see Using Excel for Handling, Graphing, and Analyzing Scientific Data:  A Resource for Science and Mathematics Students (2003) to get started.  If you are just converting over to Excel 2007, here is a quick guide to get you started.  What features NOT supported in Excel 2007, click here!  See Dealing with Data in Excel for using Excel 2013/2016 (2010).

Some of the new interactive spreadsheets are done in Google Sheets (very Excel-like), which has great data pooling capabilities, see Data Pool in the Cloud for more information and activities or read Oh Sheets!: A Tool for Online Collaboration in the Cloud. How to add a check box in Google Sheets - click here.

Here are some examples of Excelets in chemistry and mathematics (For best results - right click and then select Save Target As... to download, then open directly in Excel) :

 interactive features tour fractions derivatives flipping pennies box-and-whisker plot (using drag-and-drop of data points) M&M's counting ("just add data", How does your bag compare?) descriptive statistics ("just add data", visual display of variation) calorie calculator (list box and lookup table, "just add data") temperature scales (deriving conversions and inverse functions) Eo vs. EN (data culling using autofilters) potential energy diagram (using drag-and-drop of data points) interactive periodic trends (lots of features for changing graphs) counting coins (coin equivalency, summation, and making change) area and perimeter (comparison for a square and rectangle) The Acceleration Due to Gravity How do you square a binomial? (visualizing by graphing a square and determining area) Pythagorean Theory (two visual geometric proofs) Playing the Genetic Odds! (random numbers, sample size, and error) Area of a ring (concentric circles and setting areas) Orbital Motion (circular and elliptical motion and trig functions) Blackbody Radiation (linear and logarithmic scales) Exploring the Family of Quadratic Functions Shake, Rattle, and Roll… (earthquakes, p & s waves with distance-time & locating epicenters) Pan Water Cycle (systems model) P-V-T Surface Plot (a 3-D surface plot) ideal gas law (activity) radioactive decay (activity) number line (examines adding/subtracting positive/negative integers) Gnomon (a vertical shadow stick and many measurements) Solar System (scaling and habitable zone) Septic Tanks (residence time and pumping) Exploring Relative Humidity (examine the behavior of water vapor in the atmosphere) Classifying Stars (the Hertzsprung-Russell or H-R Diagram) Spectroscopy in Motion (Doppler Effect and measuring velocity in astronomy) How small an impactor can reach the surface of a planet? (parameters that influence) Will the peg fit in the opening? Dynamic Right Triangles Quadratic Equation Root Finder (Google Sheets) (in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Taking the repeated square root of a number (Google Sheets) (in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet)

For more Excelets in general chemistry, see the Chemical Excelets page and for materials science, see the MatSci Excelets page.

How do I get started developing Excelets?

The basics of developing interactive computational Excel spreadsheets are described in An Interactive Higher-Order Thinking Tool, which includes an Excel tutorial to get you started.  For step-by-step instructions to get started with two Excelets, see Interactive Excel Spreadsheets:  Constructing Visualization Tools to Enhance Your Learner-centered Math and Science ClassroomHere is an excellent website for Excelets in mathematics:

Interactive MS Excel Workbooks and instructions (See ICTCM 2008 for starters)

Listed below are a series of links to pdf files that describe a variety of useful things needed to develop Excelets.  Numerous screen shots are included with the instructions.  The forms toolbar tools are used because they operate on both PC and Mac platforms.  Will Excelets function in Open Office Calc? - click here

 For Excel 2007 - click here Drag-and-drop of data points Using Error Bars in a Creative Fashion Data Culling with Autofilters Check Box or Option Button from the Forms Toolbar Using the List Box from the Forms Toolbar Using the Vertical Lookup Table Function Analysis ToolPak Troubleshooting Guide Decimals and Negative Values for Spinners and Scroll Bars Making Decisions using the Logical Functions Cell References Developing a Systems Model Excelet (Pan Water Cycle includes naming variables) Zoom Square and Zoom Out (Excel) (automatic square grid for data and a manual zoom out method for graphs) Formula Auditing Tools as an Instructional Tool in Building Excelets To get the Developer Tab in Excel 2010 (or 2013/2016) How to get regressions in Excel 2013/2016

A major use of Excelets is to support mathematical modeling in the sciences.

 Mathematical Modeling of Data -  Support materials Getting started with your first model from experimental data: Investigating the Height of a Stack of Cookies* ("Just add data" Excel) Investigating the Height of a Stack of Cookies Activity** (pdf ) Measuring the Stack Height of Nested Styrofoam Cups ("Just add data" Excel) Measuring the Stack Height of Nested Styrofoam Cups Activity (pdf) Stacking Cups II ("Just add data" Excel) Patterns in Data: Ideal and Real-world Examples (Excel) Rate of Change Explorer (Excel) Correlation:  Are two variables related? (Excel) Scatter of Data (Excel) Best-fit Straight Line*** (Excel) Types of Error (Excel) Scatter of Data Activity (pdf) Interpolation and Extrapolation**** (Excel) Types of Error Activity (pdf) Comparing Mathematical Models and Experimental Error (Excel) Comparison of Limited and Unlimited Population Growth (Excel) Developing Systems Models in an Excel Spreadsheet (Excel) Exploring Measurement Error with Cookies (Excel) Exploring Cyclic Data in Nature (Excel) Atmospheric Carbon Dioxide over Time (Excel) Using Excel’s Solver to minimize the SSE for a mathematical model (pdf) Non-linear Regressions by Using the Solver ("Just Add Data" Excel) Paradise Lost: Chesapeake Bay and Sea Level Change (Excel) ( pdf activity)  updated 2014 Numerical Methods Intercepts, both x and y (Excel) The Mathematics of Straight Lines (Excel) Best-fit Straight Line II:  Examining Error in Linear Regression (Excel) Kinetics of Cancer Cell Growth (Excel) Investigating the y-intercept set equal to zero (Excel) (Linear regression forced thro zero) The Spread of Algae on a Pond (Excel) Newton–Raphson Method: Finding Roots of Polynomials (Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Gaussian Function Fitting(Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Discovering Pi & Its Measurement Variation(Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Averaging Out (Excel) The Antarctic Ozone Hole (Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Deriving multivariable models: Stacking Bricks Model (pdf)  Brick Height Simulator (Excel) Excelet revised Stacking Nested Cubes:  An Algebraic and Scientific Investigation (pdf)  Excelet Unstacking Pennies (G Doc)   Unstacking Coins (Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Deriving an equation from a multivariable simulation  distance-time graph (Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Stacking Nested Cubes - Regressions by Solver (Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet) Probability Models    (use RandBetween (min,max) function) Flipping Pennies (Excel) Flipping a Penny:  Real or Fabricated Data (Excel) What are the odds?  Using probability in mathematical models (Excel) To die for:  What are the chances? (Excel) Reach out and torch someone!  (Excel) ( activity) The Law of Large Numbers (Google Sheets)(in Google Sheets, go to File > Make a copy... to have an interactive spreadsheet)

*http://mathforum.org/mathtools/tool/25383             **http://mathforum.org/mathtools/activity/25384  ***http://mathforum.org/mathtools/tool/20618        ****http://mathforum.org/mathtools/tool/22405

High school teacher-developed Excelets as part of Computation and Science for Teachers (CAST) Workshop held at the Pittsburgh Supercomputing Center, in Pittsburgh, PA and in partnership with the Maryland Virtual High School:

 Computational Resources Overview of CAST Computational Reasoning Computational Spreadsheets CAST Professional Development Modules CAST Workshop Activities

More high school teacher-developed Excelets from the Hampton Roads Modeling and Simulation Initiative.

An excellent source of information on spreadsheets in all disciplines is Spreadsheets in Education (eJSiE).

Excel resources for mathematics and the sciences - click here for a pdf file with hot links (2/11 version).

Please e-mail any corrections, modifications, suggestions, or questions.

Scott A. Sinex        Prince George’s Community College        6/2018