170 likes | 684 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