CN115936838A

CN115936838A - System and method for automatically evaluating bank counter actual operation

Info

Publication number: CN115936838A
Application number: CN202211660984.7A
Authority: CN
Inventors: 宋新军; 林征; 陈花平; 陈丹丹; 张新奥淇; 郭超年; 程舒晗
Original assignee: Fujian Rural Credit Union
Current assignee: Fujian Rural Credit Union
Priority date: 2022-12-22
Filing date: 2022-12-22
Publication date: 2023-04-07

Abstract

The invention provides a system and a method for automatically evaluating bank counter business operation, wherein the system comprises a management terminal system installed on an examiner computer and an examinee terminal system installed on the examinee computer, wherein the management terminal system and the examinee terminal system operate independently and communicate through FTP and Socket; the management terminal system is responsible for the operation of the whole examination room process and is connected with a background service system database in a butt joint mode, the management terminal system comprises a test paper generation module, a test paper distribution module and a test paper grading module, the examination room terminal system is responsible for the functions of title display and examination paper delivery grading, and the examination room terminal system comprises a test paper display module. The system and the method for automatically evaluating the bank counter practice operation solve the problems of large workload of question setting and various defects caused by manual paper evaluation in the existing bank counter practice operation examination, simplify the editing mode of a question bank, realize automatic evaluation and shorten the grading and examination period.

Description

System and method for automatically evaluating bank counter actual operation

Technical Field

The invention relates to the technical field of bank evaluation, in particular to a system and a method for automatically evaluating bank counter business operation.

Background

In order to improve counter business handling level and operation efficiency of tellers and avoid major business errors, banks often organize tellers to carry out counter business operation training and level examinations. The teller training and examination in each time mainly use paper examination papers for questions, and then the teller performs practical operation at a counter business system client according to the examination questions. The examination paper is evaluated manually, the examination paper is often checked for two hours, the examination paper is evaluated for two weeks, and the like, and technicians are required to coordinate to call the data of the background service system database for the examination paper evaluation in the examination paper evaluating process. With the rapid development of banking business, the number of tellers is increasing, which leads to the continuous extension of the paper evaluation time, and the conditions of subjective error, sentiment, impression and the like exist in the paper evaluation process, which leads to the insufficient credibility of the score. The bank urgently needs an automatic evaluation system for counter business operation, which can realize automatic, standardized and batch evaluation and get rid of various defects caused by manual evaluation.

At present, there is no patent specially designed for the bank counter examination system, and the patents of the related examination system in the financial industry include: the Chinese invention patent 'an examination training system based on banking business' with publication number CN106683011A and publication date 2017-5-17 provides an examination training system based on a pre-embedded question bank, and realizes automatic batch examination paper grouping and marking by a computer; the invention discloses a Chinese patent 'an insurance examination system and method' with publication number CN114936941A and publication number 2022-8-23, which relates examination papers created by each sub-administrator to each examinee, so that the examination papers required to be examined by each examinee are related to the corresponding examinee, and the examinee can know which examination needs to be taken after logging in an examination platform, and can take the examination without the need of knowing the type of the examination required to be taken by the employee, thereby facilitating the operation of the employee and avoiding the phenomena of missed examination and wrong examination.

The examination system focuses more on electronizing the traditional paper examination paper, then extracts the examination questions from the pre-embedded question bank based on the rules, the examination questions cannot be freely combined according to the business elements, real business scenes cannot be completely displayed, examinees cannot participate in business operations in the real scene, and the examination system mainly scores objective questions (selection questions, judgment questions and blank filling questions). In addition, the examination system cannot simulate various facility environments on the bank counter, and the accuracy of the examination content cannot be guaranteed.

Disclosure of Invention

The technical problem to be solved by the invention is to provide a system and a method for automatically evaluating bank counter practice operation, which solve the problems of large workload of question making and various defects caused by manual paper evaluation in the existing bank counter practice operation examination, simplify the editing mode of a question bank, realize automatic evaluation and shorten the grading and examination period.

In a first aspect, the invention provides a system for automatically evaluating the actual operation of a bank counter, which comprises a management terminal system installed on an examiner computer and an examinee terminal system installed on an examinee computer, wherein the management terminal system and the examinee terminal system operate independently and communicate through FTP and Socket;

the system comprises a management terminal system, a background business system database, a question display module, a test paper distribution module, a test paper grading module, a question display module, a test paper delivery module, a test paper grading module, a question display module, a test paper delivery module and a test paper grading module, wherein the management terminal system is responsible for the operation of the whole examination room process and the butt joint of the background business system database;

the test paper generation module is used for finishing the editing of the test paper template and the generation of specific test paper;

the test paper distribution module is used for checking whether FTP service of each examinee computer is started, newly building a folder in each examinee computer and each examinee computer, and distributing the corresponding test paper to the folder corresponding to each examinee computer through the FTP;

the examination paper display module is used for carrying out examination paper acquisition and interface display at an examinee end, and after the examinee finishes transaction operation and hands on examination paper, the management terminal system calculates scores for the examinee to inquire the scores;

the test paper grading module is used for judging a critical value by acquiring service mark critical value information prestored in a folder when an examination starts and ends, combining an answer configuration xml file to judge the critical value, checking a grading environment, reading the test paper and an answer configuration xml rule, calling a unified answer processor, inquiring and judging whether the answer is correct or incorrect by adopting a database according to the content of the answer rule file, and giving a final grade based on the score ratio of each step of the question of the test paper.

Furthermore, a bank counter business system client needs to be installed on the computer of the examinee at the same time, the examinee performs practical operation according to the examination paper questions, and the examination paper questions are displayed on the bank counter business system client interface at the same time.

Further, the test paper generation module further comprises:

the question bank editing module is used for editing questions by business personnel through Excel office software, and technical personnel complete writing of a question scoring script through an xml file and store the script for subsequent long-term use;

the template generating module is used for automatically selecting a proper amount of questions according to configuration parameters to synthesize a complete test paper template, wherein the configuration parameters comprise types, difficulty, number of the questions and total score, and different emphasis points of the examination are met;

