JP2010079859A - Questionnaire management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a questionnaire management system capable of increasing a questionnaire collection rate while maintaining the secrecy of questionnaire respondents and the answer contents of the questionnaire respondents. <P>SOLUTION: The questionnaire management system includes: a name database for encrypting and storing the names of all questionnaire target persons and personal particular data of a contact address or the like; an answer database for storing answer groups composed of questionnaire answer data to one question or more in each answer group; and a means for extracting the name of a respondent of answer results of the questionnaire with the name written therein collected by using a network, checking whether the personal particular data corresponding to the name of the respondent is previously registered in the name database, and performing processing when registered, which additionally stores identification information on the existence of a questionnaire answer and additionally stores questionnaire answer data in a record of the answer database corresponding to the personal particular data. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a questionnaire management system for increasing the collection rate of registered questionnaires on the Web.

Traditionally, in-house questionnaires that use paper media, etc., all employees are often designated as survey subjects. When conducting a questionnaire, it is necessary to request the entry of individual names in the questionnaire. Thus, if the collected questionnaire is matched with the submitted questionnaire using the employee list, the questionnaire collection result to be collected becomes clear, and the questionnaire collection rate is inevitably high.
In addition, by placing a list to check that the questionnaire has been conducted in front of the box for collecting the questionnaire, the surveyed person can prove that the questionnaire has been conducted by checking the list, and the accuracy of the questionnaire results It becomes possible to come out with a better guideline by becoming higher.

  However, in the conventional questionnaire method using paper media, collection conditions such as collection places are limited or collection time zones are often generated, so if certain timing is not met, Frequently, insufficient recovery occurs. As a result, it has often been found that the questionnaire collection rate has deteriorated and sufficient questionnaire results cannot be obtained.

  On the other hand, when conducting a survey using the Web, in order to maintain the confidentiality of the relationship between the survey respondent and the content of the survey, it is not possible to know who the survey unanswered and I can't remind you. For example, when all the questionnaire subjects are prompted to answer a questionnaire, those who have not answered the questionnaire may still not answer. Therefore, the questionnaire collection rate does not increase even when the questionnaire response is prompted.

As one method for increasing the questionnaire collection rate, there is a method of adding some added value, such as providing a point service to the questionnaire respondents. However, there is a problem that it is not always possible to give added value to the respondents of the questionnaire depending on the purpose of the questionnaire and the organizer like an in-house questionnaire.
In addition, there exists the following patent document 1 as a well-known technical document relevant to this invention.

JP-A-11-252257

Even in the case of registered questionnaires, it is necessary to maintain the confidentiality of the relationship between the respondents of the questionnaire and the contents of the responses. Furthermore, in the case of a WEB questionnaire, it is necessary to prevent the same person from answering the questionnaire a plurality of times or to invalidate the questionnaire itself that has been answered a plurality of times.
It is very difficult to obtain questionnaire responses from all survey subjects. As a cause of this, in order to maintain the confidentiality of the relationship between the questionnaire respondents and the contents of the responses, it is not possible to know who is not responding to the questionnaire and cannot prompt the questionnaire respondent to answer the questionnaire. Even if the person who has not answered the questionnaire is known and only the person who has not answered the questionnaire is prompted to answer the questionnaire, the person who has not answered the questionnaire may still not answer.

  The objective of this invention is providing the questionnaire management system which can make a questionnaire collection rate high, maintaining the confidentiality of a questionnaire respondent and the reply content.

In order to achieve the above object, the questionnaire management system of the present invention is a questionnaire management system for conducting a questionnaire using a network,
Encrypted personal identification data such as the name and contact information of all surveyed persons, an answer database that stores a group of answers consisting of questionnaire answer data for one or more questions, and a network The name of the respondent of the recorded questionnaire response result collected using the name is extracted, and it is confirmed whether the personal identification data corresponding to the name of the respondent is registered in the name database in advance. It is characterized by comprising means for additionally storing identification information with a questionnaire response and additionally storing questionnaire response data in a record of the response database corresponding to the personal identification data.
The name database may further include means for prompting an answer based on contact data registered in the personal identification data for a questionnaire target person who does not store identification information with a questionnaire answer.

