七年级学生成绩自动统计.xls

《七年级学生成绩自动统计.xls》由会员分享，可在线阅读，更多相关《七年级学生成绩自动统计.xls（28页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、七年一班考试成绩汇总表考号 班级姓名语文数学英语思品历史地理生物总分名次 年名 考场一张雪梅49938.549102442221.5一赵煜59149350255757355一董芳冰9010299.560558482572.5一刘勇3712213151418138一孙小蕾675273.55253082361.5一郑伟196172991448142一张瑞泽67466656365574400一王鑫宇7811010767548477577一姜纪绅6951742185971281一孙佳乐59144953132234244一张婧雯625077.551166476396.5一车金航61639.5472456

2、60293.5一李悦642260.552113839286.5一尤利萍668389.570607374515.5一隋天昂58183251203155265一南洋57242632175848262一张玉婷73779867437080508一雷欣宇66677.544246254333.5一任艳东52973.557105630287.5一陈崇正691077951537888525一汪涛滔7111139.544396072436.5一魏雪鸽622061.546264860323.5一李树伟64797646254372405一康佳妤529355582758244一栾忠宇0一刘成洋435320462348

3、43276一于立禛727885.580466695522.5一夏远航41201444287366286一修合彬721007153314287456一李金龙678980.553315463437.5一谷文强73434855306066375一张嘉琪72628468248176467一张照洋665778.568414570425.5一杨可心61124854243446279一徐欣817435.566388188463.5一孙磊6131535695546311一杨金凤06191686257一李双双6036849283749294一闫丽花867983.564568179528.5一张旭文547432.

4、564506364401.5一张文文0一王思甜6419695192830270一张春雪45931.52332736174.5一宋婷婷652260.553182070308.5一张远洋67946.544113760274.5一孙坤721147565307577508一孙洁怡3847753621264929271学科语文数学英语思品历史地理生物实考人数 45454545454545及格人数 1014181111626及格率 22.2231.1140.0024.442.2235.5657.78总分2731199226252310116522462713平均分60.6944.2758.3351.332

5、5.8949.9160.29优生人数0631057优生率 0.0013.336.672.220.0011.1115.56差生人数21910329102差生率 4.4442.2222.226.6764.4422.224.44标准差 15.9035.8625.4912.5915.5321.0919.81众数67.009.0073.5053.0024.0081.0060.00中位数 64.0031.0061.5052.0024.0055.0063.00最高分9011410780608495最低分031416362100-120061000090-99103000180-89225105670-798

6、6101051260-691916916750-597411758440-494341135830-3921837650-292227329102使用说明：1.录入成绩时输入班级、姓名和各科成绩即可，其他不用填写，系统会自动生成，可以改变学科名称。2.表的最后为学科统计数据，其中语文、数学、英语三个学科满分为120分，其他学科满分为100分。七年二班考试成绩汇总表考号 班级姓名语文数学英语思品历史地理生物总分名次 年名二王宇瑶8111510186608680609二曲天琪7610787.560457130476.5二田兆亮501336.543145873287.5二靖叶萱775183.5553

7、96367435.5二徐春艳4934537123717200二于思佳38125851212545250二刘云飞27928108167105二刘芳含73547761487978470二吴宏俊432628.555181430214.5二张家俊5033450142444219二毕建军38271730172550204二汪龙女811059876776781585二由志顺4732849385541261二潘婉婷816896.572417780515.5二薛福林46943.549172315202.5二丛珊829590.572568574554.5二袁青林71578362436772455二许立颖7129

8、85.554315764391.5二刘兆辉67308666406978436二姜吉顺2918222016794二姚金生54375554237446343二包晶茹747291.567434678471.5二冯欣如4233238246638243二程美琪581568.546193553294.5二杜娟797986.561437785510.5二郑馨66267947115139319二刘佳5564163135535268二鲁精武748784.561667181524.5二张家辉52795226127144336二李延秋68827461305969443二孙冬雪736580.554356970446.

9、5二于文玲5462940203044223二张雅宁82739478545874513二王欣宇70699162337678479二周田甜643657.517276253316.5二王欣蕾711166.566647067415.5二包德毅522359.546287542325.5二徐成3991943162210158二张春旭5903236205019216二于华67366966328275427二赵伟鹏514180.548135762352.5二白欣宝8010794.566488580560.5二谢鑫莲69496149417775421二宋明轩513173418523921472学科语文数学英语思