the system comprises an examinee information import module, a test management module and an evaluation management module, wherein the examinee information import module is used for storing examinee information by adopting a TXT text, the text naming rule is YYYYYMMDD-XX-title TXT, YYYYYMMDD is the evaluation test date, XX is the field (the examiner is determined according to the actual situation), the title is the evaluation test title, and the examinee information comprises an examinee name, an examinee identity card, an examinee institution number, an examinee teller number and an examinee computer terminal ip;

the test paper generation module is used for automatically generating a test paper for each examinee according to the test paper template and the examinee information, and the test paper naming rule is as follows: xls, the common area in each test taker's test paper is populated with the test taker's information.

Further, the question bank editing module specifically includes:

an Excel question design standard template is designed in advance and comprises a public area, a question area and an answer configuration area, wherein the public area comprises a title, an examinee name, an examinee identity card, a field, an examinee teller number, an examination date and an examination score; the title area comprises a title number (unique), a title ID (unique), types (deposit type, cash type, voucher type, settlement service type and the like), type description, difficulty (difficult, medium and easy), score and title content (a place needing to generate different contents according to actual conditions every time adopts a placeholder); the answer configuration area contains elements and element values (placeholders corresponding to the subject content are used by the changed elements);

business personnel select the transaction needing to be evaluated by the counter system, analyze the transaction key evaluation point, and then write the question in the question area according to an Excel question design standard template and a placeholder use specification provided by technical personnel, wherein the key evaluation point is replaced by a placeholder, and list the counter transaction evaluation element and the element value in the answer configuration area, and the element value is replaced by the placeholder corresponding to the question area;

technical staff configure and determine a business system related to the question according to the question and the grading factor provided by the business staff, and design a grading script to complete the connection configuration and answer configuration of a business system database;

the answer configuration uses an xml format, and each question of an xml file has the following naming rules: topic ID number, xml; the method comprises the steps that a root element of an answer configuration xml file is an AnswerRoot, sub-elements are stages, other elements are illegal, one Stage element represents one step, one title comprises a plurality of steps, the Stage element supports two attributes check and percent, and the check conditions and the fraction percentage of the step are represented respectively;

under the sub-element Stage, only elements beginning with Condition can be configured, wherein one Condition X represents a Condition and cannot have a repeated name, and supports an attribute "ret" for realizing the detail judgment of Condition success and failure;

auxiliary elements supported by the ConditionX are Db, sql and Para, wherein Db represents a name of a database to be accessed, and the name of the database uses a corresponding dbName in database configuration file database. Sq1 represents the database access Sql text, using standard Sql syntax, for parameter values in the where statement? "instead, there are several"? "then there must be several Para elements in the following auxiliary parameters, and the corresponding values of the Para elements are used to replace" in the where statement in turn according to the order of appearance of the Para elements? "; para represents the parameter value of the Sql text, the Sq1 Wen Shi is analyzed in a program, a corresponding actual value is obtained according to the parameter configuration to form a complete Sq1 text, the element supports six attributes, and the attributes are used for determining the source, the format and the type of the Para element, namely id: showing the ID number of the subject, if the ID attribute is not set, defaulting the ID number of the subject; from: representing the source of Para element data, the values supported include Exam (test paper subject area), pub (test paper public area), examStart (start test acquisition data) and ExamEnd (end test acquisition data); fmt: representing formatted data, supported values including AMT (amount format), DATE (DATE format) and CQ (expiration format); fmtStr: indicating a specific DATE format, commonly used with fmt = "DATE", supported values include "yyyy-MM-dd" and "yyymmdd"; len: indicating the format of the amount of money, and the supported values comprise '13,2' and '17,0' and indicate the length and precision of the converted number; type: data type conversion, conversion of real character string and SQL data type.

Further, the test paper distribution module specifically includes:

the connection checking module is used for reading the information of the examinees, sequentially checking whether the FTP service of each examinee computer is started, newly building a folder in each examinee computer and each examinee computer, and naming the folder as YYYYMMDD-XX, namely the date and the field of the examination to be evaluated;

and the test paper distribution module is used for reading the information of the examinees, sequentially acquiring the corresponding relation between the teller numbers of the examinees and the ip of the computer, and distributing the corresponding test papers to the specific folders of the examinee computer through the FTP.

Further, the test paper display module specifically includes: the examination paper acquisition and display module, the cross paper scoring module and the score query module;

the test paper acquisition and display module is used for realizing the functions of acquiring, displaying and selecting test paper questions at the examinee end, and specifically executes the following operations: obtaining a test paper, inputting a counter number, a field and a test date of the examinee into a subsystem interface of the examinee terminal by the examinee, and clicking to obtain the test paper; the method comprises the following steps of interface display, wherein an examinee triggers to obtain a test paper event, the examinee end automatically reads the content of the test paper to generate a question list, a counter service system client is automatically opened, an examination question display frame is fixed at the upper left corner of the counter service system client, each question corresponds to a question index, and the examination questions are prohibited from being copied; the method comprises the following steps that (1) an examinee selects questions, after the examinee end displays a question list, the examinee selects, switches and checks the questions by operating an up-down question button or a drop-down frame, the examinee end also provides a marking function for marking the questions according to different purposes, the examinee selects a transaction which accords with the question meaning in a client operation interface of a counter service system according to the content displayed by the questions to operate, all elements in the transaction interface are input according to the description of the questions, the questions are not described, the examinee selects and inputs the questions according to the actual conditions, and the examination supports connection or simulation of real counter hardware equipment;

the examination paper scoring module is used for scoring examination papers of the examinee terminal and specifically executes the following operations: initiating examination paper delivery, clicking an examination paper delivery grading button after an examinee answers a question, and firstly, obtaining local examinee information including an examinee teller number, a field and an examination date by an examinee terminal and splicing a examination paper delivery request; then, a volume delivery request thread is newly established, a volume delivery request packet is sent, and a socket transaction channel is established with a management end; calculating scores, establishing a result queue by a management end according to a paper delivery request submitted by an examinee end, placing the result queue at a specified position of the queue after the scores are calculated, and returning after waiting for an examinee to trigger a score inquiry event;

