JP2002169454A - Management system for contents aiming at education and method for managing the contents - Google Patents

Abstract

PROBLEM TO BE SOLVED: To make it possible to distribute optimum teaching materials to learners in accordance with study results of the learners at the time of performing the distributing of teaching materials for study by using the Internet/an intra-network and to enable a manager to totalize and manage efficiently these teaching materials for study. SOLUTION: This management system is provided with a database 11 in which IDs of users of teaching materials are registered and in which study user's personal histories of the users are recorded and a contents management device 10 in which a means 1 which verifies the password of an user based on the registered information of the database 11 and which makes only set teaching materials to be laid open to the public with respect to a logged-on user, a means 2 which records and stores the user's personal history of an user to the database 11, a means 3 which totalize the study histories stored in the database 11 and display states of the histories on a manager's terminal and means 4, 5 which narrow down a plurality of attributes as to users by combining the attributes and set a condition and search and extract trainees conforming to the pertinent condition and store the extracted result as a text file and distribute electronic mails to the extracted trainees in unison are provided.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

TECHNICAL FIELD The present invention relates to a WBT (WEB)
(Base Training), that is, when distributing learning materials using the Internet / intranet, the users are limited or the learning status of the users is saved as a history in a database, and the administrator of the learning materials or the entire system is used. The present invention relates to a system for managing a series of contents for totalizing the contents and a management method thereof.

[0002]

[Prior Art] From the use of personal computers for education to the use of the Internet, and as the third step, educational contents and know-how are linked via an information and communication network to provide integrated utilization as "education media," such as the Learning Web Project and remote use. The big flow to education has begun. The future prospect is that educational contents and know-how can be accessed arbitrarily, "anyone,""anytime," or "anywhere" through the Internet.

[0003] In recent years, CGI has been required to authenticate, store and compile history of contents for educational purposes running on the Web.
(Common Gateway Interface
e) Methods for realizing using programs and their management systems have been developed and proposed. For example, Lotus Learning Space R4, NTT X-Carat, NEC Cultiva, Hitachi High Plus, Fujitsu Internet Nubbingware and the like are known.

[0004]

However, in the method implemented by the conventional method, it is extremely difficult to use a fine-grained education and utilize the history of teaching materials. That is,
When managers try to use their learning history as they please,
Either the method is limited or it requires database expertise.

[0005] Therefore, an object of the present invention is to solve these conventional problems, and to limit the users in distributing learning materials using the Internet / intranet.
Save the learning status of the user as a history in the database,
It is an object of the present invention to provide a content management system and a management method for educational purposes capable of totalizing and managing teaching materials or the entire system in accordance therewith.

[0006]

In order to achieve the above object, a content management system for education according to the present invention is connected to a client terminal operated by a plurality of managers via the Internet or an intranet. A content management system, in which a user ID of a teaching material is registered, a password of a user is collated based on a database in which a learning history of the user is recorded, and registration information of the database, and the set teaching material is set. Means for disclosing only the logon user, means for recording and storing the learning history of the user in the database, and summing up the learning history stored in the database, and displaying the history status on the screen of the administrator terminal. Means, and a plurality of attributes related to the user are combined to narrow down, set conditions, and meet the conditions. To find and extract the lecture who, to save the extracted result as an external text file, is characterized in that it has the means to deliver all at once an e-mail to the extracted student.

[0007] The content management method for the purpose of education according to the present invention is a content management method for distributing teaching materials to a learner using the Internet or an intranet. The password of the learner is verified, the database is inquired whether or not the password matches, and if the password matches, only the set teaching materials are disclosed to the learner who has logged on, and each learner, learning material, question, A first process of storing a learning history recorded for each execution start date and time in the database;
The second process is called from the content for confirming the use status of the learning material of the learner, sums up the learning histories stored in the database, and transmits the history status to the administrator terminal, and is stored in the database. A third process in which a plurality of attributes related to the relevant person are combined and narrowed down, a range of use date and time and an execution restriction are set, a teaching material specified only for the relevant person is set, and the third process cooperates with the first process; Automatically generate an SQL sentence for searching or extracting the specified teaching material, write the extracted result to a text file by the administrator, and deliver the e-mail to the students corresponding to the extracted result at the specified time all at once And a fourth process.

