Interactive Excel Spreadsheets: AV isualization Tool for

Document Sample
Interactive Excel Spreadsheets: AV isualization Tool for Powered By Docstoc
					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
   •   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)
 ...as a tool in math and science
• Great for handling, graphing,
                                               Pre-set
  and analyzing data                         calculations
• Easy transforming of data                   & graphs –
                                               just add
  such as taking the log                         data
• Regression and goodness-of-fit

• So a great tool for mathematical
  modeling of data and presenting graphs

        Using Excel for... Scientific Data
...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!!!!!
       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
Interactive features
Fractions
Find it in



             Regression
Now let’s construct
 a simple Excelet!

  So let’s go into Excel
            As a learning tool...
•   Active engagement of students
•   Numerical experimentation
•   Derive the ideal mathematical model
•   “What if” scenarios
•   Science processes            science

    –   predictions              Model      Simulation
    –   graphical interpretation
                                     excelets
    –   conclusions
    –   random and systematic error (ideal to
        real) See Investigating Types of Errors
  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
            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!!!

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:15
posted:9/11/2012
language:Unknown
pages:12