and the score query module is used for querying scores calculated by the management end in a polling mode at fixed intervals by the background of the examinee end after the examinee clicks the score query button, and displaying the scores of the examinee on an interface after score information is acquired.

Further, the examination paper scoring module specifically comprises an examination starting and ending module, a scoring environment preparation module, an examination paper scoring module and a score export module:

the examination starting and ending module is used for collecting service mark critical value information in each service system database table when an examination is started, wherein the service mark critical value information comprises a service system serial number and a service system timestamp maximum value when the examination is started, the service mark critical value information is stored in a corresponding folder of an examiner computer, a file is named as ExamStart. The system English is called business critical mark for short, the business critical mark value is called business critical mark for short, and the method is used for judging the critical value in the answer configuration xml file; and when the examination is finished, collecting service mark critical value information in each service system database table, wherein the service mark critical value information comprises a service system serial number and a service system timestamp maximum value when the examination is finished, and storing the service mark critical value information in a corresponding folder of an examiner computer, wherein the file is named as ExamEnd.xml, and the storage format of the service mark critical value is as follows: the system English is called business critical mark for short, the business critical mark value is called business critical mark for short, and the method is used for judging the critical value in the answer configuration xml file;

the system comprises a management terminal, a grading environment preparation module, a management terminal and a management terminal, wherein the grading environment preparation module is used for acquiring the relevant conditions of the grading environment of an examination to ensure that the management terminal scores correctly, the management terminal reads and configures the corresponding examination conditions according to the examination date and the examination time, the corresponding examination conditions comprise core accounting system date and examination relevant business system serial number information, the information is assembled into Sql text, the management terminal is connected with an examination relevant business system database to inquire the current system state and return the result to the management terminal in real time, the management terminal judges the returned result information according to the defined judgment conditions, if the judgment result is true, the examination data of the examination room cannot cross the border, namely the environmental examination passes, the management terminal records the relevant system state for the examination grading of the management terminal, otherwise, the configuration of the management terminal is required to be adjusted, and the environmental examination is carried out again;

the test paper scoring module is used for finishing the test paper scoring function and specifically executing the following operations:

reading the test paper, and setting a filtered file type through a management terminal interface by an examiner to obtain a test paper file name list; after selecting files in the file name list (supporting the simultaneous selection of a plurality of files), the management terminal stores the file contents into the memory for the subsequent steps according to the agreed identification format and the file name identification;

rule reading, namely reading the grading rule content of the answers, dividing the rule content into a plurality of rule files according to questions, wherein the rule content comprises condition parameters and database information for assembling and judging the correct and wrong Sq1 text, obtaining the question ID number of the test paper after the management end reads the content of the test paper file, finding a corresponding xml answer configuration file according to the question ID number, and configuring the xml rule for the Sq1 text? The values corresponding to the Para elements are used for carrying out replacement or conversion, the rule content information in the replaced or converted file is stored in a memory of a management end, and after the examination room is subjected to volume grading, the management end judges that the examination room answers wrongly;

judging whether the answer is correct or wrong, adopting database query to judge whether the answer is correct or wrong according to the content of the answer rule file by calling a uniform answer processor, and giving a final score based on the score ratio of each step of the test paper question;

the score export module is used for obtaining each score of each examinee from the single-question score queue, summarizing the score, calculating to obtain the total score of the examinee, storing the total score into an examinee score list, updating an examination score field in a common area of the examination paper, exporting the score list by adopting an Excel file format at a management end, and inquiring and obtaining the score through the examinee end.

Further, the specific implementation manner of the correctness judgment in the test paper scoring module is as follows:

inputting information, acquiring a question ID number and rule contents by a management end, building an answer processor, and transmitting the information into the answer processor, wherein the answer processor is a JAVA object called by the management end and is compatible with various formats such as lists, character strings, numerical values and Boolean types;

and an execution processor, wherein after the answer processor starts executing, firstly, according to the content of the rule, a service system database corresponding to ConditionX under Stage is connected, and Sql text is sent to the service system database to be executed, if the returned records meet the condition of ConditionX element attribute ret (generally, the number of the returned records is greater than 0, and if the number of the returned records is greater than 1, it is indicated that the examinee has operated the question for multiple times), namely, the ConditionX is correct. After all ConditionX conditions in the Stage are processed, performing logic AND and OR calculation on all condition conclusions according to an answer configuration file rule to obtain a Stage correctness conclusion and calculate scores, wherein the score = the total score of the Stage multiplied by percentage; after all stages are processed, performing logic AND calculation on all Stage conclusions to obtain a conclusion whether the answer content of a question is correct or not;

and outputting a result, closing the answer processor after the answer score is calculated, and storing the answer score of the examinee in a management-end single-question score queue, wherein the queue elements comprise an examinee teller number, an examinee computer IP, a question number ID and a question score, and are used for summarizing and calculating the total score of the examinee in the following steps.

Further, the background business system database comprises a core accounting system database, an ECIF database, a middle business system database, a counter system database and other system databases.

In a second aspect, the present invention provides a method for automatically evaluating banking counter practice operations, which needs to provide the system as described above, and the method includes the following steps:

step 1, editing a question bank by a service person and a technical person at a management end together;

step 2, the management terminal system automatically selects a proper amount of questions to synthesize a complete test paper template according to configuration parameters, wherein the configuration parameters comprise types, difficulty, number of questions and total scores, and different emphasis points of the examination are met;

step 3, importing examinee information and an examination paper template for processing to generate an examination paper, and distributing the corresponding examination paper to the examinee according to an examinee information list and an IP (Internet protocol);

step 4, clicking by the examiner computer to start the examination;

