一班
编号姓 名成绩编号姓 名成 绩编号188317061280328862382.53310063478.53458559.5358065653.5368866796379267879386943996691084406970118541987112904261721379438673149244577415954536751692467576179447877718394887781980498779208450588021605193812290525782239253918324965488842584558585269856778627955787872882588588298359943090609990总人数参考评估指标（二）评估指标（一）赋分76分 类人数%姓 名成绩7675828349571004256662783704973.579二班
编号姓 名成绩编号姓 名成 绩编号姓 名19231766128232616238633100634683497515358465679368766792378767877388261839676910954096701140414871127542877213954383731439449474159045787516867176176747827718824860781978497920245083802185517181229352938223534083247354948425805587852693567086278557938727585288296759963091607390总人数参考评估指标（二）评估指标（一）赋分76分 类人数%赋分成绩70784969639654909559738281.5编号姓 名1234567101112131415161718192021222324252627282930总人数参考赋分76赋分最后得分最后得分参考人数总分2.00均分均分赋分5955.5及 格6246181.660.51.320.3910.297.78.19参考人数总分2.00均分均分赋分5781.5及 格41384.253.93.921.059.177.6876.42参考人数78.4优 秀37.6137学 困76.1优 秀36.51474学 困2.00767676西安交大彬县阳光小学成绩统计表
（ ）年级（ ）科
参考（2%）班级学生人数1234567年级参考人数赋分2.002.002.002.002.002.00#DIV/0!2.00总分5955.55781.55520.56063.55850.56014.5035186均分78.3676.0772.80.8575.9879.14#DIV/0!77.16赋分37.6136.5134.8738.8136.4737.99#DIV/0!37.04人数62546761650373及格率81.5884.2171.05.3379.2285.53#DIV/0!81.80赋分20.3921.0517.7622.3319.8121.38#DIV/0!20.45人数41365038420253优秀率60.5353.9547.3766.6749.3555.26#DIV/0!55.48赋分10.299.178.0511.338.399.39#DIV/0!9.43人数134011010平均分（48%）及格率（25%）优秀率（17%）差生率（8%）总得分名次任课教师年级百分比年 月 日
学困率1.323.955.260.001.301.32赋分7.7.687.588.007.907.78.1976.4270.2682.4774.5678.66#DIV/0!76.74346152胡敏胡敏梁海燕101.7676767577760456767676757776045699.51.55梁海燕107.47程小埂97.16程小埂102.49#DIV/0!#DIV/0!#DIV/0!2.197.82100.00说明 总得分=考试人数×2＋平均分×48℅＋及格率×25＋优秀率×17＋（8－学困率×8）本班人数阅卷组长：成 员：
本成绩计算表严格按照学校统一的计算方法编写而成，表内大部分内容已写保护，仅年级、科目、日期、成绩、名次、任课教师可填写。老师只要填入成绩，可马上算出所有“项目”。选定汇总表，可直接打印“选定区域”。
制作人：李晓锋
三班
成绩56665080.59245.596.593782531763967.59391847282.570.510077.56553.540.59578编号3132333435363738394041424344454748495051525354555657585960姓 名成 绩编号姓 名81.561256286.56353.558.5657766100675268866950.570887195.57288.573677485.575977656779978157992804581998256.58382.58423.58580861008793.588835590评估指标（二）分 类人数%赋分成绩65698366.54485817877.5583976928410092编号1234567101112131415161718192021222324252627282930四班
姓 名成绩编号姓 名成 绩编号姓 名9631836193327562613357.56387346866.5357765883670.566863753.567783886.5687139886993.54082.57083.54158.57194429172874362.5737144807492.54584.575874671.5768347507797.5417883.54974.57991.55088.58085.55181.5819352948291.55387839154828455.5558593568486.55788879155805993816040总人数评估指标（二）参考评估指标（一）赋分75分 类人数%赋分成绩99.58248.583.5708473854999.59678.566.5编号姓 名成绩编号186312543238033481345143561003679037878362.5391055.5401149.5411268.54213631494.544159545169346179447181987492086502197512280522377.553245425100552676562796572848.5582982.559306960总人数参考评估指标（一）赋分77五
评估指标（一）最后得分最后得分总分均分均分赋分5520.5及 格54371.147.45.317.768.057.5870.26参考人数总分2.00均分均分赋分6063.5及 格67500.366.70.022.3311.338.0082.47参考人数总分2.00均分均分赋分5850.576.036.4706572.6优 秀34.86632学 困80.8优 秀38.80学 困7577成绩、选定区域”。
五班
姓 名成 绩编号姓 名8861.5628563528065586658677568546952.57088716372437372.574787580.576947785.57875.579798081.581838292.58372.5845985758663878088707490评估指标（二）分 类人数%赋分成绩93.58058.578.591797773.59281957452.548.5.550.5编号1234567101112131415161718192021222324252627282930总人数六班
姓 名成绩9967551009210049.583.553.577298247.59969658371.599.5839077.56787988610059编号3132333435363738394041424344454748495051525354555657585960姓 名成 绩编号9561916274.5639571651006687677661.56986.5705071967259.5739174827587.5769777807179.58070819382618379.584908552867987868869.53590评估指标（二）分 类人数%姓 名成绩100476397.5968078887763.56677.573.56186编号1234567101112131415161718192021222324252627282930总人数七班
姓 名成绩编号3132333435363738394041424344454748495051525354555657585960姓 名最后得分76参考赋分评估指标（一）赋分最后得分0参考赋分评估指标（一）分 类及 格优 秀学 困6138179.249.41.319.818.397.9074.56参考人数总分2.00均分均分赋分6014.579.1及 格优 秀6542185.555.31.321.3.397.78.66参考人数总分#DIV/0!均分均分赋分0#DIV/0!#DIV/0!及 格优 秀学 困7637.98632学 困0班
成 绩编号616263656667686970717273747576777879808182838485868780评估指标（二）人数%姓 名成绩赋分最后得分000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
