JP2010079502A - Information processor and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To more utilize the tabulation result of answers to questions. <P>SOLUTION: A server device 1 is provided with: an external storage device 18 for storing questionnaire definition 31 defining the question content of questionnaire, questionnaire answer data 34 including the content of questionnaire answers 33, a question template 35 as the model of question components 41b of an analytic table 41 and a graph template 36 as the model of the table definition for graphs; and a CPU 11 for creating the analytic table 41 based on the questionnaire definition 31 and the question template 35 by software processing, and for creating data 42 for graphs based on the analytic table 41 and the questionnaire answer data 34, and for creating table definition 43 for graphs based on the data 42 for graphs and the graph template 36. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to an information processing apparatus and a program.

There is known a method in which a person who investigates an event presents a question to a person to be investigated, obtains answers to the question, and totals them using an information processing apparatus. For example, when the contents of a questionnaire are defined by input to a computer, a questionnaire form is generated, a process for distributing the questionnaire to a terminal of a surveyed person, collection of response contents made, storage of data of response contents, There is a form output method that automatically performs a series of processes up to analysis of response contents and output of analysis results (for example, Patent Document 1).
JP 2001-184273 A

  However, in the case of the form output method of Patent Document 1, there is a problem that the analysis result may not be used. For example, an analysis result output of a questionnaire by the form output method of Patent Document 1 is browsed using an original software tool. Therefore, when customizing the analysis result output data into another display format (for example, graph), etc., it can only be performed within the scope of the function provided by the software tool, and it can be used. It is scarce. In addition, since the series of processing up to the analysis result output of the questionnaire analysis result output by the form output method of Patent Document 1 is automated, if you want to customize such as changing the analysis viewpoint and outputting the analysis result, It is necessary to use a unique tool for changing the contents of analysis processing, and customization cannot be performed without learning how to use the unique tool.

  An object of the present invention is to make it possible to utilize the result of counting the answers to a question.

  In order to solve the above problem, the invention according to claim 1 is an information processing apparatus that analyzes an answer in a format for selecting at least one of a plurality of options set for one or more questions. A definition information storage means for storing definition information for defining the questions and options, an answer storage means for storing the answers, and a graph indicating the number of selected options for the questions are displayed by a spreadsheet program. And a graph table definition creating means for creating a graph table definition.

  The invention according to claim 2 is the information processing apparatus according to claim 1, wherein the definition information can define a plurality of questions, and the graph table definition creating means is included in the definition information For a plurality of questions, a graph table definition based on the contents of answers to individual questions and a chart table definition based on the contents of answers to all questions are created.

  The invention according to claim 3 is the information processing apparatus according to claim 1 or 2, further comprising a graph template storage unit that stores a graph template serving as a template of the graph, wherein the graph table definition creation unit includes: A graph table definition is created based on the graph template.

  The invention according to claim 4 is the information processing apparatus according to any one of claims 1 to 3, wherein the graph is at least one of a pie chart, a bar graph, and a graph having a multidimensional analysis function. It is characterized by including one.

  The invention according to claim 5 is the information processing apparatus according to any one of claims 1 to 4, wherein the analysis is a model of graph data, which is a table indicating the number of selections of each option for the question. Analysis table creation means for creating a table; and graph data creation means for creating the graph data based on the analysis table and the answer stored in the answer storage means, the graph table definition creation means Is characterized in that the graph table definition is created based on the graph data.

  A sixth aspect of the present invention is the information processing apparatus according to the fifth aspect, further comprising: a question template storage unit that stores a question template serving as a template of the analysis table.

  According to a seventh aspect of the present invention, there is provided a program as an information processing apparatus for analyzing an answer in a format for selecting at least one of a plurality of options set for one or more questions. Definition information storage means for storing definition information for defining the questions and options, answer storage means for storing the answers, graph table definition for displaying a graph indicating the number of choices of each option for the questions by a spreadsheet program It is characterized by functioning as a graph table definition creating means for creating a graph.

  According to the present invention, it is possible to make more effective use of the results of counting answers to questions.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiments. The embodiment of the present invention shows the most preferable mode of the invention, and the application of the invention is not limited to this.

  FIG. 1 shows a questionnaire system including a server apparatus 1 which is one embodiment of an information processing apparatus according to the present invention. The questionnaire system includes a server device 1 and a client device 2. The server apparatus 1 and the client apparatus 2 are connected via a communication network 3 so that they can communicate with each other.

