基于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 VBA的计算机理论知识无纸化考试系统设计

基于Excel VBA的计算机理论知识无纸化考试系统设计摘要：利用Excel VBA设计了计算机理论知识无纸化考试系统。

该系统可以在学生登录后自动随机抽题成卷，并可在系统规定的时间内结束考试，可自动判分，减轻了教师阅卷的工作量。

关键词：Excel；VBA；考试系统；无纸化0 引言在当今飞速发展的信息化社会中，计算机已在各行各业被广泛应用，计算机应用能力已成为现代人必须具备的一种能力，所以各级学校都开设了计算机基础的公共课程。

为了加强学生对计算机知识掌握，在日常教学过程中对学生的测试是必不可少的。

而对于计算机理论知识，传统的做法是用纸质试卷测试，但教师阅卷的工作量较大，为减轻教师的工作量，便用Excel VBA设计了一个无纸化的计算机理论知识自动抽题、自动阅卷的考试系统。

1 系统实现的关键技术Excel是Microsoft Office 家族成员，它应用非常广泛，具有方便的表格式数据综合管理、强大计算统计分析和图表功能。

此外，Excel还提供了一种的宏语言Visual Basic for Application（简称VBA）,它是一种完全面向对象体系结构的编程语言，它又一种寄生于应用程序不能单独存在的编程语言。

由于其在开发方面的易用性和强大的功能，为广大用户提供了一个新的、更高层次的二次开发平台，它不但可以设计出个性化的程序，也可以使程序具有自动功能，减少大量重复繁琐的操作，提高工作效率。

2 系统的实现2.1 系统功能模块该系统主要有4个功能模块：（1）登录模块。

学生和教师分别不同身份登录。

学生只能进入考试界面，教师可以取得全部权限，可以查看评分情况，并可以修改题库内容和学生信息和基本设置。

（2）自动抽题。

该模块从题库中随机抽取规定数量的题传送到“测试题”表中，并将所抽取题目的标准答案传送到评分表。

（3）系统定时。

抽题结束后，系统将在考试系统的状态栏中显示倒计时。

并在规定的考试时间到达时，系统自动关闭并自动保存学生的所做题目。

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建立模拟考试系统做教师的少不了为学生制作各种各样的考试卷子，市面上虽有各种模拟考试系统，却因程序制作复杂，将老师们拒之门外。

其实根本不需要懂编程，用Excel 2003你也可以制作一个类似的系统。

一个可以自动出题、验证考号、答题后自动评分、保存记录的模拟考试系统，当然你也可以给它加上其他功能系统设计1.建立题库打开Excel 2003，建立“单选题”工作表(如图1)，在A2输入公式=ROW()-1&"."以自动生成序号，在D2输入=IF(C2="","",RAND())，选中A2:D2拖动其填充柄向下复制到其他单元格，大概有几百行也就够了，剩下的需要时再复制。

按住Ctrl键拖动工作表标签复制出两份，分别重命名为多选题、判断题。

图12.设计试卷建立“试卷”工作表，你可以按需要设置试卷，并输入单选题、多选题、判断题三个大题目，多选题需注明错、漏、多选均不得分。

并留出相应的题目位置，单选题30题(A5:C34)，多选题40(A36:C75)，判断题30题(A77:C106)。

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

再右击此按钮选择“添加文字”，在按钮上输入“出题”2字。

同样再画一个按钮，把它命名为“评分按钮”，添加文字“评分”。

(如图2)图23.显示题目在A5输入公式=INDIRECT("单选题!R"&ROW()-3&"C"&COLUMN(),0)，选中A5复制，再选中A5:C34进行粘贴。

