CN110457665A - A kind of Examination System without paper based on Excel VBA - Google Patents
A kind of Examination System without paper based on Excel VBA Download PDFInfo
- Publication number
- CN110457665A CN110457665A CN201910749676.3A CN201910749676A CN110457665A CN 110457665 A CN110457665 A CN 110457665A CN 201910749676 A CN201910749676 A CN 201910749676A CN 110457665 A CN110457665 A CN 110457665A
- Authority
- CN
- China
- Prior art keywords
- scoring
- examination
- type
- topic
- paper
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
Abstract
Examination System without paper disclosed by the invention based on Excel VBA, it is related to teaching examination technical field, pass through the examination question setting scoring point and scoring model to each topic type, when teacher scores to paper, objective item need not must be converted by calculation question and practice topic, it improves teacher and gos over examination papers and efficiency and form oneself teaching resources library convenient for teacher, be conducive to teachers ' teaching.
Description
Technical field
The present invention relates to teaching examination technical fields, and in particular to a kind of Examination System without paper based on Excel VBA.
Background technique
Examination System without paper currently on the market is mostly based on B/S structure, only supports objective item topic type, scores in teacher
When, objective item must be converted by calculation question and practice topic, this brings many inconvenience to field research and examination, and teacher is caused to go over examination papers
Efficiency is lower and is not easy to the teaching resources library that teacher forms oneself, is unfavorable for teachers ' teaching.
Summary of the invention
To solve the deficiencies in the prior art, the embodiment of the invention provides a kind of nonpaperlized examinations based on Excel VBA
System, the Examination System without paper include:
Scoring point editor module, for being set in Excel worksheet for each topic type examination question in exam pool in the form of annotation
Comment on branch, wherein each topic type examination question includes single choice, multiple choice, True-False, calculation question, practice topic；
The scoring point editor module, is also used in the form of annotation, clicks through to the scoring of topic type examination question each in exam pool
Row positions and the type of the scoring point, scoring model, score value is arranged；
The scoring point editor module is also used to utilize Excel VBA language, cell annotation is increased, is modified,
It deletes, batch increase, batch modification, batch deletion；
Topic type general view module, using Excel VBA language, is calculated for obtaining whole examination questions of single topic type in exam pool
The volume of the examination question, score value, degree-of-difficulty factor, scoring point quantity；
Exam pool overview module, using Excel VBA language, is calculated for obtaining whole examination questions of all topic types in exam pool
The volume of the examination question, score value, degree-of-difficulty factor, scoring point quantity；
It selects a topic general view module, for obtaining in exam pool the examination question being selected in single topic type, using Excel VBA language,
Calculate the volume, score value, degree-of-difficulty factor, scoring point quantity of the examination question；
It selects a topic overview module, for obtaining in exam pool the examination question being selected in all topic types, using Excel VBA language,
Calculate the volume, score value, degree-of-difficulty factor, scoring point quantity of the examination question.
Setting questions module is imported, for the examination question batch of typing to be imported into exam pool from examination question template；
Setting questions module is exported, for selecting a certain number of examination questions from exam pool, paper is generated according to the examination question,
In, the paper includes the paper for marking answer and the paper of corresponding unmarked answer.
Preferably, the scoring vertex type includes monomer scoring type and combination scoring type, in which:
Individual unit lattice are set a scoring point by monomer scoring type；
A module unit lattice region is set general comment branch by combination scoring type, by every a line in the cell region
Monomer scoring point is arranged in cell, sets the scoring factor for the individual unit lattice in every a line cell.
Preferably, the scoring model includes precise score mode and vague marking mode, in which:
Monomer scores type suitable for precise score mode；
Combination scoring type is suitable for the combination of precise score mode and vague marking mode.
Preferably, the Examination System without paper further include:
Transceiver module, for the paper of unmarked answer to be sent to student side and receives the examination of the student side upload
Volume.
Examination System without paper provided in an embodiment of the present invention based on Excel VBA has the advantages that
By the examination question setting scoring point and scoring model to each topic type, when teacher scores to paper, without
Must by calculation question and practice topic be converted into objective item, improve teacher go over examination papers efficiency and convenient for teacher formed oneself teaching money
Source library, is conducive to teachers ' teaching.
Detailed description of the invention
Fig. 1 is the structural schematic diagram of the Examination System without paper provided in an embodiment of the present invention based on Excel VBA；
Fig. 2 is the main interface schematic diagram of the Examination System without paper provided in an embodiment of the present invention based on Excel VBA.
Specific embodiment
Specific introduce is made to the present invention below in conjunction with the drawings and specific embodiments.
Referring to Fig. 1, the Examination System without paper provided in an embodiment of the present invention based on Excel VBA includes:
Scoring point editor module, for being set in Excel worksheet for each topic type examination question in exam pool in the form of annotation
Comment on branch, wherein each topic type examination question includes single choice, multiple choice, True-False, calculation question, practice topic.
Wherein, each topic type examination question is first passed through to be manually entered into examination question template in advance and is generated in exam pool.
Scoring point editor module, is also used in the form of annotation, determines the scoring point of topic type examination question each in exam pool
Simultaneously the type of the scoring point, scoring model, score value is arranged in position.
Scoring point editor module is also used to increase cell annotation using Excel VBA language, modify, delete
It removes, batch increase, batch modification, batch deletion.
Topic type general view module, using Excel VBA language, is calculated for obtaining whole examination questions of single topic type in exam pool
The volume of the examination question, score value, degree-of-difficulty factor, scoring point quantity.
Wherein, degree-of-difficulty factor is to be manually set according to the difficulty of each examination question.It, can be with as a specific embodiment
The maximum value of degree-of-difficulty factor is set as 5.0, minimum value 1.0.
Exam pool overview module, using Excel VBA language, is calculated for obtaining whole examination questions of all topic types in exam pool
The volume of the examination question, score value, degree-of-difficulty factor, scoring point quantity；
It selects a topic general view module, for obtaining in exam pool the examination question being selected in single topic type, using Excel VBA language,
Calculate the volume, score value, degree-of-difficulty factor, scoring point quantity of examination question；
It selects a topic overview module, for obtaining in exam pool the examination question being selected in all topic types, using Excel VBA language,
Calculate the volume, score value, degree-of-difficulty factor, scoring point quantity of examination question.
Setting questions module is imported, for the examination question batch of typing to be imported into exam pool from examination question template；
Setting questions module is exported, for selecting a certain number of examination questions from exam pool, the examination question is exported and generates paper,
In, paper includes the paper for marking answer and the paper of corresponding unmarked answer.
Wherein, the paper of answer is marked to be used to refer to for teacher to score to paper, the paper of unmarked answer is used
In being sent to student side for student examination.
Optionally, scoring vertex type includes monomer scoring type and combination scoring type, in which:
Monomer scores type as unit of a cell, sets scoring point, scoring point annotation mark for individual unit lattice
Show on corresponding cell；Combination scoring type is set monolithic unit lattice region to as unit of a module unit lattice region
One general comment branch, by every a line cell setting monomer scoring point in region, by the individual unit in every a line cell
Lattice are set as the scoring factor, and scoring point annotation is indicated on the cell in the bulk portion upper left corner.
As a specific embodiment, if the cell region that one piece of 3 row 2 is arranged as a TOP SCORES point,
Its every a line is all a monomer scoring point, if each monomer scoring point score value is 1 minute, TOP SCORES point is 3 minutes.It is each
Row has 2 cells, each of which cell is a scoring factor, thus each monomer scoring point there are two score because
Son.
As a specific embodiment, monomer score type be suitable for single choice, multiple choice, True-False, calculation question this
The topic type of class simple structure；Combination scoring type is suitable for the topic type that practice inscribes this kind of labyrinth.
Optionally, scoring model includes precise score mode and vague marking mode, in which:
Monomer scores type suitable for precise score mode；
Combination scoring type is suitable for the combination of precise score mode and vague marking mode.
As a specific embodiment, for using precise score mode, a region for being distributed in 3 rows 2 column of scoring
For examination question, if there is a line not score, then the whole not score of the examination question；For using vague marking mode, scoring point minute
Cloth is for the examination question in the region that 3 rows 2 arrange, if wherein a line not score, continues the score for calculating other rows and by each row
Score of the sum of score as the examination question.
Optionally, the Examination System without paper further include:
Transceiver module, for the paper of unmarked answer is sent to student side and receive student side upload paper.
Examination System without paper provided in an embodiment of the present invention based on Excel VBA passes through the examination question to each topic type
Setting scoring point and scoring model be converted into visitor without that must inscribe calculation question and practice when teacher scores to paper
Sight topic, improves teacher and gos over examination papers and efficiency and form oneself teaching resources library convenient for teacher, is conducive to teachers ' teaching.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, there is no the portion being described in detail in some embodiment
Point, reference can be made to the related descriptions of other embodiments.
It is understood that the correlated characteristic in the above method and device can be referred to mutually.In addition, in above-described embodiment
" first ", " second " etc. be and not represent the superiority and inferiority of each embodiment for distinguishing each embodiment.
It is apparent to those skilled in the art that for convenience and simplicity of description, the system of foregoing description,
The specific work process of device and unit, can refer to corresponding processes in the foregoing method embodiment, and details are not described herein.
Algorithm and display are not inherently related to any particular computer, virtual system, or other device provided herein.
Various general-purpose systems can also be used together with teachings based herein.As described above, it constructs required by this kind of system
Structure be obvious.In addition, the present invention is also not directed to any particular programming language.It should be understood that can use various
Programming language realizes summary of the invention described herein, and the description done above to language-specific is to disclose this hair
Bright preferred forms.
In addition, memory may include the non-volatile memory in computer-readable medium, random access memory
(RAM) and/or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM), memory includes extremely
A few storage chip.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flash RAM).Memory is computer-readable Jie
The example of matter.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including element
There is also other identical elements in process, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product.
Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application
Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code
The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The above is only embodiments herein, are not intended to limit this application.To those skilled in the art,
Various changes and changes are possible in this application.It is all within the spirit and principles of the present application made by any modification, equivalent replacement,
Improve etc., it should be included within the scope of the claims of this application.
Claims (4)
1. a kind of Examination System without paper based on Excel VBA characterized by comprising
Scoring point editor module, for being commented in Excel worksheet for topic type examination question setting each in exam pool in the form of annotation
Branch, wherein each topic type examination question includes single choice, multiple choice, True-False, calculation question, practice topic；
The scoring point editor module, is also used in the form of annotation, determines the scoring point of topic type examination question each in exam pool
Simultaneously the type of the scoring point, scoring model, score value is arranged in position；
The scoring point editor module is also used to utilize ExcelVBA language, cell annotation is increased, is modified, is deleted,
Batch increase, batch modification, batch are deleted；
Topic type general view module, for obtaining whole examination questions of single topic type in exam pool, using Excel VBA language, described in calculating
The volume of examination question, score value, degree-of-difficulty factor, scoring point quantity；
Exam pool overview module, for obtaining whole examination questions of all topic types in exam pool, using Excel VBA language, described in calculating
The volume of examination question, score value, degree-of-difficulty factor, scoring point quantity；
General view module of selecting a topic, using ExcelVBA language, calculates institute for obtaining the examination question being selected in single topic type in exam pool
State the volume, score value, degree-of-difficulty factor, scoring point quantity of examination question；
Overview module of selecting a topic, using ExcelVBA language, calculates institute for obtaining the examination question being selected in all topic types in exam pool
State the volume, score value, degree-of-difficulty factor, scoring point quantity of examination question.
Exam pool module is imported, for the examination question batch of typing to be imported into exam pool from examination question template；
Exam pool module is exported, for selecting a certain number of examination questions from exam pool, paper is generated according to the examination question, wherein institute
Stating paper includes the paper for marking answer and the paper of corresponding unmarked answer.
2. Examination System without paper according to claim 1, which is characterized in that the scoring vertex type includes monomer scoring
Type and combination scoring type, in which:
Individual unit lattice are set a scoring point by monomer scoring type；
A module unit lattice region is set general comment branch by combination scoring type, by every a line unit in the cell region
Monomer scoring point is arranged in lattice, sets the scoring factor for the individual unit lattice in every a line cell.
3. Examination System without paper according to claim 1, which is characterized in that the scoring model includes precise score mould
Formula and vague marking mode, in which:
Monomer scores type suitable for precise score mode；
Combination scoring type is suitable for the combination of precise score mode and vague marking mode.
4. Examination System without paper according to claim 1, which is characterized in that further include:
Transceiver module, for the paper of unmarked answer to be sent to student side and receives the paper of the student side upload.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910749676.3A CN110457665B (en) | 2019-08-14 | 2019-08-14 | Paperless examination system based on Excel VBA |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910749676.3A CN110457665B (en) | 2019-08-14 | 2019-08-14 | Paperless examination system based on Excel VBA |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110457665A true CN110457665A (en) | 2019-11-15 |
| CN110457665B CN110457665B (en) | 2023-02-21 |
Family
ID=68486495
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910749676.3A Active CN110457665B (en) | 2019-08-14 | 2019-08-14 | Paperless examination system based on Excel VBA |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457665B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112819309A (en) * | 2021-01-25 | 2021-05-18 | 江西五十铃汽车有限公司 | Employee performance scoring and payroll calculation system based on EXCEL software |
| CN113065325A (en) * | 2021-02-26 | 2021-07-02 | 成都环宇知了科技有限公司 | Excel document analysis method and system based on OpenXml |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101692316A (en) * | 2009-11-02 | 2010-04-07 | 福建农林大学 | Method for automatically grading no-paper exam by C/C++language program design |
| CN103164629A (en) * | 2013-04-07 | 2013-06-19 | 深圳市卓帆科技有限公司 | Automatic grading method of Flash software operating skills |
| CN104217310A (en) * | 2014-09-27 | 2014-12-17 | 昆明钢铁集团有限责任公司 | Smart paperless examination system and method |
| CN104331764A (en) * | 2014-10-24 | 2015-02-04 | 沈阳化工大学 | Network online examination management information system |
-
2019
- 2019-08-14 CN CN201910749676.3A patent/CN110457665B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101692316A (en) * | 2009-11-02 | 2010-04-07 | 福建农林大学 | Method for automatically grading no-paper exam by C/C++language program design |
| CN103164629A (en) * | 2013-04-07 | 2013-06-19 | 深圳市卓帆科技有限公司 | Automatic grading method of Flash software operating skills |
| CN104217310A (en) * | 2014-09-27 | 2014-12-17 | 昆明钢铁集团有限责任公司 | Smart paperless examination system and method |
| CN104331764A (en) * | 2014-10-24 | 2015-02-04 | 沈阳化工大学 | Network online examination management information system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112819309A (en) * | 2021-01-25 | 2021-05-18 | 江西五十铃汽车有限公司 | Employee performance scoring and payroll calculation system based on EXCEL software |
| CN113065325A (en) * | 2021-02-26 | 2021-07-02 | 成都环宇知了科技有限公司 | Excel document analysis method and system based on OpenXml |
| CN113065325B (en) * | 2021-02-26 | 2023-06-23 | 成都环宇知了科技有限公司 | Excel document analysis method and system based on OpenXml |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457665B (en) | 2023-02-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110457665A (en) | A kind of Examination System without paper based on Excel VBA | |
| Vytasek et al. | Topic models to support instructors in MOOC forums | |
| CN106886510B (en) | Method and device for displaying chart | |
| CN103324942A (en) | Method, device and system for image classification | |
| CN109033438B (en) | Method and device for recording learning content of user | |
| CN109298941A (en) | A kind of document generating method and device | |
| CN108550019A (en) | A kind of resume selection method and device | |
| Srikantaiah et al. | Knowledge management in practice: connections and context | |
| US10614083B2 (en) | Method and system for identifying incipient field-specific entity records | |
| CN106776746A (en) | A kind of creation method and device of full-text index data | |
| CN106557564A (en) | A kind of object data analysis method and device | |
| Gilson et al. | Doing Health Policy Analysis: The Enduring Relevance of Simple Models: Comment on" Modelling the Health Policy Process: One Size Fits All or Horses for Courses" | |
| CN109472512A (en) | A kind of user's medal generation method and system applied to classroom instruction | |
| CN104881413B (en) | Methodology for Entities Matching and device | |
| CN110020227A (en) | A kind of data reordering method and device | |
| Naranjo et al. | Analysis of the use of the Python programming language for statistical calculations | |
| CN108228542A (en) | A kind of processing method and processing device of non-structured text | |
| Yang | English scores by distributed ID3 algorithm of computer network | |
| CN110399604A (en) | Generation method, device and the computer readable storage medium of e-book academic probation part | |
| Bisnar et al. | Cloud-Based Library System Implementing Responsive Web Design Framework | |
| CN109582938A (en) | Report form generation method and device | |
| Huang | The Rise and Fall of Technology in Historical Perspective: Lessons and Experiences from China | |
| Student | Vulnerability is dynamic: An interactive approach to enhance adaptation strategies to climate change for coastal tourism | |
| Edwards et al. | Can you fathom this? Connecting data analysis, algebra, and geometry with probability simulation | |
| Kolomina et al. | Development of “Mathematical Models in Economics” Software Package and its Application in Educational Process |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20210723 Address after: 311200 Higher Education Park (Qianjiang farm), Xiaoshan District, Hangzhou City, Zhejiang Province Applicant after: TOURISM College OF ZHEJIANG Applicant after: Hangzhou Yuyi Information Technology Co.,Ltd. Address before: 311231 room 2202, unit 1, building 23, zhijiayuan, Beigan street, Xiaoshan District, Hangzhou City, Zhejiang Province Applicant before: Hangzhou Yuyi Information Technology Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |