基于Excel深层应用的考试和阅卷系统

合集下载

基于Excel深层应用的考试和阅卷系统

基于Excel深层应用的考试和阅卷系统刘凌波;刘苏淮【期刊名称】《软件工程师》【年(卷),期】2015(000)003【摘要】Based on the curriculum of the excel deep application in the economy and statistics,the examination and grading system is developed accordingly.There're realized the processes of examination questions management,generating test paper automatically,auto-grading,examination paper analysis.Especially,the marking processes of operation questions are achieved.The system makes the examination process more fair and justice.It also aims to alleviate the workload for teachers and promote the efficiency.%针对Excel在经济统计中的深层应用课程开发了相应的考试和阅卷系统，实现了试题管理、自动组卷、自动阅卷、试卷分析的过程，特别是解决了操作题的阅卷环节，使考试过程更加公平、公正，减少了教师的工作量，提高了工作效率。

【总页数】3页(P3-5)【作者】刘凌波;刘苏淮【作者单位】南京财经大学信息工程学院，江苏南京 210023;南京财经大学会计学院，江苏南京 210023【正文语种】中文【中图分类】TP311.52【相关文献】1.基于VBA的 Excel操作题自动阅卷系统的设计与实现 [J], 刘宇君2.基于VBA技术的大学计算机基础考试主观操作题自动阅卷系统的研究 [J], 刘建华;杨小劲3.采用非编程方法使用Excel研制单选题填空题考试和阅卷系统 [J], 赵龙强4.基于HTML5工程图学考试自动阅卷系统的研究 [J], 陈平; 李晓武; 周晓雨; 曹彤5.《计算机应用基础》上机考试——自动阅卷系统的开发与应用 [J], 邱炳城因版权原因，仅展示原文概要，查看原文内容请购买。

基于Excel构建智能计算机考试系统

排成０１０２０３等，图１示。根据考生填入０、０、０如所
收稿日期：２１００１— ９—２９基金项目：２１００年度广西教育厅科研项目（０００Ｘ８）２１１Ｌ３４作者简介：甘伟明（９４一）１５，男，高级工程师，研究方向为计算机应用、多媒体技术应用。
智能计算机考试系统基本上实现了考试的全自
动化。主要功能有：
考卷部分又包括登录页、题型考卷、各答题部分及自动评分部分。每个考生的考卷，据其填写的根
（）１自动组卷；（）２自动判题评分；
学号姓名等信息从原始试卷题目中组题。
（ｃｏｌｆｎｏｍａｉｎａｄＳａｉｃ，ａｇｉｉａｃｎｃｎｍｉｏｌｅＮｎｉ３０３ＣｉａＳｈｏｆｒｔｎｔｔｔｓＧｕｘｎｎｅａｄＥｏｏｃＣｌｇ，ａｎｎ５００，ｈｎ）ｏＩｏｓｉｎＦｓｅｇ
ＡｂｔａｔＴｅｉｔｌｇｎｅｃｌｕａｏｘｍｉａｏｙｔｍａｒｅｕｏｅａｎａｉａｌｆｆｌｓｒｃ：ｈｎｅｌｅｃａｃｌｔｒｅａｎｔｎｓｓｉｉｅｃｒｉｄｏｔｔｘｍｉｅｂｓｃｌｏｕｌｙ —
教师端包括原始试卷一答案、班级成绩汇总生
成部分及考试成绩统计分析报表自动生成部分。
１１原始试卷．
（）动统计卷面分数；３自（）４自动生成班级（场）考成绩报表；
（）５自动生成成绩统计分析表。智能计算机考试系统的自动组卷功能在学生考

excel自动阅卷考试系统

Excel 自动阅卷考试系统一、设计背景考试是学校重要的一个环节，考试的复杂性，谁都知道。

由此，产生了自动阅卷系统，而网上众多的阅卷系统，操作复杂，不是要互联网，就是要安装服务器，连接数据库等，而且制作电子试卷入题库也很复杂、繁琐。

本软件设计简单，易操作，无需互联网，也无需架设服务器、数据库等，是基于Excel软件而设计开发的。

教师只需要将全部word试题复制到Excel模板题库中，接着分发给学生做，然后收卷，最后由本软件自动批阅试卷，统计分数，形成Excel 表格。

方便快捷，无需编程基础，只要您会使用鼠标单击，打开文件即可，其余的交给软件自动完成。

二、使用说明1、试卷制作（制作部分）存在两种方式，由用户灵活选择。

①第一种类型——方便易操作采用的是word试卷与答题卡分开。

（1）对于word试卷，没有任何要求，上面有题目内容，有选项即可。

