Tabellab
Math & Teaching Intermediate

Calculus with Spreadsheets: Rates of Change, Optimisation & Area

Learn calculus by computing it: difference quotients, derivatives and tangents, marginal analysis, profit optimisation, elasticity, trapezoid and Simpson integration, consumer surplus and growth with e in 8 hands-on labs.

8 lessons 8 labs 2.4 h Certificate

The first lesson is free โ€” no account needed.

About this course

A calculus course where you compute every idea instead of only reading about it, for business, economics and science students and anyone brushing up before a first-year exam. You watch the average speed of a falling package settle on the instantaneous speed as the interval shrinks, estimate a derivative from a table with central differences and draw the tangent line, model a bike maker's marginal cost, revenue and profit, find the profit maximum where the derivative changes sign and solve Pโ€ฒ(q) = 0, turn an exponential demand curve into a point elasticity and the revenue-maximising price, integrate a speed curve with the trapezoid rule and Simpson's rule against the exact answer, measure consumer and producer surplus as areas between curves and grow cash with continuous compounding and e, including a half-life. The first lab is free.

Lessons

  1. Average vs Instantaneous Rate: The Difference QuotientLab15 minFree
  2. Numerical Derivative Table & the Tangent LineLab18 min Pro
  3. Marginal Cost, Revenue & ProfitLab18 min Pro
  4. Optimisation: Find the Profit MaximumLab18 min Pro
  5. Point Elasticity of Demand with a DerivativeLab18 min Pro
  6. Numerical Integration: Trapezoid & Simpson vs ExactLab20 min Pro
  7. Area Between Curves & Consumer SurplusLab20 min Pro
  8. Growth & Decay with e: Continuous Compounding & Half-LifeLab18 min Pro