The questionnaire management system of the present invention has the following effects.
The name of the respondent of the registered questionnaire responses collected using the network is extracted, and it is confirmed whether the personal identification data corresponding to the name of the respondent is registered in the name database in advance. A process of additionally storing the identification information with the questionnaire response and additionally storing the questionnaire response data in the record of the response database corresponding to the personal identification data.
As a result, at the stage of answering the questionnaire, the information on the questionnaire respondent and the content of the answer are integrated, but at the stage of registration in the answer database, the personal identification information of the questionnaire respondent and the answer result of the questionnaire are separated. As a result, it is possible to confirm who answered the questionnaire itself, and furthermore, the contents of the questionnaire response itself are separated from the information of the individual who answered the questionnaire, so that the confidentiality of the relevance of the information can be maintained.
For respondents who answered the questionnaire, identification information (flag) with a response is additionally stored, so this identification information (flag) can be easily extracted as an unregistered target person, and personal identification data It is possible to increase the questionnaire collection rate by prompting the reply to the e-mail address of the contact address registered in.

Hereinafter, an embodiment of a questionnaire management system to which the present invention is applied will be described.
FIG. 1 is a system configuration diagram showing an embodiment of the present invention.
The present invention is premised on a system for conducting a questionnaire on a network connected by a plurality of computers and servers, not a questionnaire system using paper media.
As is clear from FIG. 1, this questionnaire management system is composed of a host system 3 having a name database 7 and an answer database 8, and is connected to the network 2. Further, a plurality of terminals 1 for answering and transmitting questionnaires are connected to the network 2.

The questionnaire response result transmitted from the terminal 1 is sent to the host system 3 via the network 2. The host system 3 includes a database update unit 4 that processes the sent questionnaire response results, a search processing unit 5 that searches the name database 7, and a mail distribution unit 6 that prompts survey respondents for those who have not responded to the survey. It has.
In addition to updating the data, the data updating unit 4 separates the personal data such as the name of the questionnaire respondent and the data of the questionnaire content itself from the information read result of the questionnaire data, and converts the data into the separated personal information. Processing such as encryption / decryption is performed.
In addition, data processing when data is stored in the databases 7 and 8 is also performed by this processing unit.
The name database 7 stores personal information that has been answered to the questionnaire, and data such as names that will be sent the questionnaire.
The answer database 8 organizes the results of the questionnaire for each type of the questionnaire and stores the answer results.

In the present embodiment, the name of the respondent of the recorded questionnaire response result collected using the network 2 is extracted, and it is confirmed whether the personal identification data corresponding to the name of the respondent is registered in the name database 7 in advance. If it is, the host system 3 performs a process of additionally storing the identification information (flag) with the questionnaire response and additionally storing the questionnaire response data in the record of the response database 8 corresponding to the personal identification data.
In addition, the mail distribution unit 6 of the host system 3 performs a process of prompting the questionnaire target person who does not store the identification information with the questionnaire response in the name database 7 based on the contact data registered in the personal identification data. Do.

FIG. 2A shows the data structure of the name database 7.
The name database 7 is composed of the following items.
Item number 21 contains the serial number of the data item, but it may be taken from the beginning every time the database is new.
For item number 22, a name is entered. For item number 23, a name is input. The item numbers 22 and 23 may be one. The item number 24 can be arbitrarily changed to enter a mail address, a mobile phone address or an E-mail address, and a plurality of addresses can be inputted.
Item number 25 is the gender input. This is one of the conditions for whether or not the respondent is unique. If each data item is unique, it may be unanswered.
In the name database 7, in order to reduce individual duplication and to be able to specify a specific individual, make the conditions as unique as possible. Other conditions include data such as name numbers, addresses, and telephone numbers. May be entered. Data items can be arbitrarily specified in each questionnaire.