FIG. 2 shows a main configuration of the server device 1.
The server device 1 includes a CPU 11 that performs various processes by the server device 1, a ROM 13 that stores various programs, data, and the like, a RAM 14 that functions as a storage area for temporarily storing data in various processes performed by the CPU 11, and the CPU 11. Rewriting data, display device 15 for displaying image output contents in accordance with various processes by, frame buffer RAM 16 for temporarily storing image data to be displayed on display device 15, input device 17 for performing manual input An external storage device 18 that can be stored, a communication I / F (interface) 19 that enables communication with an external device such as the client device 2 via the communication network 3, and a bus 12 that connects these components, Have

  The CPU 11 performs so-called software processing that reads various programs and data from the ROM 13 or the external storage device 18 and performs various processes. The function provided by the server device 1 is based on software processing of the CPU 11.

  The display device 15 is a display using, for example, a CRT or a liquid crystal. The input device 17 is, for example, a keyboard or a mouse. The software processing by the CPU 11 is accompanied by a display by the display device 15 according to the processing content, interprets the content input via the input device 17 and reflects it in the processing content.

  The storage device 18 is a rewritable storage device having, for example, a hard disk, a semiconductor, and the like, and stores at least a questionnaire definition 31, questionnaire response data 34, a question template 35, and a graph template 36. The questionnaire definition 31, questionnaire response data 34, question template 35, and graph template 36 will be described later.

FIG. 3 shows the main configuration of the client apparatus 2.
The client device 2 includes a CPU 21 that performs various processes by the client device 2, a ROM 23 that stores various programs and data read in various processes performed by the CPU 21, and a storage area that temporarily stores data in various processes performed by the CPU 21. A RAM 24 that functions as a display device, a display device 25 that displays image output contents associated with various processes by the CPU 21, a frame buffer RAM 26 that temporarily stores image data to be displayed on the display device 25, and an input for performing manual input. A device 27, an external storage device 28 capable of rewriting and storing data, a communication I / F (interface) 29 enabling communication with an external device such as the client device 2 via the communication network 3, and each of these components And a bus 22 for connecting the two.

  Similarly to the server device 1, the client device 2 performs various processing operations by software processing by the CPU 21. Processing contents and operations by the server device 1 and the client device 2 described below are based on software processing.

FIG. 4 shows an outline of the operation from the creation of the questionnaire definition 31 to the storage of the questionnaire response data 34 in the questionnaire system.
The server device 1 creates and stores a questionnaire definition 31 in response to an operator input performed via the input device 17, and automatically generates a questionnaire form 32 from the questionnaire definition 31. The server device 1 distributes the questionnaire form 32 to the client device 2. When the questionnaire response 33 is input in the client device 2, the server device 1 collects the questionnaire response 33 and stores the questionnaire response data 34.

The questionnaire definition is data defining a questionnaire question and a plurality of options set for each question.
FIG. 5 shows an example of the configuration of the questionnaire definition 31. 5A shows the overall structure of the questionnaire definition 31, FIG. 5B shows the structure of the header record 31b, FIG. 5C shows the structure of the destination record 31c, and FIG. 5D shows the structure of the question record 31d. .
Hereinafter, in the diagram shown in the table format, one column in the horizontal direction is a row and one column in the vertical direction is a column. Each of the second and subsequent lines from the top shown in FIG. 5D is one question record 31d, and FIG. 5D includes a plurality of question records 31d.

  As shown in FIG. 5A, the questionnaire definition 31 includes one header record 31b, one destination record 31c, and at least one question record 31d. Hereinafter, each record will be described.

  First, the header record 31b will be described. As shown in FIG. 5B, the header record 31b includes data of a record identification symbol, a questionnaire identification symbol, a subject, a destination number, a question number, and an explanation.

  The record identification symbol is data indicating the type of the record, and the data “H” included in the header record 31b indicates the header record 31b. The header record 31b is also included in the destination record 31c and the question record 31d, the record identification symbol of the destination record 31c is “T” as shown in FIG. 5C, and the question record 31d is shown in FIG. 5D. The record identification symbol is “Q”.

The questionnaire identification symbol is data indicating the question record 31d associated with the questionnaire definition 31 having the header record 31b. That is, the questionnaire identification symbol of the header record 31b is associated with the question record 31d included in the questionnaire definition 31.
The subject is data indicating the subject of a questionnaire conducted based on the questionnaire definition 31. The number of destinations is data indicating the number of destinations to which the questionnaire form 32 automatically generated based on the questionnaire definition 31 is transmitted. The number of questions is data indicating the number of questions in the questionnaire. The description is data including an explanatory text such as a comment regarding the questionnaire.

  Next, the destination record 31c will be described. As shown in FIG. 5C, the destination record 31c includes data of a record identification symbol, a destination type, and a destination code. Since the record identification symbol has been described above, it will be omitted.

  The destination type and the destination code are data indicating a destination to which the questionnaire form 32 is transmitted. Although not shown, the server device 1 has a table for associating the destination type and destination code with the client device 2, and the client device 2 that transmits the questionnaire form 32 by comparing the table with the destination type and destination code. decide.

  Next, the question record 31d will be described. As shown in FIG. 5 (d), the question record 31d includes data of a record identification symbol, a question, a question type, the number of options, and options. Since the record identification symbol has been described above, it will be omitted.

  The question is data including a content sentence of the question. The type of question is data including any one of “SA”, “MA”, or “TA”, and these two-letter alphabets correspond to the type of question. “SA” indicates a question to be answered by selecting any one of a plurality of options. “MA” indicates a question to be answered by selecting an arbitrary number of options from among a plurality of options. “TA” indicates a question to be answered by inputting text.

  The number of options is data indicating the number of question answer options when the question type is “SA” or “TA”. The option is data indicating the contents of each option of the answer, and is provided according to the number of options of each question.

