JP4104617B2 - Product information management system and product information management program - Google Patents

Description

  The present invention relates to a deliverable information management system and a management program for managing information on deliverables of enrolled students. The present invention also relates to a system and program for supporting evaluation of results based on the deliverables.

  In educational institutions, not only paper media tests but also tests may be conducted on the WWW using the World Wide Web (WWW). In the past, faculty and staff generally scored by hand on paper media, entered the score by hand on an entry form, and then entered the score into spreadsheet software. On the other hand, in a test on the WWW, the test processing system automatically inputs the tester's input device by operating the input device of the terminal device, reads the answer stored in the storage device of the test system, and automatically scores it. The scoring results are stored in a storage device.

In a descriptive test, an answer sheet is read using a scanner, its image information is acquired, and information for identifying a student who is an answerer is associated with a scoring result and stored in a storage device. Processing systems are also known (see, for example, Patent Document 1).
Japanese Patent Laying-Open No. 2005-24693 (pages 3-8, FIGS. 9-10)

  Traditionally, faculty members refer to scoring results entered using the tabular software described above for paper-based deliveries, ie, tests conducted on paper media, to determine the grades of students taking the course, and As for electronic data products, that is, tests on the WWW, it is necessary for the grade processing system to execute processing and to refer to the scoring results stored in the storage device. Therefore, there has been a problem that the final result must be determined after confirming and evaluating the scoring results of each test separately.

  SUMMARY OF THE INVENTION An object of the present invention is to provide a system and a program for centrally managing paper-based products and electronic data products, thereby supporting calculation of results and unit determination.