[0008]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 10 is a system diagram of a content management system for educational purposes to which the present invention is applied. In FIG. 10, reference numeral 15 denotes an Internet / intranet, 10 denotes a server, and a content management device newly proposed according to the present invention for educational purposes;
Is a database (history database 1) that is connected to the content management apparatus 10 and stores detailed information of a user who is a learner and learning history information such as a test result by the user.
04, consisting of the user database 114), 12, 1
Reference numerals 3 and 14 denote client terminals, that is, terminals used by learners. The content management apparatus 10 for educational purposes according to the present invention includes a learner authentication function, a learning history storage function, a learning history display function, a narrowing-down function for applicable persons, a history extraction by an administrator, and a learning material distribution function.

[0009] The content management apparatus 1 for educational purposes according to the present invention.
0 is roughly composed of the following two programs and one user interface. (1) HTML (Hyper Text Markup)
Language) A CGI program called from teaching materials created by others, (2) The administrator uses WEB
A CGI program called from the content to check the usage status of the teaching materials executed from above, (3) a user interface of a database client program executed by an administrator to perform processes such as user registration and history extraction of the teaching materials. is there. Hereinafter, these programs and interfaces will be described in detail.

(1) A CGI program called from a teaching material has roughly the following two functions. Learner authentication function This performs password verification and queries the database for a match. This discloses only the teaching materials set by the database client program of (3) to the logged-on user. Learning history storage function This function saves the learning history that is recorded for each learner / teaching material / question / execution start date and time. The items mainly recorded are, in addition to the above, the execution end date and time, the correct answer value, the answer value, the right / wrong judgment, and the score.

(2) The CGI program called from the content for confirming the use status of the teaching material has the following functions. Learning history display function This is to aggregate the database of saved learning history,
A program for transmitting a situation to an administrator or a student. The user interface portion is a CGI program that is created in HTML or the like and is called from the same as the teaching material.

(3) The user interface of the database client program for performing processes such as user registration of learning materials and history extraction has the following functions. This function narrows down the combination of multiple attributes (age, affiliation, etc.) related to the person in the personal database, and further limits the use date and time and execution restrictions (until a passing score is obtained / only once / restricted) None, etc.), and set so that only the pertinent person can execute the designated teaching material, and cooperate with the CGI program of (1). Processing and teaching material distribution function by administrator This is an SQL (Struct) for searching / extracting.
The user inputs the subject and content for the user interface that automatically generates the (ured QueryLanguage) statement, the function that writes the result to an external text file so that the administrator can freely process the result, and the extraction result (individual). This is a function to simultaneously deliver e-mails of the same content at a specified time.

Next, the program of the present invention will be described in detail with reference to the drawings. FIG. 1, FIG. 2, and FIG. 3 are flowcharts showing the cooperative operation and operation of a CGI program called from a teaching material according to an embodiment of the present invention. (1) There are two types of CGI programs called from teaching materials: a CGI program for writing a history, and a CGI program for collating a user database and performing password authentication before executing the teaching material. FIG.
(A) shows a cooperative operation when a CGI program for writing a history is operated. First, each user uses the WWW browser 101 of the client terminal to execute a normal W
A program for operating the screen in a manner of viewing the website, displaying the WEB content 102 created by HTML or another method, calling the CGI program 103 (an original creation part) by the Post command, and writing a history to the database. Make it work. The connection with the database engine connects to the SQL server or the local database 11 and writes the history to the history database 104.

FIG. 1B shows a cooperative operation when a CGI program for password verification is operated. First, each user operates the screen by using the WWW browser 111 of the client terminal in a manner of viewing a normal Web site, and the WE created by HTML or another method.
B content 112 is displayed, and CG by Post command is displayed.
The I program 113 (independently created portion) is called to operate a program for performing password verification. The connection by the database engine connects to the SQL server or the local database 11, checks the password against the user database 114, and returns the result to the CGI.
W via program 113 and WEB content 112
The return value is received by the WW browser 111.

FIG. 2 shows a processing flow of a CGI program for writing a history. When the program is started, a recording request from the teaching material is received (step 12).
1) Receive personal information and other recording items (step 122) and record them in the database 11 (history database 104) (step 123). FIG. 3 shows a processing flow of a CGI program for performing password verification. When a collation request is received from the teaching material (Step 1
31), the user information and the password are received (step 132), collated with the user database 114 (step 133), and the result of matching or not matching is returned to the teaching material (step 134).

FIGS. 4 and 5 show a CGI called from a content for confirming the use status of the teaching material of the present invention.
It is a cooperation operation of a program and an operation flowchart. (2) The CGI program called from the content for confirming the use state of the teaching material can confirm the learning history written in the history database 104 from the WWW browser. In FIG. 4, the user first uses the WWW browser 141 of the client terminal to perform normal Web
b) The screen is operated in a manner of viewing the site, the WEB content 142 created by HTML or another method is displayed, and the CGI program 143 (a unique creation part) is called by a Post command. The program 143 refers to the history database 104, performs a specific tally, and returns a result to the browsing content. In the history database 104, learning histories written by the history writing CGI are accumulated.

FIG. 5 shows an operation flow of the CGI program called from the content for confirming the use state of the teaching material. This flow is activated when the administrator executes the flow from the web. First, upon receiving a tallying request from the content for confirming the usage status of the teaching material (step 151), it receives the tallying target parameter (step 152), retrieves the data from the history database 104 and tallys it (average / rank etc.). ) (Step 1
53). Then, the table of the totaled result is returned to the content for confirming the use state of the teaching material (step 154).

Next, (3) the user interface of the database client program and its functions (
The function of setting the designated teaching material for the corresponding person, the function of extracting the history, and the function of distributing the mail) will be described with reference to a screen example. FIG.
FIG. 5 is a diagram showing an example of a screen for narrowing down a personal database and performing settings for executing a designated teaching material only for a relevant person. This function narrows down by combining multiple attributes (age, affiliation, etc.) related to the person in the personal database (table), furthermore, the range of use date and time and execution restrictions (until a passing score is obtained / once only / no limit, etc.) ) To allow only the relevant person to execute the designated teaching materials,
Cooperate with the program.

Here, the conditions entered / edited / recorded are:
The authentication before the execution of the learning material is used as a criterion of the CGI program for authentication to determine which learning material is to be executed by each individual. Specifically, when this information is recorded, related information for linking the individual with the teaching material is recorded, and the CGI program refers to this immediately before executing the teaching material, and enumerates the names of the teaching materials to be executed by the logged-in person. Become. Since the teaching material executor (learner) cannot see the unset teaching material from the menu screen, it is practically impossible to execute the teaching material.

FIG. 6 shows the distribution rule screen among the distribution rule, individual, extraction, student, teaching material, master, and import categories on the maintenance screen.
Enter D, supervisor, years of service, age, job title, and code in charge, and also release date, examination conditions (until a passing score is obtained / 1)
By inputting the delivery name, passing score, etc., the person in charge determines which learning material should be executed by the student, and determines the delivery ID, the teaching material ID, and the like. Fill in the fields.

FIGS. 7, 8 and 9 are diagrams showing examples of screens as interfaces showing data extraction and mail distribution functions. FIG. 7 is a screen for extraction in the database client program, FIG. 8 is a screen showing the result of inquiring the database by clicking the extraction button in FIG. 7, and FIG. 9 is clicking a mail button in FIG. Thus, the mail transmission setting screen is displayed. The functions are: a user interface that automatically generates an SQL sentence for search / extraction, a function that writes the results to an external text file so that the administrator can freely process the results, This is a function in which the administrator inputs the subject and the contents, and simultaneously distributes e-mails of the same contents at the designated time.

In the extraction screen of FIG. 7, by selecting various extraction conditions from options, an SQL sentence is automatically generated.
Query the database. Here, extraction patterns (such as teaching material units) and connection conditions (AND or OR)
And then input matching, partial matching, size, etc. as conditions such as teaching material ID, pass / fail, score, etc. Clicking the extract button automatically generates an SQL sentence,
The database is queried. The result is the screen of FIG. By clicking the mail button on the screen of FIG. 8, the screen moves to the mail transmission setting screen of FIG.