FIG. 6 shows an example of the questionnaire form 32.
The questionnaire form 32 is data that is automatically generated by the server device 1 based on the contents of the questionnaire definition 31 and transmitted to the client device 2. The questionnaire respondent inputs a questionnaire response via the input device 27 to the questionnaire form 32 displayed on the display device 26 of the client device 2. The inputted questionnaire responses 33 are collected by the server device 1.

FIG. 7 shows an example of a questionnaire response 33 by the client device 2. FIG. 7A shows the overall configuration of the questionnaire response 33, and FIG. 7B shows the configuration of the response 33 a included in the questionnaire response 33. Each of the second and subsequent lines from the top shown in FIG. 7B is one answer 33a, and FIG. 7B includes a plurality of answers 33a.
As shown in FIG. 7A, the questionnaire answer 33 includes data of a questionnaire identification symbol, a subject, a respondent ID, the number of questions, and at least one answer 33a. Each data of the questionnaire identification symbol, subject, and number of questions corresponds to each data of the same name included in the questionnaire definition 31.
The respondent ID is data indicating an ID assigned to the questionnaire respondent. Although not shown, the server device 1 has a table for associating the respondent IDs with the information on the questionnaire respondents, and can check the questionnaire respondents based on the respondent IDs.

As shown in FIG. 7B, the answer 33a to the question “SA” or “MA” includes data indicating each question, choice 1, choice 2,. The contents of the question and each option correspond to each data included in the question record 31 d of the questionnaire definition 31.
The selection state of each option, such as the option 1 selection state, the option 2 selection state, etc., the option n selection state, includes numerical data of either 1 or 0. 1 indicates that the option is selected, and 0 indicates that the option is not selected.
The answer 33a to the “TA” question is stored as a text document in “Option 1”.
The questionnaire answer 33 shown in FIG. 7A has data of the number of answers 33a corresponding to the number of questions, and the data of each answer is as shown in FIG. 7B. It has data indicating the selection state of options.

FIG. 8 shows the structure of the questionnaire response data 34.
When the server apparatus 1 collects the questionnaire responses 33 from the client apparatus 2, the server apparatus 1 stores the questionnaire response data 34 in the configuration shown in FIG. Specifically, the structure of the questionnaire response data 34 is composed of a record of a questionnaire identification symbol, an answerer ID, and the number of questions, and general-purpose 1, general-purpose 2. The questionnaire identification symbol, the respondent ID, and the number of questions correspond to each data of the same name included in the questionnaire definition 31 described above.

  The general-purpose record stores data indicating the question of the questionnaire, each option, and the selection state of the option. For example, “question” data of the questionnaire response 33 is stored in the general-purpose 1, “option 1” data of the questionnaire response 33 is stored in the general-purpose 2, and “option 1 selection state” data of the questionnaire response 33 is stored in the general-purpose 3. Stored. When the storage of each data related to one question is completed, the answer contents of the next question are stored in the same number in the subsequent general-purpose record, and are stored up to the end of the questionnaire answer 33.

  The one-line questionnaire response data 34 shown in FIG. 8 is questionnaire response data corresponding to the respondent ID of one questionnaire respondent, and the server apparatus 1 stores the questionnaire response data 34 having the same configuration for the number of people who made the questionnaire responses. To do.

  The server device 1 has a questionnaire analysis function that is a process of analyzing the questionnaire based on the questionnaire response data. That is, the server device 1 has a function of displaying a selection state distribution of each option set for each question of the questionnaire. The distribution of the selection state of each option is performed using a graph display function of the spreadsheet program.

FIG. 9 shows an outline of the questionnaire analysis process.
The questionnaire analysis processing includes analysis table creation processing, graph data creation processing, and graph creation processing. The result of the questionnaire analysis process is input to the spreadsheet program, and a graph is displayed by the graph creation function of the spreadsheet program. That is, the questionnaire analysis process is a process of displaying a graph by a spreadsheet program based on the contents of the questionnaire response data. Although not shown, the ROM 13 or the external storage device 18 stores a program corresponding to each processing content of the questionnaire analysis processing, and the CPU 11 calls and executes the program corresponding to each processing content, thereby executing the questionnaire analysis processing. I do. The details will be described below.

