Jump to Content
Your Recent History
View Cart
You are not logged into this journal. Log In
The Physics Teacher -- December 2011 -- Volume 49, Issue 9, pp. 580
A Simple Tool for Integration and Differentiation of Tabular Values in Microsoft Excel
Alerts
Alert Me When Cited
Alert Me When Corrected
Tools
Download Citation
Add to MyScitation
Blog This Article
Print-Friendly
Research Toolkit
Share
Email Abstract
Connotea
CiteULike
del.icio.us
BibSonomy
Tweet this Article
Add to FacebookThere are many software alternatives for analyzing experimental data in our physics teaching. I prefer to use Excel® because of its flexibility and widespread use elsewhere in our society. Whatever our students will work with in their future career, they almost certainly will have access to a spreadsheet. For a long time I have missed a tool for integrating and differentiating tabular values in Excel. For every new version I thought it would appear, but it did not. Such a tool could also be useful if you analyze data from other sources than your own experiment, for example, data from the Internet. Therefore, I have written a simple tool that can be integrated seamlessly into Excel as an add-in. It is written in Excels powerful macro language Microsoft Visual Basic for Applications. The tool can be downloaded online1 and there are two versions of it: one for Excel 2003 and one for Excel 2007/2010.
© 2011 American Association of Physics Teachers
KEYWORDS and PACS
ARTICLE DATA
Digital Object Identifier
For access to fully linked references, you need to log in.
Access to article objects (figures, tables, multimedia) requires a subscription; log in to view available files.
(Access to supplementary files, where available, is free for this journal.)
Supplemental Files (EPAPS)
- Calculus_2003.xla (184 kB) 16-Nov-2011 16:54
- Calculus_2007_2010.xlam (116 kB) 16-Nov-2011 16:54
Facebook
Twitter
YouTube
Guidestar
This Publication
Scitation
SPIN
Google Scholar
PubMed