step 5, clicking a button on a computer of an examinee terminal to obtain a test paper, generating a question list by the examinee terminal, automatically opening a bank counter business system client to fix an examination paper display frame at the upper left corner of the client, carrying out corresponding transaction operation on the bank counter business system client by the examinee according to the question of the test paper, and clicking to hand over the paper to score after the examinee finishes answering;

step 6, the examiner computer clicks to finish the examination;

step 7, the management terminal performs scoring environment preparation to obtain test paper information submitted by each examinee;

step 8, obtaining each examination question grading script and an examinee test paper to assemble SQL sentences, executing the SQL sentences to grade the test paper, and generating each examination score;

and step 9, the examinee end obtains the examination scores of the examinees through score inquiry operation and displays the examination scores.

The invention has the following advantages: the system analyzes the counter transaction key evaluation points of the bank, parameterizes and scripts the counter transaction key evaluation points to achieve the purpose of automatically evaluating counter transaction practice operations, unifys the evaluation standards, automatically evaluates in batches, improves the evaluation efficiency of the examination, saves the examination cost, can automatically generate examination questions after the administrator uniformly inputs examination elements, improves the examination question evaluation efficiency, and meets the requirements of developing and evaluating each organization of the bank in a normalized, intelligent and agile way by developing an electronic examination; the automatic evaluation system is adopted to enhance the official trust of the examination, the problems of 'untight connection service scene, single examination question, subjective error in examination reading' and the like in the traditional non-electronic bank examination are solved, the real service scene can be completely simulated, the accuracy and the safety of the examination are improved, an intelligent question combination mode based on service elements is adopted, the unified scoring standard is combined, the objectivity of the examination question and the fairness of the examination reading are realized, and the examination efficiency and the official trust are effectively improved by combining the two modes.

Drawings

The invention will be further described with reference to the following examples with reference to the accompanying drawings.

Fig. 1 is a schematic structural diagram of a system for automatically evaluating the banking counter practice operation according to the present invention.

FIG. 2 is a network architecture diagram of the automatic evaluation system for banking counter practice operations according to the present invention.

FIG. 3 is a flow chart of an implementation of the method for automatically evaluating the banking counter practice operations according to the present invention.

Detailed Description

The embodiment of the application provides a system and a method for automatically evaluating bank counter business operation, which are used for solving the inconvenience caused by paper rolling and manual rolling during bank counter business operation evaluation, simulating a real business scene to realize the automatic evaluation process of the bank counter business operation by simplifying rolling flow and automatic evaluation, and improving the overall evaluation efficiency.

The technical scheme in the embodiment of the application has the following general idea: the automatic evaluation system for the actual operation of the bank counter comprises two parts: the system comprises a management terminal system and an examinee terminal system, wherein the management terminal system is installed on an examinee computer, the examinee terminal system is installed on the examinee computer, a bank counter client is also needed to be installed on the examinee computer and used for answering questions of the examinees, the two subsystems run independently, and communication is carried out through FTP and Socket. The management terminal system is responsible for the operation of the whole examination room process and the butt joint of a background service system database and comprises three modules of test paper generation, test paper distribution and test paper scoring; the examinee terminal system is responsible for the subject display and the paper delivery grading function and comprises a module for test paper display. The test paper generation module mainly comprises four functions of question bank editing, template generation, examinee information import and test paper generation. The test paper distribution module mainly comprises two functions of connection check and test paper distribution. The test paper display module mainly comprises three functions of test paper acquisition and display, paper delivery grading and score inquiry. The examination paper grading module mainly comprises four functions of starting and ending an examination, grading environment examination, grading an examination paper and exporting scores. According to the method, by analyzing key evaluation points of counter transaction of the bank, excel table conversion is formulated, and parameterization and scripting are carried out on the Excel table conversion, so that question editing and automatic answer evaluation are carried out on counter transaction practical operation.

In order to better understand the technical scheme, the technical scheme is described in detail in the following with reference to the attached drawings of the specification and specific embodiments.

Example one

As shown in fig. 1 and fig. 2, the present invention provides a system for automatically evaluating the banking counter practice operations, which comprises a management terminal system installed on an examiner computer and an examinee terminal system installed on an examinee computer, wherein the management terminal system and the examinee terminal system operate independently and communicate with each other through FTP and Socket;

the management terminal system is responsible for the operation of the whole examination room process and the butt joint of a background service system database, the management terminal system comprises a test paper generation module, a test paper distribution module and a test paper grading module, the examinee terminal system is responsible for the functions of question display and paper delivery grading, and the examinee terminal system comprises a test paper display module;

the test paper distribution module is used for checking whether the FTP service of each examinee computer is started or not, newly building a folder in each examinee computer and the examinee computer, wherein the folder is named YYYYMMDD-XX (namely named according to the evaluation test date and field) and distributing the corresponding test paper to the corresponding folder of each examinee computer through the FTP;

the test paper grading module is used for judging a critical value by acquiring service mark critical value information prestored in a folder when an examination starts and ends and combining an answer configuration xm1 file, carrying out grading environment check, reading test papers and an answer configuration xml rule, calling a unified answer processor, inquiring and judging whether the answer is correct or wrong by adopting a database according to the content of an answer rule file, and giving a final grade based on the score ratio of each step of test paper questions.

Preferably, the examinee computer is also required to be provided with a bank counter business system client for the examinee to perform practical operation according to the examination paper questions, and the examination paper questions are displayed on the bank counter business system client interface at the same time. Specifically, when an examinee end computer clicks a button to obtain a test paper, the examinee end generates a question list, a bank counter business system client is automatically opened to fix an examination question display frame in the upper left corner of the client, the examinee performs corresponding transaction operation on the bank counter business system client according to the question of the test paper, and the examinee clicks the paper to be handed over and scores after answering.

Preferably, the test paper generation module further includes:

the question bank editing module is used for editing questions by business personnel through Excel office software, and technical personnel can edit the questions through xml files to complete the writing of a question scoring script and store the script for subsequent long-term use without editing the question bank during each evaluation;