The product information management system according to the present invention is capable of integrating and managing the results of tests performed on paper media and the results of tests performed as electronic data, for example, the results of tests performed on the WWW. it can. Thereby, it is possible to check the results of both tests on the same terminal device and evaluate the final results. Specifically, the test conducted on paper media, for example, after scoring handwritten scoring by faculty and staff, reads the scored product using a scanner, and uses a predetermined format (eg, TIFF (Tag Image File Format) format). Create an image file and use OCR (Optical Character
The student ID number and scoring result (score) information is acquired using Reader, and stored in the storage device in association with the image file.

  In addition, the test conducted as electronic data is automatically scored, and the score result is stored in the storage device. The deliverables information management system stores the score history of multiple exams and reports for each course, by class and student, and at the end of the course based on a predefined formula. Automatically calculate grades and credits.

More specifically, the object of the present invention is to specify a general file storing an electronic data file among actual data files related to a product related to a subject taken by a student, each record for identifying the product, The product information file including the course and student number, the product name identifying the product and its score, and the respective records are the course, product name, and product. A storage device having a correspondence table including a storage destination of the actual data file in the storage device,
In the storage device, a course data and a product name are received from an input device or a terminal device connected via a network, and a series of actual data files about the product are read from a scanner. Image file storage means for determining a storage location of the image file, and storing the series of image files in the storage location in the storage device;
A correspondence table record generating means for generating a record of the correspondence table including the course, the product name, and the storage destination, and storing the record in the storage device;
The product name and the image read from the scanner in the record of the product information file based on the student ID obtained by recognizing the predetermined area in the image subject and the image file This is achieved by a product information management system comprising product information file record generation means for storing scores obtained by character recognition of other predetermined areas in the file.

  In a preferred embodiment, the deliverable information file record generation unit reads the general file stored in the storage device, and refers to the record of the correspondence table based on the storage destination, thereby Identify the deliverable name and refer to the course, student number, and score included in the general file, and record the result in the deliverable information file record based on the course and student ID An object name and the score are stored.

In another preferred embodiment, a scoring table in which each record further stores a weight corresponding to each of the deliverable names relating to the subject,
From the terminal device, information identifying a course is received, the record relating to the course is identified in the scoring table, and the weight corresponding to each of the deliverable names is identified in the identified record, A corresponding weight is given to the score of the deliverable in the record of the deliverable information file, a score is calculated based on the score given the weight, and the calculated score is recorded in the record of the deliverable information file. And a result calculation means for storing the data.

In a more preferred embodiment, the record of the deliverable information file stores the attendance number and absence number of students taking the course, and the record of the scoring table stores a weight for the attendance,
The grade calculation means assigns a weight for the attendance to information representing attendance for the subject based on the number of attendances and the number of absences, and considers information representing attendance to which the weight is given. Is calculated.

Further, in another preferred embodiment, each record further includes a pass / fail judgment table including a reference value for each course, or a series of information for calculating a reference value,
From the terminal device, information specifying a course subject is received, a record related to the course subject is identified in the acceptance / rejection determination table, the reference value is referred to in the identified record, or the standard value is calculated. A reference value is calculated based on the series of information, the result in the record of the deliverable information file is compared with the reference value, and information indicating whether or not a unit is granted based on the comparison is obtained. Unit determination means for storing in the record.

In a more preferred embodiment, the record of the acceptance / rejection determination table includes, as the series of information for calculating the reference value, at least a result range information indicating a range of a result serving as a basis for calculating the reference value, and the range. The standard selection information indicating whether the highest, average or lowest of the grades to be used as the reference value calculation is stored,
Based on the grade range information, the unit determination unit extracts a record including a grade corresponding to the grade range from the record of the deliverable information file, and from the grade included in the extracted record, A reference value is calculated based on the reference calculation information.

In a preferred embodiment, a course subject and an extraction condition of the deliverable information file are accepted from the terminal device, a record that matches the course subject and the extraction condition is extracted from the deliverable information file, and the record A list screen generating means for generating a list screen and displaying the list screen on the display device of the terminal device,
The product information file record generation unit updates the product information file based on the value input in the input field in the list screen in the terminal device, and the result calculation unit and the unit determination unit, Based on the updated deliverable information file, for each record, a score is calculated and information indicating whether or not a unit is granted is generated, and the generated score and information indicating whether or not a unit is allowed are provided. , And stored in each record of the deliverable information file.

In addition, the object of the present invention is to provide a general file storing electronic data files among actual data files for deliverables related to the subjects taken by the students, and each record is used to identify the deliverables. A product information file including a student ID number, a product name identifying the product, and its score, and each record includes the course, the product name, and the product A product information management program readable by a computer including a storage device having a correspondence table including a storage destination in a storage device of an actual data file,
In the storage device, a course data and a product name are received from an input device or a terminal device connected via a network, and a series of actual data files about the product are read from a scanner. And storing the series of image files in the storage destination in the storage device; and
Generating a record of the correspondence table including the course, the product name, and the storage destination, and storing the record in the storage device;
The product name and the image read from the scanner in the record of the product information file based on the student ID obtained by recognizing the predetermined area in the image subject and the image file This is achieved by a product information management program that executes a product information file record generation step for storing a score obtained by character recognition of another predetermined area in the file.

In a preferred embodiment, in the deliverable information file record generating step, the computer includes:
The general file stored in the storage device is read, and based on the storage destination, the product name of the general file is specified by referring to the record of the correspondence table, and included in the general file. The step of storing the product name and the score in the record of the product information file based on the course and the student ID number is executed with reference to the course subject, the student ID number, and the score.

In another preferred embodiment, the storage device further includes a scoring table in which each record stores a weight corresponding to each of the deliverable names related to the course subject,
In addition, the computer
From the terminal device, information identifying a course is received, the record relating to the course is identified in the scoring table, and the weight corresponding to each of the deliverable names is identified in the identified record, A corresponding weight is given to the score of the deliverable in the record of the deliverable information file, a score is calculated based on the score given the weight, and the calculated score is recorded in the record of the deliverable information file. The grade calculation step stored in is executed.

In a more preferred embodiment, the record of the deliverable information file stores the attendance number and absence number of students taking the course, and the record of the scoring table stores a weight for the attendance,
In the score calculation step, the computer
Based on the number of attendances and the number of absentees, a step of assigning a weight for the attendance to information representing attendance to the subject and calculating the grade in consideration of the information representing attendance given the weight Let

In another preferred embodiment, the storage device further includes a pass / fail judgment table in which each record includes a reference value for each course, or a series of information for calculating a reference value,
In addition, the computer
From the terminal device, information specifying a course subject is received, a record related to the course subject is identified in the acceptance / rejection determination table, the reference value is referred to in the identified record, or the standard value is calculated. A reference value is calculated based on the series of information, the result in the record of the deliverable information file is compared with the reference value, and information indicating whether or not a unit is granted based on the comparison is obtained. The unit determination step stored in the record is executed.

In a more preferred embodiment, the record of the acceptance / rejection determination table includes, as the series of information for calculating the reference value, at least a result range information indicating a range of a result serving as a basis for calculating the reference value, and the range. The standard selection information indicating whether the highest, average or lowest of the grades to be used as the reference value calculation is stored,
In the unit determination step, the computer
Based on the grade range information, a record including a grade corresponding to the grade range is extracted from the record of the deliverable information file, and based on the standard calculation information from the grade included in the extracted record Then, the step of calculating the reference value is executed.

In a preferred embodiment, the computer further accepts a course subject and an extraction condition of the deliverable information file from the terminal device, and matches the course subject and the extraction condition from the deliverable information file. To generate a list screen of the record, to execute a list screen generation step to be displayed on the display device of the terminal device,
Further, the computer is caused to execute the product information file record generation step based on the value input in the input field in the list screen in the terminal device, and the product information file is updated,
Causing the computer to execute the grade calculation step and the unit determination step, and based on the updated deliverable information file, calculates a grade for each record and generates information indicating whether or not unit grant is possible Then, the generated result and information indicating whether or not to grant a unit are stored in each record of the product information file.

  According to the present invention, both the paper-based test result and the test result implemented as electronic data can be stored in the storage device, and the information can be integrated and managed. In addition, since the grades and credits for each course taken are automatically calculated, faculty and staff can easily perform grade evaluation.

  That is, according to the present invention, it is possible to centrally manage paper-based products and electronic data products, thereby providing a system and program for supporting calculation of results and unit determination. Become.

  Embodiments of the present invention will be described below with reference to the accompanying drawings. FIG. 1 is a glock diagram showing a configuration of a result evaluation support system according to an embodiment of the present invention. As shown in FIG. 1, the grade evaluation support system 10 according to the present embodiment includes a support server 12, an OCR recognition server 14, a scanner 16 connected to the OCR recognition server 14, a storage device 18, and a plurality of terminal devices. , 20-n. The support server 12, the OCR recognition server 14, the storage device 18, and the terminal devices 20-1, ..., 20-n are connected by a network 22. In the following description, the term “terminal device 20” is simply used except when referring to a specific terminal device. In FIG. 1, the support server 12 functions as a deliverable information management system.

  The support server 12 includes a file generation processing unit 40, a result calculation unit 42, and a unit determination unit 44. Further, the storage device 18 stores an image file 32, a general file 34, a product information file 36, a correspondence table 38, and a unit determination information file 39. In the storage device 18, the image file 32 and the general file 34 are preferably stored in folders, for example, by year, by semester (first semester, second semester, etc.) and by department. The deliverable information file 36 is also preferably stored in folders by year, semester and department.

  In FIG. 1, the support server 12 and the OCR recognition server 14 are shown as separate bodies. However, the present invention is not limited to this, and a single server may have both functions. Further, the storage device 18 or a storage device (not shown) directly connected to each of the OCR recognition server 14 and the support server 12 performs the processing steps described with reference to the flowchart as described later. A computer program to be executed by the recognition server 14 and the support server 12 is stored.

  In the present embodiment, the OCR recognition server 14 uses the scanner 16 to output answers and reports, which are the results of paper-based students, in accordance with instructions input to the input device by operators such as faculty and staff, as will be described later. Thus, an image file including image data in a specific format (for example, TIFF format) can be generated. Further, the OCR recognition server 14 recognizes a course subject, a student ID number, a score, and the like by OCR recognizing a predetermined area of the image data. In order to recognize courses and the like, the OCR recognition server 14 stores in advance a storage device (in the storage device 18) information indicating the area where the courses, student ID number, score, etc. are printed or entered for each answer or report. Or may be another storage device (not shown) that stores necessary information in the OCR recognition server 14. Then, in accordance with the input to the input device by the operator, the information on the area to be recognized by the OCR according to the answer or report is read from the storage device, and the character in that area is recognized in the image data.

  The image data read by the scanner 16 is stored in the storage device 18 as an image file 32 under the control of the support server 12. In addition, the support server 12 generates a product information file based on information such as a course subject, a student ID number, and a score recognized by the OCR recognition server 14, and also generates a product name and a storage device 18 for the product. A correspondence table is created that associates the storage location and the like with each other.

  FIG. 2 is a flowchart showing an example of processing for generating a record of a correspondence table based on information read by a scanner and recognized by an OCR recognition server and a record generation of a product information file according to the present embodiment. In the example shown in FIG. 2, the support server 12 instructs the OCR recognition server 14 to scan the product and recognize the OCR, and the image data read by the scanner 16 and the OCR recognition server 14 recognize it. The information is transmitted to the support server 12. The file generation processing unit 40 of the support server 12 stores the image data in a storage destination (folder) as described below, and generates a record of a product information file for each product.

  For example, the operator operates the input device and inputs a year, a semester, a faculty, a subject, and a product name for a product to be captured using the scanner 16. Here, an image file format (TIFF, JPEG, etc.) may be input. As shown in FIG. 2, when the support server 12 receives the input year, semester, department, course subject, and product name (step 201), the file generation processing unit 40 reads the image data read by the scanner 16. The storage location (folder name) in the storage device 18 of the image file 32 including the file is determined (step 202). The file generation processing unit 40 generates a record of the correspondence table 38 in which the received information is associated with the storage destination of the image file, and stores it in the storage device 18 (step 203).

  FIG. 3 is a diagram illustrating an example of the data configuration of the correspondence table according to the present embodiment. As shown in FIG. 3, the record of the correspondence table 38 has items of year, semester (semester), undergraduate, course subject, deliverable name, deliverable storage folder name, and extension. If the format of the image file is input in step 201, the extension indicating the format of the data is stored in the record at the time of step 203 in the extension. In step 201, even when the format of the image file is not input, the file generation processing unit 40 can determine the format of the image file and store the extension in the correspondence table.

  The support server 12 requests the OCR recognition server 14 to read the product using the scanner 16 and to acquire information by OCR recognition of a predetermined area. The OCR recognition server 14 reads a product using the scanner 16 and acquires the image data, and recognizes a course, a student ID number, a score, and the like by performing OCR recognition on a predetermined area of the image data. The file generation processing unit 40 of the support server 12 receives the image data, creates the image file 32 from the received image data, and stores it in the storage device 18 in the storage location determined in step 202 (step 204). . If the student ID number recognized by OCR is included in the file name of each image file 32, the image file can be searched and read using the student ID number as a key.

  The file generation processing unit 40 generates a record of the deliverable information file 36 or updates the record based on the course subject and the student ID number related to the image file (step 205).

  FIG. 4 is a diagram illustrating an example of the data configuration of the product information file according to the present embodiment. As shown in FIG. 4, the record of the deliverable information file 36 includes items such as a course subject, a student ID number, the number of attendances, the number of absences, grades, and credits. Furthermore, the record of the product information file 36 has items of product name and score for each product. As can be understood from FIG. 4, the record of the deliverable information file 36 can identify the deliverable related to a certain course of study by a student having a certain student ID number. In FIG. 4, the score is a score recognized by the processing of the OCR recognition server 14, and the grade is the final grade of the subject subject based on the score and the number of attendances. The score and result may be a numerical value, or may be a character or a character string (eg, A, B, C).

  The file generation processing unit 40 searches the record of the deliverable information file 36 using the course and student ID number transmitted from the OCR recognition server 14 as keys, and if the record including the key cannot be found, Generate a record that includes the subject and the student ID number. In this record, the product name and score received in step 201 are stored. When the record is found, the file generation processing unit 40 updates the record so as to add the product name and score items.

  The storage of the image file in a predetermined storage location in the storage device 18 (step 204) and the generation / update of the record of the product information file (step 205) are performed for all the image files and the information recognized by OCR from the image data. It is executed (see step 206).

  In addition, the operator can confirm the content by displaying the display screen including the record information of the product information file on the display device (not displayed) of the support server 12. If the record information in the product information file includes an error in a number or character string recognized by OCR, the operator may operate the input device to correct the error.

  In the example of FIG. 2, the operator inputs the department, the subject, and the product name. However, the present invention is not limited to this, and the undergraduate, the subject, and the result are added to the paper-based student product in advance. Symbols and characters that can be used to determine an object name are described, and the OCR recognition server 14 may recognize these symbols and characters, and based on these, the support server 12 may generate a correspondence table.

  For paper-based deliverables, the OCR recognition server 14 and the support server 12 execute the above-described processing, whereby the records of the deliverable information file 36 and the records of the correspondence table 38 can be generated. Next, processing executed for a product made up of electronic data such as a test on the WWW will be described below.

  For electronic data including answers to exams conducted on the WWW, the operator operates the input device to store the year, semester, department, subject, product name, and the electronic data as a general file 34. The storage destination (folder name) and the format of the electronic data are given to the file generation processing unit 40 of the support server 12. Upon receipt of the input, the file generation processing unit 40 generates a record of the correspondence table 38 in which the year, semester, undergraduate, course subject, product name, storage location (folder name), and extension are associated with each other, and the storage device 18. To store. Therefore, electronic data including the course subjects, student ID numbers, and scores, as well as the answers to the tests conducted on the WWW, are stored in the storage device 18 as the general file 34. Further, when storing the general file 34 in the storage device 18, if the support server 12 stores the file name including the student ID number, the general file 34 can be searched and read using the student ID number as a key. It becomes.

  FIG. 5 is a flowchart illustrating an example of processing for generating a record of a product information file based on electronic data.

  As shown in FIG. 5, the file generation processing unit 40 reads the general file 34 (step 501), and acquires a course subject, a student ID number, and a score included in the general file (step 502). The product name can be specified by referring to the correspondence table 38 based on the storage location of the general file 34.

  The file generation processing unit 40 generates a record of the deliverable information file 36 or updates the record based on the course number and the student ID number acquired in step 502 (step 503).

  As in step 205 in FIG. 2, the file generation processing unit 40 searches the record of the deliverable information file 36 using the acquired course and student ID as a key, and if it cannot find a record including the key, A new record including the subject and the student ID number is generated. In this record, the product name and the score are stored. When the record is found, the file generation processing unit 40 updates the record so as to add the product name and score items.

  Reading of the general file 34 (step 501), acquisition of a course subject, student ID number and score (step 502), and generation / update of a record of the product information file 36 (step 403) are executed for all the general files 34. (See step 504).

  Thus, according to the present embodiment, the image file 32 obtained by reading the paper-based product using the scanner and the electronic data that is the product of the test performed on the WWW are included. The general file 34 is stored in the storage device 18, and both of them are managed by a correspondence table 38 that associates each product name, the storage location in the storage device 18, and the file format (extension). . Also, in the product information file 36, each product name and score can be managed in a form in which the image file 32 and the general file 34 are mixed for each course and student number.

  Therefore, the support server 12 refers to the record of the product information file 36 and the correspondence table 38 according to the instruction of the operator who operates the input device of the terminal device 20, and stores the image file 32 and the general file 34 from the storage device 18. The contents of these files can be read and displayed on the display device of the terminal device 20. Thereby, the operator can refer to both the product in the form of the image file 32 and the product in the form of the general file 34.

  In this way, by managing both image files based on paper-based deliverables and general files based on electronic data, the results are calculated with reference to both, as shown below. It becomes possible to make a judgment of certification.

  FIG. 6 is a flowchart showing an example of processing executed by the result calculation unit of the support server according to the present embodiment regarding the result calculation processing executed in the support server 12. An operator operates an input device (not shown) of the terminal device 20 to designate and input one or more courses. The designation input by the operator is transmitted to the support server 12 via the network 22.

  As shown in FIG. 6, when the support server 12 accepts a course subject input to the terminal device 20 (step 601), the grade calculation unit 42 stores a scoring table stored in the storage device 18 (in FIG. 1, FIG. 6). Referring to (not shown), a record related to the accepted course is specified, and a calculation formula for calculating the grade is obtained based on the value in the record (step 602). FIG. 7 is a diagram showing an example of the data structure of the scoring table according to the present embodiment. As shown in FIG. 7, the record in the scoring table includes items of a course subject, attendance weight, and a product name and a weight for each product. In the present embodiment, the following calculation formula is used.

Grade = Σ (product score x weight of the product) +
((Number of attendance-number of absences) x weight of attendance)
Information on this calculation formula is stored in advance in the storage device 18 or the like, and the score calculation unit 42 reads the information and obtains a calculation formula for calculating the score using the weight in the record of the scoring table as a parameter. For example, the score calculation formula for the first record (see reference numeral 701) in FIG. 7 is acquired by the score calculation unit 42 as follows.

(Score of report a × 0.2) + (score of test b × 0.3) +.
+ (Number of attendance-number of absences) x 1
Next, the grade calculation unit 42 reads a record related to the accepted course from the deliverable information file 36 (step 603). The grade calculation unit 42 calculates values by applying values such as the number of attendances, absences, and scores for each deliverable in the read record to the above-described calculation formula, and using the obtained values as grades. In the record of the deliverable information file 36, it is stored in the item of grade (step 604). When the score in the record is a character (A, B, C, etc.), a conversion table (for example, A: 90 points, B :) of characters and points stored in the storage device 18 in advance. With reference to 75 points, correspondences such as C: 60 points (not shown), characters are converted into numerical values and then the values may be calculated.

  If there is another record of the same course in the deliverable information file 36 (Yes in Step 605), Steps 603 and 604 are repeated to obtain the grade for each student in the course, The result is stored in the record of the product information file 36. If there is a course that has not been processed among accepted courses (Yes in Step 606), the process returns to Step 602.

  Thus, after the grade of the student who has taken the subject is calculated for the desired subject, the support server 12 can execute the unit determination process by the operation of the operator.

  FIG. 8 is a flowchart illustrating an example of processing executed by the unit determination unit of the support server according to the present embodiment. An operator who wants to make a credit determination operates an input device (not shown) of the terminal device 20 to designate and input a course subject. The designation input by the operator is transmitted to the support server 12 via the network 22.

  As shown in FIG. 8, when the support server 12 accepts a course subject input to the terminal device 20 (step 801), the unit determination unit 44 searches the deliverable information file 36 and receives the accepted course subject. Then, a record in which the courses in the record coincide with each other is read, and a unit determination information file 39 including the student ID number and grade items in the read record is generated in the storage device 18 (step 802).

  FIG. 9 is a diagram illustrating an example of the data configuration of the unit determination information file according to the present embodiment. As shown in FIG. 9, the record of the unit determination information file 39 has items of student ID number, grade, target information, and pass / fail information. In the target information column, as will be described later, information indicating whether or not the record is to be a reference value calculation target is stored. The pass / fail information column stores the result of unit determination, that is, information indicating whether or not the unit can be acquired. Initially, in the record of the unit determination information file 39, the values of the student ID number and the grade item in the record of the deliverable information file 36 are stored in the item of the student ID number and the grade, and the target information and pass / fail information include An invalid value is stored.

  Next, the unit determination unit 44 acquires a record related to the accepted course from a pass / fail determination table (not shown in FIG. 1) stored in advance in the storage device 18 (step 803). FIG. 10 is a diagram illustrating an example of a data configuration of the pass / fail determination table according to the present embodiment. As shown in FIG. 10, the record of the acceptance / rejection determination table includes items of a course subject, a score, an upper exclusion, a lower exclusion, reference selection information, and an adjustment rate. When a value is stored in the score item, the score is a reference value, as will be described later, and therefore, it is not necessary to store a value after the top exclusion item. On the other hand, if no value is stored in the score item or an invalid value is stored, at least the reference selection information that is either high / average / low information and the adjustment rate item The value of is stored.

  The unit determination unit 44 refers to the acquired record of the pass / fail determination table and determines whether or not a value is stored in the item of score (step 804). If it is determined as Yes in step 804, the score is used as a reference value (step 805), and it is determined whether or not credits are acquired for each of the students. This reference value is stored in the storage device 18 or the storage device (not shown) of the support server 12 itself.

  On the other hand, if no value is stored in the score item or the value is an invalid value (No in step 804), the unit determination unit 44 sorts the records of the unit determination information file 39 in the order of results. To do. Further, the unit determination unit 44 refers to the items of upper exclusion and / or lower exclusion in the records of the pass / fail determination table, and sets the value “N” in the target column of the records in the range indicated by the unit determination information file 39. Store (step 806).

  More specifically, if the value “U” is stored in the upper exclusion field in the record of the pass / fail determination table, the unit determination unit 44 determines that the higher order in the grade order in the records of the sorted unit determination information file 39. The value “N” is stored in the target column of each record until the ratio indicated by the value “U” is reached in order. If the value “L” is stored in the lower exclusion column, the unit determination unit 44 sets the ratio indicated by the value “L” in order from the lower order of the grade order in the records of the sorted unit determination information file 39. Until the value is reached, the value “N” is stored in the target column of each record. The storage of the value “N” means that the record is excluded from the reference value calculation target. In FIG. 10, in the first record (see reference numeral 1001), the value “0.8” is stored in the lower exclusion column. Therefore, the value “N” is stored in each target column of the record from the lowest to 80%. In the next record (see reference numeral 1002), the value “0.1” is stored in each of the upper target column and the lower target column. Therefore, the value “N” is stored in each target column of the records from the top to 10%, and the value “N” is also stored in each target column of the records from the bottom to 10%.

  Next, the unit determination unit 44 refers to the value of the reference selection item in the record of the pass / fail determination table, and calculates the reference value according to the value (step 807). For example, if the value of the criterion selection item is “high”, the unit determination unit 44 sets the value of the grade item among the records in which the value “N” is not stored in the target column in the unit determination information file 39. Is determined, and the value obtained by multiplying the value of the result item by the adjustment rate included in the record of the pass / fail judgment table is used as the reference value. If the value of the criterion selection item is “low”, the unit determination unit 44 sets the value of the grade item among the records in which the value “N” is not stored in the target column in the unit determination information file 39. Is specified, and the value obtained by multiplying the value of the item of the result by the adjustment rate included in the record of the pass / fail determination table is used as a reference value.

  On the other hand, if the value of the criterion selection item is “average”, the unit determination unit 44 determines the value of the grade item for the record in which the value “N” is not stored in the target field in the unit determination information file 39. An average value is obtained, and a value obtained by multiplying the obtained average value by the adjustment rate is used as a reference value. The calculated reference value is stored in the storage device 18 or the storage device (not shown) of the support server 12 itself.

  In FIG. 10, for example, for the first record (reference numeral 1001), the unit determination unit 44 obtains the average value of results for records in which the value “N” is not stored in the target field in the unit determination information file 39. The calculated average value is multiplied by the adjustment rate “0.65”, and the obtained result is stored as a reference value.

  Next, for each record of the unit determination information file 39, the unit determination unit 44 compares the value of the grade item with the reference value, and if “grade ≧ reference value”, the pass / fail information is included in the record. A value indicating acceptance is stored in the item (step 808). Thereafter, the unit determination unit 44 updates the record of the product information file 36 based on the content of the unit determination information file 39. More specifically, the unit determination unit 44 uses the value of the pass / fail information item in the record of the unit determination information file as the unit value of the record specified by the corresponding course and student number in the deliverable information file 36. (Step 809). Thereby, the product information file 36 can store information indicating whether or not a student of each student number can obtain a credit for a certain course.

  After the unit determination process described above, the support server 12 refers to the deliverable information file 36 in response to a specification (for example, a course, or a course and a student ID number) input to the terminal device 20 by the operator. The record according to the designation can be read, and a screen including the result and whether or not the unit can be acquired can be displayed on the display device of the terminal device 20. The operator can refer to the grade for each course number and whether or not credits can be obtained.

  The display of the screen including the results and unit acquisition on the display device of the terminal device 20 and the processing associated with the results evaluation by the operator will be described in detail below. FIG. 11 is a flowchart illustrating an example of processing executed in the support server during screen display and grade evaluation.

  The operator operates the input device of the terminal device 20 to input a list display request. When the support server 12 accepts the list display request, in response to this, the search condition designation screen is displayed on the display device of the terminal device 20 (step 1101). FIG. 12 is a diagram illustrating an example of a search condition designation screen displayed on the display device of the terminal device. As shown in FIG. 12, in the search condition designation screen, various extraction conditions can be designated in addition to the course subjects. In the example shown in FIG. 12, all the records for the above courses can be specified (all) as an extraction condition, and whether or not credits can be acquired (pass / fail) is specified, or the grade is specified You can also As for the grade, it is possible to designate a certain score or less, or a certain score or more, and it is also possible to designate a certain range by inputting two scores.

  When the support server 12 receives the course subject and the search condition (step 1102), the support server 12 searches the deliverable information file 36 in the storage device 18 to identify a group of records with the same course subject value (step 1103). Next, the support server 12 extracts a record that matches the value of the item indicated by the extraction condition from the group of records specified in step 1103, and records the search result file that includes the value of the predetermined item of the record. Is generated and stored in the storage device 18 (step 1104).

  For example, if the unit is “combined” in the extraction condition, a record in the product information file 36 in which the unit item has a value indicating pass or unit acquisition is extracted. If a predetermined value is set for the grade, a record in the deliverable information file 36 in which the value of the grade item matches the set value or range is extracted. The record of the search result file basically includes items similar to the record of the deliverable information file. In the present embodiment, the record of the search result file includes items such as student ID number, unit, grade, number of attendance, number of absentees, and score for each deliverable.

  The support server 12 generates a list display screen based on the search result file, and displays the generated list display screen on the display device of the terminal device 20 via the network (step 1105). FIG. 13 is a diagram illustrating an example of a list display screen displayed on the display device of the terminal device. As shown in FIG. 13, for courses designated on the search condition designation screen, records that match the extraction conditions are displayed. The operator can specify the sort order as any of the student ID number order, the descending order of the grades, or the ascending order of the grades. The support server 12 generates a list display screen in which the records are sorted according to the specified sort order.

  Further, in the present embodiment, the operator can operate the input device of the terminal device 20 to correct the number of attendances, the number of absent seats, the score for the deliverable, etc. among the items displayed on the list display screen. it can. Although not shown, it is also possible to call a scoring table (see FIG. 7) or a pass / fail judgment table (see FIG. 10) and change the contents thereof.

  After such correction, when the operator turns on the “save / recalculate” button (Yes in step 1106), the support server 12 receives the information (value of the corrected item) input in the input field of the list display screen. ) And corrects the product information file 36 according to the received information (step 1107). Next, the support server 12 executes a result calculation process (see FIG. 6) and a unit determination process (see FIG. 8) (step 1108). This is because there is a possibility that the grade and the unit acquisition possibility may be changed in accordance with the correction of the product information file 36 or the correction of the scoring table or the pass / fail judgment table.

  Therefore, when step 1108 is executed, the support server 12 newly receives a search condition, performs a series of processes, generates a list display screen again, and displays it on the display device of the terminal device 20 ( Step 1102 to Step 1105). Alternatively, a search result file may be generated under the same search condition, and a list display screen may be displayed on the display device of the terminal device 20 (see steps 1104 to 1105).

  As described above, according to the present embodiment, the operator confirms the results calculated and determined by the support server 12 and the possibility of unit acquisition, and if necessary, the product information file, the scoring table, and / or pass / fail. It is possible to correct the determination table and redo the calculation of the grade and the unit determination. The calculation of the results and the unit determination do not require complicated procedures as described above.

  According to the present embodiment, for both an image file based on a paper-based product and a general file based on electronic data, the product name and score are centrally managed in the product information file. Based on the score, the grade can be calculated. In addition, based on the grade of each student, it is possible to determine whether or not the student can earn credits. In other words, according to the present embodiment, even when results of a paper-based test or tests performed as electronic data, for example, results of a test on the WWW are mixed, the product information is used. The score is centrally managed, and as a result, it is possible to automatically calculate the grade and determine whether or not to acquire the unit.

  The present invention is not limited to the above-described embodiment, and various modifications are possible within the scope of the invention described in the claims, and these are also included in the scope of the present invention. Needless to say.

  For example, in the above embodiment, the answer or report of the student is used as a product, but the present invention is not limited to this.