The questionnaire extraction process is performed through an input operation on the operation designation dialog 100.
FIG. 10 shows an example of the operation designation dialog 100.
The operation designation dialog 100 is a dialog displayed on the display screen 16 of the server device 1, and the operator can select a questionnaire for performing analysis processing by an input operation on the operation designation dialog 100. The operation designation dialog 100 has a questionnaire symbol input form 101 and a questionnaire subject name input form 102. For example, when a questionnaire identification symbol of a questionnaire to be analyzed as a questionnaire symbol is input to the questionnaire symbol input form 101, the subject of the questionnaire definition 31 having the questionnaire identification symbol is reflected in the questionnaire subject input form 102. When “OK” is selected in the questionnaire operation designation dialog, the server apparatus 1 performs a questionnaire analysis process on the questionnaires input to the questionnaire symbol input form 101 and the questionnaire subject name input form 102. The questionnaire designation input for analysis in the action designation dialog may be performed by other methods. For example, the server device 1 may display a questionnaire identification symbol or a subject name of a questionnaire storing the questionnaire response data 34 in a menu so that the operator can select from the menu.

  Next, each processing content included in the questionnaire analysis processing will be described. First, analysis table creation processing will be described. The analysis table creation process is a process for creating a form format of the graph data 42. The graph data 42 is a table showing the number of choices for each option for each question in the questionnaire. That is, the analysis table is a framework of the table.

FIG. 11 shows an example of the analysis table 41. FIG. 11A shows the overall configuration of the analysis table 41, FIG. 11B shows the configuration of the common area 41a, and FIG. 11C shows the configuration of the question component 41b.
As shown in FIG. 11A, the analysis table 41 has one common area 41a and at least one question part 41b. The number of question parts 41b corresponds to the number of questions in the questionnaire selected as the target of the analysis process.

As shown in FIG. 11B, the common area 41a has a title area, an explanation area, and a detail area. A blank area of one line is provided between the explanation area and the detail area.
The title area is an area that reflects the title of the questionnaire, that is, the subject. Specifically, the contents of the subject data in the questionnaire definition 31 are reflected. The explanation area is an area in which the contents of the explanation data in the questionnaire definition 31 are reflected. The detail area is an area where the ID of the respondent who made the questionnaire response is reflected, and is blank when creating the analysis table. The common area 41a is generated by reading the questionnaire definition 31, reflecting the contents in the title area and the explanation area, and setting a blank area and a detail area.

  As shown in FIG. 11C, the question component 41b has a question area, an option area, a total area, and an answer area. The question area is an area that reflects a character string that is the content of a questionnaire question. Specifically, it is included in the questionnaire response data 34 and corresponds to the question data shown in FIG. The option area is an area in which options in questionnaire questions are reflected. The tabulation area is an area for setting a calculation formula for calculating the number of answers selected from the options reflected in the option area immediately above. The calculation area is set only when the question type is “MA”, and is a blank area when the other question type is used. The answer area is an area in which the selection state of options is reflected. Each area is defined so that it can be interpreted as an individual cell in a spreadsheet program.

  Creation of the question component 41b in the analysis table creation processing is performed based on a question template 35 prepared in advance. The question template 35 is a template having, for example, a question area, an option area, a total area, and an answer area. Based on the question template 35, the number of columns of the question parts, the totaling area, and the answer area of each question part in the analysis table 41 is provided by the number corresponding to the number of choices of each question included in the question record 31 d of the questionnaire definition 31. In the question area, a plurality of cells in the same row can be combined according to the length of the character string that is the content of the question.

