CN109191342A - A kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools and system - Google Patents

Abstract

The present invention proposes a kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools and system.To ensure that data by unauthorized access, do not devise the least privilege access control of based role；To realize multistage examination, each profession independent examination stage is devised；To realize that acting on behalf of outer school selects student, devises main profession and be associated with profession of praticing fraud；To realize multi-specialized marking of once taking an examination, the one-to-many association of subject and profession is devised；Guarantee that examination is fair and close rule, devises to call the roll of the contestants in athletic events at random and distribute examinee to examination hall, devise orientation for particular/special requirement and call the roll of the contestants in athletic events；For trace on marking paper, each professional examiner's papery marking table is devised；Mistake is separated to prevent from stepping on, devises the verification of typing twice；Be it is fault-tolerant, devise the safety entrance of three sections of passwords modification achievement；It for the convergence of more examination point achievements, devises and imports subject achievement, and be mapped to examinee academic result, start new round examination after delimiting score line payment, solve more wheel examinations and select Human Resources.

Description

A kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools With system

Technical field

The invention belongs to management information system software design and examination of education informatizations, are related to a kind of multistage mostly The more examination point examination integrated management design methods in school and system are specifically closed in conventional examination data management, examiner's marking, achievement And pay the fees etc. examination datas processing in, design realize test subject with it is multi-specialized it is corresponding, examination, the multistage talent can be acted on behalf of The method of examination and system of choice and data safety.

Background technique

In terms of patent database, Hu Xiufeng devises the examination system based on C/S, and client realizes online testing, achievement is looked into It askes, modification personal information, log off four parts；Server-side realizes administrator to the management function of system information, including user Personal information data and examination paper data base administration.Zheng Hui devise including background server, authentication, set a question, take an examination client The examination system held, goed over examination papers with examination question memory module.

In terms of paper, Yang Xiaoli proposes skill and examines generalized information management system framework, comprising: enrollment is registered, examination hall arranges, It gos over examination papers marking, score management module.King, which builds, proposes a kind of On-line Examining system based on Web, comprising: examination is logged in, taken an examination Interface, back-stage management, score inquiry.

From Research Literature in terms of patent database query result, the country lacks a kind of more examination point undergraduate course skills of multistage more schools at present Art class entrance examination whole process score management method and software systems are acted on behalf of close profession and are examined to meet multistage selection of talented people The skill of examination, more examination point achievement convergences, multi-specialized achievement marking of once taking an examination examines total management system.

Summary of the invention

The present invention proposes a kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools and system. To ensure that data by unauthorized access, do not devise the least privilege access control of based role；To realize multistage examination, if Each profession independent examination stage is counted；To realize that acting on behalf of outer school selects student, devises main profession and be associated with profession of praticing fraud；For It realizes multi-specialized marking of once taking an examination, devises the one-to-many association of subject and profession；Guarantee that examination is fair and close rule, devise with Machine examination record distribution examinee devises orientation for particular/special requirement and calls the roll of the contestants in athletic events to examination hall；For trace on marking paper, each professional examiner is devised Papery marking table；Mistake is separated to prevent from stepping on, devises the verification of typing twice；Be it is fault-tolerant, devise three sections of passwords modification achievements Safety entrance；It for the convergence of more examination point achievements, devises and imports subject achievement, and be mapped to examinee academic result, delimit score line Start new round examination after payment, solves more wheel examinations and select Human Resources.

A kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools are with system features, wrap Include following steps:

Step 1: including examiner, examine business, fee-collector, examination point director and system manager role least privilege user pipe Reason.

Examiner is responsible for the examinee's marking having an interview.It examines the responsible examinee of business to call the roll of the contestants in athletic events, and examinee is assigned randomly to accordingly Interview examination hall.Fee-collector is responsible for paying dues after examinee is by the examination of current generation, and examinee can participate in next stage and examine later Examination.Examination point director is responsible under typing achievement error situation, interview marking achievement of the modification examiner to examinee.System manager is negative The environment configurations and examination advancement monitoring of duty examination essential information.

Step 2: examinee enters oneself for the examination information management and registered speciality management.

It imports and enters oneself for the examination information from the examinee that external skill examines Entries System, by entering oneself for the examination the horizontal table of information table, i.e. an examinee Multiple professional records are entered oneself for the examination, imports and generates vertical table, is i.e. the profession one of examinee one record, and extract all professions Information generates professional table.

Configure the profession of chief examiner, this school pratice fraud profession and chief examiner of profession and corresponding, the outer school of chief examiner's profession that pratice fraud it is professional It is corresponding.

Step 3: examination stage management and test subject management.

Multistage selection of talented people is adapted to, the examination stage is provided with, each profession can configure several examination stages.Configuration is examined Subject is tried, multiple professions can examine same subject.And it configures the examination stage of profession, profession is corresponding with test subject.

Step 4: examination hall management and examiner examination hall associate management.

Classroom where configuring the examination hall of each profession, and examiner is assigned to each examination hall, each examiner can only be arranged In an examination hall, an examination hall configures 3-5 interview examiners.

Step 5: member of the seizure and subject management of calling the roll of the contestants in athletic events.

One or several members of the seizure are configured for the test subject in each examination stage.

Step 6: process management of calling the roll of the contestants in athletic events.User logs according to its member of the seizure role, logs into interface of calling the roll of the contestants in athletic events, scanning is examined Raw admission card for entrance examination two dimensional code, if examinee, system distributes an examination hall to examinee at random if time is examined in list.

Step 7: examiner, which gives a mark, to be managed.

Examinee takes an examination to examination hall, and examiner is presented to examinee according to examinee's interview and gives a mark, and a subject examines multiple professions, respectively To each profession marking, the achievement for profession of praticing fraud is, it is specified that beat same score, subsequent each professional score line with chief examiner's profession It can be different.Examinee does not take an examination after calling the roll of the contestants in athletic events, and examines labeled as lacking.It examines if having been marked as lacking, took an examination again later, It can look for and examine business teacher, be deleted to lack by system manager and examine label, called the roll of the contestants in athletic events and take an examination again.Sound when if examinee takes an examination It is bright to abandon a certain professional examination, it is examined labeled as abandoning.

Step 8: grouping typing achievement is stepped on twice to verify consistency.

