Mass, Measurement, Materials, and
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

Mass, Measurement, Materials, and Mathematical Modeling: The Nuts and Bolts of Extrapolation PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on
  • Presentation posted in: General

Mass, Measurement, Materials, and Mathematical Modeling: The Nuts and Bolts of Extrapolation Ted Chambers – Prince George’s Community College Scott Sinex - Prince George’s Community College Josh Halpern – Howard University. Presented at ACS MARM, College Park, MD on 21 May 2011.

Download Presentation

Mass, Measurement, Materials, and Mathematical Modeling: The Nuts and Bolts of Extrapolation

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Mass, Measurement, Materials, and

Mathematical Modeling:

The Nuts and Bolts of Extrapolation

Ted Chambers – Prince George’s Community College

Scott Sinex - Prince George’s Community College

Josh Halpern – Howard University

Presented at ACS MARM, College Park, MD on 21 May 2011


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

  • First Semester Chemistry Activity

    • 24 Students - Worked in Groups of 4

    • Group Interaction to Discover Underlying Concepts

  • Experience Gained

    • Graphing

    • Data Analysis Using Excel

    • Mathematical Modeling Using Excel

    • Group Collaboration Using Google Docs

Pre-built into spreadsheet


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

  • Technique Used

    • Mass a Bolt with One through Five Nuts On It

    • Determine Mathematical Model for the Data

    • Extrapolate To “Zero Nuts” To Determine Bolt’s Mass

    • Enter Data In Google Docs

    • Group Collaboration - Discussion Based on Google Docs Data

    • Explore Effect of Scatter in Data

    • Explore Pitfalls of Extrapolation


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Data Analysis

Examine Data Locally

Enter Data and Results In Google Docs

Examine Data Collaboratively Using Google Docs

Local Evaluation of Data Variation and Extrapolation Pitfalls


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Excel Plot Of Bolt Mass With Various Number Of Nuts


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Data With Linear Regression Line


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

  • Sharing Results Using Google Docs

  • 6 Groups, Each Representing a Different Institution

  • Enter Data In Google Docs Using a Form

  • Examine Data in Real-time Using Google Docs Spreadsheet

  • Collaborative Discussion Between Groups

  • Use of Current Technology In a Collaborative Setting


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Online Google Docs Data Entry Form

Link to form on

spreadsheet


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Google Docs Spreadsheet – Collaborative Discussion


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

  • Effect of Variation in Data Using Excel

  • Performed Locally – Not in Google Docs

  • Random Variation in Mass

  • Effect On Slope

  • Effect on Goodness of Fit

  • Density of materials (not discussed today)


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Data With Random Variation Added


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Possible Pitfall

Extrapolating Past Known Data Range


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Students Provided Anonymous Feedback

Results of Ranking Questions

out of 5

Instructions Clear and Unambiguous 4.33

Activity Was Informative About Extrapolation 4.38

Size of Work Groups Appropriate4.54

Activity Rated as a Learning Experience4.13

Activity Overall Rating4.20


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

  • Students Comments

  • Positive Feedback

    • Using Google Docs to Compare and Discuss Results

    • Using Excel for Modeling and Data Analysis

    • Working In Groups

    • Bringing Innovation to First Semester Chemistry Course

    • Using The Same Format to Look at Different Group’s Data

  • Suggestions and Negative Feedback

    • Activity Too Long (took 2.5 hours)

    • More Computers in Lab With Internet Connectivity


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

  • General Lab Activity Results

    • Good Discussion Within Groups

    • Good Discussion Between Groups Using Google Docs

    • Exploring Differences In Results

    • Raised Awareness of Possible Pitfalls of Extrapolation

    • Good Data Agreement Between Groups


Mass measurement materials and mathematical modeling the nuts and bolts of extrapolation

Questions?

http://academic.pgcc.edu/~ssinex/excelets/matsci_excelets.htm

This work is supported by the Howard/Hopkins/PGCC Partnership for Research and Education in Materials (PREM), funded by NSF Grant No. DMR-0611595


  • Login