10、品历史地理生物实考人数44444444444444及格人数1311201842222及格率29.5525.0045.4540.919.0950.0050.00总分2654183927402289139224842389平均分60.3241.8062.2752.0231.6456.4554.30优生人数0431046优生率0.009.096.822.270.009.0913.64差生人数2181042286差生率4.5540.9122.739.0950.0018.1813.64标准差16.9434.5326.4216.1416.9321.1323.14众数81.003.0028.0061.004

11、3.0071.0078.00中位数65.0033.0067.5054.0029.0060.5057.50最高分8211510186778685最低分2017108147100-120041000090-99017000080-89629104670-79114341111160-696341337550-5911357210340-495231091730-3934457360-29221842286使用说明：1.录入成绩时输入班级、姓名和各科成绩即可，其他不用填写，系统会自动生成，可以改变学科名称。2.表的最后为学科统计数据，其中语文、数学、英语三个学科满分为120分，其他学科满分为100分

12、。考场七年三班考试成绩汇总表考号 班级姓名语文数学英语思品历史地理生物总分名次 年名三孙家淼35122037163441195三杨亚男70126752305544330三白雪66285069366873390三李佳67755961284963402三刘佳男849161.562446179482.5三朱晓楠69915472436670465三王俊雨69846869527573490三许欣6563061312541259三王新燃54123554254954283三宫兆嘉598049.549486560410.5三姜连露831057977367260512三张春雪6533454191547237三赵

13、雯婧84937271567776529三王悦821116576617981555三孙思宇57123547243934248三万怡79654982393562411三康家宝57183849334236273三鲁精文646751.545196367376.5三王传民68926652406158437三孙悦68214560273960320三孙平文3262326141223136三包宇琦73153939277153317三孙晓晨53333463496276370三王传玉5212272971942188三丁志鹏661137464637073523三张双杰81486470456862438三隋欣7461

14、5872526045422三历彦军62114848376185352三丛俊一628540.547435977413.5三宋晓青8711291.567588574574.5三孙楠56619.533143530193.5三姜吉龙4963037115828219三陶春旭821175881748986587三陈红6632873282863289三宋伟镇687973.562607372487.5三刘学斌562840.544202453265.5三丛芯宇64183653303382316三李晓宇71124068264751315三孙仕久58101540173741218三孙文393203626164218

15、273学科语文数学英语思品历史地理生物实考人数40404040404040及格人数101452041922及格率25.0035.0012.5050.0010.0047.5055.00总分2596185618882251140820762337平均分64.9046.4047.2056.2835.2051.9058.43优生人数0502024优生率0.0012.500.005.000.005.0010.00差生人数2191221710差生率5.0047.5030.005.0042.502.500.00标准差12.8339.5018.5414.7315.9820.4816.92众数66.0012.0

16、020.0037.0030.0061.0041.00中位数66.0028.0046.5057.0032.0058.5060.00最高分8711791.582748986最低分323152671223100-120050000090-99041000080-89730202470-795247171060-69153611310850-59906543540-49117874830-3931958730-29021721772使用说明：1.录入成绩时输入班级、姓名和各科成绩即可，其他不用填写，系统会自动生成，可以改变学科名称。2.表的最后为学科统计数据，其中语文、数学、英语三个学科满分为120分

17、，其他学科满分为100分。考场七年四班考试成绩汇总表考号 班级姓名语文数学英语思品历史地理生物总分名次 年名四郑玉旺6372132284452247四侯雨桐446343.555213867331.5四田馨757673.554587067473.5四于乐61341.53662540212.5四陈佳琳771118972349067540四张庆宇55162243332563257四孙杨佳龙52182037182566236四刘旭东60103436273657260四邓丹丹38326208106111四孔祥菲718459.559344558410.5四张鑫736585.549374260411.5四洪

18、孟573036.557151744256.5四张双双69604674335464400四刘先峰6811557.554317073468.5四李善佳392241.543261263246.5四肖雅萱72847359287572463四邹德红59326.552222055237.5四李悦714470.566194066376.5四于君521423.537101656208.5四宋丽君663147.548242343282.5四李琳7810476.576449073541.5四周庆虹8310095.555607374540.5四耿梦远603834.561292843293.5四丁佳奇0四宣冬月747

19、86767243860408四荣广鑫597987.559276443418.5四杨志国4692247211841204四时睿8311394.572607972573.5四刘文轩711017257253843407四孙佳东804286.554314767407.5四柳建安3663022144360211四徐青雨4323224821266725074学科语文数学英语思品历史地理生物实考人数31313131313131及格人数9111072818及格率29.0335.4832.2622.586.4525.8158.06总分193515521626160186813211782平均分62.4250.0

20、652.4551.6528.0042.6157.48优生人数0600020优生率0.0019.350.000.000.006.450.00差生人数0108220121差生率0.0032.2625.816.4564.5238.713.23标准差13.4237.9825.2214.0313.2122.9314.12众数71.003.0022.0054.0021.0038.0067.00中位数63.0042.0046.0054.0027.0038.0060.00最高分8311595.576609074最低分36320206106100-120060000090-99002002080-8932400

21、0070-79935405560-697313211350-596021111540-49325616730-3933457400-290128220121使用说明：1.录入成绩时输入班级、姓名和各科成绩即可，其他不用填写，系统会自动生成，可以改变学科名称。2.表的最后为学科统计数据，其中语文、数学、英语三个学科满分为120分，其他学科满分为100分。考场七年五班考试成绩汇总表考号 班级姓名语文数学英语思品历史地理生物总分名次 年名五贺文欣72827937201455359五袁静茹695179.563255453394.5五刘海深6494749194462294五宋鑫超675383505076

22、78457五岳安琪87839070335677496五于增睿211255.534171613168.5五李晓庆5382156475182318五王翔宇449213361315141五代嘉乐55232643294560281五姜涛50173545174821233五张鑫宇628382.546295545402.5五倪双707489.545302350381.5五张雪86999587554977548五吕珍珍51295855235064330五黄思琦78709354477377492五徐雪莹641739.530183468270.5五钱洋洋429192310208131五辛丽娜655052.535

23、322457315.5五倪宝鑫514967.553142968331.5五朱童旭20341.551123960226.5五李春婷546223791229169五李佳571362.5404125193.5五王学威8510910485568173593五石慧坤709795.574353068469.5五官晓庆694792.562282961388.5五孙增祥46112634121721167五侯雪67267453201753310五南凤颖847282.576245656450.5五宫子强573234181665213五韩旭4616242361938172五李林544539.548183459297

24、.5五包贵鑫4515204422667829075学科语文数学英语思品历史地理生物实考人数32323232323232及格人数681370416及格率18.7525.0040.6321.880.0012.5050.00总分190512901841157677512021696平均分59.5340.3157.5249.2524.2237.5653.00优生人数0312011优生率0.009.383.136.250.003.133.13差生人数2149223147差生率6.2543.7528.136.2571.8843.7521.88标准差16.1432.4028.2216.0014.1820.0

25、622.19众数69.009.0021.0037.0020.0056.0077.00中位数59.5027.5056.7547.0021.0034.0059.50最高分8710910487568182最低分20319234125100-120011000090-99025000080-89434201170-79433302660-69802201950-59933736740-49532924130-3900374410-292179223147使用说明：1.录入成绩时输入班级、姓名和各科成绩即可，其他不用填写，系统会自动生成，可以改变学科名称。2.表的最后为学科统计数据，其中语文、数学、英语

26、三个学科满分为120分，其他学科满分为100分。考场七年六班考试成绩汇总表考号 班级姓名语文数学英语思品历史地理生物总分名次 年名六王鑫汝531246.547143532239.5六姜雨新823490.562434970430.5六刘晓晨81104101.572717372574.5六袁小隆683957.560223764347.5六曲艺613578.551376457383.5六潘杭媛80567868407261455六孙文强764786.553483967416.5六冯鑫鑫73899184486471520六韩磊75566967606072459六徐斌46924.532192218170.

27、5六王紫卓875510576485573499六李永安5563940193246237六谭静78728755313762422六王雨泽8010996.572655871551.5六高健烨67777255195273415六刘栋7811411262567284578六于慧雯88789768698871559六韩卫国60407751678854437六董嘉美87509763425569463六李坤51203136113026205六金朝798910647478486538六李潇8211795.571716778581.5六迟佳鑫581328.559192056253.5六冯双双684474.565

28、496473437.5六韩昊513239.511131820184.5六高金娜90106108.557668180588.5六张文晋5163752271319205六牛世龙7499102.548456460492.5六杨春宇471139.52716921170.5六王彬58124026253257250六盖明钰69488266392850382六孙小婷65295753406767378六修和洋59666.547362465303.5六于连成52142438141636194六孙冬旭4315203791328165六代双玉713859.557355472386.5六程琳8350735553666

29、2442六许智博784579.551546048415.5六刘峻宇5317612631021191六李雪58517247346271395六杨铭861057971526973535六栾福欣66836235205442362六窦睿8047997049606547076学科语文数学英语思品历史地理生物实考人数43434343434343及格人数2013251671926及格率46.5130.2358.1437.2116.2844.1960.47总分2947217930432290164521172463平均分68.5350.6770.7753.2638.2649.2357.28优生人数071010

30、43优生率0.0016.2823.262.330.009.306.98差生人数0135415107差生率0.0030.2311.639.3034.8823.2616.28标准差13.2433.8326.1015.4618.7722.5319.33众数80.006.0072.0047.0019.0064.0071.00中位数69.0047.0074.5055.0040.0055.0064.00最高分9011711284718886最低分43620113918100-120066000090-99117000080-891133104370-799396231360-6980495121050-5

31、911631246540-493626111330-3905556720-290134415107使用说明：1.录入成绩时输入班级、姓名和各科成绩即可，其他不用填写，系统会自动生成，可以改变学科名称。2.表的最后为学科统计数据，其中语文、数学、英语三个学科满分为120分，其他学科满分为100分。考场七年级考试成绩汇总表2013.10月考班级姓名语文数学英语思品历史地理生物总分学年名次二王宇瑶8111510186608680609二曲天琪7610787.560457130476.5二田兆亮501336.543145873287.5二靖叶萱775183.555396367二徐春艳493453712

32、3717二于思佳38125851212545二刘云飞27928108167二刘芳含73547761487978二吴宏俊432628.555181430二张家俊5033450142444二毕建军38271730172550二汪龙女811059876776781二由志顺4732849385541二潘婉婷816896.572417780二薛福林46943.549172315二丛珊829590.572568574二袁青林71578362436772二许立颖712985.554315764二刘兆辉67308666406978二姜吉顺29182220167二姚金生54375554237446二包晶茹747

33、291.567434678二冯欣如4233238246638二程美琪581568.546193553二杜娟797986.561437785二郑馨66267947115139二刘佳5564163135535二鲁精武748784.561667181二张家辉52795226127144二李延秋68827461305969二孙冬雪736580.554356970二于文玲5462940203044二张雅宁82739478545874二王欣宇70699162337678二周田甜643657.517276253二王欣蕾711166.566647067二包德毅522359.546287542二徐成399194

34、3162210二张春旭5903236205019二于华67366966328275二赵伟鹏514180.548135762二白欣宝8010794.566488580二谢鑫莲69496149417775二宋明轩5131734185239六王鑫汝531246.547143532六姜雨新823490.562434970六刘晓晨81104101.572717372六袁小隆683957.560223764六曲艺613578.551376457六潘杭媛80567868407261六孙文强764786.553483967六冯鑫鑫73899184486471六韩磊75566967606072六徐斌46924.

35、532192218六王紫卓875510576485573六李永安5563940193246六谭静78728755313762六王雨泽8010996.572655871六高健烨67777255195273六刘栋7811411262567284六于慧雯88789768698871六韩卫国60407751678854六董嘉美87509763425569六李坤51203136113026六金朝798910647478486六李潇8211795.571716778六迟佳鑫581328.559192056六冯双双684474.565496473六韩昊513239.511131820六高金娜90106108

36、.557668180六张文晋5163752271319六牛世龙7499102.548456460六杨春宇471139.52716921六王彬58124026253257六盖明钰69488266392850六孙小婷65295753406767六修和洋59666.547362465六于连成52142438141636六孙冬旭4315203791328六代双玉713859.557355472六程琳83507355536662六许智博784579.551546048六刘峻宇5317612631021六李雪58517247346271六杨铭861057971526973六栾福欣6683623520544

37、2六窦睿80479970496065三孙家淼35122037163441三杨亚男70126752305544三白雪66285069366873三李佳67755961284963三刘佳男849161.562446179三朱晓楠69915472436670三王俊雨69846869527573三许欣6563061312541三王新燃54123554254954三宫兆嘉598049.549486560三姜连露831057977367260三张春雪6533454191547三赵雯婧84937271567776三王悦821116576617981三孙思宇57123547243934三万怡796549823

38、93562三康家宝57183849334236三鲁精文646751.545196367三王传民68926652406158三孙悦68214560273960三孙平文3262326141223三包宇琦73153939277153三孙晓晨53333463496276三王传玉5212272971942三丁志鹏661137464637073三张双杰81486470456862三隋欣74615872526045三历彦军62114848376185三丛俊一628540.547435977三宋晓青8711291.567588574三孙楠56619.533143530三姜吉龙4963037115828三陶春旭