（2）对于答题卡，必须使用本软件设计的标准答题卡三、使用截图（具体见 VB自动阅卷考试系统）（英文版）Two regulations promulgated for implementation is in the party in power for a long time and the rule of law conditions, the implementation of comprehensive strictly strategic plan, implementation in accordance with the rules and discipline to manage the party, strengthen inner-party supervision of major initiatives. The two regulations supporting each other, the < code > adhere to a positive advocate, focusing on morality is of Party members and Party leading cadres can see, enough to get a high standard; < rule > around the party discipline, disciplinary ruler requirements, listed as "negative list, focusing on vertical gauge, draw the party organizations and Party members do not touch the" bottom line ". Here, the main from four square face two party rules of interpretation: the first part introduces two party Revised regulations the necessity and the revision process; the second part is the interpretation of the two fundamental principles of the revision of laws and regulations in the party; the third part introduces two party regulations modified the main changes and needs to grasp several key problems; the fourth part on how to grasp the implementation of the two regulations of the party. < code > and < Regulations > revised the necessity and revised history of the CPC Central Committee the amendment to the Chinese Communist Party members and leading cadres honest politics several guidelines > and < Chinese Communist Party discipline and Punishment Regulations > column 1 by 2015 to strengthenparty laws and regulations focus. Two party regulations revision work lasted a Y ears, pooling the wisdom of the whole party, ideological consensus, draw historical experience, respect for the wisdom of our predecessors, which reflects the unity of inheritance and innovation; follow the correct direction, grasp the limited goals, adhere to the party's leadership, to solve the masses of the people reflect a focus on the problem. The new revision of the < code > and < rule >, reflects the party's 18 and the eighth session of the third, the spirit of the fourth plenary session, reflecting the experience of studying and implementing the General Secretary Xi Jinping series of important speech, reflects the party's eighteen years comprehensive strictly practice. (a) revised two regulations of the party need of < the ICAC guidelines > in < in 1997 Leaders as members of the Communist Party of China clean politics certain criteria (Trial) > based on revised, the promulgation and implementation of January 2010, to strengthen the construction of the contingent of leading cadres play an important role. But with the party to manage the party strictly administering the deepening, has not been able to fully meet the actual needs. Content is too complicated, "eight prohibition, 52 are not allowed to" hard to remember, and also difficult to put into practice; the second is concisely positive advocated by the lack of prohibited provisions excessive, no autonomy requirements; the third is banned terms and discipline law, both with the party discipline, disciplinary regulationsrepeat and Criminal law and other laws and regulations repeat; the fourth is to "clean" the theme is not prominent, not for the existing problems, and is narrow, only needle of county-level leading cadres above. < rule > is in 1997 < Chinese Communist Party disciplinary cases (Trial) > based on revision, in December 2003 the promulgation and implementation, to strengthen the construction of the party play very important role. Along with the development of the situation, which many provisions have been unable to fully meet the comprehensive strictly administering the practice needs. One is Ji law, more than half of the provisions and criminal law and other countries laws and regulations Repetition; two is the political discipline regulations is not prominent, not specific, for violation of the party constitution, damage the authority of Party Constitution of misconduct lack necessary and serious responsibility to pursue; third is the main discipline for the leading cadres, does not cover all Party members. Based on the above situation, need to < the criterion of a clean and honest administration > and < rule > the two is likely to be more relevant regulations first amendment. By revising, really put the authority of Party discipline, the seriousness in the party tree and call up the majority of Party members and cadres of the party constitution of party compasses party consciousness. (II) two party regulations revision process the Central Committee of the Communist Party of China attaches great importance to two regulations revision . Xi Jinping, general books recorded in the FifthPlenary Session of the eighth session of the Central Commission for Discipline Inspection, on the revised regulations < > made clear instructions. According to the central deployment, the Central Commission for Discipline Inspection from 2014 under six months begin study two regulations revision. The Standing Committee of the Central Commission for Discipline Inspection 4 review revised. Comrade Wang Qishan 14 times held a special meeting to study two regulations revision, amendment clarifies the direction, major issues of principle, path and target, respectively held a forum will listen to part of the province (area) secretary of the Party committee, Secretary of the Discipline Inspection Commission, part of the central ministries and state organs DepartmentThe first party committee is mainly responsible for people, views of experts and scholars and grassroots party organizations and Party members. Approved by the Central Committee of the Communist Party of China, on 7 September 2015, the general office of the Central Committee of the Party issued a notice to solicit the provinces (autonomous regions, municipalities) Party, the central ministries and commissions, state ministries and commissions of the Party (party), the General Political Department of the military, every 3 people organization of Party of two regulations revision opinion. Central Commission for Discipline Inspection of extensive solicitation of opinions, careful study, attracting, formed a revised sent reviewers. In October 8 and October 12, Central Committee PoliticalBureau Standing Committee and the Political Bureau of the Central Committee After consideration of the two regulations revised draft. On October 18, the Central Committee of the Communist Party of China formally issued two regulations. Can say, two laws amendment concentrated the wisdom of the whole party, embodies the party. Second, < code > and < Regulations > revision of the basic principles of two party regulations revision work and implement the party's eighteen, ten eight plenary, the spirit of the Fourth Plenary Session of the Eleventh Central Committee and General Secretary Xi Jinping important instructions on the revised < low political criterion > and < Regulations >, highlighting the ruling party characteristics, serious discipline, the discipline quite in front of the law, based on the current, a long-term, advance as a whole, with Bu Xiuding independent < rule > and < rule >. Main principle is: first, adhere to the party constitution to follow. The constitution about discipline and self-discipline required specific, awaken the party constitution of party compasses party consciousness, maintaining the authority of the constitution. General Secretary Xi Jinping pointed out that "no rules, no side round. Party constitution is the fundamental law, the party must follow the general rules. In early 2015 held the eighth session of the Central Commission for Discipline Inspection Fifth Plenary Session of the 16th Central Committee, Xi Jinping again pointed out that constitution is the party must follow the general rules, but also the general rules." the revisionof the < code > and < rule > is Method in adhere to the regulations established for the purpose of combining rule of virtue is to adhere to the party constitution as a fundamental to follow, the constitution authority set up, wake up the party constitution and party rules the sense of discipline, the party constitution about discipline and self-discipline specific requirements. 4 second is to adhere to in accordance with the regulations governing the party and the party. The Party of rule of virtue "de", mainly refers to the party's ideals and beliefs, excellent traditional style. The revised the < code > closely linked to the "self-discipline", insisting on the positive initiative, for all members, highlight the "vital few", emphasized self-discipline, focusing on the morality, and the majority of Party members and the ideological and moral standards. The revised < > Ji method separately, Ji, Ji Y an to Method, as a "negative list", emphasizing the heteronomy, focusing on vertical gauge. Is this one high and one low, a positive reaction, the strict party discipline and practice results transformation for the integration of the whole party to observe moral and discipline requirements, for the majority of Party members and cadres provides benchmarking and ruler. Third, insist on to. In view of the problems existing in the party at the present stage, the main problems of Party members and cadres in the aspect of self-discipline and abide by the discipline to make clearly defined, especially the party's eighteen years strict political discipline and political rules, organization and discipline andto implement the central eight provisions of the spirit against the four winds and other requirements into Disciplinary provisions. Not one pace reachs the designated position, focusing on in line with reality, pragmatic and effective. After the revision of major changes, major changes in the < code > and < rule > modified and needs to grasp several key problems (a) < code > < code > adhere to according to regulations governing the party and party with morals in combination, for at the present stage, the leadership of the party members and cadres and Party members in existing main problems of self-discipline, put forward principles, requirements and specifications, showing Communists noble moral pursuit, reflected at all times and in all over the world ethics from high from low 5 common requirements. One is closely linked to the "self-discipline", removal and no direct relation to the provisions of . the second is adhere to a positive advocate, "eight prohibition" 52 are not allowed to "about the content of the" negative list moved into synchronization amendment < cases >. Three is for all the party members, will apply object from the leadership of the party members and cadres to expand to all Party members, fully embodies the comprehensive strictly required. The fourth is prominent key minority, seize the leadership of the party members and cadres is the key, and put forward higher requirements than the ordinary Party members. Five is to simplify, and strive to achieve concise, easy to understand, easy to remember. The revised < code > is the ruling Party since the first insists ona positive advocate forAll Party members and the self-discipline norms, moral declaration issued to all members of the party and the National People's solemn commitment. > < criterion of a clean and honest administration consists of 4 parts, 18, more than 3600 words. After the revision of the < code >, a total of eight, 281 words, including lead, specification and Party member cadre clean fingered self-discipline norms, etc. Part 3 members low-cost clean and self-discipline, the main contents can be summarized as "four must" "eight code". Lead part, reiterated on ideal and faith, fundamental purpose, the fine traditions and work style, noble sentiments, such as "four must" the principle of requirements, strong tone of self-discipline, The higher request for 6 and supervised tenet, the foothold in permanent Bao the party's advanced nature and purity, to reflect the revised standards requirements. Members of self-discipline norms around the party members how to correctly treat and deal with the "public and private", "cheap and rot" thrifty and extravagance "bitter music", put forward the "four norms". Party leader cadre clean fingered self-discipline norms for the leadership of the party members and cadres of the "vital few", around the "clean politics", from civil servant of the color, the exercise of power, moral integrity, a good family tradition and other aspects of the leadership of the party members and cadres of the "four norms" < > < norm norm. "The Party member's self-discipline norms" and "party members and leading cadre clean fingered self-discipline norms," atotal of eight, collectively referred to as the "eight". "Four must" and "eight" of the content from the party constitution and Party's several generation of leaders, especially Xi Jinping, general secretary of the important discussion, refer to the "three discipline and eight points for attention" statements, and reference some embody the Chinese nation excellent traditional culture essence of epigrams. (2) the revised regulations, the main changes in the revised Regulations > to fully adapt to the strictly requirements, reflects the according to the regulations governing the law of recognition of deepening, the realization of the discipline construction and Jin Ju. < rule > is party a ruler, members of the basic line and follow. And the majority of Party members and cadres of Party organizations at all levels should adhere to the bottom line of thinking, fear discipline, hold the bottom line, as a preventive measure, to keep the party's advanced nature and purity. 1, respect for the constitution, refinement and discipline. Revised < rule > from comprehensive comb physical constitution began, the party constitution and other regulations of the Party of Party organizations and Party discipline requirements refinement, clearly defined in violation of the party constitution will be in accordance with regulations to give the corresponding disciplinary action. The original 10 categories of misconduct, integration specification for political discipline, discipline, honesty and discipline masses Ji Law and discipline and discipline and other six categories, the content of < rule >real return to Party discipline, for the majority of Party members and listed a "negative list. 7 2, highlighting the political discipline and political rules. > < Regulations according to the stage of the discipline of outstanding performance, emphasizing political discipline and political rules, organization and discipline, in opposition to the party's leadership and the party's basic theory, basic line, basic program and basic experience, the basic requirement of behavior made prescribed punishment, increase the cliques, against the organization such as violation of the provisions, to ensure that the central government decrees and the Party of centralized and unified. 3, adhere to strict discipline in the law and discipline In front, Ji separated. Revised < Regulations > adhere to the problem oriented, do Ji separated. Any national law existing content, will not repeat the provisions, the total removal of 79 and criminal law, repeat the content of the public security management punishment law, and other laws and regulations. In the general reiterated that party organizations and Party members must conscientiously accept the party's discipline, die van comply with national laws and regulations; at the same time, to investigate violations of Party members and even criminal behavior of Party discipline and responsibility, > < Regulations distinguish five different conditions, with special provisions were made provisions, so as to realize the connection of Party discipline and state law. 4, reflect Wind building and anti-corruption struggle of the latest achievements. < rule > the party's eighteen yearsimplement the spirit of the central provisions of the eight, against the requirements of the "four winds" and transformation for disciplinary provisions, reflecting the style construction is always on the road, not a gust of wind. In the fight against corruption out of new problems, increase the trading rights, the use of authority relatives profit and other disciplinary terms. Prominent discipline of the masses, the new against the interests of the masses and ignore the demands of the masses and other disciplinary terms and make provisions of the disposition and the destruction of the party's close ties with the masses.Discipline to protect the party's purpose. 8 of these regulations, a total of three series, Chapter 15, 178, more than 24000 words, after the revision of the regulations a total of 3 series, Chapter 11, 133, 17000 words, divided into "general" and "special provisions" and "Supplementary Provisions" Part 3. Among them, add, delete, modify the provisions of the proportion of up to nearly 90%. 1, the general general is divided into five chapters. The first chapter to the regulations of the guiding ideology, principles and scope of application of the provisions, highlight the strengthening of the party constitution consciousness, maintenance the authority of Party Constitution, increase the party organizations and Party members must abide by the party constitution, Y an Centralized centralized, would examine at all levels of the amended provisions implementing and maintaining Party discipline, and consciously accept the party discipline,exemplary compliance with national laws and regulations. The second chapter of discipline concept, disciplinary action types and effects of the regulations, will be a serious warning from the original a year for a year and a half; increase the Party Congress representative, by leaving the party above (including leave probation) punishment, the party organization should be terminated its representative qualification provisions. The third chapter of the disciplinary rules of use prescribed in the discipline rectifying process, non convergence, not close hand classified as severely or heavier punishment. "Discipline straighten "At least eighteen years of five years, these five years is to pay close attention to the provisions of the central eight implementation and anti -" four winds ". The fourth chapter on suspicion of illegal party disciplinary distinguish five different conditions, with special provisions were made provisions, to achieve effective convergence of Party and country 9 method. < rule > the provisions of Article 27, Party organizations in the disciplinary review found that party members have committed embezzlement, bribery, dereliction of duty dereliction of duty and other criminal law act is suspected of committing a crime shall give cancel party posts, probation or expelled from the party. The second is < Regulations > Article 28 the provisions of Party organizations in the disciplinary review But found that party members are stipulated in the criminal law, although not involved in a crime shall be investigated for Party discipline and responsibility shouldbe depending on the specific circumstances shall be given a warning until expelled punishment. This situation and a difference is that the former regulation behavior has been suspected of a crime, the feeling is quite strict, and the latter for the behavior not involving crime, only the objective performance of the provisions of the criminal code of behavior, but the plot is a crime to slightly. < Regulations > the 29 provisions, Party organizations in the discipline review found that party members and other illegal behavior, affect the party's image, the damage to the party, the state and the people's interests, we should depend on the situation Seriousness given disciplinary action. The loss of Party members, seriously damaging the party's image of behavior, should be given expelled from the party. At this article is party member is in violation of the criminal law outside the other illegal acts, such as violates the public security administration punishment law, customs law, financial laws and regulations behavior. The fourth is < cases > Article 32 stipulates, minor party members and the circumstances of the crime, the people's Procuratorate shall make a decision not to initiate a prosecution, or the people's court shall make a conviction and exempted from criminal punishment shall be given within the party is removed from his post, probation or expelled from the party. Party members and crime, sheets were fined in accordance with For acts; the principal Ordinance amended the provisions of the preceding paragraph. This is the new content, in order to achieve Ji method effectiveconvergence. Five is < > the thirty third article 10 of the provisions, the Party member due to an intentional crime is sentenced to criminal law (including probation) sheets or additional deprivation of political rights; due to negligence crime and was sentenced to three years or more (excluding three years) a penalty, shall give expelled punishment. Due to negligence crime is convicted and sentenced to three years (including three years) in prison or be sentenced to public surveillance, detention, shall in general be expelled from the party. For the individual may not be expelled from the party, should control Approval. This is followed and retained the original > < Regulations the provisions of punishment party authorization rules and report to a level party organizations. For is "party members with criminal acts, and by the criminal punishment, generally should be expelled from the party". The fifth chapter of probationary Party member of the discipline and discipline after missing members of the treatment and punishment decisions, such as the implementation of the provisions, clear the related party discipline and punishment decision made after, for duties, wages and other relevant alteration formalities for the longest time. 2, sub sub section will the original regulations of10 categories of acts of violation of discipline integration revised into 6 categories, respectively, in violation of the punishments for acts of political discipline "in violation of discipline behavior of punishment" in violation of integrity of disciplinary action points "of violation punishments for actsof mass discipline" "the violation of work discipline, punishment" in violation of discipline of life behavior punishment "6 chapters. 3, annex" Supplementary Provisions "clear authority making supplementary provisions of, cases of interpretative organ, as well as regulations implementation time and retroactivity etc.. 11 (3) learning understanding > < regulations needs to grasp several key problems The first problem -- about the violation of political discipline behavior > < new ordinance chapter 6 the political discipline column for the six disciplines, that is the main opposition to Party leadership and the opposition of the basic theory, basic line, basic program and basic experience, basic requirements of misconduct made provisions of the disposition, especially the eighteen since the CPC Central Committee put forward the Yan Mingzheng treatment of discipline and political rules requirements and practical achievements transformation for Discipline article, increase the false debate central policies, cliques, against the organization review, make no discipline of the principle of harmony terms. These are the party's eighteen years in comprehensive strictly Process combined with the practice of rich content. (1) false debate the central policies and undermine the Party of centralized and unified the problem is made in accordance with the provisions of the party constitution. Constitution in general programme requirements adhere to democratic centralism is one of the requirements of the construction of the party must adhere to the four cardinal. Applicationof this principle is not only the party the basic organization principle and is also the mass line in party life, it requires that we must fully develop inner-party democracy, respect for the dominant position of Party members, safeguarding the Party member democratic rights, give full play to the enthusiasm and creativity of the party organizations at all levels and Party members, at the same time, also must implement the right concentration, ensure the party's mission < the chaos in unity and concerted action to ensure that the party's decision to get quickly and effectively implementing. The Party Central Committee formulated the major principles and policies, through different channels and ways, fully listen to the party organizations and Party members of the opinions and suggestions, but 12 is some people face to face not to say back blather "" will not say, after the meeting said, "" Taiwan does not say, and nonsense ", in fact, not only disrupt the people thought, some causing serious consequences, the damage to the Party of the centralized and unified, hinder the central policy implementation, but also a serious violation of the democratic system of principles. There is no doubt that shall, in accordance with the Regulations > 4 Specified in Article 6 to give the appropriate punishment. For did not cause serious consequences, to give criticism and education or the corresponding tissue processing. (2) about the destruction of the party's unity < New Regulations > the forty eighth to fifty second article, to damage Party's unity unified and violation of political discipline, punishment situationmade explicit provisions. Article 52 of the new "in the party get round group, gangs seek private gain, cliques, cultivate private forces or through the exchange of interests, for their own to create momentum and other activities to gain political capital, given a serious warning or withdraw from their party posts disposition; if the circumstances are serious, to give Leave a party to observation or expelled from the party. (3) on against the organization review of the provisions of the constitution, party loyalty honesty is party members must comply with the obligations. Members must obey the organization decision, shall not violate the organization decided encounters by asking questions to find organization, rely on the organization, shall not deceive the organization, against the organization. For example, after the investigation does not take the initiative to explain the situation, but to engage in offensive and defensive alliance, hiding the stolen money is against survey organization, is a violation of the behavior of political discipline. Article 24 of the original > < Regulations, although the provisions of the interference, hinder group review the behavior of the fabric can be severely or 13 Aggravated punishment, but did not put this kind of behavior alone as a discipline for qualitative amount of discipline. > < new regulations increase the Article 57, "anti organization review, one of the following acts, given a warning or serious warning; if the circumstances are relatively serious, giving removed from or placed on probation within the party post; if the circumstances are serious, give。

