Materials Contributed through SERC-hosted Projects
Using Excel to plot numerical and analytical forms of the diffusion equation part of Cutting Edge:Early Career:Previous Workshops:Workshop 2010:Teaching Activities
This computer-based assignment forces students to compare and contrast integral and differential forms of the conservation of mass equation, as well as analytical and numerical approaches to solution. Students are given a text description of a simple environmental problem (a conservative tracer diffusing in a one-dimensional system with no-flux boundaries) and are then required to first write equations that describe the system and then implement these equations in an Excel spreadsheet or Matlab m-file. Students then use their spreadsheets/m-files to compare different solution methods and must communicate these results in short text answers.
Learn more about this review process.