学生考试成绩质量自动分析表 2.xls

《学生考试成绩质量自动分析表 2.xls》由会员分享，可在线阅读，更多相关《学生考试成绩质量自动分析表 2.xls（8页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、中中学学 年年级级 班班 期期 考考试试成成绩绩分分析析表表科目语文数学英语政治历史地理生物物理化学满分120120120100100100100100100参考人数9493909494939225及格人数（100分*60%）141202244133023及格率%14.8912.900.0023.4046.8113.9832.61100.0060.00高分人数（100分*85%）4501102313高分率%4.265.380.001.0610.642.153.2650.0060.009090以以上上（100100分分制制）2 25 50 00 05 51 11 11 12 280以上（100分

2、制）510411280170 0以以上上（100100分分制制）970416570060以上（100分制）83414125141050 0以以上上（100100分分制制）16631212870040以上（100分制）136151513100130 0以以上上（100100分分制制）129415615100030以下（100分制）2956784017443501最高分(原始分）1161368085100959210099最低分（原始分）23542926012平均分51.538.817204 24.766667 38.148936 55.085106 36.731183 40.9347838066

3、最高分者成 绩 录 入折 算 后 成 绩班级座号 姓名语文 数学 英语 政治 历史 地理 生物 物理 化学 语文数学英语政治历史地理生物物理化学输入满分分数=120120120100100100100100100折 算 成 100 分 制 的 分 数2班 41张三11511670859679861009995.83 96.67 58.3385967986100992班 30李四1051308074858680609087.5 108.3 66.677485868060902班 16王五9013631809495921275113.3 25.83809495920122班 43吴六9111740

4、8282807375.83 97.5 33.3382828073002班79296647983726676.678053.3379837266002班 426711554568967804455.83 95.8345568967800442班 151008977647961548583.33 74.17 64.17647961540852班 46908742839245757572.53583924575002班 17116841965100656496.677015.83651006564002班490902167857869757517.567857869002班 459268397875

5、608776.67 56.67 32.578756087002班 448061726582527066.67 50.836065825270002班6789433596968646578.33 27.559696864002班 40724932758843696040.83 26.6775884369001班 119733256875487380.83 27.5 20.8368754873002班 336280296074546051.67 66.67 24.1760745460002班 283988635672465332.5 73.33 52.556724653002班 246180225

6、975734350.83 66.67 18.3359757343002班 346380266668535552.5 66.67 21.6766685355002班 275857746681383648.33 47.5 61.6766813836002班 299866166791392981.675513.3367913929001班210513235082498187.5 10.83 19.1750824981002班 235588163974755445.83 73.33 13.3339747554002班 328647296871454171.67 39.17 24.17687145410

7、02班26471214973535453.33 59.17 17.549735354002班 146337186877505752.5 30.831568775057001班 247017226987554758.33 14.17 18.3369875547002班 316358265472513852.5 48.33 21.6754725138002班13852194582586031.67 43.33 15.8345825860002班 477435315678364261.67 29.17 25.8356783642002班 205660144869494946.675011.67486

8、94949002班35968193062268049.17 56.67 15.8330622680001班88835204265296573.33 29.17 16.6742652965002班 228231236675303268.33 25.83 19.1766753032002班 397548183276306062.5401532763060002班 217646275262393263.33 38.33 22.552623932001班 166325313865297252.5 20.83 25.8338652972001班18510164871226870.83 8.333 13.

9、3348712268002班54737146478413539.17 30.83 11.6764784135001班5602036346528675016.673034652867001班37022273048228158.33 18.33 22.530482281002班 185245175935384343.33 37.5 14.1759353843002班87739225044351964.17 32.5 18.3350443519002班 262935265058462324.17 29.17 21.6750584623001班45314171855208344.17 11.67 14

10、.1718552083001班 175122212052256842.5 18.33 17.520522568001班 38612163247256550.83 17.5532472565001班 424041173162432033.33 34.17 14.1731624320001班 206510195442342754.17 8.333 15.8354423427002班 114523233447452737.5 19.17 19.1734474527001班76225222253283051.67 20.83 18.3322532830001班 346421183844401453.3

11、3 17.51538444014002班 482610123268314121.67 8.3331032683141001班 1212232720569701019.17 22.52056970001班 155313153048282144.17 10.83 12.530482821001班 13181326125612701510.83 21.6712561270001班 184210174541466358.333 14.174541466002班 50457163545243537.5 5.833 13.3335452435001班 335127112848311042.522.5 9.

12、16728483110002班 51242216245129382018.33 13.3324512938001班 292244183637261218.33 36.671536372612001班6491917452193140.83 15.83 14.174521931001班 264628191454181238.33 23.33 15.8314541812001班 142613143545322121.67 10.83 11.6735453221001班 234891526601511407.512.526601511001班 284113311438261934.17 10.83 2

13、5.8314382619002班 136214181430271351.67 11.671514302713002班 4982017175221426.667 16.67 14.1717522142002班 529411964813397.534.17 15.836481339001班 393513231028135129.17 10.83 19.1710281351002班 256572210273314547.5 18.3310273314002班 354115112431311234.17 12.5 9.16724313112001班 255418222220187451518.3322

14、20187002班 362623252127221021.67 19.17 20.8321272210001班 3618221125511821518.33 9.1672551182001班 4021614144412451.667 13.33 11.6714441245002班9314201837141725.83 3.333 16.6718371417001班 41298184514411.6677.56.66718451441001班 435039440181041.672.57.54401810001班 302123181221231517.5 19.171512212315002班

15、10231919262216219.17 15.83 15.832622162001班 3513127184622510.83105.8331846225001班 2244166036.6700166000001班 1042121616283351001616283001班 191262282729710518.33827297001班 271092482322118.3337.5208232211001班923161981021719.17 13.33 15.83810217001班 211213261919141010.83026191914002班 376920241027757.516

16、.672410277002班 382191811102731.667 15.83151110273002班 1914131012231711.67 10.83 8.333122317001班 32229512616918.337.54.167126169002班 12267844241.66755.83384424001班 311462042711.6750204270001班 3700000000096000000000970000000009800000000099000000000#000000000#000000000#000000000#000000000#000000000#000

17、000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#000000000#