170 likes | 606 Vues
Why interactive spreadsheets?. Easy access for students and good tool for them to knowEasy for instructors to develop
E N D
1. Simulations in the Math/Science Classroom: Creating an Engaging Pedagogy with Excel! Scott A. Sinex
Prince Georges Community College, Maryland
Mark Clemente
National Institute of Aerospace/Virginia Beach Public Schools
2. Why interactive spreadsheets? Easy access for students and good tool for them to know
Easy for instructors to develop see Developers 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!!!!
9. Excelets . Interactive concept
exploration
Supports Mathematicians'
Rule of Four
Mathematical modeling
Error analysis
Supports national standards in mathematics, sciences, and technology
13. The How to resources...
14. Excelets developed by high school teachers Hampton Roads Modeling and Simulation Initiative
http://modsim.wikispaces.com/Math+and+Science+Lessons
Exercises developed by Computation and Science Teachers (CAST) Workshop http://www.psc.edu/eot/k12/cast.php
(see previous years)
15. More info... Scott Sinex ssinex@pgcc.edu
http://academic.pgcc.edu/~ssinex
Mark Clemente mark.clemente@nianet.org
Webpages embedded in PowerPoint
get LiveWeb (http://skp.mvps.org/liveweb.htm)
16. Resources Computational Resources by Maryland Virtual High School
http://mvhs.shodor.org/CAST2008
Introduction to Computational Science Angela B. Shiflet and George W. Shiflet
http://wofford-ecs.org/IntroComputationalScience
Supercomputing Conference Education Program Wiki
http://sc08edprogk12.wikispaces.com/
17. Data analysis Graphing with Excel LabWrite
http://www.ncsu.edu/labwrite/res/gt/gt-menu.html
Using Excel for Handling, Graphing, and Analyzing Scientific Data: A Resource for Science and Mathematics Students
http://academic.pgcc.edu/psc/Excel_booklet.pdf
18. Data sets Quantitative Environmental Learning Project (QELP) as Excel files
http://seattlecentral.edu/qelp/Data.html
Exploring Data datasets as Excel files
http://exploringdata.cqu.edu.au/datasets.htm