the template generation module is used for automatically selecting a proper amount of questions to synthesize a complete test paper template according to configuration parameters, wherein the configuration parameters comprise types, difficulty, number of the questions and total scores and meet different emphasis points of the examination;

the system comprises an examinee information import module, a TXT data storage module and a TXT data storage module, wherein the TXT data storage module is used for storing examinee information by adopting a TXT text, and the text naming rule is YYYYYMMDD-XX-title TXT, wherein YYYYMMDD is an evaluation test date, XX is a field (the evaluation is determined by an examiner according to actual conditions), and the title is an evaluation test title, such as the third evaluation by a third provincial teller in 20221022-02-2022 years TXT;

the test paper generation module is used for automatically generating a test paper for each examinee according to the test paper template and the examinee information, and the test paper naming rule is as follows: xls, if the number of examinee teller is 100545, the examinee test paper is named 100545.Xls. And filling a public area (Pub) of each examinee test paper by using the examinee information, wherein titles, field times and examination dates are filled by using information related to the examinee information file names, and in order to realize that the elements of each examinee test paper are different, placeholders of question areas (Que) and answer configuration areas (Exam) among different examinees are replaced by randomly generating legal information.

Preferably, the question bank editing module specifically comprises:

an Excel question design standard template is designed in advance and is divided into a public area (Pub), a question area (Que) and an answer configuration area (Exam). The public area (Pub) comprises a title, an examinee name, an examinee identity card field, an examinee teller number, an examination date and an examination score; the question area (Que) contains a question number (unique), a question ID (unique), a type (deposit type, cash type, voucher type, settlement service type and the like), a type description, difficulty (difficult, medium and easy), a score and question content (a place needing to generate different content according to actual conditions at each time adopts a placeholder); the answer arrangement region (Exam) includes elements and element values (placeholders corresponding to changed element use topic contents); the business personnel selects the transaction needing evaluation by the counter system, and analyzes the key points of the transaction, such as: the method comprises the steps that an account is opened for trading at a current time, key scoring points are account opening person identity information, account opening amount, account opening products and the like, then questions are written in a question area (Que) according to an Excel question design standard template and a placeholder use specification provided by technicians, wherein the key scoring points are replaced by placeholders, scoring elements and element values of counter surface trading are listed in an answer configuration area (Exam), and the element values are replaced by placeholders corresponding to the question area (Que);

the Excel theme design standard template is designed by taking personal account opening transaction operation as an example and is shown in the following table 1:

TABLE 1

/>

Technical staff determines a service system related to the theme according to the theme and the grading factor configuration provided by the service staff, and designs a grading script to complete the connection configuration and answer configuration of a service system database:

the database connection configuration is realized in an xml file, and the file name is database. The root element of the xml file is database, the child element is sqlserver, a plurality of sqlservers can be configured to represent different database connections, and other elements are all illegal. The fixed configuration of the next five stator elements of sqlserver is: dbName: the database name representing the definition, which can be named by itself, but must be unique, is used for referring the database name in the answer rule file, such as CORE, ECIF and the like; driver: representing a database drive class path which is required to be consistent with a path in a downloaded database drive package; url: representing a database connection string. The method generally comprises basic elements of a connection mode, a database server address, a database name or a database instance; and a user: representing the database user to access; password: indicating the database password to be accessed. Other extension sub-elements under sqlserver are configured as: initialSize: representing the initial connection number of the database; minPoolSize: represents the minimum number of connection pools; maxPolSize: represents the maximum number of connection pools; maxIdleTime: represents idle time, 0 is permanent; retryAttempts: indicating the number of attempts to establish a connection; acquireIncrement: indicating the number of connections per application.

Answer configuration uses xml format, each question is an xml file, and the file naming rule is as follows: topic ID number, xml, as first topic, topic ID: n001, the file name is N001.Xml. An example of xml answer configuration may be referred to with the following code:

/>

the root element of the answer configuration xml file is AnswerRoot, the child elements are Stage, other elements are illegal, one Stage element represents one step, and one question can have multiple steps. The Stage element supports two attributes, check, percentage, representing the inspection condition and fractional percentage of the step (using decimal to represent percentage, e.g. "0.3" to represent thirty percent), respectively, and check content uses a specified expression, represented by "^" and "|" and the meaning of and or.

Under the sub-element Stage, only elements beginning with Condition, such as Condition1 and Condition2, can be configured, one Condition x represents a Condition and cannot have a repeated name, and the Condition x element supports an attribute "ret" for realizing detailed judgment of Condition success and failure.

The auxiliary elements supported under Conditionx are Db, sq1, para. Db: indicating a database name to be accessed, wherein the database name uses a corresponding dbName in a database configuration file database. Sql: represents a database access to Sql text (that is, a file composed of Sql is an executable file), using standard Sql syntax, "? "instead, there are several"? "then there must be several Para elements in the following auxiliary parameters, and the corresponding values of the Para elements are used to replace"? "; para: and when the program analyzes the Sql text, acquiring a corresponding actual value according to the parameter configuration to form a complete Sql text, wherein the element supports six attributes and is used for determining the source, the format and the type of the Para element. Id: if the ID number of the subject is represented and the ID attribute is not set, the ID number of the subject is defaulted; from: representing the source of Para element data, and supporting values such as Exam (examination paper subject area), pub (examination paper public area), examStart (examination starting data collection), examEnd (examination ending data collection) and the like; fmt: indicating formatted data, and supporting values such as AMT (amount format), DATE (DATE format), CQ (expiration format), etc.; fmtStr: indicating a specific DATE format, typically used with fmt = "DATE", supported values of "yyyyy-MM-dd", "yyyyMMdd", etc.; len: indicating amount format, typically used with fmt = "AMT", supporting values of "13,2", "17,0" indicating converted digit length and precision (where 13,2 indicates a positive digit length of 13 bits, where there are 2-bit decimal, 11-bit integer; 17,0 indicates a positive digit length of 17 bits, all bit integer); type: and (3) data type conversion, namely converting the character string and the SQL data type, wherein if the int is configured, the data type of the query condition converted into the Sql text is 'Integer'.