Examiner gives a mark to the interview of examinee, is recorded on papery table, special to step on grouping examiner's account typing achievement.It examines Consider and step on a point possible error, use typing twice, whether verification is consistent, has verifying function.If a typing and two typings Unanimously, illustrate that typing is errorless, if inconsistent, artificial nucleus to and submit and examine business and do, modified by examination point director's account.For same The same subject achievement of examinee if there is score, inconsistent, the same prompt typing mistake that lacks examiner's marking for examining and abandons and examining, by The modification of examination point director's account.

Step 9: by examination point director's account modification examiner to the marking achievement of examinee when typing mistake.

Examination point director's account uses three sections of passwords, and by system manager, examination point director and Kao business executive director take care of respectively, Three sections of password holders can modify examiner to the marking achievement of examinee when on the scene, and generate modification log.

Step 10: subject achievement calculates.

It checks there is no after inconsistent marking situation, the average mark that all examiners give a mark to examinee is calculated, as examinee's Subject achievement.Import the subject achievement of nonlocal examination point, handled before importing by Excel calculate examiner to examinee give a mark averagely at Achievement, i.e. examinee's subject achievement.

Step 11: professional overall scores calculates.

According to the overall scores ratio of each professional this stage examination, professional examination stage, profession and subject corresponding relationship, written examination The weight of score and interview score, calculates examinee academic result.Professional achievement that profession is praticed fraud in this school and outer school is praticed fraud according to The association of main profession generates.

Step 12: generation passes through list.The score line for setting main profession and profession of praticing fraud, to examinee academic result, etc. It is taken an examination in being higher than score line identification by this stage, the write-in of examinee's specialized information passes through list.

Step 13: fee-collector with pass through stage profession associate management.The toll administration of each professional current generation is set Set one or several toll administration persons.

Step 14: toll administration.Examinee's admission card for entrance examination is scanned, if examinee pays the fees, in corresponding profession by list Examinee enter time and examine list.

Step 15: deployment and security strategy.Skill examines a part for belonging to college entrance examination, be included in artistic examinee college entrance examination admission at Achievement, therefore the safety of data is particularly important.System deployment is used using local area network, two-shipper linux system, database server Principal and subordinate's two-node cluster hot backup, application server two-shipper is online, all write-in main database server, synchronous through SQL log by primary server It is written from database server.Unauthorized access is prevented, using white list firewall, the IP address of non-white list forbids opening skill Test system.

In the step 1, access control based roles simultaneously ensure data not by unauthorized using least privileged user account It accesses and checks, role logs into different software module interfaces.Examiner's marking can only see oneself marking achievement to examinee, It is invisible after submitting and auditing.Member of the seizure, which can only call the roll of the contestants in athletic events, examinee and distributes examinee to examination hall, does not contact score information.Payment person, Charge link is only completed, score information is not contacted.Examination point director account only modifies vicious examiner to the scoring information of examinee, It is invisible after submission.System manager can only configure exam information, monitoring test state, not check before examination terminates The entrance of achievement.It is invisible before calculating subject achievement after achievement storage, it is ensured that performance information is not tampered.

In the step 2, examinee, which enters oneself for the examination information and examines Entries System by skill, to be generated, and horizontal table turns vertical table, and extracts all special Industry information generates professional table, has maximally utilized registration information table, and as few as possible allow and prevents system manager's logging data Mistake.Pratice fraud profession and corresponding, the outer school of chief examiner's profession of configuration chief examiner profession, this school is praticed fraud the profession correspondence professional with chief examiner, Realize the function of acting on behalf of other school examinations.

In the step 3, multistage selection of talented people is adapted to, is provided with the examination stage, each profession can configure several examine In the examination stage, each professional examination stage is independent, and the examination stage of different majors can be different in the same time.To realize multiple professions Same subject is examined, test subject is configured with, realizes multi-specialized marking of once taking an examination.The marking section of setting system, certain scores Section does not allow to give a mark, and avoids the uniformity of marking, guarantees otherness.

Configuration professional examination stage, profession are corresponding with test subject, as the essential information once taken an examination, configure examination First trial marking section, review marking section and subject weight.The academic result of examinee is the weighting of this professional examination stage achievement Average, weight provides the flexibility of the screening talent.And achievement event is provided, whether setting opens achievement event, and event provides The storage of examinee's detailed information.

Configure event title, marking section and the event weight in professional examination stage and test subject.For there is event The marking watchband of profession, generation has event column.

In the step 5 and step 6, one or several members of the seizure are configured for the test subject in each examination stage, if Setting type of calling the roll of the contestants in athletic events is that first trial is called the roll of the contestants in athletic events, review is called the roll of the contestants in athletic events or mixing is called the roll of the contestants in athletic events.If examinee regards as outstanding examinee by first trial examination hall, There is the examination hall of review link, examinee is led to be called the roll of the contestants in athletic events again to review examination hall, is given a mark again to examinee by authoritative expert.

Default configuration of calling the roll of the contestants in athletic events be do not allow orient call the roll of the contestants in athletic events at random call the roll of the contestants in athletic events, to prevent call room that examinee is specially arranged into certain Examination hall cheats at one's exam.Allow orientation to call the roll of the contestants in athletic events for profession (one group of interview of the N number of examinee) setting in group face, prevents from waiting the long-time examined It waits.

In the step 4 and step 7, special setting examination hall is allowed to require, for example there are " piano ", performance of talent and art in certain examination hall The examinee of piano, which will orient, to call the roll of the contestants in athletic events to the examination hall.

Examinee takes an examination after calling the roll of the contestants in athletic events to examination hall, and examiner is presented to examinee according to examinee's interview and gives a mark, and multiple professions examine a section Mesh, such as " musicology ", " recording art (recording engineering direction) ", " recording in artistic (sound equipment director direction) ", " musicology (electronics Music making direction) ", " music performance (vocal performance direction) " corresponding test subject be all " interview of music class ", Kao Shengkao Examination is primary, and examiner gives a mark to " interview of music class " all professions that examinee enters oneself for the examination respectively respectively, allows difference, and realization is once examined Examination, multiple academic results.

