搜索
236200812JournalofLiuzhouTeachersCollegeVol23No6Dec2008[]2008-09-02[](1964),,,,:(,545004):数据处理是大学物理实验步骤中不可分割的一部分本文利用Excel对实验伏安法测电阻的数据分别用四种方法进行数据处理并比较它们的优缺点,从而选择合适的方法处理数据:物理实验;数据处理;伏安法;Excel:O4-39:A:1003-7020(2008)06-0111-04,:,,Excel,111实验仪器(010V,05)(0100mA,05)()12实验数据的测量,11U(V)0.541.542.543.524.535.516.527.538.539.51I(mA)5.015.025.035.045.055.065.075.085.095.013数据处理方法1311,Excel,,22U(V)0.541.542.543.524.535.516.527.538.539.51I(mA)5.015.025.035.045.055.065.075.085.095.0R=UI()108.0102.7101.6100.6100.7100.2100.3100.4100.4100.1R=1015A,BuB(U)=UMAX!U%3=10!05%3=0.029(V)uB(I)=UMAX!I%3=100!05%3=0.29(mA)uB(R)R=uB(U)U2+uB(I)I2=00294532+0294502=0.0091111UMAXIMAX,UI[1]uc(R)=uB(R)=00091R=00091!1015=0.92=0.9():R∀uc(R)=101.5∀0.9()132()()1,(XY),1:1R=b=9975,a=004133,Un2+i-Ui=#Ui,In2+i-Ii=#IR=∃Un2+i-UiIn2+i-Ii%n2=∃(Un2+i+Ui)n2#In10,i1,2,3,4,544U(V)0.541.542.543.524.535.516.527.538.539.51I(mA)5.015.025.035.045.055.065.075.085.095.0R()99.4099.6099.80100.209960R()99.72[2],uc(R)R=uc(U)#U2+uc(I)#I2#U=∃(Un2+i-Ui)n2=4.99(V),#I=∃(In2+i-Ii)n2=50(mA)=0.050(A)uA(U)=∃(#U-#Ui)2n2!(n2-1)0.075,uB(U)=0.029(V)uc(U)=u2A(U)+u2B(U)=uB(U)=0.030(V)uA(I)=0,uB(I)=0.00029(A),uc(I)=0.00029(A),ucR=0.6()R∀uc(R)=99.7∀0.6()134Excel,,112,,Excel1,:R=∃UiIi∃I2i=10041uA(R)=∃Ii∃Ii∃(Ui-RIi)2n(n-1)=0.34,uB(I)=0.00029(A),uB(U)=0.029(V)uB(R)R=uB(U)U2+uB(I)I2,uB(R)=0.82(),uc(R)=0.89():R∀uc(R)=100.3∀0.9()2,,,,,[3],(,A),;,,,,,,;,,,,,,,,,,[4];,,,,[5],3:,,,,,,,,,,[][1][M]:,2004:54[2][M]:,2004:23[3][J],2007(2):70-73[4][M]:,2004:14[5]Excel[J],2003(4):66-68(责任编辑:喜文敏)113ACaseAnalysisofDataProcessingMethodinCollegePhysicExperimentsLIYuxuan(DepartmentofPhysicsandInformationScience,LiuzhouTeachersCollege,Liuzhou,Guangxi545004,China)Abstract:DataprocessingisanessentialpartofcollegePhysicexperiments.ByusingExcelintheexperimentgettingdatafromresistancemeasurementwithvoltammetry,andcontrastingfourmethodsofprocessingthedata,thispaperistodecidethemostsuitablemethodtododataprocessing.Keywords:Physicexperiments;dataprocessing;voltammetry;Excel(上接第77页)MoralEducationResearchontheBuildingofCollegeStudents&HarmoniousPersonalityCUIHongli(DepartmentofIdeologicalandPoliticalTheory,GuangdongWomen&sPolytechnicCollege,Guangzhou,!Guangdong511450,china)Abstract:Thebuildingofcollegestudents&harmoniouspersonalityistheinevitabmepursuitformoraleducation.Buildingharmoniouspersonalityshouldbestartedwithcorrectingthepersonalitydefectsincollegestudentscurrently,whichisfollowedbyexploringtheprimarymeansofbuildingharmoniouspersonalityfrominternalandexternalcauses.Keywords:harmoniouspersonality;personalityshaping;moraleducationresearch(上接第90页)InvestigationintoLifeEventsofCollegeStudentsJIANGYanbin(SchoolofPsychologicalCognitiveScience,EastChinaNormalUniversity,Shanghai200062,China)Abstract:InacasestudyofLiuzhouTeachersCollege,acollegestudentlifeeventsscaleisusedinthequestionnairefor525collegestudents.Theresultshowsthatthelifeeventsexperiencedbythecollegestudentsaremainlypositiveevents,whichareinfluencedgreatlyfromthepersonalrelationshipsandpsychologicalsupports;thelifeeventsvaryintheaspectsofsex,grade,subject,studentsourceandfamilyeconomiccondition.And,thepositiveandnegativeeventsinvolvedwitheconomicchangeshavegreaterinfluenceonruralstudentswhoareinpoorerfamilyeconomiccondition.Keywords:collegestudents;positiveandnegativeevents;lifeevents(上接第101页)StudyofConstructionandInnovationofCourseSystemofPhysicalandHealthMajorinHigherVocationalCollegesLIULing,HUANGChao,SHIDianhui(GuangxiCollegeofPhysicalEducation,Nanning,Guangxi530012,China)Abstract:Thecoursesystemofphysicalandhealthmajorinhighervocationalcollegesisinvestigated.Aimingatthedefectsandproblemsincurrentsituation,newideasareputforwardforconstructionandinnovationofcoursesystemofthismajor.Keywords:highervocationalcolleges;physicalandhealthmajor;coursesystem;constructionandinnovation114