FIG. 2B is a diagram showing the data structure of the answer database 8.
Since the respondent database 8 is linked to the name database 7, the ID of the name database 7 is embedded in the answer database so that the item number is always the same ID in the name database 7 and the answer database 8.
The role of the answer database 8 is roughly divided into two.
An answer presence / absence flag 26 for confirming whether or not the questionnaire has been answered, a descriptive answer mandatory flag 27 specified in the questionnaire, and an answer content 28 as its contents are configured.
The content 28 of the answer can be arbitrarily changed in the number of items and the item attribute according to the content of the questionnaire. Specific contents will be described later.

FIG. 3 is an explanatory diagram showing the relationship between the questionnaire and the name database 7 and the answer database 8.
The questionnaire data input from the terminal 1 is read, the data portion of the personal information of the questionnaire data read by the database update unit 4 is separated from the questionnaire portion, and stored in the respective databases to be stored.
The questionnaire data may be separated by adding personal information attributes and questionnaire information attributes, or may be separated according to the questionnaire form entry location, position, frame position, frame position, etc. Absent.
The name data 301 (FIG. 2 (a) 22, 23) is encrypted by the encryption processing 304 of the database update unit 4 and is compared with the encrypted data in the name database 7. Then, for the data that matches the collation result, the answer flag 26 of the questionnaire in FIG. 2 is updated to “1”. The meaning of this update means that the questionnaire has already been answered. The questionnaire that has been answered is stored in the answer database 8 as data 302 of the questionnaire answer group 1 and data 303 of the answer group 2.

FIG. 4 is a diagram showing a questionnaire creation flowchart in the case where the questionnaire side constructs a questionnaire.
When creating a questionnaire tailored to each application, it is first determined whether the name is registered or unsigned (step 401). When generating an anonymous survey, only the collected questionnaire response results are confirmed (step 402), and subsequent confirmation of personal data is unnecessary, so there is no need to generate a questionnaire form for unanswered followers Judgment is made (step 403) and the generation of the questionnaire form is terminated (step 404).
If it is determined in step 401 that the name data needs to be entered, it is confirmed whether or not all the members need to submit a questionnaire (step 405). If necessary, an additional questionnaire for follow-up is provided. The form is generated (step 406).
The addition of attribute information to each questionnaire item will be described later.

5 and 6 are diagrams showing a questionnaire template.
The template 501 requires input of first and last names and e-mail addresses, and other than that, it is a selection type including a questionnaire. An area surrounded by a frame line 502 is a part that requires individual description input as an input part of personal information.
The template 601 requires input of first and last names and e-mail addresses, and the others are selectable including a questionnaire. An area surrounded by a frame line 602 is a part that requires individual description input as an input part of personal information. An input area 603 is an input portion that requires individual descriptions in the questionnaire portion.
Attributes of attribute data described later are designated in advance in each description input area.

7 and 8 are diagrams showing the answer results to the questionnaires in the format of FIGS.
FIG. 9 is a diagram showing an example in which attributes are set in an input area for a descriptive questionnaire.
A name attribute 1 is set in the frame 901, a name attribute 2 is set in the frame 902, and a mail address attribute is set in the frame 903. Text attributes that can be input are specified in the questionnaire description area.
In the frame 904, the full-width, half-width, kanji, hiragana, alphanumeric, and katakana attributes of the text attribute 1 are set. In the frame 905, the half-width, hiragana, and katakana attributes of the text attribute 2 are set. In the frame 906, single-byte alphanumeric characters are set in the text attribute 3.
The determination process for these attributes will be described with reference to FIG.