For this school or outer school pratice fraud profession achievement, it is specified that beat same score with main profession, selected by score line Source of students, profession of such as praticing fraud are " [school B] recording art " profession, are associated with, with main profession " recording in artistic (sound equipment director direction) " It asks and beats same score.

If examinee has entered oneself for the examination different section's purpose professions, arrives after different majors call room is called the roll of the contestants in athletic events and take an examination respectively.

Label lacks after examination, is examined business and does processing and can call the roll of the contestants in athletic events again and taken an examination, it is ensured that the fault-tolerance of system.Abandoning is examined explanation and is examined Raw to have arrived examination hall interview, statement cannot call the roll of the contestants in athletic events again after abandoning a certain professional examination.

In the step 8 and step 9, mitigate examiner's workload, examiner gives a mark in the empty list of results after calling the roll of the contestants in athletic events, it is ensured that Trace on paper.Stepping on grouping prevents mistake using Data Input twice.

By examination point director's account modification examiner to the marking achievement of examinee when typing mistake, three sections of passwords are respectively by three people It saves, prevents unwarranted illegal operation, while providing bug patch entrance, there is fault-tolerant ability, and generate modification day Will, in case accident is inquired.

It is described Step 10: in 11,12,13 and 14, summarize and calculate examiner the mean value conduct that examinee give a mark is examined Raw subject achievement, and provide importing nonlocal examinee's subject achievement.

Professional overall scores calculating considers written examination interview achievement by priority aggregation, and according to examination stage, profession and section The corresponding achievement for calculating each main professional examination stage of purpose, the mapping calculation of realization subject achievement to academic result.By praticing fraud specially Industry is associated with main profession, generates that profession is praticed fraud in this school and outer school is praticed fraud academic result, and realization is praticed fraud.

After exporting achievement, respectively professional score line delimited by school side, profession of praticing fraud and the school that pratices fraud, typing score line is raw At each profession by list, by list, achievement of putting up a notice simultaneously provides and imports skill and examine Entries System for export, by examinee's inquiry at Achievement.

Each professional fee-collector is configured, examinee enters next to payment at professional payment, examinee and specialized information is passed through Stage time is examined in list.

The step 3 configures next stage exam information into step 14, starts next stage examination.The examination stage It can repeatedly recycle, as long as there are also the examinees for crossing line to recycle always, meet multistage talent's screening requirements.

A kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools of the present invention and system it is excellent Point is:

(1) to ensure data not by unauthorized access, using the access control based roles of least privilege, deployment is adopted With white list, unauthorized IP is forbidden to access, database two-node cluster hot backup, it is ensured that data safety.

(2) examinee is made full use of to enter oneself for the examination information, profession is by entering oneself for the examination information extraction.To realize multistage examination, devise each A profession non-interfering examination stage devises main profession and is associated with realization agency's examination function with profession of praticing fraud.

(3) for realize once take an examination it is multiple profession marking, devise subject with profession it is one-to-many it is associated merge, for analyse Examinee academic result out, and realize from subject achievement and generate academic result.

(4) meet and be randomly assigned examinee to examination hall, it is ensured that examination is just.Marking realizes that trace archive can be looked on examiner's paper, Typing achievement has verifying function twice, to be fault-tolerant, devises the safety modification achievement entrance of three sections of passwords.

(5) each professional examination stage does not interfere with each other, and the examination stage can take turns circulation more.

Detailed description of the invention

Fig. 1 is that a kind of more examination point undergraduate course students recruiting total marks of the examination management methods of more schools of multistage are set with system architecture Meter；

Fig. 2 is data design Storage of the invention；

Fig. 3 is user information of the invention and enters oneself for the examination information base data management；

Fig. 4 is the data configuration managements such as examination stage subject of the invention；

Fig. 5 is examinee's first round exam information initialization process of the invention；

Fig. 6 is of the invention to examine business and call the roll of the contestants in athletic events process flow；

Fig. 7 is examiner's scoring treatment process of the invention；

Fig. 8 is that interface is realized in examiner's marking of the invention；

Fig. 9 is subject achievement and academic result's calculation process of the invention；

Figure 10 is toll administration process of the invention；

Figure 11 is main-process stream of taking an examination the multistage of the invention；

Figure 12 is system deployment figure of the invention；

Specific embodiment

It elaborates with reference to the accompanying drawing to the present invention.

Object of the present invention is to design a kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools With system, the intersection score management of more examination points, more schools, multi-specialized, more examination stages, multidisciplinary is realized, have payment, inspection Record, marking such as review, summarize, cross at the series functions.Including four subsystems: background management system, examinee call the roll of the contestants in athletic events system, examine Official's scoring system, registration charging system.What the access between each subsystem was mutually isolated, it is ensured that data safety, i.e. system are used Family checks role when logging in, and is oriented in specified subsystem, and have no right to access other subsystem contents.

The present invention is to ensure that data by unauthorized access, do not devise the least privilege access control of based role；For reality Existing multistage examination, devises each profession independent examination stage；To realize that acting on behalf of outer school selects student, devise main profession with Profession of praticing fraud association；To realize multi-specialized marking of once taking an examination, the one-to-many association of subject and profession is devised；Guarantee that examination is public It is flat to close rule, it devises to call the roll of the contestants in athletic events at random and distributes examinee to examination hall, devise orientation for particular/special requirement and call the roll of the contestants in athletic events；For marking paper on trace, Devise each professional examiner's papery marking table；Mistake is separated to prevent from stepping on, devises the verification of typing twice；Be it is fault-tolerant, devise three The safety entrance of section password modification achievement；It for the convergence of more examination point achievements, devises and imports subject achievement, and be mapped to examinee's profession Achievement starts new round examination after delimiting score line payment, solves more wheel examinations and selects Human Resources.

A kind of skill test method of the present invention and system include 24 modules, referring to Fig. 1, it may be assumed that typing imports user information (i.e. Examiner member of the seizure and fee-collector), import examination enter oneself for the examination information, generate specialized information and configure main profession, profession of praticing fraud with it is main special Industry association, examination stage management, test subject management, the management of marking section, stage subject correspondence, subject event management, score Wire management, examination hall management examine that business is associated with test subject, examiner is associated with examination hall, fee-collector is associated with by the stage, is examined with professional Business is called the roll of the contestants in athletic events, examiner's marking, subject achievement summarizes calculating or importing, professional overall scores calculate, check that time examines list, generation passes through name It is single, pass through after payment, wait and examine monitoring, marking monitoring, lack and examine monitoring.