39、821175881748986三陈红6632873282863三宋伟镇687973.562607372三刘学斌562840.544202453三丛芯宇64183653303382三李晓宇71124068264751三孙仕久58101540173741三孙文3932036261642四郑玉旺6372132284452四侯雨桐446343.555213867四田馨757673.554587067四于乐61341.53662540四陈佳琳771118972349067四张庆宇55162243332563四孙杨佳龙52182037182566四刘旭东60103436273657四邓丹丹38326208

40、106四孔祥菲718459.559344558四张鑫736585.549374260四洪孟573036.557151744四张双双69604674335464四刘先峰6811557.554317073四李善佳392241.543261263四肖雅萱72847359287572四邹德红59326.552222055四李悦714470.566194066四于君521423.537101656四宋丽君663147.548242343四李琳7810476.576449073四周庆虹8310095.555607374四耿梦远603834.561292843四丁佳奇缺考四宣冬月74786767243860

41、四荣广鑫597987.559276443四杨志国4692247211841四时睿8311394.572607972四刘文轩711017257253843四孙佳东804286.554314767四柳建安3663022144360四徐青雨43232248212667五贺文欣72827937201455五袁静茹695179.563255453五刘海深6494749194462五宋鑫超67538350507678五岳安琪87839070335677五于增睿211255.534171613五李晓庆5382156475182五王翔宇449213361315五代嘉乐55232643294560五姜涛5017

42、3545174821五张鑫宇628382.546295545五倪双707489.545302350五张雪86999587554977五吕珍珍51295855235064五黄思琦78709354477377五徐雪莹641739.530183468五钱洋洋429192310208五辛丽娜655052.535322457五倪宝鑫514967.553142968五朱童旭20341.551123960五李春婷546223791229五李佳571362.5404125五王学威8510910485568173五石慧坤709795.574353068五官晓庆694792.562282961五孙增祥461126

43、34121721五侯雪67267453201753五南凤颖847282.576245656五宫子强573234181665五韩旭4616242361938五李林544539.548183459五包贵鑫45152044226678一张雪梅49938.549102442一赵煜59149350255757一董芳冰9010299.560558482一刘勇3712213151418一孙小蕾675273.55253082一郑伟196172991448一张瑞泽67466656365574一王鑫宇7811010767548477一姜纪绅6951742185971一孙佳乐59144953132234一张婧雯62

44、5077.551166476一车金航61639.547245660一李悦642260.552113839一尤利萍668389.570607374一隋天昂58183251203155一南洋57242632175848一张玉婷73779867437080一雷欣宇66677.544246254一任艳东52973.557105630一陈崇正691077951537888一汪涛滔7111139.544396072一魏雪鸽622061.546264860一李树伟64797646254372一康佳妤529355582758一栾忠宇缺考一刘成洋43532046234843一于立禛727885.58046669

45、5一夏远航41201444287366一修合彬721007153314287一李金龙678980.553315463一谷文强73434855306066一张嘉琪72628468248176一张照洋665778.568414570一杨可心61124854243446一徐欣817435.566388188一孙磊6131535695546一杨金凤061916862一李双双6036849283749一闫丽花867983.564568179一张旭文547432.564506364一张文文缺考一王思甜6419695192830一张春雪45931.52332736一宋婷婷652260.553182070一张

46、远洋67946.544113760一孙坤721147565307577一孙洁怡38477536212649七学科语文数学英语思品历史地理生物实考人数235235235235235235235及格人数687191791888130及格率28.9430.2138.7233.627.6637.4555.32总分147681070813762.51231772531144613380平均分62.8445.5758.5652.4130.8648.7156.94优生人数03117701821优生率0.0013.197.232.980.007.668.94差生人数811462171266125差生率3.40

47、48.5126.387.2353.6225.9610.64标准差15.2235.9526.2215.0016.8322.1919.80众数67.006.0039.5055.0024.0055.0060.00中位数65.0038.0059.5053.0028.0052.0061.00最高分9011711287779095最低分001410362100-1200289000090-992825002180-8933152570162070-79462134254335760-696310234714375250-595316205919342940-492117235033213430-39111433303931170-29610643171266125使用说明：1.录入成绩时输入班级、姓名和各科成绩即可，其他不用填写，系统会自动生成，可以改变学科名称。2.表的最后为学科统计数据，其中语文、数学、英语三个学科满分为120分，其他学科满分为100分。