The mail transmission setting screen shown in FIG. 9 shows a setting portion for a function of simultaneously distributing mail to the extraction result target person. First, specify the SMTP server, specify the SMTP user ID, specify the source mail address, specify the sender name, specify the subject, write the mail contents, and click the mail button to deliver the mail. Preparation is completed. Further, functionally, it is possible to specify the time of mail distribution.

[0024]

As described above, according to the present invention,
When distributing learning materials using the Internet / intranet, limit the users on the screen and save the user's learning status as a history in a database, and optimize the learners according to the learning results It is possible to distribute important teaching materials, and it is possible to obtain a remarkable effect that a manager of the teaching materials or the entire system can efficiently collect and manage them.

[Brief description of the drawings]

FIG. 1 is a flowchart illustrating a cooperative operation of a CGI program called from a teaching material according to an embodiment of the present invention.

FIG. 2 is an operation flowchart of a CGI program for writing a history according to an embodiment of the present invention.

FIG. 3 is an operation flowchart of a CGI program for performing password verification according to an embodiment of the present invention.

FIG. 4 is a flowchart illustrating a cooperative operation of a CGI program called from content for confirming the use status of a teaching material according to an embodiment of the present invention.

FIG. 5 is an operation flowchart of a CGI program called from content for confirming a use state of a teaching material according to an embodiment of the present invention.

FIG. 6 is a diagram showing a screen of a personal narrowing down function (delivery setting) as a user interface of a database client program showing one embodiment of the present invention.

FIG. 7 is a view showing a screen for automatically generating a SQL sentence based on an extraction condition input displayed subsequently to FIG. 6;

FIG. 8 is a diagram showing a screen displaying data extracted according to FIG. 7;

FIG. 9 is a diagram showing a mail distribution screen displayed subsequently to FIG. 8;

FIG. 10 is a system diagram of a content management system for educational purposes to which the present invention is applied.

[Explanation of symbols]

10 ... server (education purpose content management device), 11 ...
Database, 12, 13, 14 ... client terminal,
104: history database, 15: Internet / intranet, 114: user database.

Continued on the front page (51) Int.Cl. ⁷ Identification code FI Theme coat II (Reference) G06F 17/60 302 G06F 17/60 302E F term (Reference) 2C028 BB04 BB05 BC01 BD02 BD03 CA13 CB13 DA04 5B075 KK07 KK13 KK33 KK37 ND03 ND20 ND23 NK46 PQ02 PQ26 PR03 QR03 QT06 UU24 UU40

Claims (2)

[Claims] 1. A content management system connected to a client terminal operated by a plurality of learners via the Internet or an intranet, wherein a user ID of a learning material is registered and a learning history of the user is recorded. Means for checking the user's password based on the registered information of the database and the registered information of the database, and opening only the set teaching materials to the logged-on user, and recording and storing the learning history of the user in the database. Means, a means for totalizing learning histories stored in the database, a means for displaying the history status on the screen of the administrator terminal, a combination of a plurality of attributes relating to the user, narrowing down, setting conditions, and setting conditions. Search and extract matching students, save the extracted results as an external text file, and send the extracted students Management system of content for the purpose of education, characterized in that it comprises a means for simultaneously delivered the mail. 2. A content management method for distributing a learning material to a learner's terminal using the Internet or an intranet, wherein the content is called from the learner's learning material, and the learner's password is verified. Inquires the database as to whether or not they match, and if they match, only the set teaching materials are disclosed to the logged-on learner, and the learning history recorded by learner, teaching material, question, and execution start date and time is recorded. The first processing to be stored in the database and the content for confirming the use status of the learning material by the learner are called up, the learning histories stored in the database are totaled, and the history status is transmitted to the administrator terminal. The second process is combined with a plurality of attributes related to the person stored in the database to narrow down the data, and the range of the use date and time and the execution restriction are reduced. Only, the set of specified materials only the relevant person, the first
And a third process that cooperates with the above process, automatically generates an SQL sentence for searching or extracting the specified teaching material, writes the extracted result to a text file by an administrator, and selects a student corresponding to the extracted result. And a fourth process for simultaneously distributing e-mails at a designated time.