170 likes | 651 Views
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 George’s 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 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!!!!
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