同样在A36输入公式=INDIRECT("多选题!R"&ROW()-34&"C"&COLUMN(),0)并复制到A36:C75，在A77输入公式=INDIRECT("判断题!R"&ROW()-75&"C"&COLUMN()并复制到A77:C106。

用EXCEL制作模拟考试系统

1.建立题库打开Excel 2010，建立“模拟考试系统-出题测试版”。

打开此工作簿，建立“单选题”工作表(如图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的考试系统设计与实现本系统主要实现一个在线考试系统，系统分为三大模块：用户模块、管理员维护模块、试卷和试卷管理模块。

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

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

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

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

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

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

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

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

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

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

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

基于Excel的试卷自动生成系统的设计与实现

ＺｈｎｇａＹｕｙｅ，ＭａＣｈｕｎｑｉｎｇ￣
（Ｊ．Ｄｅｐｔ．ｏｆｃｏｍｐｕｔｅｒ，ＪｉｎａｎＶｏｃａｔｉｏｎａｌＣｏｌｌｅｇｅ，Ｊｉｎａｎ，Ｓｈａｎｄｏｎｇ２５００１４，Ｃｈｉｎａ；２．ＪｉｎａｎＩｎｆｏｒｍａｔｉｏｎＥｎｇｉｎｅｅｒｉｎｇＳｃｈｏｏ１）
ｐｏｗｅｒｆｕｌｆｕｎｃｔｉｏｎｏｆＥｘｃｅｌｉｔｓｅｌｆ，ｔｈｅｉｎｖｅｓｔｍｅｎｔｎｄｉｅｖｅｌｏｐｍｅｎｔｉｓｒｅｌａｔｉｖｅｌｙｓｍａｌ１．Ｔｈｅｓｙｓｔｅｍｄｏｅｓｎｏｔｎｅｅｄｔｏｉｎｓｔａｌｌａｎｄｉｓｅａｓｙ
ｔｏｕｓｅ．Ｉｔｉｓｓｕｉｔａｂｌｅｆｏｒｍｏｓｔｃｏｕｒｓｅｓｉｎａｌｌｔｙｐｅｓｏｆｓｃｈｏｏｌｓ．Ｔｈｅｄｅｓｉｇｎｎｄａｒｅａｌｉｚａｔｉｏｎｐｒｏｃｅｄｕｒｅｏｆｈｅｔｓｙｓｔｅｍｒｅａｄｅｓｃｒｉｂｅｄ．Ｋｅｙｗｏｒｄｓ：Ｅｘｃｅｌ；ＶＢＡ；ａｕｔｏｍａｔｉｃｇｅｎｅｒａｔｉｎｇｓｙｓｔｅｍｏｆｅｘａｍｐａｐｅｒｓ；ｔｅｓｔｑｕｅｓｔｉｏｎｓｄａｔａｂａｓｅ

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

基于Ｅｘｃｅｌ的考试系统设计与实现作者：刘世能来源：《中小学信息技术教育》2007年第03期当前的考试系统既有用各种语言开发的单机版软件，也有用Asp等开发的网络版系统。

单机版软件适合学生自测，但一般无成绩导出汇集统计功能，因而不适合班级统一测试与成绩分析；网络版考试系统需要服务器等高技术支持，对网络带宽有一定要求且一般用于局域网，因此不方便各科推广使用。

随着Excel办公软件版本的升级，其功能也越来越强大。

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

一、基于Excel的考试系统设计思路以课堂测试为例，其中包括基本的单项选择题、多项选择题、判断题、填空题、简答题等。

在Excel中制作好试卷，通过指定单元格输入学生信息、作答情况，再通过函数IF读取标准答案并判断正误，给出得分。

学生将试卷保存后交给老师，最后在成绩统计文件中读出所有学生得分或答题情况，计算总分、平均分，并可做考试分析。

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

在输入解题信息时，若直接在相应单元格中输入，则会增加学生的作答要求，如答案字母的大小写、空格等均会影响学生成绩，为此笔者采用了数据序列与窗体控件进行选择设计，可尽量减少操作对成绩的影响。

数据序列：在输入单元格中单击“数据”菜单，选择“有效性（L）…”，在允许中选择序列，在来源中设计要选择的信息，设置结果如图1、图2。

这种方法在班级信息、单项选择题与判断题答案输入中显得直观、易操作，只需单击选择项即可输入答题信息。

窗体控件：打开“视图”菜单工具栏下的窗体工具，单击分组框工具，待鼠标变成十字光标后在相应题上画出一个矩形框，并输入相应题号（本处第4题）。

基于Excel开发窗体版模拟考试系统实例与技巧

考试系统考生登录题型选择单选题多选题判断题交卷评分图1 模拟考试系统功能框架图图2 模拟考试系统结构图图3 sheet2 表数据结构图4 sheet3 表数据结构基于E x ce l开发窗体版模拟考试系统实例与技巧高智超张志揆摘要：在考试系统的开发过程中，常用VB、JavaE E 等软件开发，对小微型考试系统多用Excel办公软件开发。

从实用性出发，用熟悉的Excel 开发了一个小微型的模拟考试系统，骤简单。

方便实用，步关键词：Excel；窗体考试系统；开发实例技巧对于考试系统的开发，可以选择的开发工具很多，笔者曾用Visual Basic 6.0 开发了一套考试系统，也曾用JavaEE 开发了在线考试系统。

虽然开发出的软件实用性很强，但是开发过程相对要艰难和复杂，开发周期较长，不论是VB 还是JavaEE都要配置数据源，与数据库进行连接，JavaEE 开发网站式考试系统时考试环境的配置较烦琐。

而Excel 作为优秀的电子表格软件，不仅具有强大的表格数据处理功能，并且Excel 提供了二次开发的环境，直接调用Excel 表格中的数据，就可以编写出功能强大的考试系统，进行无纸化考试。

虽然Excel 开发的考试系统较简单，但是开发周期短，短小精悍，对于人数不多的无纸化考试，省去了考试环境的安装与配置，既可以完成的系统结构图如图 2 所示：应用于公司短期培训考试，实用。

也可以进行教学单元测试，方便2 数据库用一个Excel 文件完成模拟考试系统的开发，新建一个名为“模拟考试系统”的Excel 文件。

其中Sheet1 表格不存放数下面以进行模拟考试系统开发的具体过程，来详细说明Excel 开发窗体系统的实例和技巧。

具体开发步骤由功能结构分析、数据库设计、窗体界面设计、试题库准备、测试考试等组成。

代码设计、据，作为考试时的激活工作表。

Sheet2 里面保存试题、答案、按顺序保存每个考生答题结果及得分，每个考生占两列。

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

基于Excel构建计算机考试系统
张颖
【期刊名称】《电子制作》
【年(卷),期】2013(0)22
【摘要】巧妙利用Excel办公软件构建计算机考试系统，实现考试的全自动化，在系统中主要利用Excel相关的公式函数，实现电脑自动组卷、自动评分、自动统计分数、生成报表、对成绩进行统计分析等功能。

【总页数】1页(P97-97)
【作者】张颖
【作者单位】河南广播电视大学 450000
【正文语种】中文
【相关文献】
1.基于Excel VBA的计算机理论知识无纸化考试系统设计 [J], 蒋勇
2.基于Excel构建智能计算机考试系统 [J], 甘伟明;潘东梅;白晓丽;刘兵兵
3.基于Excel VBA的计算机理论知识无纸化考试系统设计 [J], 蒋勇
4.高校基于Excel Vba考试系统的研究 [J], 刘庭立; 陈雪泉; 张文治; 龙远奎; 陈楠伟
5.高校基于Excel Vba考试系统的研究 [J], 刘庭立; 陈雪泉; 张文治; 龙远奎; 陈楠伟
因版权原因，仅展示原文概要，查看原文内容请购买。

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

收稿日期：２０１２—０８—１３修稿日期：２０１２－０９一（）１作者简介：刘本斌（１９７６一），男，安徽六安人，硕士，讲师，研究方向为计算机网络技术囝现代计算机２０１２ Nhomakorabea０９上
器．能访问教师机更好．不能就拷贝；另一好处是不要求必须有一个功能强大的服务器．考生就在自己的机器上从隐藏的试卷题库抽题生成试卷，避免了都从同一台服务器抽题的拥挤瓶颈分发与提交试卷都用机房的广播系统，考生提交试卷，文件的名称不要改动，同一格式的名称可以批量统计．如果经过考试后文件名改了．就用拖把更名器等软件．改成统一格式的答卷名称。
基于ＥｘｃｅｌＶＢＡ的考试系统的设计与实现
刘本斌
（苏州经贸职业技术学院，苏州２５１００９）
摘要：用ＥｘｃｅｌＶＢＡ实现一个功能完备的考试系统设计，整个考试环节都在一个工作簿里完成，包括题库工作表、出卷工作表、自动抽题、考生登录验证、考试界面、判卷统计等功能。可以联网收发试卷．也可以拷贝到不能联网的单机上考试或者练习，对机房环境的要求低，只要普通机房就能完全满足正常教学的期末考试的需要。

维护考试系统——用Excel2007轻松制作考试系统（十）

维护考试系统——用Excel2007轻松制作考试系统（十）三、维护考试系统1. 试题输入在前面做好的“ 单选题” 、“ 多选题” 、“ 判断题” 工作表中输入试题和答案即可，需要换行时按“ Alt+ 回车键” 输入软回车符换行，用空格进行水平定位。

答案输入时注意不要有多余字符，特别是多选题一定要按ABCD 的顺序输入多选项，否则无法正确评分，还可以对C 列单元格设置有效性。

若以后还想用到当前的题目顺序可在最后增加一列（E 列）填充序列号，需要时按此列排序即可。

在“ 考生名单” 工作表中输入考生姓名和准考证号，也可以直接从其他工作表中复制过来（若已经有的话）。

2. 隐藏工作表在实际操作中，除试卷外的其他工作表也需要隐藏起来以免考生看到，方法如下：在功能区中打开“ 开发工具” 选项组，选择“ 宏” 选项，在弹出的窗口左侧选中要隐藏的工作表名，如“ 单选题” 工作表，在属性窗口中（若看不到左侧的属性窗口可按F4 键显示）把“ Visible ” 项的值设置为“ 0 - xlsheetHidden ” ，如图10 所示，即可隐藏该工作表。

重复这一操作把除“ 试卷” 以外的其他工作表全部隐藏起来。

以后需要显示时只需按这一操作过程把“ Visible ” 项的值修改为“ - 1 - xlsheetVisible ” 即可。

图10为防止学生修改，还要在左侧“ 工程-VBAProject ” 窗口中右击“ VBAProject （考试系统. xlsx) ” 后选择快捷菜单命令“ VBAProject - 工程属性” ，在“ 保护” 选项卡中选中“ 查看时锁定工程” ，并输入和确认密码，如图11 所示，单击“ 确定” 退出。

经过这样的设置以后，没有正确的密码就不能修改内容了。

图11 工程-VBAProject本文来至E学院原文地址：本文来至E学院原文地址：。

基于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 VBA设计考试信息系统

用Excel VBA设计考试信息系统摘要高校学生期末考试,如果每场考试都采取随机座次,并且直到入考场时学生才知道自己的座次,学生就没有机会提前设计协同作弊。

但是用手工方式实现每场考试随机安排座位,工作量大,效率低下。

使用Excel制作一个考试信息系统,能完美的完成这项工作。

关键词Excel VBA;随机;信息系统1 实际工作中的问题与需要高校学生一般都安排集中期末考试,考试都是各专业单独组织考场,考生都是平时在一起学习的同学。

如果座次直接按照学号,可以方便监考老师检查考生到场情况,但是一直是一样的座次不变,固定考生相邻的时间长了,会出现协同作弊的现象,甚至出现雷同卷。

虽然可以通过监考老师加强监视力度来避免,但是最好用技术的方法来解决。

如果打印出学生学号姓名清单,随机贴到座位上,但是每场考试都贴标签,太麻烦,而且学生不容易找到自己的座位。

后来采用当场抽签的办法,制作两份号码标签,一份贴到考试座位上,另外一份让考生抽签,抽到后对号入座,这种方法虽然能够实现随机排坐,但是太费时间,监考教师手里没有座次表,学生可以趁乱自己换标签调座,另外如果有缺考的学生,难以查找登记。

最后,我们决定还是使用计算机,进行考场安排,以达到事半功倍的效果。

该设想是考场里座位上只贴号码,有N个座位则号码从1～N。

考试前半小时随机产生考生座次表,考试前10分钟在考场门口张贴一张座次表,此表按学号排序,考生可快速查到自己的座位号。

监考教师领一份座次表,此表按座位号排序,监考教师可快速查到每个座位上的考生,对缺考考生快速查找登记。

2 解决问题的思路我们借助Excel电子表格实现这个工作。

首先制作出学生清单,包含学号、姓名、性别等几列,并填入实际数据。

添加一列用来产生随机数,添加另外一列,用来产生座次号。

具体方法如下,在随机数一列第一单元格插入函数rand(),或者直接输入“=rand()”,把这一单元格内容复制到此列其他单元格,或者使用快速填充。