Excel实现的试卷质量分析表

20047263()JournalofJiangsuUniversity(HigherEducationStudyEdition)Jul.2004Vol.26No.3Excel(,215002):,Excel2000,:Excel;;;:TP311:A:1004-003X(2004)03-0088-05,,,,,2080Basic[1](p.87-89)90VFP,[2],Excel2000,Excel()Excel1.,,,,,;,,Excel2000()2.,:(1)60,(2),,:2004-03-29:(1949-),,,,()88(3),(,),(4)11,,F46,;,1(),,(),:(1)ExcelAVERAGE()MAX()MIN()(2)ExcelSTDEV(),(3),:t=75+9p(p-p),tp;pp:75,9()(4):Hi=iiHi,010001Hi0199990198(5)H,H=6ni=1aiNHiaii,NHHi,,:H01600,01600H01700,01700H01770,01770H01830,H01830(6)(,),rtt=nD21+(n-1)D2n(,),D():,Livingston(7)Livingston,rtt,,:P=rtt2+(-60)22+(-60)2,,:rttLivingstonPrtt()Prtt60,,,,,,rtt,Prtt,,rtt01700,P01900,,(8),ExcelCORREL()PEARSON()Di,,Di01150,(,),Di01150,01300Di01151,01400Di01301,Di01400DiY(Di01301)D(Di,,HiDi)D01250,20D01150,01150D01350,D01350,R(),()(1),R01600,,R01700(9)Excel,,,COUNTIF(),COUN2TIF(AL5:AL55,30)-SUM(AG53:AG54),1:()(),,,(36,37)09,(1MAGAK)(:,),(),(),,,(),!,(Cronbach),1,(),AL49(AL50)=KK-11-6S2iS2tK;S2ii;S2t(),,(),,,,,(),()#DIV/0!,,,0101Excel,[3],[4],,,[5](p.252)(),([4]0185,0144)(01593)(01917),,Excel,,,,,,11,Excel2000[1].[A].[C],:,1987.[2],.()[J].,1999,(4):80-84.[3],.Excel[J].,2001,23(4):26-28.19[4],.[J].,2000,26(11):151-153.[5],,.[M],:,1999.ASystemofQualityAnalysisDevisedforTestPapersbytheUseofExcelXUANZhong2liang(DepartmentofInformationTechnology,SuzhouEducationCollege,Suzhou215002,China)Abstract:Qualityanalysisoftestpapersinvolvesspecialknowledgeoneducationalstatisticsandmeasure2mentandisoftenrealizedbycomputerprograms.ThispaperintroducesasystemofqualityanalysisdevisedfortestpapersbytheuseofExcel2000,andfocusesontechnologicdetailsforformulaoperating,datavali2dating,datasecurityandinterfacedesigning.Keywords:Excel;educationalstatistics;educationalmeasurement;analysisoftestpapers()(73)[10],.[J].,2003,(4):23-26.[11],.R&D[J].,2002,5(4):1-6.[12]BrianJHall,KevinJMurphy.OptimalExercisePricesExecutiveStockOptions[J].AmericanEco2nomicReview,2000,90(2):209-214.[13]ChadwickC,CappelliP.AlternativetoGenericStrategyTypologiesinStrategicHumanResourceManagement[M].Greenwich,CT:JAIPress19991[14].[D].:,2001.ApplicationofGameTheoryintheManagementofTechnologicallyInnovativeTeachersofUniversitiesandCollegesZHANGCheng2hua,SHANHong2mei(1.PersonnelDivision,JiangsuUniversity,Zhenjiang212013,China;2.FacultyofScience,JiangsuUniversity,Zhenjiang212013,China)Abstract:Asthemostimportantresourcesofuniversitiesandcolleges,technologicallyinnovativeteachersaremuchsoughtafterintodaysworld.Withfineacademicqualityandgreatinitiative,theyarequitecre2ativeandeagertorealizetheirownvalue.However,itisdifficulttomonitortheirworkandevaluatetheirachievements.Infact,howtoexerciseeffectivemanagementofthesetalentedteachershasbecomethecen2traltaskincollegehumanresourcemanagement.Thispaperanalysestheircharacteristicsfromtheviewofgametheoryandconstructsananalysismodelofmanagementforthem.Basedonthemodel,agameanaly2sisofthemanagementisconductedandsomemeasuresareadvancedforitsimprovement.Anditisalsopointedoutinthepaperthataninternalsystemshouldbebuiltuptogivefullplaytotheincentivemecha2nism,thathuman2basedmanagementshouldbeenforcedandthattheculturaladvantageofauniversityshouldbeestablished.Keywords:universityandcollege;technologicallyinnovativeteacher;model;gameanalysis()29