基于Excel的考试系统设计与实现

基于Excel的考试系统设计与实现广东省佛山市南海区石门中学狮山校区刘世能邮编：528225 摘要：对于Excel办公软件，随着版本的升级，其功能也越来越强大，针对考试系统高技术高要求的情况，我们探讨了用Excel设计考试系统，实现了试卷制作简便，分发评判容易，统计快速的考试功能，可低技术、简便、灵活地解决教学中的课外作业考查、考试评价调查等问题，有一定的实用价值。

关键词：考试系统，Excel正文：当前有很多计算机考试系统，既有用各种语言开发的单机版软件，也有用Asp等开发的网络版系统，单机版软件适合学生自测，但一般无成绩导出汇集统计功能，因而不适合班级统一测试与成绩分析；网络版考试系统需要服务器等高技术支持，对网络带宽有一定要求且一般用于局域网，因此无法也不方便各科推广使用。

随着信息技术的普及，学校师生已经基本掌握office系统办公软件的操作，特别Excel作为老师统计成绩、管理成绩的好帮手，又是学生学习的实用工具，因此大家对它非常熟练。

下面笔者探讨了用Excel作为考试系统的设计与研究平台，实现了试卷制作简便，评判容易，统计快速的考试功能，而且技术含量低，操作简便、灵活，非常适合家庭作业考查或课堂测试等。

