1 / 12

Interactive animated spreadsheets: Visualizing multivariable systems for discovery learning in general chemistry

Interactive animated spreadsheets: Visualizing multivariable systems for discovery learning in general chemistry. Scott A. Sinex Prince George’s Community College. Presented at 20 th BCCE held at Indiana University on 27-31 July 2008. Why interactive spreadsheets?.

yaphet
Download Presentation

Interactive animated spreadsheets: Visualizing multivariable systems for discovery learning in general chemistry

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 animated spreadsheets: Visualizing multivariable systems for discovery learning in general chemistry Scott A. Sinex Prince George’s Community College Presented at 20th BCCE held at Indiana University on 27-31 July 2008

  2. Why interactive spreadsheets? • Easy access for students and good tool for them to know • Easy for instructors to develop – see Developer’s Guide to Excelets • Creates an engaging pedagogy

  3. …more why? • Addresses topics conceptually, while camouflaging mathematics • Students have to think: predict – test - analyze • Allows for mathematical modeling and studying errors • More science process • Mathematics resurfaces!!!!

  4. Are bond lengths constant? http://academic.pgcc.edu/~ssinex/excelets/vibration_solid.xls

  5. How does the spectrum change with pH? http://academic.pgcc.edu/~ssinex/excelets/bromocresol_green.xls

  6. Boyle’s Law Simulator To appear in Spreadsheets in Education

  7. Enzyme Kinetics http://academic.pgcc.edu/~ssinex/excelets/enzyme_kinetics.xls

  8. Chemical Excelets • Interactive concept exploration • Supports Mathematicians' “Rule of Four” • Mathematical modeling • Error analysis • Supports national standards in mathematics, sciences, and technology http://academic.pgcc.edu/~ssinex/excelets/chem_excelets.htm

  9. What do student like most? For Enzyme Kinetics: http://academic.pgcc.edu/~ssinex/excelets/assess.htm

  10. …like least? • “Make it less voluminous with fewer questions. Less stress on brain and less time spent on it. ” • “These activities require too much brain energy. However, I appreciate the challenge.” • Stop doing this and just lecture

  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 excelets Thanks for coming today too!!!

More Related