JP2004139444A - Data totaling method, database device, computer program and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To tabulate data in a data table while verifying and adjusting individual data. <P>SOLUTION: In tabulating the evaluations of learning contents, at first, a totaling method selection screen is displayed (S501), and either a learning item-based totaling method or an evaluation times range-based tabulating method is selected on this screen (S502 and S503). When the learning item-based tabulating method is selected (S502Y), a subtotal of evaluations for every learning item is found (S504) and the total sum of the subtotals is also found (S505). When the evaluation times range-based tabulating method is selected (S502N and S503Y), a subtotal of evaluations for every evaluation times range is found (S507) and the total sum of the subtotals is found (S508). The results of the totals are displayed on a screen (S506 and S509). <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a data summarizing method and the like, and more particularly, to a data summarizing method, a database device, a computer program, and a recording medium that can sum up data in a data table while verifying and adjusting individual data.
[0002]
[Prior art]
Databases are widely used for data management and aggregation. Recently, in the field of education, a database for managing a learning guidance plan, a teaching record, a student's learning evaluation, and the like has begun to be used.
[0003]
A database that manages the learning instruction plan and the like (hereinafter referred to as a learning management database) is managed by dedicated database software installed on a computer, and is operated by operating a computer and registering necessary data in a data table. It manages teaching plans and creates grades.
[0004]
In the learning guidance plan, a plurality of "learning items" are set for each subject, and "learning aims" and "learning contents" are set in detail for each learning item. The proficiency level of each learning content is evaluated in detail based on a certain evaluation viewpoint, and finally the evaluation is totaled at the end of the term or the end of the academic year, and the grade of each student is objectively created.
[0005]
FIG. 6 is a diagram illustrating an example of a registration screen (window) for evaluation of learning content.
[0006]
As shown in FIG. 6, in the data table 601 displayed in the window 600, the evaluation of the proficiency corresponding to the predetermined "learning items" 602, "learning aims" 603, and "learning contents" 604 includes: Each student 605 is registered for each predetermined evaluation viewpoint 606. As items necessary for evaluating the proficiency of each student, ranks of "A", "B", and "C" are provided for each of the evaluation viewpoints 606a to 606c, and a check box of each cell is turned on / off. By doing so, the proficiency level of each student can be registered and managed, and finally, the results can be tabulated to create grades.
[0007]
[Problems to be solved by the invention]
In the comprehensive evaluation, the numbers of "A", "B", and "C" are totaled, and an average of them is taken. Calculated automatically as a rating. This is very convenient because the final evaluation can be automatically created simply by performing daily tasks diligently.
[0008]
However, if the final evaluation is calculated mechanically, it is difficult to verify whether the overall evaluation is appropriate. That is, the evaluation of the proficiency level is important depending on the content of learning, and is not so important, and the weighting of the evaluation is often different at each time. Under such circumstances, even if the result of the automatic counting described above, for example, the comprehensive evaluation of “A” is given, it is sometimes necessary to examine in more detail whether A is really appropriate and make adjustments. is there.
[0009]
Therefore, an object of the present invention is to provide a data summarizing method, a database device, a computer program, and a recording medium that can sum up data while verifying and adjusting individual data.
[0010]
[Means for Solving the Problems]
The object of the present invention is a method for totalizing data in a data table managed by a computer, wherein at least one of a first totaling method and a second totaling method is selected, and When the aggregation method is selected, the first column is used for records having common data registered in a second column different from the first column to be aggregated in the data table. Obtaining a subtotal of the data registered in the data table; and, when the second tabulation method is selected, the first tabulation target for records in a predetermined range of the data table. And a step of obtaining a subtotal of the data registered in the column of (1).
[0011]
Further, the object of the present invention is a method for totalizing data in a data table managed by a computer having a graphical user interface, wherein at least a first totalizing method or a second totalizing method is operated by a screen operation. Selecting one of them, and when the first tabulation method is selected, data registered in a second column different from the first column to be tabulated in the data table is common Obtaining a subtotal of the data registered in the first column with respect to the record to be processed, and, when the second aggregation method is selected, records in a predetermined range of the data table in the data table. Obtaining a subtotal of data registered in the first column to be tabulated as an object; Also achieved by a data aggregation method characterized by comprising the step of displaying on the screen with at least a portion of Buru.
[0012]
In a preferred embodiment of the present invention, items of a higher concept than the first column are registered in the second column.
[0013]
According to the preferred embodiment of the present invention, subtotals can be obtained by collecting data registered in the first column for each superordinate concept.
[0014]
In a further preferred embodiment of the present invention, the step of selecting either the first tabulation mode or the second tabulation mode includes displaying the data table on a screen, and displaying the second column of the data table. And the step of combining and displaying the display of the cells having the same data.
[0015]
According to a further preferred embodiment of the present invention, the data in the data table is easy to see, and the range in which a subtotal is calculated for each learning item becomes clear.
[0016]
The object of the present invention is at least a means for managing a data table, a display means for displaying the data table on a screen, a data input means constituting a graphical user interface together with the display means, and a first tabulation method. Or means for selecting any one of the second tabulation methods, and, when the first tabulation method is selected, a second column different from the first column to be tabulated in the data table. Means for obtaining a subtotal of the data registered in the first column for records having the same registered data, and, when the second aggregation method is selected, Means for calculating a subtotal of data registered in the first column to be totalized for records in a specified range. Also achieved by a database system that.
[0017]
The object of the present invention is also to provide at least a step of causing a computer having a function of managing a data table to select one of a first tabulation method and a second tabulation method, and selecting the first tabulation method. In this case, the data registered in the second column different from the first column to be tabulated in the data table is registered in the first column for records having a common target. Calculating a subtotal of data; and when the second aggregation method is selected, is registered in the first column to be aggregated with respect to records in a predetermined range of the data table. It is also achieved by a computer program for performing the step of determining the subtotal of the data in question.
[0018]
The above object of the present invention is also achieved by a computer-readable recording medium on which the computer program is recorded.
[0019]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.
[0020]
FIG. 1 is a block diagram showing a configuration of a database device according to a preferred embodiment of the present invention.
[0021]
As shown in FIG. 1, the database device 100 is a personal computer on which predetermined software is installed, and includes a computer main body 101, display means such as a display 102, and data input means such as a keyboard 103 and a mouse 104. It has. These display means and data input means together with predetermined software constitute a graphical user interface.
[0022]
The computer main body 101 has a general computer configuration, and includes a CPU 105, a memory 106, a hard disk drive (HDD) 107, a removable media drive (RMD) 108 for recording / reproducing a recording medium such as a magnetic recording medium or an optical disk, and an input / output unit. An output interface (I / O) 109 is provided.
[0023]
An OS, various device drivers, learning management database software, and the like are installed in the database device 100. These software and the above-described hardware cooperate to provide a data table management function, a display function, and a data aggregation function. Various functions are realized. Such software may be provided by a recording medium such as an optical disk. In this case, the program is read and installed by a removable media drive. Alternatively, it may be provided online from the Internet. The installed program is read from the hard disk into the memory and executed according to an instruction from the user or automatically at the time of starting the computer.
[0024]
The learning management database in the database display device 100 has a relational database function, and a plurality of data tables are registered. In addition, a data table can be displayed on the display 102 in response to a request from the user. By operating the keyboard 103 or the mouse 104, data can be registered in each cell of the data table displayed on the display 102. In addition, data registered in the data table can be totaled based on a predetermined totaling method.
[0025]
FIG. 2 is a diagram illustrating an example of a selection screen (window) of an evaluation aggregation method.
[0026]
As shown in FIG. 2, a data table 201 displayed in this window 200 corresponds to a predetermined "subject" 202 and "school year / class" 203, and can be changed to another "subject" by operating the screen. Or it can be changed to the data table of "school year / class".
[0027]
In the data table 201, as items necessary to clarify the evaluation of the proficiency level of each learning content, “evaluation frequency” 204, “evaluation period” 205, “class implementation period” 206, “learning item” 207, Items such as “Aim of learning” 208 and “Learning contents” 209 are provided.
[0028]
The “evaluation number” 204 is a primary key of the data table 201 by being divided into evaluations for each learning content 209 and being assigned a serial number in accordance with the order of the learning content. The “learning item” 207 is an item of a higher concept than the “learning purpose” 208 and the “learning content” 209, and a plurality of “learning aims” and a plurality of “learning objectives” Content ”is set. Therefore, when looking at the relationship between “learning items” and “evaluation”, a plurality of evaluations may be given to one learning item, and there is a one-to-one or one-to-many relationship. For example, as shown in the figure, the number of evaluations 1 belongs to the learning item (1), the number of evaluations 2 and 3 belongs to the learning item (2), and the number of evaluations 4, 5, and 6 belongs to the learning item (3). . Although the actual data of each cell has specific contents according to each item, for the sake of explanation, a numeral is added following each item name.
[0029]
Although data is individually registered in each cell of the data table, when the data registered in the upper and lower adjacent cells is common, the display of the two cells is combined. For example, as shown, two cells are combined in “learning item (2)”, “learning purpose (2)”, and “learning purpose (4)”, and in “learning item (3)”, three cells are combined. Cells are connected. By displaying the data in this manner, the data in the data table can be easily viewed, and the range in which a subtotal is calculated for each learning item becomes clear.
[0030]
Further, the window 200 is provided with buttons for selecting a totaling method of evaluation, a “take a subtotal for each learning item” button 210a and a “take a subtotal for each specified number of evaluations” button 210b. Only one of these can be selected by exclusive control. When the button 210a is selected, a subtotal is calculated for each learning item. When the button 210b is selected, a subtotal is calculated for each of the specified evaluation frequency ranges. If all the evaluation times are specified as one range, it goes without saying that all the evaluation times are summed up without calculating the subtotal.
[0031]
When a subtotal is obtained for each of the specified evaluation frequency ranges, the evaluation frequency range is specified by inputting data to the evaluation frequency selection data table 211. The number of records in the evaluation count selection data table 211 is determined by operating the subtotal type selection button 212. Here, the number of records “2” is selected. A display label can be attached to each evaluation count range. Here, as shown in the figure, a display label in the range of evaluation counts 1 to 3 is set to “intermediate evaluation”, and a display label in the range of evaluation counts 4 to 6 is displayed. Is referred to as “end-of-term evaluation”.
[0032]
When the "evaluation list for each individual" button 213a or the "evaluation list for each class" button 213b is selected by a screen operation such as a click, a window for displaying a total of the evaluation corresponding to each is displayed.
[0033]
FIG. 3 is a diagram illustrating an example of a screen (window) that displays a tally result for each learning item.
[0034]
As shown in FIG. 3, in this window 300, a data table 301 for displaying information on each evaluation and a data table 302 for showing a totaling result for each learning item are displayed. Items in the data table 301 are largely classified by the number of evaluations. For example, the number of evaluations 1 is displayed in the area 301a, and the number of evaluations 2 is displayed in the area 301b. The other evaluation times 3 to 6 can be displayed by scrolling the screen. The information on each evaluation includes “evaluation period” 205, “start date” 205 a and “end date” 205 b of the evaluation, “learning item” 207, “objective of learning” 208, and “learning content” which are evaluated. 209 etc. are displayed.
[0035]
Each record 303 of the data table 302 has a "learning item" as a primary key. As described above, based on the evaluation of “A”, “B”, or “C” registered for each evaluation count as an evaluation for each evaluation viewpoint, each record 303 includes a subtotal of the evaluation of each learning content for each learning item. The result is displayed for each evaluation viewpoint. For example, as shown in FIG. 2, if the number of evaluations 1 belongs to learning item 1, the number of evaluations 2 and 3 belongs to learning item 2, and the number of evaluations 4, 5, and 6 belongs to learning item 3, the data In the record 302 of the table 302, the result of the evaluation number 1 is displayed as it is, in the record 2, the subtotal of the evaluation number 2 and 3 is calculated and in the record 3, the subtotal of the evaluation number 4, 5, 6 is calculated and displayed. Furthermore, the record 304 displays the total of the subtotal of each record. The one with the largest total value is to be adopted as the comprehensive evaluation.
[0036]
In this way, by subtotaling the evaluation of the learning content for each learning item, it is easy to determine whether the final evaluation obtained is appropriate, and each learning item is weighted. In this case, the adjustment of the evaluation becomes easy.
[0037]
FIG. 4 is a diagram illustrating an example of a screen (window) that displays a tally result for each evaluation count range.
[0038]
As shown in FIG. 4, in this window 400, a data table 301 displaying information on each of the above-described evaluations and a data table 401 showing a totaling result for each specified evaluation frequency range are displayed.
[0039]
Each record 402 of the data table 401 uses a display label set in advance in the evaluation count selection data table 211 shown in FIG. 2 as a primary key, and each record subtotals the evaluation of each learning content for each specified evaluation count range. The result is displayed. In record 1, subtotals for the number of evaluations 1 to 3 are calculated and displayed for the "middle evaluation", and in record 2, subtotals for the number of evaluations 4 to 6 are calculated and displayed for the "end-of-term evaluation". Furthermore, the record 403 displays the total of the subtotal of each record. The one with the largest total value is to be adopted as the comprehensive evaluation.
[0040]
In this way, by looking at the subtotals of the evaluations of the learning content for each evaluation frequency range, it is easy to determine whether or not the final overall evaluation is appropriate, and each evaluation frequency range is given a weight. In this case, the evaluation can be easily adjusted.
[0041]
FIG. 5 is a flowchart showing a procedure for counting the evaluation of learning contents.
[0042]
As shown in FIG. 5, in the tallying of the evaluation of the learning content, first, the tallying method selection screen shown in FIG. 2 is displayed (S501). On this screen, the user is caused to select either one of the tallying methods for each of the learning items or the evaluation frequency range (S502, S503).
[0043]
When the tallying method for each learning item is selected (S502Y), a subtotal of the evaluation is calculated for each learning item (S504), and the total of these evaluations is calculated (S505). The tally result is displayed on the screen shown in FIG. 3 (S506).
[0044]
When the totaling method for each evaluation frequency range is selected (S502N, S503Y), a subtotal of the evaluation is calculated for each evaluation frequency range (S507), and the total of these evaluations is calculated (S508). The counting result is displayed on the screen shown in FIG. 4 (S509).
[0045]
As described above, according to the embodiment, it is possible to not only verify the validity of the comprehensive evaluation while viewing the numbers of “A”, “B”, and “C” by totaling for each learning item. Since the subtotal range can be freely set for each number of evaluations, it is very convenient to verify the validity of the evaluation and obtain information for adjustment.
[0046]
The present invention is not limited to the above embodiments, and various changes can be made within the scope described in the claims, and it goes without saying that these are also included in the present invention. No.
[0047]
For example, in the above embodiment, the case where the evaluation of the learning content of each student is totaled in the learning management database has been described as an example. However, the present invention is not limited to this, and the data in the data table managed by the computer is Applicable in any case of aggregation. In particular, this is effective when the data table includes a first column to be counted and a second column in which items of a higher concept than the first column are registered.
[0048]
Further, in the above embodiment, FIG. 2 shows a screen for selecting the evaluation tallying method, FIG. 3 shows a screen for displaying the tallying result for each learning item, and FIG. 4 shows a screen for displaying the tallying result for each evaluation frequency range. Although each is shown, these layouts are merely examples, and it goes without saying that any changes are possible.
[0049]
Further, in the above embodiment, the user is allowed to select either a method of obtaining a subtotal for each learning item or a method of obtaining a subtotal for each specified evaluation count range. In the screen shown in FIG. In order to clarify the range of the case, the display of cells having the same learning item is combined and displayed. However, it is not always necessary to combine the display and cells may be individually displayed.
[0050]
【The invention's effect】
As described above, according to the present invention, it is possible to provide a data totaling method, a database device, a computer program, and a recording medium capable of totalizing data while verifying and adjusting individual data.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of a database device according to a preferred embodiment of the present invention.
FIG. 2 is a diagram illustrating an example of a selection screen (window) of an evaluation aggregation method;
FIG. 3 is a diagram illustrating an example of a screen (window) that displays a tally result of each learning item;
FIG. 4 is a diagram illustrating an example of a screen (window) that displays a tally result for each evaluation count range;
FIG. 5 is a flowchart illustrating a procedure for counting the evaluation of learning contents;
FIG. 6 is a diagram illustrating an example of a registration screen (window) of evaluation of learning content;
[Explanation of symbols]
REFERENCE SIGNS LIST 100 database device 101 computer main body 102 display 103 keyboard 104 mouse 105 CPU
106 Memory 107 Hard disk drive (HDD)
108 Removable Media Drive (RMD)
109 input / output interface (I / O)
Selection screen (window) of evaluation method
201 Data table 202 "Course" item 203 "Grade level / class" item 204 "Evaluation frequency" item 205 "Evaluation period" item 206 "Class implementation period" item 207 "Learning item" item 208 "Learning item" Aim 209 Item "Learning content" item 210a "Take a subtotal for each learning item" button 210b "Take a subtotal for each specified evaluation frequency range" button 211 Evaluation frequency selection data table 212 Subtotal type selection button 300 Learning Screen (window) that displays the total result of each item
301 Data table 302 Data table 205a showing the totaling result for each learning item 205a "Start date" item for evaluation 205b "End date" item for evaluation 303 Each record 304 Record 400 Screen displaying the totaling result for each evaluation count range ( window)
401 Data table 402 showing the aggregation result for each of the specified number of evaluation times range Each record