一、基于Excel的考试系统设计与实现以课堂测试为例，包括基本的单项选择题、多项选择题、判断题、填空题、简答题等，下面详细介绍制作思路与主要技术。

设计思路：在Excel中制作好试卷，通过指定单元格输入学生信息、作答情况，再通过函数IF读取标准答案并判断正误、给出得分，学生试卷保存后交给老师，最后在成绩统计文件中读出所有学生得分或答题情况，计算总分、平均分，并可做考试分析。

信息流程与功能设计如下：主要技术要点：1．输入设计：与传统试卷一样，Excel试卷包括试卷标题、试卷说明、试卷正文（试题），另外还有班级、姓名、学号、解答处、分数等填写项。

试卷内容输入与排版无特殊之处，输入解题信息如采用直接在相应单元格中输入，则会增加学生解答要求，如答案字母的大小写、空格等均会影响学生成绩，对此我们采用了数据序列与窗体控件进行选择设计，尽量减少操作对成绩的影响，下面谈谈两种选择输入的设计：数据序列：在输入单元格中单击“数据”菜单选择“有效性（L）…”，在允许中选择序列，在来源中设计要选择的信息，设置与结果如下图一、图二。

基于Excel的自动阅卷评分系统

基于Excel的自动阅卷评分系统2.1 试卷设计（1）打开Excel文档，建立“试卷”工作表，合并A1：G1单元格，在A1单元格中输入试卷名称“雅安职业技术学院《计算机应用基础》普通专科公共必修课2013年期末测试试卷”并居中。

