A Simple Tool for Integration and Differentiation of Tabular Values in Microsoft Excel

• Autores: Ole Anton Haugland
• Localización: The Physics Teacher, ISSN 0031-921X, Vol. 49, Nº. 9, 2011, pág. 580
• Idioma: inglés
• Texto completo no disponible (Saber más ...)
• Resumen

  • There 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 online1and there are two versions of it: one for Excel 2003 and one for Excel 2007/2010.