Claims (7)

A method for aggregating data in a data table managed by a computer,
at least,
Causing the user to select either the first aggregation method or the second aggregation method;
When the first tabulation method is selected, the data table is registered with the same data registered in a second column different from the first column to be tabulated in the data table. Obtaining a subtotal of the data registered in column 1;
Obtaining the subtotal of the data registered in the first column to be totalized, for the records in a predetermined range of the data table, when the second totaling method is selected; A data aggregation method, comprising: A method for aggregating data in a data table managed by a computer with a graphical user interface, comprising:
at least,
Causing the user to select either the first tabulation mode or the second tabulation mode by screen operation;
When the first tabulation method is selected, the data table is registered with the same data registered in a second column different from the first column to be tabulated in the data table. Obtaining a subtotal of the data registered in column 1;
Obtaining the subtotal of the data registered in the first column to be totalized, for the records in a predetermined range of the data table, when the second totaling method is selected; When,
Displaying a result of the subtotal on a screen together with at least a part of the data table. 3. The data totaling method according to claim 1, wherein an item of a higher concept than the first column is registered in the second column. The step of selecting either the first aggregation method or the second aggregation method includes:
4. The method according to claim 1, further comprising displaying the data table on a screen, and combining and displaying the display of cells having the same data in the second column of the data table. Or the data aggregation method according to item 1. at least,
Means for managing a data table;
Display means for displaying the data table on a screen;
Data input means constituting a graphical user interface together with the display means,
Means for selecting either the first aggregation method or the second aggregation method;
When the first tabulation method is selected, the data table is registered with the same data registered in a second column different from the first column to be tabulated in the data table. Means for obtaining a subtotal of data registered in column 1;
Means for obtaining a subtotal of data registered in the first column to be totalized for records in a predetermined range of the data table when the second totaling method is selected. A database device comprising: at least,
A computer with a function to manage data tables
Causing the user to select either the first aggregation method or the second aggregation method;
When the first tabulation method is selected, the data table is registered with the same data registered in a second column different from the first column to be tabulated in the data table. Obtaining a subtotal of the data registered in column 1;
Obtaining the subtotal of the data registered in the first column to be totalized, for the records in a predetermined range of the data table, when the second totaling method is selected; Computer program for executing A computer-readable recording medium on which the computer program according to claim 7 is recorded.

Images