在A2单元格输入“班级”，D2单元格输入“学号”，F2单元格输入“姓名” ( 合并B2：C2单元格，将B2，E2，G2单元格设置成蓝色底纹。

)。

在A3：G6单元格区域设置（如图一）。

（2）填空题的设计，合并A7：G7，在单元格中输入“一、填空题（每空1分，共20分，请将正确答案填写在相应小题下一行红色文字“答题处”所在单元格内）”，合并A8：G8，在单元格中输入题目，例如：“1、在WINDOWS XP中，若系统长时间不响应用户的要求，为了结束该任务，应使用的快捷键组合是CTRL+ALT+（）。

”在A9单元格中输入“答题”，并将单元格设置成蓝色底纹，按此方式设计10题（如图二）。

（3）选择题的设计，合并A29：G29，在单元格中输入“二、选择题（单选题，每题2分，共50分。

请在每小题右边的“选择答案处”内选择正确答案对应的大写字母）”合并A31：G31，在单元格中输入题目，例如：“2. 要在Excel2003单元格中输入任何分数并保留输入时的数字和数位，方法是：（）。

”合并A32：C32，D32：G32，A33：C33，D33：G33，分别在这四个单元格中输入A、B、C、D四个选项。

单击H列设置数据有效性，打开数据有效性对话框，在“设置”选项卡中，有效性条件允许中选择“序列”，来源中输入“选择答案处,A,B,C,D”（不含引号且其中逗号为半角格式），勾选“提供下拉箭头”，单击“确定”按钮完成设置。

按此方法共设计25个选择题（如图三）。

2.2 评分表的设计（1）在同一个工作薄中建一个工作表命名为“评分表”，合并A1：F1单元格，在单元格中输入“雅安职业技术学院公共必修课《计算机应用基础》评分表”，分别在A2，E2单元格中输入“学号”、“姓名”，为了在评分表中能够自动获取考生在试卷中填写的信息，在B2单元格中输入“=试卷!E4”，在F2单元格中输入“=试卷!G4”。

基于Excel的考试系统设计与实现

基于Excel的考试系统设计与实现本系统主要实现一个在线考试系统，系统分为三大模块：用户模块、管理员维护模块、试卷和试卷管理模块。

1、用户模块实现的功能用户登录：不同用户可以通过选择对应的用户类型，然后输入用户名和密码登录系统，同时包括修改自己密码的功能。

2、管理员模块实现的功能(1)教师管理：可进行教师信息的维护操作，如增加、修改、查询、删除以及教师任课班级设置功能。

(2)班级管理：可进行班级信息的管理和维护操作，如增加、修改、查询、删除和班级任课教师的管理功能。

(3)学生管理：可进行学生信息的增加、修改、查询、删除操作。

3、试卷和试卷管理模块实现的功能(1)试卷发布、修改、删除：教师可发布新的考试试卷、其中包括试卷的增加、修改、查询和删除。

(2)试题的增加、修改、删除：可对试卷包含的试题进行增加、修改和删除。

(3)学生考试：学生登录系统后，可选择参加某考试，在规定时间内完成答卷并给出相应分数。

以课堂测试为例，包括基本的单项选择题、多项选择题、判断题、填空题、简答题等，下面详细介绍制作思路与主要技术。

信息流程与功能设计如下：负责班级及学生信息管理部分：1. 学生登录可以使用查阅学籍情况、查阅本人所学课程设置情况、查阅本人成绩情况、查阅本人考试安排情况、查阅本人所在班级、查阅学校最新通告以及对本人的登录密码进行修改等权限。

2. 教务人员登录可以使用对在校学生学籍管理、课程设置管理、成绩管理、考试安排管理、班级管理、教师信息、学校最新通告管理以及登录教务人员密码修改等权限。

基于Excel的试卷生成和评分系统

过利用Ｅｃｌ式和ＶＢ编程，ｘｅ公Ａ实现题库管理、自动组题和评分等核心功能，建了一个试卷自动生成和评分构系统。该系统能节省纸张的费用、少诸多考试环节，减节省教师大量的阅卷时间，高等院校中具有很高的推在
案．后用Ｉ函数进行判分。后，Ｓ然Ｆ最用ＵＭ函数对各大题求总分．求总成绩。外，再此由于简答题和问答题无法使用自动评卷，要教师手工评卷。需五、统的安全策略系在上述的Ｅｃｌ作簿中，和题库相关的工作表ｘｅ工
ＣＤ” 如图４所示。，，
告面答案判分ＯＯＢ２ＣＯＡ２５Ｂ２二、判断珏ｔ本大题共ｓ韪，每韪２小分ｌ置号卷薅答案判分ｌ对２２错２３错２４错２５对０
二、库的构建和管理题
，
雾
７ｌＢ４５
：、新ｌ锺行将ｊ搏囊箐椿本量ｓ，丘曩刊置对越翔，葺＾囊元，大麸矗踟二龊小
ｍ；１
建立一个Ｅｃｌ作簿文件，人多个工作表。为ｘｅ工插作
后点击 “ 成试卷，始考试 ” 钮，系统会自动从相应生开按则题库中随机抽取试题以组成试卷，该按钮在考生点击一次后自动失效，以避免考生重复抽题。击该按钮应执行点的ＶＡ代码如下：ＢＰｉａｅＳｂＣｍｍａｄｕｔｎＣｉｋｒｔｕｏｖｎＢｔｌｌ０ｏｃ

Excel在考试考核管理系统中的简单应用