FIG. 10 is a flowchart showing a process for separating name information and questionnaire response information from a questionnaire response result.
The information described here is divided into name attribute, address attribute, telephone attribute, and address attribute as input information. Based on these attributes, name information and questionnaire information are separated.
When determining the name attribute (step 1001), it is decomposed into words and words by morphological analysis, and a dictionary database such as each word, word and name database is referenced to determine whether the name is a name. This is constituted by well-known and well-known techniques.
If it is not determined as a name, the questionnaire is processed as invalid as an unrecognizable error (step 1007).
Next, when determining the address attribute (step 1002), as the first check, the inputted sentence includes any of “city”, “road”, “prefecture” and “prefecture” with the prefecture. Then, in the second check, it is checked that any of the “city”, “city”, “town”, and “village” of the city is included.
In these two checks, if “Yes” is determined in any of the first, second, and second checks, it is determined that the information input there is an address.

If it is determined in step 1002 that the address is an address, the process proceeds to step 1004 beyond the process in step 1003. If the result of “Yes” is 0 or 1 in the process of step 1002, the process proceeds to the third check process of the address attribute in step 1003.
As a third check, it is checked whether or not a specific term used in an address such as “Ding”, “Address”, “No.”, “Apartment”, “Apartment”, “Terrace” is included. In the third check, it is checked whether the analyzed sentence includes two or more of the terms in the order of the terms.
Even if only the third check is valid, it is determined that the information input there is an address.
Even if it is determined that the processing in step 1003 is not an address, whether or not it is important to enter an address in the item of the questionnaire varies depending on the necessity of the questionnaire, and is not determined as invalid. It is assumed that it is effective as a questionnaire.

The determination as to whether the attribute is a telephone attribute (step 1004) is made based on whether the number of digits of the input data is 10 digits or 11 digits. If the number of digits is other than that, it is determined that it is not a telephone number. In this judgment, if the result of all members is required, the result is invalid, and a follow-up notification is made using the name and address recognized first.
Whether or not it is a mail address (step 1005) is determined by whether or not “@” is included in the object. If the free address is not possible, it is determined whether the address is a free address by checking the domain. Here, if it is not determined to be an e-mail address, an invalidation process is performed, and then the name, address, and telephone number are followed again.
If it is necessary to enter company information such as company name and company name address in addition to these judgment processes, set specific terms such as (stock), company, (present), corporation, company, etc., and whether these terms exist In some cases, a process for determining whether the information is company information is added.

11 and 12 are flowcharts for explaining processing for separating personal information and questionnaire response results.
First, it is necessary to add attribute information indicating whether the data input area is an attribute of personal information or an answer to the questionnaire to the template used for the questionnaire. The attributes shown in FIG. 9 are added to the questionnaire forms shown in FIGS. 6, 7, 8, and 9. Further, how the attributes are analyzed will be described.
First, it is assumed that the questionnaire result has already been subjected to OCR processing.
First, when a user selects a document to be a target of the created questionnaire form template, the document and attribute information of the document are displayed.
First, when a user selects a document to be a template target, the document is displayed. Here, when the input name is already defined as the template name of the template already registered in the answer DB 8, a warning message is displayed to prompt the user to input with a different name (steps 1101 and 1102).

  Next, information for determining the document type is registered. For the document being displayed, the user uses a mouse or the like to specify a character string area specific to the document type. The system accepts this, displays the input area rectangle on the screen, and reads and displays the character string in the input area. If the input document is image data without character code information, the input area is displayed after character recognition is performed by OCR processing (steps 1103 and 1104).

The frame 502 in FIG. 5 and the frames 602 and 603 in FIG.
The character read from this area is made editable, and if there is an editing operation, it is accepted (step 1105).
If the rectangular area is specified so as to include a character string that is characteristic of the document type, even an unnecessary character string may be read in step 1104. Therefore, only necessary character strings are made by this editing operation. If it is decided to register this area as a questionnaire form, a character string is created as an element of the questionnaire form, and registered as an attribute element for the read character (steps 1106 and 1107).
If this area is not registered, the process returns to step 1103 and the registration process is executed again. In addition, when a characteristic area is further added to the document, the process returns to step 1103 and registration processing for another area is executed (step 1108).

