Using Excel in Finite Math and Business Calculus

WE HAVE MOVED - click here for the new page

Download

Printed Guide

Excel in Precalculus

Workshop

• Resources for college mathematics , including graphing calculator guides, interactive sites and more.
• FIles for Download
  • Graph of line
  • Parabola
  • Modeling
  • Hours of daylight
• Modeling with Excel. A self contained Excel workbook showing how to graph functions, build tables and perform curve fitting with polynomials. The file contains macros to use for graphing. Download and open with Excel for maximal functionality. You can also view and run most of the workbook comands through Internet Explorer, if you have Excel installed. If you do not have Excel, you can download a free Excel viewer from Microsoft.

Overview

The online Excel projects and online guide to projects and a separate printed supplement are a result of my experience in teaching finite math for business majors while I was at Saint Peter's College (1995-2000). The online projects and online guide to projects are freely available from Prentice Hall as supplements to their textbooks, although they are fairly general. The printed Excel supplement is published by BrookCole/Cengage. If you are interested in just taking a peek, an overview , in PDF format, gives a summary and some example Excel tutorials and projects. To view the file, you will need an Adobe Acrobat Reader , which can be downloaded for free.  I hope you find these materials useful in your course. Please feel free to email me at rnarasim@kean.edu if you have any questions.  -- Reva Narasimhan

Printed Excel guide

BrooksCole/Cengage has published Excel guide for finite mathematics and applied calculus (ISBN: 0395961483), written by R. Narasimhan, as a supplement to their series of finite mathematics and business calculus books. The introductory chapter is available from the Cengage web site. You can probably request a complimentary copy of the entire book from your publisher's representative if you are a faculty member.

Excel files for download from the Prentice-Hall FTP site.

Barnett Series	Goldstein Series
Finite Math  Excel projects  and Guide	Finite Math  Excel projects and guide
College Math Excel projects	Calculus  Excel projects  and Guide
Calculus  Excel projects	Brief Calculus   Excel projects  and Guide

Description: These files were written  R. Narasimhan, Kean University to accompany the various finite math and business calculus textbooks published by Prentice Hall. They are available for free download for classroom use. Besides the various Excel files,a guide to the projects, in MS Word, is also available for download.The guide describes the contents of the worksheets in more detail.Please see terms of use from Prentice-Hall.

Prentice Hall companion web sites and other spreadsheet sites

Description: The following sites have more information on using spreadsheets in mathematics. Online journal for spreadsheets in education Many interesting spreadsheet files from the Association of Teachers of Mathematics (UK) Austrian site on spreadsheets in mathematics A site in Babson college on spreadsheets and modeling Spreadsheets in Biology

Workshops

I gave a computer minicourse at ICTCM 2000 on modeling and simulation using Excel. You may download my workshop materials.

A paper on using Excel for optimization arising in an industrial setting. Accessible for upper level undergraduates.