１引言．
Ｅｃｌｘｅ是微软Ｏｆｅｆｃ软件中专门用于数据处理的一个成员。它具有ｉ强大的数据计算、数据分析和管理功能，还支持ＶＡ语言，Ｂ可以通过编写代码扩展其功能，因此在数据处理系统中有着广泛的用途。基于一个教育工作者，生的考试考核丁作是整个教学活动中的重要环节。高学在校中学生人数众多，传统的手工方式完成这项任务工作量大、效率低、容易出错。利用Ｅｃｌｘｅ软件设计一个简易考试系统，能够实现计分、成绩录入、成绩统计等工作的自动化，大大减轻教师的工作负担，提高工作质量和效率２设计思路．建立一个试卷文件ｓ＠ａ．ｓ在其中录入单项选择题、ｈｎｘ，ｉ判断题、多项选择题、客观题四种题型的出题内容，在工作表右侧区域中设置对应每道题的正确答案、所得分数，Ｅｃｌ让ｘｅ实现自动计分（客观题除外）学：生在考试过程中答案、分数相应列被隐藏保护，只能看到试题。考试完毕，将试卷文件另存为以学号命名的文件，例如“ ９１ｌ、００．ｓ依００．ｓ “ ９２ｘ ” ｘ” ｌ此类推到“９７ｌ（班级有６０６．ｓ以ｘ” ７人为例）然后提交到服务器上教师，账号对应的空间中。教师考试结束后，登陆服务器，在账号对应的空间中下载所有考生的文件，并打开对客观题进行人工评分，然后保存。新建～个成绩统计文件ｓｏｅｌ，ｃｒ．ｓ在其中通过ＶＢｘＡ编程实分计算。在Ｓｅｔｈｅｌ中ｈｅ２中对Ｓｅｔｈｅｌ中的成绩单进行分析，统计出最高分、最低分、平均分、各个分数段的人数百分比，以图表的形式展现出来。并３详细设计．（）１单项选择题如下图１所示，ｓｉａ．ｓ文件的Ｓｅｔ在ｈｊｎｘｕｌｈｅ１中，一行显示学生的第姓名，第二行显示题型标题、选项对应编号、学生答案、正确答案、得分情况等列（中空余列被隐藏了，以列号不连续）从第三行开始是每其所。道题目的内容。

EXCEL操作题题库建设和自动阅卷的实现

EXCEL操作题题库建设和自动阅卷的实现摘要：本篇文章为EXCEL操作题的题库建设和自动阅卷提供了一种思路：利用XML文档是纯文本篇文章档，语法简单，传输方便、准确、安全，不但能够存储数据，而且能够表示数据之间复杂的逻辑关系这个系列特点，为每一道试题配置一个XML评分规则文件，通过设计一个评分规则文件解释系统，生成和解释评分规则文件，从而真正实现试题和阅卷代码的分离，而且老师还能通过可视化的界面来编制试题，实行题库建设。

关键词：EXCEL操作题XML 题库建设自动阅卷EXCEL操作题是高中信息技术课程必修内容的重要组成部分，对它的练习和巩固无论对于老师还是对于学生，都是一项巨大的工程，以往的方法主要集中于二点：其一是纯手工操作，老师发下试题，学生练习完成后上交，老师再批阅学生试题，给出分数；其二是利用现有的练习软件，系统给出试题，学生完成后交卷，系统实行自动阅卷并给出阅卷结果。

上述二种方法都有其无法克服的缺点，前者是费时费力，老师需要手工批阅每个学生的作业，对于信息技术老师来说，一次作业可能就是几百份，工作量相当巨大，而且学生无法实时地知道自己的完成结果，对于一星期二课时的安排，学生可能无法想起自己上一节课的所完成的作业的情况，不利于知识点的掌握和巩固。

后者因为采用了现有的软件，这些软件多为某一次考试而编制，采用固定的试题，固定的阅卷代码，老师无法实行试题的编制，也就无法实行知识点的安排和拓展，因而软件的适用率有限，无法真正地为教学服务。

基于上述的考虑，本篇文章为EXCEL操作题的题库建设和自动阅卷提出了一种新的思路：利用XML文档是纯文本篇文章档，语法简单，传输方便、准确、安全，不但能够存储数据，而且能够表示数据之间复杂的逻辑关系这个系列特点，通过为每一道试题配置一个XML评分规则文件，利用评分规则文件解释系统来生成和解释评分规则文件，从而真正实现试题和阅卷代码的分离，而且老师还能通过可视化的界面来编制试题，实行题库建设。

基于excel的考试系统设计与实现

基于Excel的考试系统设计与实现需要考虑到以下几个方面：1. 考试题目管理：需要设计一个Excel表格来存储考试题目，包括题目类型、题目难度、题目内容等信息。

可以使用Excel的多个工作表来分类存储不同类型的题目，例如选择题、填空题、判断题等。

2. 学生信息管理：需要设计一个Excel表格来存储学生信息，包括姓名、学号、班级等信息。

可以使用Excel的多个工作表来分类存储不同班级的学生信息。

3. 考试成绩管理：需要设计一个Excel表格来存储考试成绩，包括学生姓名、学号、考试成绩等信息。

可以使用Excel的多个工作表来分类存储不同班级的考试成绩。

4. 考试计时器：可以设计一个计时器来控制考试时间，例如使用Excel的宏功能来实现倒计时功能。

5. 考试监考功能：可以设计一个监考表格来记录考试过程中的情况，例如监考教师姓名、监考时间等信息。

基于以上几个方面的考虑，可以按照以下步骤来实现基于Excel 的考试系统：1. 设计考试题目表格：使用Excel的多个工作表来分类存储不同类型的题目，建立相应的表格结构，并填写题目内容。

2. 设计学生信息表格：使用Excel的多个工作表来分类存储不同班级的学生信息，建立相应的表格结构，并填写学生信息。

3. 设计考试成绩表格：使用Excel的多个工作表来分类存储不同班级的考试成绩，建立相应的表格结构，并填写考试成绩。

4. 实现考试计时器：使用Excel的宏功能来实现倒计时功能，可以在监考表格中添加一个计时器控件来实时更新考试时间。

5. 实现考试监考功能：在监考表格中添加相应的监考教师姓名、监考时间等信息，以便记录考试过程中的情况。

6. 调试和测试：对整个系统进行调试和测试，确保各个功能都能够正常运行。

7. 发布和维护：将系统发布给用户使用，并定期进行维护和更新，以确保系统的稳定性和可靠性。

需要注意的是，基于Excel的考试系统虽然可以实现基本的考试功能，但可能存在一些限制和不足之处。

自己动手_用EXCEL做一个考试成绩分析应用软件

自己动手，用EXCEL做一个考试成绩分析应用小软件长期以来，在每次考完试后，不但要去处理学生的成绩，还要计算和分析教师的成绩。

这是一件非常烦琐和无可奈何的事情。

假如仅仅对学生的总分、名次、各科的平均分实行统计的话，用EXCEL去完成这项工作是一件非常容易的事情，不过很多学校还要对任课教师实行成绩统计，依据就是该任课教师所教该学科的“三率和”。

“三率和”是指将某一学科的平均分+及格率（及格人数/参加考试的人数*100）+优秀率（优秀人数/参考人数*100）。

