1 / 12

Interactive Excel Spreadsheets: A Visualization Tool for Mathematics and Science

Interactive Excel Spreadsheets: A Visualization Tool for Mathematics and Science. Scott A. Sinex Department of Physical Sciences and Engineering Prince George’s Community College. Presented at MICCA 2006 Conference in Baltimore, MD on 2-4 May. Why Excel?. Ready off-the-shelf software

clinton
Download Presentation

Interactive Excel Spreadsheets: A Visualization Tool for Mathematics and Science

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Interactive Excel Spreadsheets: A Visualization Tool for Mathematics and Science Scott A. Sinex Department of Physical Sciences and Engineering Prince George’s Community College Presented at MICCA 2006 Conference in Baltimore, MD on 2-4 May

  2. Why Excel? • Ready off-the-shelf software • Found in the work-place • Found on home computers too • Easy to use by students • Can it be an interactive learning tool? (no marcos or VBA programming, just computation via formulas)

  3. ...as a tool in math and science • Great for handling, graphing, and analyzing data • Easy transforming of data such as taking the log • Regression and goodness-of-fit • So a great tool for mathematical modeling of data and presenting graphs Pre-set calculations & graphs – just add data Using Excel for... Scientific Data

  4. ...so now to Excelets! • Excelets are interactive Excel spreadsheets • A “Javaless” applet! • A simulation of a mathematical model or an illustration of a simple concept • A tool for higher-order thinking and illustrating science process • and a tool that is easy to construct!!!!!

  5. So let’s take a tour of the interactive features available in Excel Start tour ! Click on links at the bottom of the next three slides to get the interactive spreadsheets

  6. Interactive features

  7. Fractions

  8. Find it in Regression

  9. Now let’s construct a simple Excelet! So let’s go into Excel

  10. science Model Simulation excelets As a learning tool... • Active engagement of students • Numerical experimentation • Derive the ideal mathematical model • “What if” scenarios • Science processes • predictions • graphical interpretation • conclusions • random and systematic error (ideal to real) See Investigating Types of Errors

  11. The “How to” resources... Developer's Guide to Excelets: Dynamic and Interactive Visualization with "Javaless" Applets or Interactive Excel Spreadsheets <http://academic.pgcc.edu/~ssinex/excelets> Tutorial, instructions, and a variety of interactive Excel spreadsheet examples Resource list for mathematics and science

  12. More info... • Scott Sinex – ssinex@pgcc.edu • See course webpages and publications http://academic.pgcc.edu/~ssinex • Webpages embedded in PowerPoint – get LiveWeb (http://skp.mvps.org/liveweb.htm) ...and THANKS for coming today!!!

More Related