If it is determined in step 1108 that no other area is designated, the process proceeds to the designation process for the next attribute data area.
In the attribute data area designation process, first, the user designates an area so as to surround the location of the attribute data. The system accepts the input and displays a rectangle of the input area on the screen (step 1109).
Next, an item name of the attribute data is received for the designated attribute data area, and selection of whether or not the attribute data area is cell data in the table is also accepted (steps 1110 and 1111. This is a frame 603 in FIG. Fall under).

If there is a condition regarding the data format of the attribute data, the input is accepted. This is because a character string satisfying this data format condition is extracted as attribute data (step 1112). Register the above information.
If these pieces of information are not registered, the process returns to step 1109 to perform registration processing relating to the attribute data area again (steps 1113 and 1114). If another attribute data area is to be registered, the process returns to step 1115 to resume the process. When all the attribute data areas are registered, the process is terminated (step 1115).

As described above, according to the present embodiment, the name of the respondent of the recorded questionnaire response result collected using the network is extracted, and whether the personal identification data corresponding to the name of the respondent is registered in the name database in advance. If it is confirmed and registered, identification information with a questionnaire response is additionally stored in the response database record corresponding to the personal identification data, and the questionnaire response data is additionally stored.
As a result, at the stage of answering the questionnaire, the information on the questionnaire respondent and the content of the answer are integrated, but at the stage of registration in the answer database, the personal identification information of the questionnaire respondent and the answer result of the questionnaire are separated. As a result, it is possible to confirm who answered the questionnaire itself, and furthermore, the contents of the questionnaire response itself are separated from the information of the individual who answered the questionnaire, so that the confidentiality of the relevance of the information can be maintained.
For respondents who answered the questionnaire, identification information (flag) with a response is additionally stored, so this identification information (flag) can be easily extracted as an unregistered target person, and personal identification data It is possible to increase the questionnaire collection rate by prompting the reply to the e-mail address of the contact address registered in.

1 is a system configuration diagram showing an embodiment of the present invention. It is a data block diagram when registering the data structure when registering personal information of a questionnaire in a name database, and a questionnaire result in an answer database. It is explanatory drawing showing the relationship between a questionnaire, a name database, and an answer database. It is a figure which shows the questionnaire preparation flowchart in case the side which implements a questionnaire constructs | assembles a questionnaire. It is a figure which shows an example of the template of a questionnaire. It is a figure which shows the other example of the model of a questionnaire. It is a figure which shows an example of the reply result with respect to a questionnaire. It is a figure which shows the other example of the answer result with respect to a questionnaire. It is a figure which shows the example which set the attribute to the input area for description type | formula questionnaires. It is a flowchart which shows the process which isolate | separates name information and questionnaire information from a questionnaire result. It is a flowchart explaining the process for isolate | separating personal information and a questionnaire reply result. 12 is a flowchart showing a continuation of FIG.

Explanation of symbols

1 terminal 2 network 3 host system 4 DB update unit 5 search processing unit 6 mail distribution unit 7 name database 8 answer database

Claims (2)

A survey management system for conducting surveys using a network,
Encrypted personal identification data such as the name and contact information of all surveyed persons, an answer database that stores a group of answers consisting of questionnaire answer data for one or more questions, and a network The name of the respondent of the recorded questionnaire response result collected using the name is extracted, and it is confirmed whether the personal identification data corresponding to the name of the respondent is registered in the name database in advance. A questionnaire management system comprising means for additionally storing identification information with a questionnaire response and additionally storing questionnaire response data in a record of the response database corresponding to the personal identification data.   2. The apparatus according to claim 1, further comprising means for prompting an answer based on contact data registered in the personal identification data for a questionnaire target person who does not store identification information with a questionnaire answer in the name database. The questionnaire management system described.

Images