1 / 18

Scott A. Sinex Prince George’s Community College

Computational Reasoning for Novice Learners: The Amazing Power of Animated Interactive Spreadsheets. Scott A. Sinex Prince George’s Community College. Undergraduate Computational Engineering and Sciences Program Finalists’ Presentations at SC10, 13-16 November 2010.

kamuzu
Download Presentation

Scott A. Sinex Prince George’s Community College

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. Computational Reasoning for Novice Learners: The Amazing Power of Animated Interactive Spreadsheets Scott A. Sinex Prince George’s Community College Undergraduate Computational Engineering and Sciences Program Finalists’ Presentations at SC10, 13-16 November 2010

  2. Low-end of the computational food chain Teragrid Supercomputers Computer programming Spreadsheets Amazing power!!!

  3. Why interactive 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

  4. …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!!!!

  5. …and just maybe Computational spreadsheets computational pipeline

  6. Measure and build a mathematical model Experiment  model  simulation

  7. Develop an understanding of the model The physical and mathematical models

  8. Examine possible errors in the model Explore the influence of a variety of random and systematic errors

  9. Burning a virtual candle model Simulation  model  error

  10. Changing the approach Examine the model in a different way

  11. Radiocarbon and age dating Macroscopic and microscopic views

  12. The systems modeling approach Systems model of production in atmosphere and radioactive decay

  13. Student feedback… Which do you prefer: Spring 07Spring 09 static graphs in textbook 21% (6)7% (2) dynamic graphs in Excel76% (22)89% (25) both 3% (1)4% (1) Using Excelets does not require that you be familiar with Excel. most definitely 7% (2)25% (7) I think so 38% (11)36% (10) just barely 34% (10)32% (9) not at all 14% (4)7% (2) don’t know 7% (2) All Student Survey results http://academic.pgcc.edu/~ssinex/excelets/assess.htm

  14. more feedback… Excelets offer a more visual experience with graphs instead of using just the mathematical equations. most definitely 66% (19)75% (21) I think so 24% (7)14% (4) just barely 10% (3)11% (3) not at all don’t know Excelets make it easier to grasp or learn a concept. most definitely 55% (16)43% (12) I think so 31% (9)54% (15) just barely 14% (4)4% (1) not at all don’t know

  15. Post workshop survey… As you think back on the CAST program experience, which part(s) of the training were most helpful and why? Learning Excelets… Learning Vensim… Learning NetLogo… Responses from 21 TEACHERS (out of 46) from three years.

  16. 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

  17. My sincere thanks • SC10 and the UCES 2010 award committee • My colleagues at • Support from NSF for Maryland Virtual High School

  18. excelets

More Related