FIG. 12 shows an example of the analysis table 41. Hereinafter, row numbers (1, 2, 3,...) From the upper row are assigned to the rows of the analysis table 41 and the graph data 42, alphabets (A, B, C,. The range from the line to the row line is described as “Koto: Kenting”. “K” and “K” are line numbers, and “B” and “Ding” are alphabets attached to the columns.
As shown in FIG. 12, the analysis table 41 includes a common area 41a, question parts 41b associated with general purpose 1-5, and question parts 41b associated with general purpose 6-18. Hereinafter, the question parts 41b are distinguished from those on the left side of FIG. 12 by numbering them as question parts 1, question parts 2,. Each area of the question part 1 corresponds to each number of the general-purpose record in the structure of the questionnaire response data 34. In the questionnaire response data 34 stored in the server device 1, “question” data is stored in the general-purpose 1, “option 1” data in the questionnaire response data 34 is stored in the general-purpose 2, and “option” in the questionnaire response data 34 is stored in the general-purpose 3. In the general-purpose 4, “option 2” data of the questionnaire response data 34 is stored, and in the general-purpose 5, “option 2 selection state” data of the questionnaire response data 34 is stored. That is, the question part 1 corresponds to the content of the first question in the questionnaire definition 31. Each area of the question part 2 also corresponds to the content of the second question in the questionnaire definition 31 by the same mechanism as the question part 1. Although not shown in FIG. 12, the association of the question component 41 b when there is the question component 3 or later is the same as that of the question components 1 and 2.

  The question data area 51 is set in the question part 41b. The question data area 51 is data indicating a data range related to one question. For example, in the case of the analysis table 41 shown in FIG. 12, the question data area 51 (question 1 data area 51a) of the question part 1 is set to a range from B1 to C4 (B1: C4), and the question data area of the question part 2 51 (question 2 data area 51b) is set in a range from D1 to I4 (D1: I4). Hereinafter, the question data area 51 of the question part n is referred to as “question n data area”.

  In the analysis table 41, a question data area 52 is set. The question data area 52 is data indicating a data range including all question parts. For example, in the case of the analysis table 41 shown in FIG. 12, the question data area 52 is set in a range from B1 to I4 (B1: I4).

  Although not shown in the analysis table 41 shown in FIG. 12, when there is a question part 3 or later, the question data area 51 is set for each question part, and the question data area 52 is a range including the question part 3 or later. Set to

  The analysis table 41 illustrated in FIG. 12 is merely an example, and the association between each area of the analysis table 41 and the configuration of the questionnaire response data 34 varies depending on the contents of the questionnaire definition 31.

FIG. 13 shows a procedure for creating the analysis table 41. 13A to 13E show the order in which the analysis table 41 is created.
First, as shown in FIG. 13A, a common area 41a is generated. The corresponding data described above is set in each area included in the common area 41a.

  Next, based on the question template 35, as shown in FIG. 13B, a question area, an option area, a total area, and an answer area are generated as the first column of the question part 1. Next, as shown in FIG. 13C, the option area, the total area, and the answer area of the question part 1 are the option area, the total area, and the answer in the first column according to the number of options for the question of the question part 1. Added to the right side of the area. At this time, the question area provided on the option area in each column of the question component 1 may be generated as a separate area (blank) or may be combined with the question area in the first column.

When the generation of the question part 1 is completed, the common area 41a and the question part 1 are integrated. As shown in FIG. 13 (d), the question component 1 is provided so as to be continuous on the right side of the common area 41a.
When there is a second or subsequent question in the questionnaire response data to be analyzed, each question part after question part 2 is generated by the same procedure as question part 1, and is sequentially provided on the right side of question part 1 It is done.

  As shown in FIGS. 13A to 13E, a column of the row attribute 200 is provided in the common area 41a of the analysis table 41 being created and the leftmost column of the question part. As shown in FIG. 13 (d), when the question area is continued to the common area 41a, a positional relationship is obtained in which the respective row attributes match in the row direction. When the creation of the analysis table 41 is completed, the column of the row attribute 200 is deleted as shown in FIG.

  The setting of the question data area 51 is performed in parallel with the generation of each question part during the process of creating the analysis table 41. For example, the question 1 data area 51a of “B1: B4” is set when the question part 1 shown in FIG. 13B is generated. Thereafter, as shown in FIG. 13C, when the column of the question part 1 is added, the question 1 data area 51a is updated to “B1: C4”. Thereafter, as shown in FIG. 13D, the question 1 data area 51a is updated to “C1: D4” in accordance with the process of making the common area 41a and the question part 1 continuous. After that, when the column of the row attribute 200 is deleted as shown in FIG. 12 with the completion of the analysis table creation process, the question 1 data area 51a is updated to “B1: C4”.

  The question data area 52 is set in accordance with the process of continuing the common area 41a and the question part 1 shown in FIG. 13D, and is updated at the timing when the question parts are further provided and when the row attribute 200 is deleted. Is done.

Next, the graph data creation process will be described.
The graph data creation processing is processing for creating graph data 42 that is data reflecting the contents of the questionnaire response data 34 in the analysis table 41.
FIG. 14 shows an example of the graph data 42.
Graph data 42 is created based on the correspondence between each area of the analysis table 41 described above and the structure of the questionnaire response data corresponding to each area. Of these, for the data in the fourth and subsequent rows, the answer contents of the answer data 34 including the answer ID of each answer and the answer ID for the answer data for all of the answer data for the questionnaire subject to data analysis processing. Is reflected.

  The question data area 51 and the question data area 52 are reset to a range including the last line of the graph data 42. For example, in the case of the graph data 42 shown in FIG. 14, the question 1 data area 51a is (B1: C33), the question 2 data area 51b is (D1: I33), and the question data area 52 is (B1: I33).

  Further, although not included in the graph data 42 of FIG. 14, when the type of question is “MA”, the third row of each column of options included in the question is set based on the set calculation formula. The cumulative total of answers that have selected options is calculated and reflected.

Next, the graph creation process will be described. The graph creation processing is processing for outputting data for performing graph display output by the graph creation function of the spreadsheet program.
FIG. 15 shows an example of the graph. 15A is a pie chart 71, FIG. 15B is a bar chart 72, and FIG. 15C is a stacked bar chart 73.
When the graph creation process is performed, a graph related to the result of the questionnaire is displayed by the graph display function of the spreadsheet program. For example, when the graph creation process using the graph data 42 shown in FIG. 14 is performed, graphs as shown in FIGS. 15A to 15C are displayed by the graph creation function of the spreadsheet program. The graph creation processing is performed by outputting the data corresponding to the question data area 51 or the question data area 52 of the questionnaire response data and the command for causing the spreadsheet program to display the graph to the spreadsheet program by outputting the graph to the spreadsheet program. Make a display. In the following description, the data range output to the spreadsheet program by the graph creation process is referred to as a graph table definition 43.

  The spreadsheet program refers to a program having a spreadsheet function and a graph display function. The graph table definition 43 outputs the graph table definition 43 in a data format that can be displayed by a spreadsheet program. That is, the graph table definition 43 is output in a data format that can be input to the spreadsheet program. The spreadsheet program is not limited to a specific spreadsheet program, and by outputting the chart table definition 43 in a data format that can be input to the spreadsheet program that is the output target of the chart table definition 43, an existing spreadsheet is calculated. Graph display can be performed by a program or a new spreadsheet program to be provided in the future.

  FIG. 16 shows an example of the graph table definition 43. FIG. 16A is the data of the graph of FIG. 15A, FIG. 16B is the data of the graph of FIG. 15B, and FIG. 16C is the data of the graph of FIG.

  The graph table definition 43 is output in a data format for a spreadsheet program to display and output a graph, and the content includes contents based on the question data area 51 or the question data area 52. As shown in FIGS. 16A to 16C, the graph table definition 43 includes data of a graph type, a title, and a data range.

The graph type is a character string indicating the type of graph. The graph type in the graph table definition in FIG. 16A is a pie chart 71, the graph type in the graph table definition in FIG. 16B is a bar graph 72, and the graph type in the graph table definition in FIG. It is a bar graph 73.
The title is a character string that becomes the title of the graph output by the graph table definition 43. The title of the graph table definition 43 of the stacked bar graph 73 is the subject of the questionnaire that is the analysis target. The title of the graph table definition 43 other than the stacked bar graph 73 is a character string indicating the content of the question displayed by the graph, that is, a character string reflected in the question area.

  The data range is a range of questionnaire response data represented by a graph output by the graph table definition 43. The data range of the graph table definition 43 of the multipurpose graph is a question data area 52 set in the graph data 42 of the questionnaire response data to be analyzed. The title of the graph table definition 43 other than the multi-purpose graph is one of the question data areas 51 set in the graph data 42 of the questionnaire response data to be analyzed, and the title included in the graph table definition 43 And the question data range set in the data range correspond to each other.

The graph table definition 43 is created based on a graph template prepared in advance. In the graph template, a page for displaying a graph corresponding to the set graph type is set together with the graph table definition 43 in which any one of the pie graph 71, the bar graph 72, and the stacked bar graph 73 is set in advance. Is a file. The graph creation process reads the graph data 42 and creates a graph table definition 43 based on the question data area 51 of each question and a graph table definition 43 based on the question data area 52 based on the graph template.
The graph template is prepared in advance in a data format that allows graph display by a spreadsheet program.

  Of the graph templates, the graph template whose graph type is the pie chart 71 is used for the question whose question type is “SA”, and the graph template whose graph type is the bar graph 72 is the question type “MA”. Used for certain questions. Hereinafter, the graph template whose graph type is the pie chart 71 is “SA graph template”, the graph template whose graph type is the bar graph 72 is “MA graph template”, and the graph template whose graph type is the stacked bar graph 73 is “all”. "Graph template".

  In the stacked bar graph 73, the vertical axis item, horizontal axis item, and each data serving as a reference for stacking each bar graph can be changed, replaced, etc. by the user's operation on the displayed graph. And the contents of the displayed graph can be changed accordingly. That is, the stacked bar graph 73 has a so-called multidimensional analysis function that can change the data to be analyzed and the viewpoint of analysis. As the multidimensional analysis function, for example, there are a slice function, a die function, a drill-up function, a drill-down function, and the like, and it is possible to perform cross tabulation etc. on the answer contents of the questionnaire. An example of a graph having such a multidimensional analysis function is a pivot graph. The stacked bar graph 73 is one of pivot graphs.

  Next, the operation of the server apparatus 1 for data analysis processing will be described using the flowcharts of FIGS.

First, analysis table creation processing will be described.
FIG. 17 shows a flowchart of the analysis table creation process.
First, the CPU 11 reads the questionnaire definition 31 of the questionnaire to be analyzed (step S1), and generates a common area 41a based on the questionnaire definition 31 (step S2). Next, the CPU 11 generates a question part question area (step S3), and generates a question part option area and a total area (steps S4 and S5). At this time, the CPU 11 determines whether or not the question type is “MA” (step S6). If the question type is “MA” (step S6: YES), a calculation formula for totaling is added to the totaling area. Set (step S7). Next, the CPU 11 generates an answer area for question parts (step S8). If the question type is not “MA” in step S6 (step S6: NO), the process proceeds to step S8.

  After generating the question part option area, the total area, and the answer area in steps S4 to S8, the CPU 11 determines the number of options set for the question in the questionnaire definition 31 and the generated option area, the total area, and the answer area. The number of columns is compared, and it is determined whether or not columns of the option area, the total area, and the answer area are generated by the number of options of the question. That is, the CPU 11 determines whether there is an option for which a column has not yet been generated (step S9). If there is still an option (step S9: YES), the process returns to step S4. When columns of option areas, total areas, and answer areas are generated as many as the number of options of the question (step S9: NO), the CPU 11 determines the number of questions set in the questionnaire definition 31 and the number of question parts generated. And whether or not the question parts are generated by the number of questions is determined. That is, the CPU 11 determines whether there is a question for which a question part has not yet been generated (step S10). If there is still a question (step S10: YES), the process returns to step S3 to generate a question part for a new question. The question area generated when returning from step S10 to step S3 is generated as a question area different from the question parts that have been generated so far. If question parts are generated for the number of questions (step S10: NO), the analysis table creation process is terminated.

  At the end of the analysis table creation process, a question data area 51 is set for each question part, and a question data area 52 is set for a range including all the question parts.

Next, the graph data creation process will be described. FIG. 18 is a flowchart of the graph data creation process.
First, the CPU 11 reads the analysis table 41 created by the above-described analysis table creation process (step S21). Next, the CPU 11 writes and reflects data corresponding to each question area of the question part of the analysis table 41 (step S22). Next, the CPU 11 writes and reflects the data corresponding to the option area of each question part (step S23).

Next, the CPU 11 reads the data (questionnaire answer record) of the selection state of each option for the questionnaire based on the questionnaire definition 31 that is the analysis target among the data included in the questionnaire answer data 34 (step S24), and each question component The read data is written and reflected in the answer area (step S25). With the processing in step S25, the respondent ID corresponding to the contents of the questionnaire response record is written and reflected in the detail area of the common area 41a.
Next, the CPU 11 determines whether or not the questionnaire response data 34 has a questionnaire response record that has not yet been written in the graph data 42 (step S26). If there is (step S26: YES), the CPU 11 returns to step S24. The processes in step S24 and step S25 are sequentially performed for each respondent ID.

  In step S26, when there is no questionnaire response record yet written in the questionnaire response data 34 (step S26: NO), the CPU 11 includes “MA” as the question type of the questionnaire definition 31 to be analyzed. It is discriminated whether or not (step S27). If it is included (step S27: YES), based on the calculation formula set in the total area of the question part of the question, the total selected for each option is written and reflected (step S28), and graph data is created. The process ends. In step S26, if the question type is not “MA” (step S26: NO), the graph data creation process is terminated.

  With the creation of the graph data, the question data area 51 and the question data area 52 are reset to a range including the last line of the graph data 42.

Next, the graph creation process will be described. FIG. 19 shows a flowchart of the graph creation process.
First, the CPU 11 reads the graph data 42 created by the above-described graph data creation processing (step S31). Next, the CPU 11 reads the question type included in the question part and determines whether or not the question type is “MA” (step S32). When the question type is “MA”, the CPU 11 reads the MA graph template (step S33), and writes and reflects the question data area 51 of the question in the data range of the graph table definition 43 included in the graph template. (Step S35). If the question type is not “MA” in step S32 (step S32: NO), the CPU 11 reads the SA graph template (step S34), and enters the data range of the graph table definition 43 included in the graph template in step S35. Perform the process. With the processing in step S35, the title of the question is also reflected in the graph table definition 43. Next, the CPU 11 outputs the graph table definition 43 for the question (step S36). Next, the CPU 11 determines whether there is a question that has not yet output the graph table definition 43 in the graph data 42 (step S37). If there is a question that has not yet output the graph table definition 43 (step S37). (S37: YES), the process returns to step S31. The processing from step S31 to step S36 is sequentially performed for each question.

  When the graph definitions for all the questions included in the graph data 42 are output in step S37 (step S37: NO), the CPU 11 reads the pivot graph template (step S38), and for the graph included in the pivot graph template. The question data area 52 is written and reflected in the data range of the table definition 43 (step S39). With the processing in step S39, the subject of the questionnaire is also reflected in the graph table definition 43. Thereafter, the CPU 11 outputs the graph table definition 43 based on the pivot graph template (step S40), and ends the graph creation process.

  According to the present embodiment, the graph table definition 43 can be used to display a graph based on the contents of the questionnaire response by the spreadsheet program, so that secondary use of the questionnaire response data by the spreadsheet program is performed. Can do. As a result, it becomes possible to analyze the results of the questionnaire responses in a more diversified manner, and to further utilize the results of the questionnaire responses. Specifically, it is possible to change the format and color of the displayed graph, edit a part or all of the data content indicated by the graph, add a comment, and the like.

  Further, for a plurality of questions included in the questionnaire definition 31, a graph table definition 43 based on the question data area 51 of each question and a graph table definition 43 based on the question data area 52 can be output. The graph showing the analysis result for each question and the graph showing the analysis result of the entire questionnaire can be displayed simultaneously. In addition, the use of the above-mentioned result of the questionnaire response can be performed for each question, and the analysis result of the entire questionnaire can also be performed.

  Furthermore, by changing the graph template, the display format showing the analysis result of the questionnaire can be easily changed.

  Furthermore, since the graph template is provided so that a graph having a multidimensional analysis function such as a pie chart 71, a bar chart 72, and a stacked bar chart 73 can be displayed, the aggregated result of questionnaire responses can be displayed by these plural types of graphs. As a result, it is possible to analyze the results of the responses to the questionnaire questions in a more diversified manner. In particular, for graphs with multidimensional analysis functions, each data is changed or replaced by the user's operation on the displayed graph for the vertical axis item, horizontal axis item, and each bar data stacking standard. It is possible to change the contents of the graph displayed thereby, and a graph display by a combination of arbitrary items can be performed.

  Furthermore, the server apparatus 1 creates an analysis table 41 that is a model of the graph data 42 that is a table showing the number of selections for each option, creates the graph data 42 from the analysis table 41 and the questionnaire response data 34, A graph table definition 43 is created based on the use data 42. At this time, the question data area 51 is set for each question in the analysis table 41 and the graph data 42, and the entire data area 52 is set. At this time, the question data area 51 and the entire data area 52 are set when the analysis table is created. As the graph data is created, the question data area 51 is automatically reset to a range reflecting the questionnaire response data for the question. With the creation of the graph data, the entire data area 52 is automatically reset to a range reflecting the questionnaire response data for all questions. As a result, the question data area 51 or the entire data area 52 of each question can be used when the data range to be displayed in the graph is designated when the graph table definition 43 is created.

  Furthermore, by changing the question template 35, the form format of the analysis table and the graph data can be easily changed.

Note that the description in the present embodiment shows an example of the present invention, and the present invention is not limited to this.
For example, the types of graphs displayed by the output of the graph table definition 43 are not limited to the pie graph 71, the bar graph 72, and the graph having a multidimensional analysis function. Other graphs such as a line graph, a band graph, and other graphs may be used.

It is a figure which shows the questionnaire system containing the server apparatus which is one Embodiment of the information processing apparatus by this invention. The main structure of a server apparatus is shown. The main structure of a client apparatus is shown. An outline of the operation from the creation of the questionnaire definition to the storage of questionnaire response data in the questionnaire system is shown. An example of the structure of a questionnaire definition is shown. 5A shows the overall structure of the questionnaire definition, FIG. 5B shows the structure of the header record, FIG. 5C shows the structure of the destination record, and FIG. 5D shows the structure of the question record. An example of a questionnaire form is shown. An example of the questionnaire response by a client apparatus is shown. FIG. 7A shows the overall structure of the questionnaire answer, and FIG. 7B shows the structure of the answer 33a included in the questionnaire answer. The structure of questionnaire response data is shown. An overview of the analysis process is shown. An example of an operation designation dialog is shown. An example of an analysis table is shown. 11A shows the overall structure of the analysis table, FIG. 11B shows the structure of the common area, and FIG. 11C shows the structure of the question part. An example of an analysis table is shown. An analysis table creation processing procedure is shown. An example of graph data is shown. It is a figure which shows an example of a pie chart. It is a figure which shows an example of a bar graph. It is a figure which shows an example of a stacked bar graph An example of a graph table definition is shown. FIG. 16A is the data of the graph of FIG. 15A, FIG. 16B is the data of the graph of FIG. 15B, and FIG. 16C is the data of the graph of FIG. The flowchart of an analysis table preparation process is shown. The flowchart of the data creation process for graphs is shown. The flowchart of a graph preparation process is shown.

Explanation of symbols

1 server device 2 client device 3 communication network 11 CPU
18 External storage device 31 Questionnaire definition 34 Questionnaire response data 35 Question template 36 Graph template 41 Analysis table 42 Graph data 43 Graph table definition 51 Question data region 52 Overall data region 71 Pie graph 72 Bar graph 73 Stacked bar graph

Claims (7)

An information processing apparatus for analyzing an answer in a format for selecting at least one of a plurality of options set for one or more questions,
Definition information storage means for storing definition information for defining the questions and options;
Answer storage means for storing the answer;
A graph table definition creating means for creating a graph table definition for displaying a graph indicating the number of selections of each option for the question by a spreadsheet program;
An information processing apparatus comprising: The definition information can define a plurality of questions,
The graph table definition creating means, for a plurality of questions included in the definition information, a graph table definition based on the contents of answers to individual questions, a graph table definition based on the contents of answers to all questions, The information processing apparatus according to claim 1, wherein: A graph template storage means for storing a graph template as a template of the graph;
The information processing apparatus according to claim 1, wherein the graph table definition creation unit creates a graph table definition based on the graph template.   The information processing apparatus according to claim 1, wherein the graph includes at least one of a pie graph, a bar graph, and a graph having a multidimensional analysis function. An analysis table creating means for creating an analysis table as a model of graph data, which is a table showing the number of choices of each option for the question;
Graph data creation means for creating the graph data based on the analysis table and the answers stored in the answer storage means,
5. The information processing apparatus according to claim 1, wherein the graph table definition creating unit creates the graph table definition based on the graph data. 6.   The information processing apparatus according to claim 5, further comprising a question template storage unit that stores a question template serving as a template of the analysis table. A computer as an information processing device for analyzing an answer in a format for selecting at least one of a plurality of options set for one or more questions;
Definition information storage means for storing definition information defining the questions and options;
Answer storage means for storing the answer;
A graph table definition creating means for creating a graph table definition for causing a spreadsheet program to display a graph indicating the number of choices of each option for the question;
A program characterized by functioning as

Images