Article View: bit.listserv.physhare
Article #1101Re: SPREADSHEET LABS
From: Patty Blanton
Date: Fri, 14 Oct 1994 12:58
Date: Fri, 14 Oct 1994 12:58
42 lines
3175 bytes
3175 bytes
Steve, I want to thank you for sharing the Trip to school project with me. I didn't send the results to you because I felt like the results I got were not in a form that would have been helpful to your students. By the time we got the corrected, it was part the time you would have been covering the info in class. It was a great project and my students learned a great deal and I hope our next attempt will be of higher quality. I have been trying to do some spreadsheet activities with my physics classes. I have tried two things that have been very successful. The first was using eatimated erro on measurements. I had the students measure the dimensions of a cylinder with a metric ruler, then a vernier caliper, and then a micrometer caliper. In the spreadsheet, the set up three colums for each measurement-one with their measured value , one with the setimated error low value , and one with the estimated error high value. Then the calculated volume with each set of values.They then graphed the volumes comparing the reported value calculation with the high and low value calculation. What they could then see clearly was the spread in values that the estimated error caused in a value calculated with measured quantities. They then compared the accuracy of the measuring devices in the same way and saw the spread of values get smaller as the precision of the instrument increased. The second spreadsheet was using the distance formula for an accelerating object ant setting up colums for time, distance and final velocity calculations. The values for acceleration could be changed as well as initial position and velocity. Once the spreadsheet was created, I gave them a list of questions they used with the spreadsheet to answer. They seemed to get a lot out of this and did very well on the test. I hope to develop more. I have a book you might want to find...it's called Dynamic Models In Physics- A Workbook of Computed Simulation Using Electronic Spreadsheets. I had the university bookstore order it for me --ISBN 0-9622556-1-0. There is also one for Chemistry. I would love to stay in touch this year and share ideas if you are willing. Thanks for your help. Patty Blanton blantonp@conrad.appstate.edu Impact NC program Watauga High School Boone, NC 28607
Technical Details
Message-ID:
<01HI9DF7KQSI9ZLE7S@conrad.appstate.edu>Path:
arc1-ca.pugleaf.net!bga.com!news.sprintlink.net!deathstar.cris.com!news1.oakland.edu!newsxfer.itd.umich.edu!europa.eng.gtefsd.com!howland.reston.ans.net!news.cac.psu.edu!psuvm!auvm!CONRAD.APPSTATE.EDU!BLANTONPShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 16cfd8,f76103ba8ae58d79,start X-Google-Attributes: gid16cfd8,public X-Google-ArrivalTime: 1994-10-14 16:47:13 PST Path: arc1-ca.pugleaf.net!bga.com!news.sprintlink.net!deathstar.cris.com!news1.oakland.edu!newsxfer.itd.umich.edu!europa.eng.gtefsd.com!howland.reston.ans.net!news.cac.psu.edu!psuvm!auvm!CONRAD.APPSTATE.EDU!BLANTONP Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU Newsgroups: bit.listserv.physhare X-VMS-To: IN%"PHYSHARE@PSUVM.PSU.EDU" MIME-version: 1.0 Content-type: TEXT/PLAIN; CHARSET=US-ASCII Content-transfer-encoding: 7BIT Message-ID: <01HI9DF7KQSI9ZLE7S@conrad.appstate.edu> Date: Fri, 14 Oct 1994 08:58:55 -0400 Sender: Sharing resources for high school physics <PHYSHARE@PSUVM.PSU.EDU> From: Patty Blanton <BLANTONP@CONRAD.APPSTATE.EDU> Subject: Re: SPREADSHEET LABS Lines: 41