实际上我们用EXCEL是能够轻松做到的。

只需将学生的考试成绩按照一定的格式录入，那么EXCEL就能够自动去完成计算三率和的工作。

下面我们通过一个实例来看一下。

比方录入初一年级某次考试成绩：录入结束后，利用EXCEL自带的一些函数，就能方便地把结果统计出来。

如图：在开始学习之前，大家有必要理解一些EXCLE 函数方面的知识。

公式和函数是Excel最基本、最重要的应用工具，是Excel的核心，所以，应对公式和函数熟练掌握，才能在实际应用中得心应手。

1．数组公式的输入数组公式的输入步骤如下：（1）选定单元格或单元格区域。

假如数组公式将返回一个结果，单击需要输入数组公式的单元格；假如数组公式将返回多个结果，则要选定需要输入数组公式的单元格区域。

（2）输入数组公式。

（3）同时按“Crtl+Shift+Enter”组合键，则Excel 自动在公式的两边加上大括号{ } 。

特别要注意的是，第（3）步相当重要，只有输入公式后同时按“Crtl+Shift+Enter”组合键，系统才会把公式视为一个数组公式。

否则，假如只按Enter键，则输入的仅仅一个简单的公式，也只在选中的单元格区域的第1个单元格显示出一个计算结果。

2．条件求和SUMIF函数SUMIF函数的功能是根据指定条件对若干单元格求和，公式为:=SUMIF(range,criteria,sum_range)式中range—用于条件判断的单元格区域, 只有当range中的相对应单元格满足条件时，才对sum_range 中的单元格求和。

利用Excel2007制作自动阅卷考试系统

３
。
■＿
● ●Ｉ ■ ：
■＿
譬釜替麒Ｂ擤甘
国象职业技齄鉴定计算机操作员中缓瑶论试题
艇昔试耀医
一
、
●氆 ■ ｔ蕈曩只有一个正ＩＩＩ口嘴蠢．镶将■ 蹇在警 ■ 酲指定的簟是悟中）
２建立学生信息工作表
冉在Ｂ１【｛１插入一个 “ 出题 ”的按钮．
（３）将第二行按图，Ｊ进行单元格合并然后输入考试
称，比如 “ 因家职业技能鉴定计算机操作员・『】级理论
试题 ” 。
后教师可以自动浏卷的功能。『犬１此在用Ｅｘｃｅｌ制作本系统时
应当建：３张Ｉ作，分别用来输入考牛信息．建立题库、制作试卷很多功能的实现都是借助于Ｅｘｃｅｌ的函数的灵活应用以及在ＥｘｅｌＶＢＡ编辑器中进行一些程序代码的编写
即可达到目的。下面详细阐述制作思路与过程
Ｅｘｃｅｌ２００７轻松地制作出一个具有随机出题、智能评分的考试系统，有效地提高了工作效率．以单选择题为例
详细阐述该系统的制作方法关键词：试卷模板制作；模板设计；自动出题；智能评分
本考试系统所具有的基本功能：具有输入考生信息．建题库，考试时Ｆ１动随机从题库中抽题。考生做完试卷
綦本形状中的棱即可，然后在Ｂｌ中拖动鼠标即可厕命

基于Excel深层应用的考试和阅卷系统

基于Excel深层应用的考试和阅卷系统摘要：针对Excel在经济统计中的深层应用课程开发了相应的考试和阅卷系统，实现了试题管理、自动组卷、自动阅卷、试卷分析的过程，特别是解决了操作题的阅卷环节，使考试过程更加公平、公正，减少了教师的工作量，提高了工作效率。

关键词：Excel；考试管理；自动阅卷；VBA中图分类号：TP311.52 文献标识码：B/A1 引言（Introduction）Excel是Office软件包的组件之一，具有数据收集、分析处理、图表设计等诸多功能，我们在日常生活和办公中常常只用到Excel最基本的功能，如：数据输入、格式设置、函数计算、排序筛选等。

实际上，Excel还具有数据分析的强大功能，如投资决策分析、经济订货量模型分析、最优化问题分析、时间序列预测和回归分析等，这些分析工具经常运用在经济统计、金融会计、生产管理、营销物流等各领域。

据统计，80%的全球500强企业都在工作中使用到了Excel 的这些深层应用功能。

在财经类院校中，为经管类的学生开设的有关Excel深层应用的课程，讲授的就是Excel在经济统计领域中常用的这些分析处理功能，这也是财经类院校学生一门重要的基础课程。

为了能够更好地对学生的学习效果进行检测，能够真正考核出学生的实践操作能力，减少人为判卷失误，提高考试的公正性和公平性，减轻教师的工作量，根据课程发展和教学需要，研究和实现了基于该课程的考试和阅卷系统[1]。

2 设计思想（Design philosophy）本系统开发主要分为：后台数据库、前台管理界面和阅卷系统三部分。

题型分为：单项选择题和操作题。

能够根据组卷方案要求，按照题目难易程度的不同和各章节题目数量的不同，自动组成一份试卷，并监管整个考试过程，对考试后的答卷自动阅卷批阅出考试成绩，最后可根据考试成绩按照整体或班级等不同角度进行成绩分析。

考试系统还借鉴了全国计算机二级考试的经验，为有效避免单项选择题考试过程中的作弊行为，在考试时首先进行单项选择题的考试，这时屏蔽了计算机中其他应用程序的使用，并且只能使用鼠标进行选项的选择。

基于Excel的试卷质量深度分析平台的实现

成都中医药大学学报（教育科学版）Journal of Chengdu University of TCM(Education Science Edition)·23·2019 年 06 月第 21 卷第 2 期Jun.2019,Vol.21,No.2基于Excel 的试卷质量深度分析平台的实现张　芸　武　斌　杨　阳(滁州职业技术学院信息工程系，安徽　滁州　239000)【摘　要】　通过对课程考核结果的分析，可以了解该课程的教学效果和学生掌握的程度。

在Excel 软件中，根据教育测量学和数理统计的原理，对考试结果进行定量研究，计算出试卷的难度、区分度、信度、效度等指标，设计出试卷质量深度分析平台。

该平台可对考试的结果作出综合评价，对以后的教学具有指导意义。

【关键词】　深度分析；难度；区分度；信度；效度Realization of In-Depth Analysis Platform forExam Papers Quality Based on Excel【Abstract 】 The analysis of the course examination results can be used to know the teaching effects of course and the masterydegree of the students. The examination results are quantitatively studied according to the principles of educational measurement and mathematical statistics in Excel.The in-depth analysis platform for exam papers quality is designed to calculatethe difficulty, differentiation, reliability, validity and other indicators of the exam papers. The platform can make a comprehensive evaluation of the examination results, and haveguiding significance for the future teaching.【Keywords 】 In-depth analysis; Difficulty; Differentiation; Reliability; Validity作者简介：张芸(1984 -)，女，讲师。

