1 / 17

Interactive Animated Spreadsheets: A Powerful Tool for Simulations

Interactive Animated Spreadsheets: A Powerful Tool for Simulations. Scott A. Sinex Prince George’s Community College. Presented at 194 th 2YC3 Conference at Montgomery College, Rockville, MD on 11-12 November 2011. Why spreadsheets?.

jaquelyn-knowles
Télécharger la présentation

Interactive Animated Spreadsheets: A Powerful Tool for Simulations

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: A Powerful Tool for Simulations Scott A. Sinex Prince George’s Community College Presented at 194th 2YC3 Conference at Montgomery College, Rockville, MD on 11-12 November 2011

  2. Why spreadsheets? Easy access for students and teachers and useful for them to know Easy for instructors to develop – see Developer’s Guide to Excelets Creates an engaging pedagogy in math and the sciences

  3. …more why? Addresses topics conceptually, while camouflaging mathematics Students have to think: predict - test - analyze …and explain Allows for mathematical modeling and studying errors More science process More multivariable approach Mathematics resurfaces!!!! Seriously lacking in our textbooks!!!

  4. The big picture… Multiple representations A multivariable approach

  5. For today… • Explore the almost endless possibilities… • Examine “how to” use in the classroom to get student’s investigating and thinking • This afternoon – build a multivariable simulation of Boyle’s Law

  6. excelets …and now http://academic.pgcc.edu/~ssinex/excelets

  7. Let’s examine… • Periodic trends • Vibrations in solids • Kinetics and chemical equilibrium • Radioactive dating • Investigate - Burning a Virtual Candle

  8. How does the size of an atom vary on the periodic table? Simple data bases for students to discover relationships http://academic.pgcc.edu/~ssinex/excelets/radii_comparison.xls

  9. What about periodic trends? Na+ why so high? Na http://academic.pgcc.edu/~ssinex/excelets/PT_interactive.xls

  10. Are bond lengths constant? Simple animations add value http://academic.pgcc.edu/~ssinex/excelets/vibration_solid.xls

  11. Enzyme Kinetics Investigate multivariable models http://academic.pgcc.edu/~ssinex/excelets/enzyme_kinetics.xls

  12. Discover the common ion effect increasing undissociated HNO2 by adding HCl decreasing nitrite http://academic.pgcc.edu/~ssinex/A_B_Behavior.ppt

  13. Radiometric Dating - How old is a rock sample? Multiple representations! 1 + D/P = ekt symbolic http://academic.pgcc.edu/~ssinex/excelets/age_dating.xls

  14. How does a burning candle behave? Here we collect the data by clicking the up arrow on the spinner. http://academic.pgcc.edu/~ssinex/excelets/burning_candles.xls

  15. …adding error to the data Scatter is added to the data by increasing random error. =E6+$K$7*RANDBETWEEN(-10,10)/10+$G$10 The circled scroll bar controls the size of random variation.

  16. Burning candle… • The activity including notes to the instructors– http://academic.pgcc.edu/~ssinex/excelets/burning_candles_act.pdf • The Excelet – http://academic.pgcc.edu/~ssinex/excelets/burning_candles.xls

  17. More info • Scott Sinex ssinex@pgcc.edu http://academic.pgcc.edu/~ssinex • Google: excelets • My thanks to NSF Thanks for attending

More Related