System key data entry is recorded as shown in Figure 2, including 24 tables, User table: for the user in maintenance system, packet It includes system manager, examine business, examiner, fee-collector, 5 class role of examination point director.Raw_student table: it is entered oneself for the examination for storing examinee Raw information, system manager obtain examinee from enrollment office and enter oneself for the examination information, imported into this table, i.e., horizontal table above-mentioned.New_ Student table: for storing the corresponding relationship of examinee and registered speciality, since examinee can enter oneself for the examination multiple and different professions, examinee As soon as often entering oneself for the examination a profession, a record is generated in this table, i.e., vertical table.Major table: for storing specialized information. Relative_major table: for store this school pratice fraud profession and corresponding, the outer school of chief examiner's profession pratice fraud profession and chief examiner it is professional Corresponding relationship.Exam_stage table: for storing the examination stage, each profession fills in respective examination rank according to arrangement of the tests Section.Subject table: for storing test subject.Exam_stage-subject table: for storing examination stage and test subject Association, be arranged it is each profession each stage test subject.Standard table: for storing the area for allowing examiner to give a mark Between.Subject_item table: the subject event title and weight of event are stored with.Scoreline table: for storing professional delimitation Score line.Exam_room table: storage examination hall information.Examiner table: storage examiner is associated with examination hall, and each examiner works as It can only be assigned in an examination hall.Rollcaller table: for storing the related information for examining business teacher and test subject, often It is a to examine one day professional test subject that call the roll of the contestants in athletic events of business.Confirmer table: for storing the pass of fee-collector and stage of taking an examination Join information.Rollcall table: it calls the roll of the contestants in athletic events information for storing examinee.Rollcall_info table: for being stored with the inspection of subject event Record information.Interview_score table: for storing examiner to examinee section purpose marking achievement.Interview_score2 table: Examiner is stored to marking two typing of achievement of examinee section purpose.Interview_score_modify_info table: Data Input twice It is inconsistent and by examination point director's account modification after, storage modification log.Subject_score table: storage examinee's subject achievement. Final_score table: storage examinee academic result.Pass_student table: the qualified examinee information taken an examination of storage. Wait_student table: storage wait examinee, i.e., all preliminary examination examinees and pass through the upper examination stage and complete payment examinee Information.

Steps are as follows for detailed design method of the present invention and realization:

A kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools are with system features, wrap Include following steps:

Step 1: including examiner, examine business, fee-collector, examination point director and system manager role least privilege user pipe Reason.

Examiner is responsible for the examinee's marking having an interview.It examines the responsible examinee of business to call the roll of the contestants in athletic events, and examinee is assigned randomly to accordingly Interview examination hall, do not contact score information.Fee-collector is responsible for paying dues after the examination that examinee passes through the current generation, later examinee's energy Next stage examination is participated in, score information is not contacted.Examination point director is responsible under typing achievement error situation, modifies examiner one by one It is invisible after submission to the interview marking achievement of examinee.System manager is responsible for the environment configurations and examination of examination essential information Schedule monitoring does not check the entrance of achievement, invisible before calculating subject achievement after achievement storage, it is ensured that performance information is not usurped Change.Access control based roles are simultaneously ensured data not by unauthorized access and are checked using least privileged user account.

System manager and examination point director's account default exist when software installation, and do not allow add-on system administrator and Kao The user of point director role.System manager log in after, in systems typing or by Excel importing examiner, member of the seizure, receipts The user informations such as Fei Yuan are stored in User table.

Step 2: examinee enters oneself for the examination information management and registered speciality management.

Administrator obtains examinee's registration information table of Excel format from enrollment office, imports the table, is stored in Raw_student In table, simultaneously as an examinee can enter oneself for the examination multiple professions, each profession that the number of examining of examinee is entered oneself for the examination with it often has one A registered speciality just adds a data in New_student table, realizes that horizontal table is converted to vertical table, sees Fig. 3.

While importing examinee information table, generates in specialized information deposit Major table, maximally utilized registration information Table, as few as possible allow and prevent mistake at system manager's logging data.Option and installment wherein main profession, configures this school and pratices fraud specially Industry and corresponding, the outer school of chief examiner's profession are praticed fraud the correspondence of profession and chief examiner's profession, and corresponding relationship is shown in Table 1, is stored in Relative_ Major table realizes the function of agency's examination.

1 skill test method of table is associated with corresponding relationship with profession of praticing fraud with the main profession of system

It pratices fraud in the school profession are as follows: numerical medium art (Sino-foreign Cooperative Education) is associated with main pro digital media art, play Acute video display director (Sino-foreign Cooperative Education) is associated with drama video display director.

Outside school profession of praticing fraud, special circumstances similar with the association of main profession are as follows: [south is wide] performance is associated with performance, is also associated with To performance (musical play performs interschool exchange project double degree class), that is, if [south is wide] can be made a report on simultaneously by making a report on performance profession Performance, [south is wide] performance can also be made a report on by making a report on performance (musical play performance interschool exchange project double degree class), if made a report on Performance, performance (musical play perform interschool exchange project double degree class) and [south is wide] performance, the then achievement that [south is wide] performs can be with Selection take one of them, maximum value or average value.Similar situation, being suitable for [south is wide] musicology, (music manager, music are compiled Lead direction).

Step 3: examination stage management and test subject management.

Multistage selection of talented people is adapted to, the examination stage is provided with, each profession can configure several examination stages, each profession The examination stage is independent, and the examination stage of different majors can be different in the same time.It is each profession according to school side's arrangement of the tests Configure the examination stage: preliminary examination, retrial, three examinations are stored in Exam_stage table, process flow is shown in Fig. 4.

To realize that multiple professions examine same subject, it is configured with test subject, is manually entered test subject, and configures the subject Examination Form, i.e., interview or written examination, be stored in Subject table.

Configuration professional examination stage (Exam_stage table), professional (Major) are corresponding with test subject (Subject table), As the essential information once taken an examination, it is stored in Exam_stage-subject table, configures the first trial marking section of examination, review is beaten By stages and subject weight.The academic result of examinee is the weighted average of this professional examination stage achievement.With numerical medium art For profession, profession corresponding examination stage and subject configuration are shown in Table 2.