基于计算结果的简易Excel作业自动阅卷程序设计

2021年9期254基于计算结果的简易Excel 作业自动阅卷程序设计裴文俊（上海市工商外国语学校，上海 200231）信息技术课程是中等职业学校各专业学生的必修公共基础课程，其中数据处理能力的培养目标明确要求学生会使用数据处理工具采集、加工与管理数据，会进行数据计算。

在众多的数据处理软件中，Excel 电子表格处理软件由于其功能齐全，学习使用简便，已经成为重要的教学软件。

教学中需要多次批阅学生Excel 作业，传统的人工批阅方式效率低和容易出错，而一般的自动批阅程序都是附属在考试阅卷系统中，成本高而且不灵活。

因此，本文根据信息技术基础学科的现状，提出了直接根据Excel 计算结果进行批阅Excel 作业的自动阅卷方法，简单快速实用，能够帮助学生反复练习Excel 函数和公式的操作，提高数据处理的基本技能。

同时也提供了一种学生评价数据采集的方法。

一、自动阅卷的优势自动阅卷一方面积极有效化解教师的阅卷压力，提高效率，另一方面，通过技术手段简化阅卷流程、增强准确率，提高工作效率，已经成为学业评价工作的热点。

机器阅卷、网上阅卷和智能阅卷等技术被越来越多的学校、考试机构所采用。

同时，学生和家长也期盼通过客观的数据分析来了解学习情况，从而进行有的放矢地针对性练习。

以往只能依靠客观的分数和教师的经验进行判断和分析，现在通过自动化阅卷技术，可以准确和及时地采集学生学业数据，从而进行数据分析，能真实反应学生现状，精准聚焦知识点，帮助学生及时进行查漏补缺，提高学习效率。

二、Excel 文件的自动阅卷技术原理分析（一）基于OLE 自动化技术实现对于Excel 文件自动阅卷的首要前提是能访问和调用Excel 文件，同时调用Excel 文件程序能够显示、控制和编辑Excel 数据，而不用启动Excel 文件，这就需要用到OLE 自动化技术。

OLE(Object Linking and Embedding)，对象链接与嵌入技术。

用EXCEL制作模拟考试系统

1.建立题库翻开Excel 2021，建立“模拟考试系统-出题测试版〞。

翻开此工作簿，建立“单项选择题〞工作表(如图1)，在A2输入公式=ROW()-1&"."以自动生成序号，在D2输入=IF(C2="","",RAND())，选中A2:D2拖动向下填充几百行。

按住Ctrl键单击“单项选择题〞工作表标签拖动复制出两份，分别重命名为“多项选择题〞〔如图2〕、“判断题〞〔如图3〕，分别输入题目和答案，按Alt+回车键换行。

请注意以下提示：1、以上3个工作表，在B列输入单项选择题题目〔样式随意，但一道题只能占一个单元格〕，在C列输入对应考题的答案，答案输入时注意不要有多余字符。

2、“多项选择题〞工作表的答案必须按ABCD的顺序填写，例如答案ABD，不能写ADB、BAD、BDA、DAB、DBA，答错、少答和多答均不得分；“判断题〞工作表的答案只能有两种，此题按“正确〞和“错误〞作为答案，其他形式如“对〞和“错〞、“√〞和“×〞也可以。

3、题库中题目数量根据实际情况而定，多多益善。

本例中题库数目为单项选择题60道、多项选择题50道、判断题45道。

图1 图2图32.建立考生新建“考生〞工作表，在A、B、C列分别输入序号、号、考生，选中B列在名称框中输入“考号〞，回车确定把B列命名为考号(如图4)。

完成后可在名称管理器看到名字为“考号〞的名称，引用位置为“考生〞工作表的B列。

图43.设计试卷建立“试卷〞工作表，按需要设置试卷，序号生成方式如题库序号。

单项选择题30题(A5:C34)，多项选择题40(A36:C75)，判断题30题(A77:C106)。

在B4输入“单项选择题〔每题1分〕〞，在B35输入“多项选择题〔每题1分，错、漏、多项选择均不得分〕〞，在B76输入“判断题〔每题1分〕〞。

用“自选图形/根本形状〞中的棱台画一个按钮，选中在名称框中输入“出题按钮〞4字回车，把它命名为“出题按钮〞。

Excel深度考核自动阅卷系统中控件的评判方法

Excel深度考核自动阅卷系统中控件的评判方法周松【摘要】Excel深度考核中由于数据是动态的,所以一般都会用到控件来进行动态数据的控制,控件的设置不能通过Excel阅卷系统中通常使用的读取单元格内容的方法来进行判断.经过对表单控件和形状控件的研究比较,找出控件评判的方法,并给出实现方法.【期刊名称】《现代计算机（专业版）》【年(卷),期】2016(000)018【总页数】3页(P59-61)【关键词】自动阅卷;Excel;VBA【作者】周松【作者单位】南京财经大学信息工程学院,南京210023【正文语种】中文Excel的作用很大，几乎每台电脑都安装有Excel软件。

不过许多用户都认为Excel的主要的作用就是做做报表和图表，计算公式，但其实Excel的功能非常强大，可以绘制动态图表，可以进行规划求解，可以进行预测和回归等。

所以有很多高校特别是财经类高校都开设了Excel深度应用的课程，如上海财经大学开设了《Excel在财务管理中的应用》，南京财经大学开设了《Excel在经济统计与分析中的应用》等课程。

这些课程大多以公共基础课的形式开设的，学员很多，考试阅卷的工作量很大，阅卷教师容易出现疲劳判错等现象。

对于学生的操作结果进行自动阅卷是一种很好的方法，它速度快，而准确性高。

单元格格式、公式、筛选排序和图表等方面的自动判断已有了不少论文进行论述［1-2］，而对于如何判断深度应用中经常用到的控件还没有很好的方法，本文将给出如何对控件进行判断的方法和关键代码。

在Excel中有表单控件和形状控件两种，形状控件一般用于在Excel中添加标注和形状，如文本框、艺术字、形状和图表等。

而表单控件是放置在单元格上方图形层中的一种小的图像组件，通过它们可以来增加易用性和控制Excel的操作流程。

默认情况下用户并不能在功能区中找到表单控件，需要在Excel“文件”选项卡中点击“选项”按钮，然后在弹出的“Excel选项”对话框中选择“自定义功能区”，在右侧的“主选项卡”中选中“开发工具”，这时在Excel的主选项卡上就会多出一个“开发工具”选项卡。