## Tags: Excel

### All Categories (1-20 of 22)

1. 18 Oct 2021 | | Contributor(s):: Maila Hallare, Charles Lamb

This activity analyzes the spread of a technological innovation using the Bass Model from Economics. The equation is a first-order, two-parameter separable equation and the solution has a characteristic S-shaped curve or sigmoid curve. The students derive the solution to the model, use least...

2. 02 Sep 2019 | | Contributor(s):: Jeff Pettit

Students perform experiments to model spread of information within a population. Students collect data, determine essential components and parameters and build a mathematical model which can be compared to predicted data, measured data, and modeled data. Part 3 can require students to move from...

3. 30 Oct 2018 | | Contributor(s):: Victoria Rayskin

A model estimating the volume of users interacting through a two-sided Internet platform (allowing interaction of two types of users) will teach students how to analyze a 2-dimensional dynamical system. The model will illustrate how the question of existence of closed orbits can be investigated....

4. 15 Sep 2018 | | Contributor(s):: Arati Nanda Pati

We offer students a simulation experience or data from a simulation and ask them to model the simulation using several approaches andusing EXCEL spreadsheet. In this particular modeling scenario, we know the exact solution and want to see how various models predict our expectations. We have used...

5. 28 Nov 2017 | | Contributor(s):: Brian Winkel

Mohameden, Ahmed. 2008. Solving initial-value second order ordinary differential equations on an Excel© spreadsheet. MSOR Connections. 8(4):  November 2008 – January 2009. 21-25.Abstract: This paper presents a friendly method of solving initial-value second order differential...

6. 25 May 2017 | | Contributor(s):: Chahid Ghaddar

We offer an illustration of PDASOLVE() an Excel Advanced Solver for Partial Differential Equations by Chahid Ghaddar of ExcelWorks (cghaddar@excel-works.com ) along with two articles concerning use of the software. ExcelWorks is in the greater Boston MA USA area and one may read about the author...

7. 22 Nov 2016 | | Contributor(s):: Gregg Waterman, Tiernan R Fogarty

This scenario is designed to lead students to discover a differential equation that models the vertical deflection of a horizontal beam under different boundary conditions. Vertical deflection occurs as a result of the weight of the beam alone, with no compressive force at the ends or distributed...

8. 21 Sep 2016 | | Contributor(s):: Holly Zullo

This paper describes the author's experiences teaching differential equations with a strong modeling component at a small liberal arts college. The course structure and incorporation of modeling are discussed, as well as challenges and rewards associated with this approach.

9. 04 Jun 2015 | | Contributor(s):: Brian Winkel

We provide data (in EXCEL and Mathematica files) on evaporation of 91% isopropyl alcohol in six different Petri dishes and one conical funnel and on evaporation of water in one Petri dish. We  ask students to develop a mathematical model for the rate of evaporation for the alcohol mixture...

10. 04 Jun 2015 | | Contributor(s):: Brian Winkel

We offer artificial (toy) and historical data on limited growth population situations in the study of protozoa and lead students through several approaches to estimating parameters and determining the validity of the logistic  model in these situations.

11. 04 Jun 2015 | | Contributor(s):: Brian Winkel

Students discover how to represent functions as sums of trigonometric functions and the value of such representations in many fields.

12. 03 Jun 2015 | | Contributor(s):: Brian Winkel

We offer data on the sublimation of dry ice (carbon dioxide) with data collected in a classroom setting so that students can model the rate of change in the mass of a small solid carbon dioxide block with a differential equation model, solve the differential equation, estimate the parameters in...

13. 03 Jun 2015 | | Contributor(s):: Brian Winkel

We help students see the connection between college level chemistry course work and their differential equations coursework. We do this through modeling kinetics, or rates of chemical reaction. We offer many opportunities to model these chemical reactions with data, some of which comes from...

14. 02 Jun 2015 | | Contributor(s):: Brian Winkel

We offer data on the temperature of water in a beaker which resides in a room of constant temperature and also in an environment of nonconstant temperature. Students are encouraged to consider both empirical and analytic modeling approaches. We offer additional data sets in Excel spreadsheets...

15. 01 Jun 2015 | | Contributor(s):: Brian Winkel

SPANISH LANGUAGE VERSION  We have placed in Supporting Docs both Student and Teacher Version (LaTeX and PDF Versions) with a Spanish LaTeX Class file, SIMIODE-SPANISH.cls. Names will be x-y-S-Title-StudentVersion-Spanish and x-y--T-Title-TeacherVersion-Spanish

16. 31 May 2015 | | Contributor(s):: Brian Winkel

We describe two situations (Pa) one in which we are saving for a purpose and (2) one in which we are borrowing for a purpose.  In the first case we ask for discrete and continuous model of the situation and in the second case we ask that the results of the model be used to examine some...

17. 30 May 2015 | | Contributor(s):: Brian Winkel

We present a situation in which a chemistry graduate student is assigned the  task of collecting data on a chemical reaction and does a poor job of collecting the data. Indeed, he only collects the data at the start and end of a number of three minute intervals and does not keep track of...

18. 30 May 2015 | | Contributor(s):: Brian Winkel

We present a situation in which a chemistry graduate student is assigned the  task of collecting data on a chemical reaction and does a poor job of collecting the data. Indeed, she only collects the data at the start and end of a number of ten minute intervals and does not keep track of when...

19. 30 May 2015 | | Contributor(s):: Karen Bliss

20. 30 May 2015 | | Contributor(s):: Brian Winkel

We describe a modeling activity for students in  which modeling with difference and differential equations is appropriate. We have used this model in our coursework for years and have found that it enlightens students as to the model building process and parameter estimation for a ...