Preferably, the test paper distribution module specifically includes:

Preferably, the test paper display module specifically includes: the examination paper acquisition and display module, the cross paper scoring module and the score query module;

the test paper acquisition and display module is used for realizing the functions of acquiring, displaying and selecting test paper questions at the examinee end, and specifically executes the following operations: obtaining a test paper, inputting a counter number, a field and a test date of the examinee into a subsystem interface of the examinee terminal by the examinee, and clicking to obtain the test paper; the method comprises the steps that interface display is carried out, an examinee triggers to obtain an examination paper event, the examinee end automatically reads examination paper content to generate a question list, a counter business system client is automatically opened, an examination question display frame is fixed to the upper left corner of the counter business system client, each question corresponds to a question index, and the examination questions are prohibited to be copied; the method comprises the following steps that (1) an examinee selects questions, after the examinee end displays a question list, the examinee selects, switches and checks the questions by operating an up-down question button or a drop-down frame, the examinee end also provides a marking function for marking the questions according to different purposes, the examinee selects a transaction which accords with the question meaning in a client operation interface of a counter service system according to the content displayed by the questions to operate, all elements in the transaction interface are input according to the description of the questions, the questions are not described, the examinee selects and inputs the questions according to the actual conditions, and the examination supports connection or simulation of real counter hardware equipment;

the examination paper scoring module is used as a core function of the examinee terminal, is used for scoring examination papers of the examinee terminal, and specifically executes the following operations: initiating examination paper delivery, clicking an examination paper delivery grading button after an examinee answers a question, and firstly obtaining local examinee information including an examinee teller number, a field number and an examination date by the examinee terminal, and sending a examination paper delivery request (namely, three values of the examinee teller number, the field number and the examination date are spliced into a character string and sent to the examinee terminal through a socket, for example, the examinee teller is 100456, the field number is 01, the examination date is 2022-12-10, and three fields are spliced into a examination paper delivery request message 100456012022-12-10); then, a volume delivery request thread is newly established, a volume delivery request packet is sent, and a socket transaction channel is established with a management end; calculating scores, establishing a result queue by a management end according to a paper delivery request submitted by an examinee end, placing the result queue at a specified position of the queue after the scores are calculated, and returning after the examinee triggers a score inquiry event;

and the score query module is used for querying scores calculated by the management end in a polling mode at fixed intervals after the examinee clicks the score query button, and displaying the scores of the examinee on an interface after score information is acquired.

Preferably, the examination paper scoring module specifically comprises an examination starting and ending module, a scoring environment preparation module, an examination paper scoring module and a score export module:

the examination starting and ending module is used for collecting service mark critical value information in each service system database table when an examination is started, wherein the service mark critical value information comprises a service system serial number and a service system timestamp maximum value when the examination is started, the service mark critical value information is stored in a corresponding folder (namely a folder in the examination paper distribution module) of an examiner computer, a file is named as ExamStart. The system English is called business critical mark for short, the business critical mark value, the system English is called business critical mark for short, for example:

< CORE _ PTXSEQ >098756781</CORE _ PTXSEQ >, which is used for judging the critical value in the answer configuration xml file, the step is executed before the test paper display module; and when the examination is finished, collecting service mark critical value information in each service system database table, wherein the service mark critical value information comprises a service system serial number and a service system timestamp maximum value when the examination is finished, and storing the service mark critical value information in a corresponding folder of an examiner computer, wherein the file is named as ExamEnd.xml, and the storage format of the service mark critical value is as follows: the system English is called business critical mark for short, the business critical mark value, the system English is called business critical mark for short, such as:

the < ECIF TIMESTAMPS >20221026144217759000</ECIF TIMESTAMPS > is used for judging a critical value in an answer configuration xml file;

the preparation module of the grading environment is used for the administration end to obtain the relevant conditions of the grading environment of the examination to be checked and ensure the administration end to grade correctly, the administration end reads and configures the corresponding checking conditions according to the examination date and the examination field, the information comprises the date of the core accounting system, the serial number of the examination related business system and the like, the information is assembled into Sql texts (the Sql texts are executable files, namely files consisting of Sql), connecting an examination correlation service system database to inquire the current system state, returning the result to a management terminal in real time, judging the returned result information by the management terminal according to a defined judgment condition, if the judgment result is true, indicating that the examination data of the examination room cannot cross the border, namely the environmental examination passes, recording the related system state by the management terminal for grading by the management terminal, otherwise, adjusting the configuration of the management terminal and carrying out the environmental examination again;

the test paper scoring module is used as a core module of the management end and used for finishing the test paper scoring function, and specifically executes the following operations:

reading a rule, reading answer scoring rule contents, dividing the rule contents into a plurality of rule files according to questions, wherein the rule contents comprise condition parameters and database information for assembling and judging correct and incorrect Sql texts, acquiring test paper question ID numbers after a management end reads the test paper file contents, finding a corresponding xml answer configuration file according to the question ID numbers, and configuring an xml rule for the Sql texts? The values corresponding to the Para elements are used for carrying out replacement or conversion, the rule content information in the replaced or converted file is stored in a memory of a management end, and after the examination room is subjected to volume grading, the management end judges that the examination room answers wrongly; if the rule file is not found, an abnormal prompt is thrown out to inform examiners that the relevant questions cannot judge that the examinees answer the questions correctly;

Preferably, the specific implementation manner of the error judgment in the test paper scoring module is as follows:

and after the answer processor starts to execute, firstly connecting a service system database corresponding to ConditionX under Stage according to rule content, and sending Sql text to the service system database to execute, wherein if the returned records meet the ConditionX element attribute ret condition (the number of the returned records is more than 0 generally, and if the number of the returned records is more than 1, the test taker is indicated to operate the question for multiple times), namely the ConditionX is correct. After all ConditionX conditions in the Stage are processed, logic AND and OR calculation is carried out on all condition conclusions according to answer configuration file rules, whether the Stage is correct or not is obtained, scores are calculated, and the score = the total score of the Stage x percent. And after all stages are processed, performing logic AND calculation on all stages to obtain a conclusion whether the answer content of one question is correct or not, namely that only one question is calculated to be correct when all condition conclusions are true. Because the management end supports the configuration of the score proportion of each Stage of the question, even if the answer is incorrect, the output of the score of the question is larger than 0;