FIG. 1 is a glock diagram showing a configuration of a result evaluation support system according to an embodiment of the present invention. FIG. 2 is a flowchart showing an example of processing for generating a record of a correspondence table based on information read by a scanner and recognized by an OCR recognition server and a record generation of a product information file according to the present embodiment. FIG. 3 is a diagram illustrating an example of the data configuration of the correspondence table according to the present embodiment. FIG. 4 is a diagram illustrating an example of the data configuration of the product information file according to the present embodiment. FIG. 5 is a flowchart illustrating an example of processing for generating a record of a product information file based on electronic data. FIG. 6 is a flowchart illustrating an example of processing executed by the result calculation unit of the support server according to the present embodiment. FIG. 7 is a diagram showing an example of the data structure of the scoring table according to the present embodiment. FIG. 8 is a flowchart illustrating an example of processing executed by the unit determination unit of the support server according to the present embodiment. FIG. 9 is a diagram illustrating an example of the data configuration of the unit determination information file according to the present embodiment. FIG. 10 is a diagram illustrating an example of a data configuration of the pass / fail determination table according to the present embodiment. FIG. 11 is a flowchart illustrating an example of processing executed in the support server during screen display and grade evaluation. FIG. 12 is a diagram showing an example of a search condition designation screen displayed on the display device of the terminal device in the present embodiment. FIG. 13 is a diagram illustrating an example of a list display screen displayed on the display device of the terminal device in the present embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Grade evaluation support system 12 Support server 14 OCR recognition server 16 Scanner 18 Storage device 20 Terminal device 22 Network 32 Image file 34 General file 36 Product information file 38 Correspondence table 39 Unit determination information file 40 File generation processing unit 42 Grade calculation unit 42 44 Unit determination unit