2 skill test method of table and system examination stage and subject profile instance

In table 2, pro digital media art and the corresponding test subject of numerical medium art (digital entertainment direction) are all Number matchmaker's class interview, i.e., multiple corresponding subjects of profession, while pratice fraud pro digital media artistic (Sino-foreign Cooperative Education) and [south Extensively] numerical medium art also corresponds to the interview of number matchmaker's class.And on the examination stage, numerical medium art, numerical medium art (close China and foreign countries Run a school) and [south wide] numerical medium art corresponding examination stage be all numerical medium art: preliminary examination.Numerical medium art (digital entertainment direction) although and the corresponding interview of numerical medium art is all several matchmaker's classes interviews, they respectively correspond oneself Examination stage, numerical medium art (digital entertainment direction): preliminary examination and numerical medium art: preliminary examination.Subsequent calculating subject achievement, Chief examiner's professional examination stage corresponding subject achievement is first calculated to examinee section purpose average mark in all examiners calculated, with For table 2, numerical medium art: the subject achievement and numerical medium art (digital entertainment of preliminary examination number of stages matchmaker's class interview is calculated Direction): number matchmaker's class in preliminary examination stage interviews achievement.

Since generally there are interview and written examination in a professional examination stage, then the profession in a professional examination stage at Achievement is equal to the weighted average of interview and written examination.That is numerical medium art: the achievement of preliminary examination is equal to the number matchmaker of numerical medium art Class interviews the weighted average of sum number matchmaker written examination, and weight is configurable.

The marking section of setting system, certain score sections do not allow to give a mark, and avoid the uniformity of marking, guarantee difference Property.First trial gives a mark section as 16-84.Review gives a mark section as 16-100.Do not allow to make in the first instance at 85 scores or more, review can be with It makes 85 scores or more, and if when review has objection to first trial score, can still make at 85 scores hereinafter, section deposit of giving a mark Standard table.In table 2, by taking numerical medium art as an example, there is review link.

Whether setting opens achievement event.Due to being commented in all directions when certain professional interviews (such as three examination of performance) examinee Valence needs subject event.Configure event title, marking section and the event weight in professional examination stage and test subject, deposit Subject_item table.For there is the profession of event, the marking sheet format of generation is different.

Delimit score line.The score line input system that each professional current test stage is obtained from school side, is stored in Scoreline Table.

In systems import examinee information after, system manager click initialization, judge Wait_students table whether be Sky, if not empty, then it represents that have been completed initialization, do not allow to initialize again；If it is empty, then initialization was not carried out, The major_name field in main_major field and New_student table in lookup Exam_stage table, successful match, Wait_students table is added in examinee information, examination session information, process flow is shown in Fig. 5.

Step 4: examination hall management and examiner examination hall associate management.

System manager's accessing system is arranged according to the examination hall that examination point office provides, configuration examination hall information (examination hall name Title, place city, test subject, examination hall type), it is stored in Exam_room table.Classroom where configuring the examination hall of each profession, and Examiner in User table is assigned to each examination hall Exam_room, each examiner can only be arranged at an examination hall, an examination hall 3-5 interview examiners are configured, are stored in Examiner table.Special setting examination hall is allowed to require, for example certain examination hall has " piano ", The examinee of skill performance piano, which will orient, to call the roll of the contestants in athletic events to the examination hall.

Step 5: member of the seizure and subject management of calling the roll of the contestants in athletic events.

One or several members of the seizure are configured for the test subject in each examination stage, is stored in Rollcaller table.It calls the roll of the contestants in athletic events Subject determines that the member of the seizure can only carry out setting section purpose and call the roll of the contestants in athletic events, and can not call the roll of the contestants in athletic events to other subjects.Type of calling the roll of the contestants in athletic events includes: First trial is called the roll of the contestants in athletic events, last instance is called the roll of the contestants in athletic events and mixing is called the roll of the contestants in athletic events.Mixing, which is called the roll of the contestants in athletic events, to indicate the member of the seizure both and can be carried out first trial to call the roll of the contestants in athletic events, and also can be carried out review It calls the roll of the contestants in athletic events.Default configuration of calling the roll of the contestants in athletic events be do not allow orient call the roll of the contestants in athletic events at random call the roll of the contestants in athletic events, examined with preventing call room that examinee is specially arranged into certain Field cheats at one's exam.Allow orientation to call the roll of the contestants in athletic events for profession (one group of interview of the N number of examinee) setting in group face, prevents from waiting the long-time etc. examined Wait see Fig. 6.

Step 6: process management of calling the roll of the contestants in athletic events.

According to member of the seizure role, user logs into interface of calling the roll of the contestants in athletic events, and examinee's admission card for entrance examination two dimensional code is scanned, if examinee is waiting It examines in table Wait_students table, then system distributes an examination hall to examinee at random, calls the roll of the contestants in athletic events if necessary to orient, and selects one Examination hall, the time that examinee calls the roll of the contestants in athletic events into the examination hall examine list, and band examinee enters examination hall after printing table of calling the roll of the contestants in athletic events, information of calling the roll of the contestants in athletic events deposit In Rollcall table.

If corresponding test subject has event, such as: the performance of phase III interview, examiner need to the body of examinee, Image makings are read aloud, perform this four events and give a mark respectively, then are otherwise the marking table that examiner's output has event exports general Logical marking table.If subject has event, information of calling the roll of the contestants in athletic events will be also stored in Rollcal_info table, see Fig. 6.

If examinee regards as outstanding examinee by first trial examination hall, in the examination hall for having review link, examinee is led to call the roll of the contestants in athletic events again, It calls the roll of the contestants in athletic events to the review examination hall of the profession, gives a mark again to examinee, as shown in Figure 6.

Step 7: examiner, which gives a mark, to be managed.

Examinee takes an examination after calling the roll of the contestants in athletic events to examination hall, and examiner is presented to examinee according to examinee's interview and gives a mark, and multiple professions examine a section Mesh, such as " musicology ", " recording art (recording engineering direction) ", " recording in artistic (sound equipment director direction) ", " musicology (electronics Music making direction) ", " music performance (vocal performance direction) " corresponding test subject be all " interview of music class ", Kao Shengkao Examination is primary, and examiner gives a mark to " interview of music class " all professions that examinee enters oneself for the examination respectively respectively, allows difference, realizes that examinee participates in Primary examination, multiple academic result's marking, profession are shown in Table 2 with subject corresponding relationship.

For this school or outer school pratice fraud profession achievement, it is specified that beat same score with main profession, selected by score line Source of students, profession of such as praticing fraud are " [school B] recording art " profession, are associated with, with main profession " recording in artistic (sound equipment director direction) " It asks and beats same score, the corresponding relationship of pratice fraud profession and main profession is shown in Table 1.

If examinee has entered oneself for the examination different section's purpose professions, arrives after different majors call room is called the roll of the contestants in athletic events and take an examination respectively.

Examinee does not take an examination after calling the roll of the contestants in athletic events, and examines labeled as lacking.It examines if having been marked as lacking, took an examination again later, It can look for and examine business teacher, be deleted to lack by system manager and examine label, called the roll of the contestants in athletic events and take an examination again.Sound when if examinee takes an examination It is bright to abandon a certain professional examination, it is examined labeled as abandoning, abandoning, which is examined, illustrates that examinee has arrived examination hall interview, after a certain professional examination is abandoned in statement It cannot call the roll of the contestants in athletic events again.

System manager's accessing system can check the testing situations of examinee at any time, if it given a mark, whether lacked and examine, It can be screened according to profession, check examination advancement.

Step 8: grouping typing achievement is stepped on twice to verify consistency.

Examiner gives a mark to the interview of examinee, is recorded on papery table, special to step on grouping examiner's account typing achievement.It examines Consider and step on a point possible error, use typing twice, whether verification is consistent, has the function of effect.If a typing (deposit Interview_score table) it is consistent with two typings (deposit Interview_score2) table, illustrate that typing is errorless, if different Cause, artificial nucleus to and submit and examine business and do, modified by examination point director's account.For same examinee same subject achievement if there is Score, to lack the examiner's marking examined and abandoned and examine inconsistent, same to prompt typing mistake, by the modification of examination point director's account.Marking is stepped on point As shown in Figure 7 with modification achievement process.

Examiner gives a mark interface, that is, steps on interface as shown in Figure 8, comprising: waits examinee's list, examinee's list, current Examinee's marking frame, basic information and marking button.Time is examined list and is arranged successively according to the sequence of calling the roll of the contestants in athletic events of examinee, and examiner can click Any one examinee's marking.Examinee's list, which illustrates, has made score, but the examinee's data that do not submit finally.Marking frame Can be according to the marking frame of different examinees entered oneself for the examination and show different numbers by situation, and it is corresponding in turn to different major names. Basic information includes the information of current marking examinee and the essential information of current examiner.Function button include it is final submit by Button, achievement audit button and log off.

Step 9: by examination point director's account modification examiner to the marking achievement of examinee when typing mistake.

Examination point director's account uses three sections of passwords, and by system manager, examination point director and Kao business executive director take care of respectively, Three sections of password holders can modify examiner to the marking achievement of examinee when on the scene, modify after checking one by one, and a typing mistake is repaired Change a typing, two typing mistakes modify two typings, and generate modification log, are stored in Interview_score_modify_info table In case accident is inquired.When modification, record modification people and modification time fill in specific modification reason.

Step 10: subject achievement calculates.

System manager's accessing system, the subject of this stage examination is completed in selection, if the subject has event, basis Event weight in Subject_item table calculates each examinee this section purpose examiner to point, is stored in Interview_score Table.It checks there is no after inconsistent situation of giving a mark, calculates what all examiners gave a mark to examinee from Interview_score marking meter Average value is stored in Subject_score as the subject achievement of examinee.Import the subject achievement of nonlocal examination point, before importing by Excel processing calculates the average achievement that examiner gives a mark to examinee, that is, what is imported is examinee's subject achievement, sees Fig. 9.

If the corresponding profession of the subject has written examination subject, need written examination achievement import system being stored in Subject_ Score table is used for subsequent calculating overall scores.

Step 11: professional overall scores calculates.

System manager's accessing system selects a completed examination stage, according to Exam_stage-subject table In written examination interview weight (note: if only interview, interview weight be 1), calculate written examination, interview achievement weighted average be allocated as For the final result in this examination stage of examinee, it is stored in Final_score table, written examination is interviewed weight and is arranged as shown in sample table 2.

The achievement for profession that profession is praticed fraud in this school and outer school is praticed fraud professional is associated with generation according to main.Lookup is praticed fraud professional right Then the main profession answered exports the final result of the main profession, as the final result for the professional examinee that pratices fraud, be stored in Final_ Score table.

Step 12: generation passes through list.

After system manager takes the score line that school side marks, each profession is configured in systems in point in this examination stage Number line, is stored in Scoreline table, assert that examinee is taken an examination by this stage equal to score line is higher than, examinee's deposit is passed through list Pass_students table can participate in the examination of next stage after examinee's payment.If examinee's score is lower than score line, the examinee The examination of this profession leaves it at that.By list, achievement of putting up a notice simultaneously provides and imports skill and examine Entries System for export, by examinee's inquiry at Achievement is shown in Fig. 9.

Step 13: fee-collector with pass through stage profession associate management.System manager's accessing system, handles official business according to examination point The fee-collector that room provides arranges, and configuration fee-collector is associated with the stage of examination, is stored in Confirmer table.

Step 14: toll administration.Examinee's admission card for entrance examination is scanned, if examinee pays the fees, in corresponding profession by list Examinee enter time and examine list list.Fee-collector's accessing system scans the bar code on admission card for entrance examination, if the examinee is passing through list It in Pass_students table, then pays the fees, which becomes next stage time examinee, is stored in Wait_students table.If examinee Not by score line of upper stage, it cannot pay the fees and then the subsequent all examinations of the profession terminate, process is as shown in Figure 10.

The step 3 configures next stage exam information into step 14, starts next stage examination.The examination stage It can repeatedly recycle, as long as there are also the examinees for crossing line to recycle always, meet multistage talent's screening requirements.Main-process stream is shown in figure 11, partial circulating is to configure examiner examination hall in an examination stage daily to correspond to, and realizes that examiner examination hall is randomly assigned, systemic circulation is to examine Try step cycle.

Step 15: deployment and security strategy.Skill examines a part for belonging to college entrance examination, be included in artistic examinee college entrance examination admission at Achievement, therefore the safety of data is particularly important.System deployment is used using local area network, referring to Figure 12, two-shipper linux system, number According to library server principal and subordinate's two-node cluster hot backup, application server two-shipper is online, all write-in main database server, is passed through by primary server SQL log is synchronously written from database server.Unauthorized access is prevented, using white list firewall, the IP of non-white list Forbid opening skill test system in location.

Claims (9)

1. a kind of more examination point undergraduate course students recruiting total marks of the examination management methods of multistage more schools are with system features, including Following steps:

Step 1: including examiner, the least privilege user management of business, fee-collector, examination point director and system manager role is examined.

Examiner is responsible for the examinee's marking having an interview.It examines the responsible examinee of business to call the roll of the contestants in athletic events, and examinee is assigned randomly to corresponding face Try examination hall.Fee-collector is responsible for paying dues after the examination that examinee passes through the current generation, and examinee can participate in next stage examination later.It examines Point director is responsible under typing achievement error situation, interview marking achievement of the modification examiner to examinee.System manager is responsible for examining Try the environment configurations and examination advancement monitoring of essential information.

Step 2: examinee enters oneself for the examination information management and registered speciality management.

It imports and enters oneself for the examination information from the examinee that external skill examines Entries System, by entering oneself for the examination the horizontal table of information table, i.e. an examinee enters oneself for the examination Multiple professional records, import and generate vertical table, the profession one of examinee one record, and extract all specialized informations, Generate professional table.

Configure the profession of chief examiner, pratice fraud profession and corresponding, the outer school of chief examiner's profession of this school is praticed fraud the profession correspondence professional with chief examiner.

Step 3: examination stage management and test subject management.

Multistage selection of talented people is adapted to, the examination stage is provided with, each profession can configure several examination stages.Configure examination section Mesh, multiple professions can examine same subject.And it configures the examination stage of profession, profession is corresponding with test subject.

Step 4: examination hall management and examiner examination hall associate management.

Classroom where configuring the examination hall of each profession, and examiner is assigned to each examination hall, each examiner can only be arranged at one A examination hall, an examination hall configure 3-5 interview examiners.

Step 5: member of the seizure and subject management of calling the roll of the contestants in athletic events.

One or several members of the seizure are configured for the test subject in each examination stage.

Step 6: process management of calling the roll of the contestants in athletic events.User logs according to its member of the seizure role, logs into interface of calling the roll of the contestants in athletic events, and scanning examinee is quasi- Two dimensional code is investigated, system distributes an examination hall to examinee at random if time is examined in list if examinee.

Step 7: examiner, which gives a mark, to be managed.

Examinee takes an examination to examination hall, and examiner is presented to examinee according to examinee's interview and gives a mark, and a subject examines multiple professions, respectively to each A profession marking, it is specified that beat same score with chief examiner's profession, subsequent each profession score line can be with for achievement for profession of praticing fraud It is different.Examinee does not take an examination after calling the roll of the contestants in athletic events, and examines labeled as lacking.It examines if having been marked as lacking, took an examination again later, it can be with It looks for and examines business teacher, deleted to lack by system manager and examine label, called the roll of the contestants in athletic events and take an examination again.If statement is put when examinee takes an examination A certain professional examination is abandoned, is examined labeled as abandoning.

Step 8: grouping typing achievement is stepped on twice to verify consistency.

Examiner gives a mark to the interview of examinee, is recorded on papery table, special to step on grouping examiner's account typing achievement.It considers A point possible error is stepped on, typing twice is used, whether verification is consistent, has verifying function.If a typing is consistent with two typings, Illustrate that typing is errorless, if inconsistent, artificial nucleus to and submit and examine business and do, modified by examination point director's account.For same examinee Same subject achievement if there is score, inconsistent, the same prompt typing mistake, by examination point that lacks examiner's marking for examining and abandons and examining The modification of director's account.

Step 9: by examination point director's account modification examiner to the marking achievement of examinee when typing mistake.

Examination point director's account uses three sections of passwords, and by system manager, examination point director and Kao business executive director take care of respectively, and three sections Password holder can modify examiner to the marking achievement of examinee when on the scene, and generate modification log.

Step 10: subject achievement calculates.

It checks there is no after inconsistent marking situation, calculates the average mark that all examiners give a mark to examinee, the subject as examinee Achievement.The subject achievement for importing nonlocal examination point is handled the average achievement for calculating examiner and giving a mark to examinee, i.e., by Excel before importing Examinee's subject achievement.

Step 11: professional overall scores calculates.

According to the overall scores ratio of each professional this stage examination, professional examination stage, profession and subject corresponding relationship, written examination score With the weight of interview score, examinee academic result is calculated.The achievement for profession that profession is praticed fraud in this school and outer school is praticed fraud according to lead specially The association of industry generates.

Step 12: generation passes through list.The score line for setting main profession and profession of praticing fraud is equal to height to examinee academic result It is taken an examination in score line identification by this stage, the write-in of examinee's specialized information passes through list.

Step 13: fee-collector with pass through stage profession associate management.Toll administration setting one to each professional current generation Name or several toll administration persons.

Step 14: toll administration.Examinee's admission card for entrance examination is scanned, if examinee, in corresponding profession, payment passes through examining on list It is raw to examine list into time.

Step 15: deployment and security strategy.Skill examines a part for belonging to college entrance examination, is included in the college entrance examination admission achievement of artistic examinee, Therefore the safety of data is particularly important.System deployment is used using local area network, two-shipper linux system, database server master From two-node cluster hot backup, application server two-shipper is online, and main database server is written in data, synchronous through SQL log by primary server It is written from database server.Unauthorized access is prevented, using white list firewall, the IP address of non-white list forbids opening skill Test system.

2. according to claim 1 a kind of more examination point undergraduate course students recruiting total marks of the examination management methods of more schools of multistage with System, it is characterised in that step 1: access control based roles simultaneously ensure that data are not unauthorized using least privileged user account Access and check, role logs into different software module interfaces.Examiner's marking can only see oneself to the marking of examinee at Achievement, it is invisible after submitting and auditing.Member of the seizure, which can only call the roll of the contestants in athletic events, examinee and distributes examinee to examination hall, does not contact score information.Payment Member, only completes charge link, does not contact score information.Examination point director's account single is inquired and modifies vicious examiner to examining Raw scoring information, it is invisible after submission.System manager can only configure exam information, monitoring examination before examination terminates State does not check the entrance of achievement.It is invisible before calculating subject achievement after achievement storage, it is ensured that performance information is not tampered.

3. skill test method and system according to claim 1, it is characterised in that examinee enters oneself for the examination information and examines report by skill in step 2 Name system generates, and horizontal table turns vertical table, and extracts all specialized informations, generates professional table, has maximally utilized registration information table, As few as possible allow and prevents mistake at system manager's logging data.Profession that configuration chief examiner is professional, this school is praticed fraud and chief examiner's profession Correspondence, outer school pratice fraud profession with chief examiner profession it is corresponding, realize agency other school examinations function.

4. skill test method and system according to claim 1, it is characterised in that step 3: multistage selection of talented people is adapted to, if It has set the examination stage, each profession can configure several examination stages, and each professional examination stage is independent, the examination rank of different majors Section can be different in the same time.To realize that multiple professions examine same subject, it is configured with test subject, realizes that how special primary examination is Industry marking.The marking section of setting system, certain score sections do not allow to give a mark, and avoid the uniformity of marking, guarantee otherness.

Configuration professional examination stage, profession are corresponding with test subject, as the essential information once taken an examination, configure the first trial of examination Marking section, review marking section and subject weight.The academic result of examinee is the weighted average of this professional examination stage achievement, Weight provides the flexibility of the screening talent.And achievement event is provided, whether setting opens achievement event, and event provides examinee face Try detailed information.

Configure event title, marking section and the event weight in professional examination stage and test subject.For there is the profession of event, The marking watchband of generation has event column.

5. skill test method and system according to claim 1, it is characterised in that step 5 and step 6: for each examination stage Test subject configure one or several members of the seizure, setting call the roll of the contestants in athletic events type be first trial call the roll of the contestants in athletic events, review call the roll of the contestants in athletic events or mixing call the roll of the contestants in athletic events.Such as Fruit examinee regards as outstanding examinee by first trial examination hall, in the examination hall for having review link, examinee is led to be called the roll of the contestants in athletic events again to review examination hall, It is given a mark again to examinee by authoritative expert.

Default configuration of calling the roll of the contestants in athletic events be do not allow orient call the roll of the contestants in athletic events at random call the roll of the contestants in athletic events, to prevent call room that examinee is specially arranged into certain examination hall Cheat at one's exam.Allow orientation to call the roll of the contestants in athletic events for profession (one group of interview of the N number of examinee) setting in group face, prevents from waiting the long-time etc. examined To.

6. skill test method and system according to claim 1, it is characterised in that step 4 and step 7: special setting being allowed to examine Field requires, for example certain examination hall has " piano ", and the examinee of performance of talent and art piano, which will orient, to call the roll of the contestants in athletic events to the examination hall.

Examinee takes an examination after calling the roll of the contestants in athletic events to examination hall, and examiner is presented to examinee according to examinee's interview and gives a mark, and multiple professions examine a subject, such as " musicology ", " recording art (recording engineering direction) ", " recording in artistic (sound equipment director direction) ", " musicology (electronic music system Make direction) ", " music performance (vocal performance direction) " corresponding test subject be all " interview of music class ", examinee's examination is primary, Examiner gives a mark to " interview of music class " all professions that examinee enters oneself for the examination respectively respectively, allows different, the primary examination of realization, Duo Gezhuan Industry achievement.

For this school or outer school pratice fraud profession achievement, it is specified that beat same score with main profession, source of students is selected by score line, Profession of such as praticing fraud is " [school B] recording art " profession, is associated with main profession " recording in artistic (sound equipment director direction) ", it is desirable that beat same The score of sample.

If examinee has entered oneself for the examination different section's purpose professions, arrives after different majors call room is called the roll of the contestants in athletic events and take an examination respectively.

Label lacks after examination, is examined business and does processing and can call the roll of the contestants in athletic events again and taken an examination, it is ensured that the fault-tolerance of system.Abandoning, which is examined, illustrates that examinee arrives Examination hall interview, statement cannot call the roll of the contestants in athletic events again after abandoning a certain professional examination.

7. skill test method and system according to claim 1, it is characterised in that step 8 and step 9: mitigating examiner's work Amount, examiner give a mark in the empty list of results after calling the roll of the contestants in athletic events, it is ensured that trace on paper.Stepping on grouping prevents mistake using Data Input twice.

By examination point director's account modification examiner to the marking achievement of examinee when typing mistake, three sections of passwords are protected by three people respectively It deposits, prevents unwarranted illegal operation, provide bug patch entrance, there is fault-tolerant ability, and generate modification log, in case Accident inquiry.

8. skill test method and system according to claim 1, it is characterised in that Step 10: 11,12,13 and 14: Summarize the subject achievement for calculating mean value that examiner give a mark to examinee as examinee, and provides and import other places examinee's subject achievement.

Professional overall scores calculating considers written examination interview achievement by priority aggregation, and according to examination stage, profession and section's purpose The corresponding achievement for calculating each main professional examination stage, the mapping calculation of realization subject achievement to academic result.By pratice fraud profession with The association of main profession, generates that profession is praticed fraud in this school and outer school is praticed fraud academic result, and realization is praticed fraud.

After exporting achievement, respectively professional score line, typing score line delimited by school side, profession of praticing fraud and the school that pratices fraud, generated each A profession is by list, and by list, achievement of putting up a notice simultaneously provides and imports skill and examine Entries System for export, inquires achievement by examinee.

Each professional fee-collector is configured, examinee pays the fees at the payment by profession, and examinee and specialized information enter next stage Time is examined in list.

9. skill test method and system according to claim 1, it is characterised in that step 3 to step 14: configuration next stage Exam information starts next stage examination.The examination stage can repeatedly recycle, as long as there are also the examinees for crossing line to follow always Ring meets multistage talent's screening requirements.