Tags: Excel

All Categories (1-20 of 21)

  1. 1-111-S-SpreadOfInformation

    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...

  2. 6-065-S-InternetPlatformUsers

    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....

  3. 1-062-S-BacterialGrowth

    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...

  4. 2008-Mohamdden-MSExcelForSolvingSecondOrderODEs

    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...

  5. Excel Advanced Solver for Partial Differential Equations

    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...

  6. 9-120-S-HorizontalBeam

    22 Nov 2016 | | Contributor(s):: Tiernan Fogerty, Gregg Waterman

    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...

  7. Differential Equations at Westminster College Personal Account

    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.

  8. 1-026-S-Evaporation

    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...

  9. 1-018-S-LogisticPopGrowth

    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. 

  10. 8-002-S-Text-TrigSumRepresentation

    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.

  11. 1-012-S-SublimationCarbonDioxide

    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...

  12. 1-011-S-Kinetics

    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...

  13. 1-031-S-CoolIt

    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...

  14. 1-030-S-IntraocularGasBubbles

    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

  15. 1-006-S-FinancingSavingsAndLoans

    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...

  16. 1-005B-S-ChemDataCollection

    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...

  17. 1-005A-S-ChemDataCollection

    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...

  18. 1-005A-S-OilSlick

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

  19. 1-005-S-OilSlick

    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 ...

  20. Population Modeling with M and M's

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

    Several activities in which population dynamics can be modeled by tossing M&M’s® candy are presented. Physical activities involving MandM’s can be modeled by difference equations and several population phenomena, including death and immigration, are studied. 

Footer - a work in progress.