Preferably, the background business system database includes a core accounting system database, an ECIF database, a middle business system database, a counter system database, and other system databases.

Example two

As shown in fig. 3, the present invention provides a method for automatically evaluating banking counter practice operations, which needs to provide the system as described in the first embodiment, the method includes the following steps:

step 2, the management terminal system automatically selects a proper amount of questions according to configuration parameters to synthesize a complete test paper template, wherein the configuration parameters comprise types, difficulty, number of the questions and total score, and different emphasis points of the examination are met;

step 4, clicking by the examiner computer to start the examination;

step 6, the examiner computer clicks to finish the examination;

step 7, the management end performs scoring environment preparation to obtain test paper information submitted by each examinee;

and 9, obtaining the examination scores of the examinees through score inquiry operation by the examinee terminal and displaying the examination scores.

The invention realizes automatic scoring of the bank counter business operation. The traditional automatic grading system for bank examinations can only grade objective questions (selected questions, judged questions and blank filling questions) and cannot grade actual counter transaction operation of a bank; the system also realizes an intelligent examination paper composing mode based on business elements, an examination administrator inputs examination information such as teller mechanisms, transaction types, transaction elements, important certificates, examination scenes, expected results and the like in advance and is used for simulating real teller transaction scenes, and the system generates examination questions, answers and grading standards according to the intelligent combination of the examination information, thereby ensuring paperless examination content, the uniformity of the grading standards, the automation of the grading mode and the batchization of the grading process; the invention can simulate real counter background system and teller foreground transaction environment. The system is in butt joint with a counter system similar to a real transaction environment, the operation practice of examinees is written into a background system simulating the production environment to generate transaction data simulating the production environment, relevant transaction data cannot be tampered by an examination administrator and the examinees, the fairness, the authenticity and the safety of the examination are ensured, meanwhile, the system simulates the real operation environment of the examinees operating on the counter, and the strain capacity of the examinees responding to various transaction scenes is examined; the invention can be compatible with diversified counter facilities, relates to a large number of certificates and counter operating equipment in teller operation, simulates various transaction certificates in a system, is compatible with various operating equipment such as a high-speed shooting instrument and the like, and ensures the authenticity and the accuracy of examination questions.

Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.

Claims

1. The utility model provides a system that is used for bank counter practice operation automatic evaluation which characterized in that: the system comprises a management terminal system arranged on an examiner computer and an examinee terminal system arranged on the examinee computer, wherein the management terminal system and the examinee terminal system operate independently and communicate through FTP and Socket;

the test paper generation module is used for finishing the editing of the test paper template and the generation of specific test papers;

the test paper distribution module is used for checking whether the FTP service of each examinee computer is started, newly building a folder in each examinee computer and each examinee computer, and distributing the corresponding test paper to the corresponding folder of each examinee computer through the FTP;

the examination paper grading module is used for judging a critical value by acquiring service sign critical value information prestored in a folder when the examination starts and ends, combining an answer configuration xm1 file to judge the critical value, checking a grading environment, reading the examination paper and an answer configuration xml rule, calling a uniform answer processor, inquiring and judging whether the answer is correct by adopting a database according to the content of an answer rule file, and giving a final grade based on the score proportion of each step of examination paper questions.

2. The system of claim 1, wherein: and the examinee computer is also required to be provided with a bank counter business system client for the examinee to carry out practical operation according to the examination paper questions, and the examination paper questions are displayed on the bank counter business system client interface at the same time.

3. The system of claim 1, wherein: the test paper generation module further comprises:

the system comprises an examinee information import module, a data processing module and an examinee information management module, wherein the examinee information import module is used for storing examinee information by adopting a TXT text, and the examinee information comprises an examinee name, an examinee identity card, an examinee institution number, an examinee teller number and an examinee computer terminal ip;

the test paper generation module is used for automatically generating one test paper for each examinee according to the test paper template and the information of the examinee, and the test paper naming rule is as follows: xls, the common area in each test taker's test paper is populated with the test taker's information.

4. The system of claim 3, wherein: the question bank editing module specifically comprises:

an Excel question design standard template is designed in advance and comprises a public area, a question area and an answer configuration area, wherein the public area comprises a title, an examinee name, an examinee identity card, a field, an examinee teller number, an examination date and an examination score; the title area comprises a title number, a title ID, a type description, difficulty, a score and title content; the answer configuration area comprises elements and element values;

only elements beginning with Condition can be configured under the sub-element Stage, one ConditionX represents a Condition and cannot have repeated names, and the ConditionX element supports an attribute "ret" for realizing the detail judgment of Condition success and failure;

auxiliary elements supported by the ConditionX are Db, sql and Para, wherein Db represents a name of a database to be accessed, and the name of the database uses a corresponding dbName in database configuration file database. Sql denotes database access Sql text, using standard Sql syntax, for parameter values in the where statement? "instead, there are several"? "then there must also be several Para elements in the following auxiliary parameters, and the values corresponding to the Para elements are used to replace the values in the where statement in turn according to the order in which the Para elements appear"? "; para represents the parameter value of the Sql text, the Sql Wen Shi is analyzed in a program, a corresponding actual value is obtained according to the parameter configuration to form a complete Sq1 text, the element supports six attributes and is used for determining the source, the format and the type of the Para element, wherein the source, the format and the type are respectively id: indicates the title ID number; from: representing a source of Para element data; fmt: representing the formatted data; fmtStr: indicating a specific date format; len: indicating the amount format; type: and converting the data type.

5. The system of claim 1, wherein: the test paper distribution module specifically comprises:

