Excel学生成绩统计.xls

Excel学生成绩统计.xls

《Excel学生成绩统计.xls》由会员分享，可在线阅读，更多相关《Excel学生成绩统计.xls（13页珍藏版）》请在冰点文库上搜索。

20122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次101孙昕雨1371371381381431437755552828578578127102黄雨薇128116133764828.528.5529.55527103徐思娴125119126.5724826.55176531104戚晨露131123135135765330305483216105顾晨129128130.5764429.529.55374422106张蓓125131129734728.528.5533.54925107钱曹仪1171111298047255097532108陆晓红121122137.5137.580575729.529.55473417109黄怡瑒128112113.5774928.528.55087733110路圆13513513513513513581815328.528.5567.5567.51811111李玲燕128109134744827.527.5520.56028112郑佳悦13292110.564362929463.59636113顾黄璐126123138138804927.527.5543.53819114赵晓仪122106114764327274888435115叶慧仪1331241381388282565626.5559.52513116宋剑玲1159994714524.5448.59837117马依欣1291201027251254998234118方天怡1311281431438888565625571571158123张霄枫14014014514514714787875454282860160122124梁智伟13713714914914714785855858303060660611125夏昊杨1261401401421429090565629.529.5583.5583.553126杨晨达128128134828251265493015127杨峥欣1271441441431438484575728.528.5583.5583.553128陶志强127133135.5135.58686585828.528.55685681710129张思源128122138.5138.573545429.529.55453718130林利祥12414614614214282825959303058358375131张志豪128135135140.5140.580532929565.52112132邱犇昊127140140143.5143.58686523030578.5578.5116133杨艺伟119129119.5774825.55186330134江腾跃136136134135.5135.58585522828570.5570.5169135沈潘鑫130115122784925.5519.56129136梁思飖121124134785228285374422137王力为134123131.571555526.55414221138周铮杰1036541433026.5308.512438139朱英杰121135135121.5818155553030543.53819140张昺豪129113129.582824828.528.55305426141刘嘉伟125132137.5137.58181555528.528.55592614146黄磊13012712177545428285374422201上官远路138138129140.5140.58585575729.529.5579579105202储竹文131129140.5140.5818156562828565.5219203严琬林12713113713784845327275592612204张果133136136143143878753282858058094205黄诞乾124134140.5140.58585555527.527.5566208207黄翘楚1211241351358383545429.529.5546.53516208黄蔚怡12611914414482825028285493014209陆瑾怡11596108734826.5466.59332成绩第1页共13页210张颖122110124794929.529.5513.57228211徐洁敏133109139.5139.58181452828535.54819212顾静雯124111135.5135.582824826526.55621213宋怡雯130123129.5734424523.55923214顾沁120117128.579452727516.56725215冯静怡128115125.5694729.529.55147127216凌婧116697358312437111436217沈云蕙127107128.5794928.528.55196224218沈徐燕12813113278565630305552813219尤筱雯12689115.570422828470.59030220韩逸雯135135107132.582824629.529.55325320221崔晋1361361311471478686585828.528.5586.5586.531222袁蕾114718771382640710835224刘琪1331341421428282555528.528.5574.5574.5136232李屹帆127126101765028.528.5508.57629233余天昊1321421421421428585555529.529.5585.5585.542234徐扬130127138.5138.588884927.527.55602411235徐俊杰13213513514114185856060303058358373236陶旭锋122126119.5775029.529.55245822237高奇119131132795328.528.5542.54018238张星129139139137137818157572929572572147239陈思玮134123134.5764929.529.55463617240胡沈佳123135135135.5135.58057573030560.52310241张俊杰11411412484845227.527.5515.56926242黄佳磊127135135127795228285483215243黄永杰11912187753729.529.5468.59231244朱志强1201007276555529.529.5452.59734245阮怡辉11810595.566523030466.59332301俞菁菁127128129.5838355552929551.5291302杭雨忻11362725836303037111422303李艳岚12712712873512727533504304易蓉蓉1118710172422643910117305朱月秀127127124.5774928.528.5533504307陆敏妍118106100744427.527.5469.59114308陆嘉莹1027378602927.527.5369.511623309范思珺12296124713828284798713310益佳雯10552474322272729612730311张玮128121120.578482929524.5576312施佳钰1106080.5473427.527.535911925313益安怡1065355503327.527.5324.512227314s黄晓萍662019141213.5144.513531315周晓琳1191281348282472828538433318王逸文122116128.5764924515.5698324解金芝117118118.573502828504.5799326王夏冰123120113.579555526.5517657327马绮旻10311268.581815127.527.5443991620122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第2页共13页328唐鑫1146284.5623727.527.538711120329忻云豪1148981.5704427.527.542610518330黄苏杰1107961513128.528.5360.511824331武思远1046259.5522826.533212126332窦奕鸣117682445252630512528333黄嘉伦936251.546232828303.512629334杨陈昊1081199582825028.528.5482.58612335黄佳俊1089168582628.528.5379.511221338张玉涵12012313613683835228.528.5542.5402340李成鹏124108109.581814929.529.55018010341潘跃海108105129775229.529.5500.58111343刘浩浩110104117664722.5466.59315344郑婷11378100.5593026.540710819401丛诗鸿12912213475433030533503402金佳意1261311258181433030536472403钱俪婷130126120724127.527.5516.5675404朱羽清1159191.5452925.539711019405程佳妮13311710269472828496839406辛春莹125122104.579482828506.5788407蔡明慧1198881.5702729.529.541510718408许鐤方1091261097640264868510409黄芷璎1229286663929.529.5434.510315411王聪慧944656432824.5291.512824412林雪霏1062853.5232827.527.526613127413苏秋光1091738.5321824.523913329418文菁阳128120118724926.5513.5726419钮羿杰11810199745128284718912420黄诚华11712512772492828518634421丁文杰1251279980523030513747422朱星元10710178.568332828415.510617423汤嘉豪11211172.5744325.543810214424徐子尧12310263.569442929430.510416425唐奕航113754736382633512022426黄子辰11212076664323.5440.510013427蔡运超10444322410292924313228428蔡皓亮123140140134.5858557572828567.5567.5181429吴镐威12911679.5774525.54728811430凌志远1016157.5443326322.512323431张雨波985933.5302428.528.527313026432s王嘉伟812929351728.528.5219.513430434沈亮1072831532829.529.5276.512925435范小军1128662.5503726373.511320448黄宇阳1128634683627273631172150150250320122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第3页共13页50450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854920122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第4页共13页55060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464520122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第5页共13页64664764864965065170170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974020122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第6页共13页74174274374474574674774874975075180180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483520122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第7页共13页836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871统计ID号1平均120.7108.1108.571.345.227.7481.420122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第8页共13页初初三三年年级级学学科科统统计计班级科科目目语语文文数数学学英英语语物物理理化化学学体体育育总总分分任课教师学年学科满分1501501509060306302012合格基数0.480.480.480.480.480.480.48学期总分162931458914641963061013738.564992.5二均分120.7108.1108.571.345.227.7481.4性质最高140149147906030606中考最低661719141013.5144.5年级极差74132128765016.5461.5初三实考人数13513513513513513513590%人数81735403010019优秀率5.9%12.6%25.9%29.6%22.2%74.1%14.1%60%人数13310598115111134112及格率98.5%77.8%72.6%85.2%82.2%99.3%83.0%及格均分121.4121.3126.776.749.327.8517.4合格人数134115113125121134126合格率99.3%85.2%83.7%92.6%89.6%99.3%93.3%合格均分121.1118.0120.474.547.827.8498.0中位数123119122764828516.5最频值128123134824928537离散度8.822.828.411.08.41.475.4标准偏差11.429.133.715.010.62.094.7=90%人数81735403010019前27%均分131.9134.5139.683.855.429.6567.5后27%均分106.067.760.151.430.425.2348.8区分度0.10.20.30.20.20.10.2单单击击此此处处，下下拉拉菜菜单单选选择择班班级级号号，则则右右侧侧统统计计将将针针对对该该班班统统计计20122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第9页共13页初初三三年年级级分分数数段段统统计计分分数数段段语语文文数数学学英英语语物物理理化化学学体体育育总总分分10%人数22322322322322322301020%人数05311002030%人数01622013040%人数04833034050%人数1119510185060%人数1911980116070%人数912136120137080%人数41281317232208090%人数7548375246326090100%人数8173539298719初初三三年年级级名名次次段段统统计计班班级级前前10%10%前前20%20%前前30%30%前前40%40%前前50%50%前前60%60%总总人人数数11731373838383821627343636363631818313131314151830303030500000050600000051700000051800000071总总计计357110713513513535820122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第10页共13页初初三三年年级级各各班班各各科科均均分分横横向向比比较较班班级级语语文文数数学学英英语语物物理理化化学学体体育育总总分分1127.2124.1128.778.050.927.9536.72125.9118.9125.478.850.228.3527.53112.592.192.265.340.027.1429.24114.691.279.260.337.327.4410.15678年年级级平平均均120.7108.1108.571.345.227.7481.4区区平平均均122.56119.18120.6475.447.73485.51均均差差率率-1.2%-7.4%-8.1%-4.5%-4.2%92.3%-0.6%初初三三年年级级各各班班各各科科合合格格率率横横向向比比较较班班级级语语文文数数学学英英语语物物理理化化学学体体育育总总分分1100.0%97.4%97.4%97.4%100.0%100.0%100.0%2100.0%94.4%100.0%100.0%100.0%100.0%100.0%396.8%71.0%71.0%93.5%80.6%96.8%93.5%4100.0%73.3%60.0%76.7%73.3%100.0%76.7%50.0%0.0%0.0%0.0%0.0%0.0%100.0%60.0%0.0%0.0%0.0%0.0%0.0%100.0%70.0%0.0%0.0%0.0%0.0%0.0%100.0%80.0%0.0%0.0%0.0%0.0%0.0%100.0%年年级级合合格格率率99.3%85.2%83.7%92.6%89.6%99.3%97.5%区区合合格格率率合合格格率率差差率率0.7%0.6%0.6%1.0%1.5%3.3%0.2%20122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第11页共13页初初三三年年级级各各班班各各科科任任课课教教师师表表班班级级语语文文数数学学英英语语物物理理化化学学体体育育班班主主任任1薛宝琴曹秀媛赵倩习云林陆智瑾曹秀媛2王重斌陆斌蒋春伟刘艳陆智瑾王重斌3王重斌曹秀媛蒋春伟习云林陆智瑾蒋春伟4薛宝琴陆斌赵倩刘艳陈超陆斌5徐晨星张政蔡舒静刘艳陈超刘艳67820122012学学年年度度初初三三年年级级第第二二学学期期中中考考考考试试成成绩绩汇汇总总表表考试时间2012年6月1617日学学号号姓姓名名语语文文数数学学英英语语物物理理化化学学体体育育总总分分名名次次班班名名次次成绩第12页共13页平均班级语文数学英语物理化学体育总分1#DIV/0!

2#DIV/0!

3#DIV/0!

4#DIV/0!

5#DIV/0!

6#DIV/0!

7#DIV/0!

8#DIV/0!

总计#DIV/0!

123456780.00.10.20.30.40.50.60.70.80.91.0语文数学英语物理化学体育总分