Claims (8)

A general file storing electronic data files among actual data files related to the deliverables related to the subjects taken by the students, each record identifying the deliverable, the student ID number, and the deliverables for identifying the deliverable Product information file including the name of the product and its score, the number of attendances and absences of the students , and the respective records for the course, the product name, and the product A storage device having a correspondence table including a storage destination in the storage device of the actual data file;
A course subject and a product name are received from an input device or a terminal device connected via a network, and among a series of actual data files about the product, a series of image files read from a scanner in the storage device A storage location is determined based on the subject, the product name, and the image file storage means for storing the series of image files in the storage location in the storage device;
A correspondence table record generating means for generating a record of the correspondence table including the course, the product name, and the storage destination, and storing the record in the storage device;
Read from the scanner the product name and the product name into the record of the product information file based on the student ID number obtained by character recognition of a predetermined area in the image file by OCR recognition Product information file record generation means for storing a score obtained by character recognition of another predetermined area in the image file,
A scoring table in which each record stores a weight corresponding to each of the deliverable names and a weight for attendance with respect to the subject ,
From the terminal device, information identifying a course is received, the record relating to the course is identified in the scoring table, and the weight corresponding to each of the deliverable names is identified in the identified record, A corresponding weight is given to the score of the deliverable in the record of the deliverable information file, a score is calculated based on the score given the weight, and the calculated score is recorded in the record of the deliverable information file. A grade calculation means for storing information on attendance stored in the scoring table is given to information representing attendance for the course based on the number of attendances and the number of absences, and the weights are given. A score calculation means configured to calculate the score in consideration of information representing attendance;
Each record is a pass / fail judgment table including a reference value for each subject, or a series of information for calculating a reference value,
From the terminal device, information specifying a course subject is received, a record related to the course subject is identified in the acceptance / rejection determination table, the reference value is referred to in the identified record, or the standard value is calculated. A reference value is calculated based on the series of information, the result in the record of the deliverable information file is compared with the reference value, and information indicating whether or not a unit is granted based on the comparison is obtained. A product information management system comprising: unit determination means for storing in the record .   The product information file record generation unit reads the general file stored in the storage device, and identifies the product name of the general file by referring to the record of the correspondence table based on the storage destination In addition, with reference to the course, student ID number, and score included in the general file, the deliverable information file record based on the course and student ID number, the deliverable name, and the The product information management system according to claim 1, wherein the product information management system is configured to store a score. As a series of information for calculating the reference value, the record of the pass / fail determination table is at least a grade range information indicating a grade range that is a basis for calculating the reference value, and the highest of the grades included in the range, Storing reference selection information indicating which one of average or minimum is used as reference value calculation,
Based on the grade range information, the unit determination unit extracts a record including a grade corresponding to the grade range from the record of the deliverable information file, and from the grade included in the extracted record, The deliverable information management system according to claim 1, wherein a reference value is calculated based on the reference calculation information. Accepting course subjects and extraction conditions of the deliverable information file from the terminal device, extracting records that match the course subjects and the extraction conditions from the deliverable information file, and generating a list screen of the records A list screen generating means for displaying on the display device of the terminal device,
The product information file record generation unit updates the product information file based on the value input in the input field in the list screen in the terminal device, and the result calculation unit and the unit determination unit, Based on the updated deliverable information file, for each record, a score is calculated and information indicating whether or not a unit is granted is generated, and the generated score and information indicating whether or not a unit is allowed are provided. 4. The deliverable information management system according to claim 3, wherein the deliverable information file is stored in each record of the deliverable information file. A general file storing electronic data files among actual data files related to the deliverables related to the subjects taken by the students, each record identifying the deliverable, the student ID number, and the deliverables for identifying the deliverable The product information file including the product name and its score, the number of attendances and absences of the students taking the course, and each record includes the subject, the product name, and the actual result of the product. Correspondence table including storage location in storage device of data file, scoring table in which each record stores a weight corresponding to each of the deliverable names and a weight for attendance relating to the subject, and each record Is a reference value for each subject, or a series of information for calculating reference values. Is readable by a computer having a storage device having a determination table, a product information management program, the computer,
A course subject and a product name are received from an input device or a terminal device connected via a network, and among a series of actual data files about the product, a series of image files read from a scanner in the storage device An image file storage step of determining a storage destination based on the subject, the product name, and storing the series of image files in the storage destination in the storage device;
Generating a record of the correspondence table including the course, the product name, and the storage destination, and storing the record in the storage device;
Read from the scanner the product name and the product name into the record of the product information file based on the student ID number obtained by character recognition of a predetermined area in the image file by OCR recognition A product information file record generation step for storing a score obtained by character recognition of another predetermined area in the image file,
From the terminal device, information identifying a course is received, the record relating to the course is identified in the scoring table, and the weight corresponding to each of the deliverable names is identified in the identified record, A corresponding weight is given to the score of the deliverable in the record of the deliverable information file, a score is calculated based on the score given the weight, and the calculated score is recorded in the record of the deliverable information file. The grade calculation step stored in the information, wherein the weight representing the attendance stored in the scoring table is given to the information representing attendance for the subject based on the number of attendances and the number of absences, and the weight is given A score calculation step configured to calculate the score in consideration of information representing attendance;
From the terminal device, information specifying a course subject is received, a record related to the course subject is identified in the acceptance / rejection determination table, the reference value is referred to in the identified record, or the standard value is calculated. A reference value is calculated based on the series of information, the result in the record of the deliverable information file is compared with the reference value, and information indicating whether or not a unit is granted based on the comparison is obtained. A product information management program that executes a unit determination step stored in the record . In the product information file record generation step, the computer
The general file stored in the storage device is read, and based on the storage destination, the product name of the general file is specified by referring to the record of the correspondence table, and included in the general file. The step of storing the product name and the score in the record of the product information file based on the course and the student ID number with reference to the course subject, the student ID number, and the score is executed. The program according to claim 5, wherein the program is characterized by: As a series of information for calculating the reference value, the record of the pass / fail determination table is at least a grade range information indicating a grade range that is a basis for calculating the reference value, and the highest of the grades included in the range, Storing reference selection information indicating which one of average or minimum is used as reference value calculation,
In the unit determination step, the computer
Based on the grade range information, a record including a grade corresponding to the grade range is extracted from the record of the deliverable information file, and based on the standard calculation information from the grade included in the extracted record The program according to claim 5 or 6, wherein a step of calculating a reference value is executed. Further, the computer accepts a course subject and an extraction condition of the deliverable information file from the terminal device, and extracts a record that matches the course subject and the extraction condition from the deliverable information file. Generating a list screen, causing a list screen generation step to be displayed on the display device of the terminal device,
Further, the computer is caused to execute the product information file record generation step based on the value input in the input field in the list screen in the terminal device, and the product information file is updated,
Causing the computer to execute the grade calculation step and the unit determination step, and based on the updated deliverable information file, calculates a grade for each record and generates information indicating whether or not unit grant is possible The program according to claim 7, wherein the generated result and information indicating whether or not to grant a unit are stored in each record of the product information file.

Images