the connection checking module is used for reading the information of the examinees, sequentially checking whether the FTP service of each examinee computer is started or not and creating a folder in each examinee computer and each examiner computer;

and the test paper distribution module is used for reading the information of the examinees, sequentially obtaining the corresponding relation between the teller numbers of the examinees and the ip of the computer and distributing the corresponding test papers to the specific folders of the examinee computer through the FTP.

6. The system of claim 2, wherein: the test paper display module specifically comprises: the examination paper acquisition and display module, the cross paper scoring module and the score query module;

the test paper acquisition and display module is used for realizing the functions of acquiring, displaying and selecting test paper questions at the examinee end, and specifically executes the following operations: obtaining a test paper, inputting a counter number, a field and a test date of the examinee into a subsystem interface of the examinee terminal by the examinee, and clicking to obtain the test paper; the method comprises the following steps of interface display, wherein an examinee triggers to obtain a test paper event, the examinee end automatically reads the content of the test paper to generate a question list, a counter service system client is automatically opened, an examination question display frame is fixed at the upper left corner of the counter service system client, each question corresponds to a question index, and the examination questions are prohibited from being copied; the method comprises the following steps that an examinee selects questions, after the examinee end displays a question list, the examinee selects, switches and checks the questions by operating an up-down question button or a drop-down box, the examinee end also provides a marking function for marking the questions according to different purposes, the examinee selects a transaction which accords with the question in a counter service system client operation interface according to the content displayed by the questions to operate, all elements in the transaction interface are input according to the description of the questions, the questions are not described, the examinee selects and inputs the questions according to actual conditions, and examination support connection or simulation of real counter hardware equipment;

the examination paper scoring module is used for scoring examination papers of the examinee terminal and specifically executes the following operations: initiating examination paper delivery, clicking an examination paper delivery grading button after an examinee answers a question, and firstly, obtaining local examinee information including an examinee teller number, a field and an examination date by an examinee terminal and splicing a examination paper delivery request; then, a volume delivery request thread is newly established, a volume delivery request packet is sent, and a socket transaction channel is established with a management end; calculating scores, establishing a result queue by a management end according to a paper delivery request submitted by an examinee end, placing the result queue at a specified position of the queue after the scores are calculated, and returning after the examinee triggers a score inquiry event;

7. The system of claim 1, wherein: the examination paper scoring module specifically comprises an examination starting and ending module, a scoring environment preparation module, an examination paper scoring module and a score export module:

the examination room examination data management system comprises a core accounting system, an examination room examination data storage module, a scoring environment preparation module, a score setting module and a score setting module, wherein the score setting module is used for a management terminal to obtain conditions related to examination score environment and ensure that the management terminal scores correctly, the management terminal reads and configures corresponding examination conditions according to examination dates and examination times, the examination conditions comprise core accounting system date and examination related business system serial number information, the information is assembled into an S ql text, the examination related business system data storage module is connected with an examination related business system database to inquire current system states and return results to the management terminal in real time, the management terminal judges the returned result information according to defined judgment conditions, if the judgment result is true, the examination room examination data cannot cross the border, namely the environment examination passes, the management terminal records the related system states and is used for the management terminal examination score, otherwise, the management terminal configuration is required to be adjusted and the environment examination is carried out again;

reading the test paper, and setting a filtered file type through a management terminal interface by an examiner to obtain a test paper file name list; after selecting the file in the file name list, the management terminal stores the file content into the memory according to the agreed identification format and the file name identification for the subsequent steps;

reading a rule, reading answer scoring rule contents, dividing the rule contents into a plurality of rule files according to questions, wherein the rule contents comprise condition parameters and database information for assembling and judging correct and wrong Sq1 texts, obtaining test paper question ID numbers after a management end reads the test paper file contents, finding a corresponding xml answer configuration file according to the question ID numbers, and configuring xml rules for the Sql texts? The values corresponding to the Para elements are used for carrying out replacement or conversion, the rule content information in the replaced or converted file is stored in a memory of a management end, and after the examination room is subjected to volume grading, the management end judges that the examination room answers wrongly;

judging whether the answer is correct or not, adopting a database to inquire and judge whether the answer is correct or not according to the content of the answer rule file by calling a uniform answer processor, and giving a final score based on the score ratio of each step of the test paper question;

the score exporting module is used for acquiring each score of each examinee from the single-subject score queue, summarizing the score, calculating to obtain the total score of the examinee, storing the total score into an examinee score list, updating an examination score field in a public area of the examination paper, and exporting the score list by adopting an Excel file format at a management end and inquiring and acquiring the score by the examinee end.

8. The system of claim 1, wherein: the specific implementation manner of the judgment of the test paper scoring module is as follows:

an execution processor, wherein after the answer processor starts executing, firstly, according to the content of a rule, a service system database corresponding to ConditionX under Stage is connected, sql text is sent to the service system database to be executed, if the returned record meets the ConditionX element attribute ret condition, namely ConditionX is correct, after all ConditionX conditions in the Stage are processed, all condition conclusions are subjected to logic AND and OR calculation according to the rule of an answer configuration file, whether the Stage is correct or not is obtained, and a score is calculated, wherein the score = the total score multiplied by percentage of the question; after all stages are processed, performing logic AND calculation on all Stage conclusions to obtain a conclusion whether the answer content of a question is correct or not;

and outputting a result, closing the answer processor after the answer score is calculated, and storing the answer score of the examinee in a single answer score queue of a management end, wherein the queue elements comprise an examinee teller number, an examinee computer IP, an answer number ID and a question score, and the queue elements are used for summarizing and calculating the total score of the examinee in the following steps.

9. The system of claim 1, wherein: the background business system database comprises a core accounting system database, an ECIF database, a middle business system database, a counter system database and other system databases.

10. A method for automatically evaluating the actual operation of bank counter is characterized in that: it is intended to provide a system as claimed in any one of claims 1 to 9, said method comprising the steps of:

step 4, clicking by the examiner computer to start the examination;

step 6, the examiner computer clicks to finish the examination;