JP2004102902A - Method and system for guiding educational lecture, and program therefor - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a method and a system for guiding educational lecture allowing an education manager (eduction department of large company) to narrow down educational lectures and guide the narrowed down lectures to employees, a program therefor, and a recording medium, whereby remarkably reducing a labor required for the preparation of books to reduce cost and improve convenience by an increase in the efficiency of business. <P>SOLUTION: In this method and system for guiding educational lectures, a plurality of lecture data on educational lectures is stored in a database, a narrow-down processing is allowed for the education manager to narrow down, from the database, lecture data required by the lecture narrow-down means, and the narrowed down lecture data is allowed for persons who desire to receive lecture to browse by a lecture browsing means to guide the educational lectures. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a training course guidance method and a system, a program, and a recording medium for, for example, narrowing down training courses recommended by an educator to employees in a company and guiding the narrowed training courses to employees.
[0002]
[Prior art]
Conventionally, in the education department of a large company, a large number of educational courses provided by various educational organizations are selected and compiled, and carefully selected educational courses are compiled into a booklet, and guided to employees as recommended educational courses. Has been done. Employees view the distributed booklet and obtain information such as the field, the presence or absence of a reward, the tuition fee, and the duration of the course, and decide whether or not to wish to take the course.
[0003]
In this way, an enormous amount of work has occurred for the education department to carefully select educational courses, and there have been many inefficient parts, for example, the method of describing various information on educational courses differs depending on the educational organization.
[0004]
In this way, as a system for selecting and browsing information on educational courses (brochures, etc.), brochures are sent in the order of the most suitable from among the accounts of educational institutions such as universities, preparatory schools, study cram schools, and pamphlets of lectures. An electronic brochure distribution / browsing method and an electronic brochure system that can be browsed on a PC of an applicant have been proposed (see Patent Document 1).
[0005]
Further, as a system related to education, an education system, an education method, a recording medium, and a learning support device capable of performing individual education according to the level of each learner have been proposed (see Patent Document 2).
[0006]
[Patent Document 1]
JP 2001-41977 A
[Patent Document 2]
JP-A-2002-108190.
[0007]
[Problems to be solved by the invention]
However, the electronic brochure system of Patent Document 1 assumes that a student who wants to attend directly selects necessary brochures and the like, and is not usable in an education department of a large company or the like.
[0008]
Further, the education system of Patent Document 2 automatically and appropriately selects a teaching material according to the level of each learner from the teaching material candidates, and can be freely compared and carefully selected by an education department of a large company or the like. It was not like that.
[0009]
The present invention provides an education course guidance method, a system, a program, and a recording medium that enable an education manager (education department of a large company or the like) to narrow down education courses and guide employees to the narrowed courses. The purpose of the present invention is to significantly reduce the labor required for creating a booklet, thereby reducing costs and improving convenience by improving work efficiency.
[0010]
[Means for Solving the Problems]
The present invention stores a plurality of course data relating to an education course in a database, allows an education manager to narrow down required course data by the course narrowing means from the database, and requests the course data to receive the narrowed course data. This is a training course guidance method for guiding a training course by allowing a user to browse through the course browsing means.
[0011]
As a result, the education manager (for example, a person in charge of the education section of a large company) carefully selects training courses to be encouraged to those who want to take the course (for example, employees who are eligible to apply for training), and the employees browse the carefully selected training courses. It becomes possible. This also allows the employee to select an education course he / she wants to attend from carefully selected education courses.
[0012]
As a preferred embodiment, the database is stored in a server, and access right setting means permits setting of an access right to the server. Thus, access to the server by a terminal via a network can be permitted.
[0013]
As a result, employees who wish to attend the course can view the course data using a personal computer or other terminal provided by the company. However, it is possible to limit the course data that can be applied for a course even if viewing is permitted.
[0014]
Further, as a preferred embodiment, the course data is set as each course data provided by a plurality of course providers, and the course provider to which a predetermined access right is set is added or deleted or provided. And / or changes can be tolerated by the course maintenance means.
As a result, a plurality of course providers can manage course data relating to their own education courses.
[0015]
Further, the present invention can be an education course guidance system configured to be able to execute the above-mentioned education course guidance method.
This makes it possible to actually operate the education course guidance system and efficiently guide the education course.
[0016]
Further, the present invention provides an educational course guide in which a narrowing process capable of narrowing down necessary course data from a database storing a plurality of course data relating to an educational course and a browsing process capable of browsing the narrowed course data are set. It can be a program.
This makes it possible to install an educational course guidance program to build an educational course guidance system, or to use an educational course guidance method, and to use a general-purpose computer such as a commercially available personal computer or workstation. Become.
[0017]
According to the present invention, there can be provided a recording medium in which the course data used in the method for guiding an education course and / or the education course guidance program described in claim 5 is recorded.
As a result, the course data and / or the educational course guidance program can be recorded on the recording medium and used, or can be installed on the computer from the recording medium.
[0018]
【The invention's effect】
According to the present invention, an education manager can narrow down an arbitrary educational course from a large number of educational courses, and can guide the narrowed educational course to a candidate.
[0019]
In addition, the course provider can freely add, delete, and / or change the course data of the educational courses provided by the course provider, and provide an environment where the database can be operated efficiently and the latest information can always be used. it can.
[0020]
BEST MODE FOR CARRYING OUT THE INVENTION
An embodiment of the present invention will be described below with reference to the drawings.
First, the system configuration of the education course guidance system 1 will be described with reference to the system configuration diagram shown in FIG.
[0021]
A course guidance management server 11, which is a key component of the education course guidance system 1, is installed in a company of a system management company and is connected to the Internet 2 via a router 10. The course guidance management server 11 includes a course database 20 (course DB), and stores various data necessary for guiding an educational course in the course database 20.
[0022]
In a company of an educational organization (English study group in the illustrated example) that provides educational courses, an organization PC 31 composed of a personal computer is installed. The group PC 31 is connected to the Internet 2 via the router 30.
[0023]
A router 50 is installed in a company that recommends education courses to employees (in the illustrated example, A Corporation), and an in-house network 5 that integrates networks of each department is connected to the Internet 2. Are connected to the in-house network 5, and the routers 50a, 50b,... Are respectively connected to the router PCs 50a, 50b,. 51a, 51b,...) Are connected.
[0024]
With the above system configuration, the course manager of the educational organization is the organization PC 31, the educator of the enterprise is the enterprise PC 51 a, and the employee of the enterprise is the enterprise PC 51 b, accessing the course guidance management server 11 and executing necessary processing. can do.
[0025]
Next, the internal configuration of the course guidance management server 11 will be described with reference to the circuit block diagram shown in FIG.
The course guidance management server 11 is constituted by a personal computer, and includes a control device 13 constituted by a CPU, a ROM and a RAM, and an I / O interface 12 in the main body.
[0026]
A monitor 14, a keyboard 15, a mouse 16, a CD-ROM drive 17, a communication device 18, and a hard disk 19 are connected to the control device 13 via the I / O interface 12. The communication device 18 and the hard disk 19 are built in the main body, and the other devices are externally mounted outside the main body.
[0027]
The monitor 14 displays symbols such as characters and images such as figures according to the RGB signals received from the control device 13. This image includes a screen required for system management.
[0028]
The keyboard 15 allows a character input such as an ID and a password and a numerical value input when performing user registration, and transmits the input character, numerical value and the like to the control device 13 as an input signal.
[0029]
The mouse 16 is a pointing device for transmitting a command such as moving a cursor and clicking an icon to the control device 13, and transmits a coordinate signal and a click signal to the control device 13 as input signals.
[0030]
The CD-ROM drive 17 reads data and programs recorded on a CD-ROM, such as an installation program (a program for installing a program necessary for constructing the education course guidance system 1), recorded on the installation CD-ROM 21, and the like. A read signal is transmitted to the control device 13.
[0031]
The communication device 18 is a communication device for connecting to the Internet 2 (FIG. 1) via the router 10 (FIG. 1). According to a communication signal received from the control device 13, the group PC 31 and the corporate PC 51 are connected via the Internet 2. And transmits the data received from the group PC 31 and the company PC 51 to the control device 13 as a communication signal.
[0032]
The hard disk 19 adds, changes, and deletes data and programs according to a write signal received from the control device 13. As a result, a course database (DB) 20, a system management program (PG) 20E, a course management program 20F, a course narrowing program 20G, and a user table 20A, a course table 20B, a company employment course table 20C, and an application history table 20D are stored. In addition, it is possible to add, change, and delete the narrowed-down course browsing program 20H.
[0033]
The system management program 20E, the course management program 20F, the course narrowing program 20G, and the narrowed course browsing program 20H are created by CGI (Common Gateway Interface), and are incorporated in order to make the course guide management server 11 function as a WEB server. It operates on Apache.
[0034]
Further, the group PC 31 and the company PC 51 are configured by personal computers similarly to the course guidance management server 11, and include an I / O interface, a control device, a monitor, a keyboard, a mouse, a CD-ROM drive, a communication device, and a hard disk. It has. The hard disk does not store the above-mentioned database and program, but stores a web browser.
[0035]
With the above configuration, the WEB browser of the course guidance management server 11, the group PC 31, or the corporate PC 51 is started, and each program in the course guidance management server 11 is executed by the WEB browser. Data can be added, changed, deleted, or browsed.
[0036]
Next, the data structure stored in the course database 20 will be described with reference to the data structure explanatory diagrams shown in FIGS.
FIG. 3 shows a user table (file) 20A for managing users who can access the course guidance management server 11, and is composed of the following fields (items).
[0037]
User ID: IDs of a system administrator, an educational organization, an educator, and an employee.
Password: A password that authenticates access rights.
User classification: 1 = system administrator, 2 = educational organization, 3 = education staff, 4 = employee.
Related ID: ID for specifying course data that can be referred to.
Company name: Name of system administrator, educational organization, educator, employee, etc.
Contact person: The name of the person in charge of the company or organization.
Postcode: The postcode of the user.
Address: The address of the user.
Phone Number: The user's phone number.
FAX: User's FAX.
E-mail: E-mail of the user.
[0038]
By configuring the user table 20A in this manner, it is possible to perform user authentication using a password, set access rights, specify course data that can be referred to, and the like.
[0039]
FIG. 4 shows a course table (file) 20B in which guidance information of an educational course provided by each educational organization is stored, and is composed of the following fields (items).
[0040]
Course ID: A unique number assigned to each course.
Course name: The name of the course.
Attendance period (month): The attendance period of the course.
Attendance fee: Fee required to take the course.
Aim: The aim of the course.
Curriculum: Curriculum of the course.
Special notes: Special notes such as the need for a CD player.
Contents of teaching materials: Contents of teaching materials to be used.
Category: Classification for use in category display and search. Multiple registration is possible.
Additional keywords: Additional keywords used for search. Multiple registration is possible.
Public limited company ID: ID of a specific company that provides a dedicated course.
Educational organization ID: ID of the educational organization that provides the course.
[0041]
By configuring the course table 20B in this way, for example, if a certain educational organization accesses, only the course data provided by the educational organization can be displayed by the educational organization ID, and addition, change, and deletion of the educational course can be permitted. it can.
In addition, a person in charge of education and an employee can search for a target educational course by various search methods, such as searching by a tuition fee or a course period, or searching by category.
[0042]
FIG. 5 shows a company recruitment course table 20C showing the education courses that the educator has narrowed down to employ in his or her company, and is composed of the following fields (items).
[0043]
Company ID: A company ID for specifying a company.
Course ID: A course ID for specifying a course.
[0044]
By configuring the company recruitment course table 20C in this way, it becomes possible for the educator of the company to narrow down the training courses recommended to employees, and to allow employees of the company to view only the narrowed training courses. And so on.
[0045]
FIG. 8 shows an application history table 20D showing the data of the history of the company employees applying for attendance, and is composed of the following fields (items).
[0046]
Name: The name of the student.
Full name: The full name of the student.
Postcode: The postcode of the student.
Address: Student address.
Phone Number: Student's phone number.
E-mail: E-mail address of the student.
Application date: Date and time of application.
Course name: The name of the educational course taken.
Attendance period: Attendance period of the educational course.
Attendance fee: The amount required for attending. Even if the price increases after the application, it will be the amount at the time of application.
Related ID: ID indicating affiliation. For example, 20000037 for an employee of A Corporation.
Educational group ID: ID indicating the educational group, for example, 2000009 if applying for a lecture provided by the English language study group.
Main application: Whether or not this application has been made.
By configuring the application history table 20D in this way, it is possible to quickly display the application history for each educational organization or company, and to confirm all students.
[0047]
With the above-described table structure, the user table 20A managed by the system management company, the course table 20B managed by the educational organization, and the company recruitment course table 20C managed by the educator are mutually linked and used effectively. Can be.
[0048]
Each field of each table is defined as an appropriate type such as an integer (integer type) for an ID and a character type for a name. In addition, although each ID is configured by a numerical value, for example, the user ID and the like may be set to an easily memorable ID by allowing alphabets.
[0049]
Next, the access right of each user (a system manager, an educational organization, a company's educator, and a company's employee) will be described with reference to the explanatory diagram shown in FIG.
[0050]
The system manager can read and write all user information (user table 20A), read all course information (course table 20B), and read all applicant information (application history table 20D).
Educational organizations can read and write course information on educational courses provided by their organizations.
[0051]
The person in charge of education of the company reads all course information, reads the course information of the education course adopted by the company, reads and writes the course information of the company (company recruitment course table 20C), and the employees of the company You can read the information of the applicant who has applied for the course.
Employees of a company can read course information on education courses adopted by the company.
[0052]
By setting the access right as described above and constructing the system, the minimum necessary authority is given to each user, and data tampering due to carelessness of others and leakage of information to other companies are prevented. Can be.
[0053]
Next, the system management process executed by the control device 13 of the course guidance management server 11 according to the system management program 20E will be described with reference to the process flow diagram shown in FIG. 8 and the screen image explanatory diagrams of FIGS. .
[0054]
The WEB browser of the course information management server 11 (or the WEB browser of another PC terminal connected to the Internet 2) is started by the system administrator, and the URL (Uniform Resource Locator) for the system administrator, that is, the inside of the course information management server 11 Is accessed, the course guidance management server 11 displays an administrator login screen shown in FIG. 9 on the web browser (step n1). (Hereinafter, in the description of the system management processing, the display means the display on the monitor of the course guidance management server 11 or the monitor of the PC terminal).
[0055]
When the ID and the password are input to the system administrator with the keyboard and the OK button is clicked with the mouse, the course guidance management server 11 refers to the user table 20A, checks the registered ID and password, and determines whether or not the authentication is possible. (Step n2). If the authentication is unacceptable, an error message is displayed and the process ends (step n3).
[0056]
If the authentication is OK, the control panel shown in FIG. 10 is displayed. If the ID and password issuance is selected (clicked) by the system administrator (step n4), one of the ID password issuance screens of FIGS. One is displayed and an ID & password issuance process is executed (step n5).
[0057]
Here, in the control panel of FIG. 10, if an organization for an educational organization is selected, an educational organization (FIG. 11) is selected. If an organization for a company is selected, an employee of the enterprise is selected (FIG. 12). (FIG. 13) is displayed, and an ID & password issuance process is executed. The user data such as the ID and the password registered here are stored in the user table 20A (FIG. 3) of the course database 20.
[0058]
When the system administrator selects the all registered course list on the control panel (step n6), the control device 13 reads all the course data with reference to the course table 20B, and reads the all registered course list shown in FIG. It is displayed (step n7). When an education course name (course name) in the list of all registered courses is selected (for example, travel English conversation), a detailed screen (travel English conversation detail screen) of the selected education course is displayed as shown in FIG. .
[0059]
When the list of all applicants is selected by the system administrator on the control panel (step n8), the control device 13 reads all applicant data with reference to the application history table 20D, and displays all applicant data shown in FIG. A list (participant list) is displayed (step n9).
[0060]
When an application status management form is selected by the system administrator on the control panel (step n10), the control device 13 reads all the application data with reference to the application history table 20D and sets the group for each educational organization or company. Then, the application status management form is displayed (step n11), and the application status management form is displayed (for example, using a Group By phrase in SQL (Structured Query Language)) (step n11). Here, when the application data for each educational organization is selected, an application status management form (for each educational organization) shown in FIG. 17A is displayed, and when the application data for each company is selected, FIG. Display the application status management form (by company) shown in 17 (B)
By the above operations, the system administrator can perform user registration (issue ID & password), check all registered courses, check the contents of educational courses, check the list of all students, and check the application status by company or educational organization. Can be tolerated.
Based on these registration and confirmation processes, the system administrator can determine the amount to be charged such as the system usage fee, and can confirm the payment in conjunction with the payment of the tuition fee.
[0061]
Next, a course management process executed by the control device 13 of the course guidance management server 11 in accordance with the course management program 20F will be described with reference to screen image explanatory diagrams of FIGS. .
[0062]
When the course manager of the educational organization starts the web browser of the group PC 31 and accesses the URL for the educational organization, that is, the web page for the educational organization in the course information management server 11, the course information management server 11 starts the web browser. In response to this, the educational group login screen shown in FIG. 19C is displayed (hereinafter, in the description of the course management processing, display means display on the monitor of the group PC 31) (step p1).
[0063]
When the ID and the password are input to the course manager by the keyboard and the OK button is clicked with the mouse, the course guide management server 11 refers to the user table 20A to check the registered ID and password with the registered ID and password to determine whether the authentication is possible. (Step p2). If the authentication is unacceptable, an error message is displayed and the process ends (step p3). If the authentication is successful, the control panel shown in FIG. 19D is displayed, and the course manager selects a process (step p4).
[0064]
When the course registration form is selected by the course manager, a course registration form shown in FIG. 20 is displayed, and a course registration process is performed to allow the course manager to register an educational course (step p5). At this time, the course data of the educational course to be input and registered is added (insert into) to the course table 20B (FIG. 4) and registered.
[0065]
When the registered course list is selected by the course manager on the screen shown in FIG. 19D, the control unit 13 determines from the course table 20B (FIG. 4) the educational organization and the educational organization ID to which the course manager belongs. The matching course data is extracted, and the registered course list shown in FIG. 21 is displayed (step p6).
[0066]
The control device 13 allows the course manager to select a course name (course name) to confirm the course contents or to select a process to change the course contents by selecting a change button (step p7).
[0067]
When a course name (course name) is selected by the course manager (for example, introduction to English conversation is selected), a detailed screen of the course contents is displayed as shown in FIG. 22 (step p8).
[0068]
When a change is selected by the course manager (for example, a change in travel English conversation), the course data corresponding to the selected educational course is searched from the course table 20B (FIG. 4) using the course ID as a key (FindFirst). Then, a course change form is displayed as shown in FIG. 23 (step p9).
[0069]
If the cancel button is selected by the course manager, the process ends without any change to the course data (step p10), and if the update button is selected, the course ID in the course table 20B (FIG. 4). Is changed (updated) to the contents displayed on the screen (step p11). Here, the abolished course button on the screen is a button for deleting the corresponding course data, and if the check is selected when the update button is selected, the course data with the matching course ID is deleted. Delete.
[0070]
With the above operation, the course manager of the educational organization can access the course guidance management server 11 via the Internet 2 with the group PC 31 in the own organization and execute addition, change, and deletion of the course data. For this addition, change, or deletion, the course data that can be operated by the ID input in the login process is limited to the data of the own organization, so that the course data of another educational organization is erroneously edited, or another educational organization is edited. It is possible to prevent the course data from being edited.
[0071]
Next, the course narrowing process executed by the control device 13 of the course guidance management server 11 according to the course narrowing program 20G will be described with reference to the screen image explanatory diagrams of FIGS. 25 to 32 together with the processing flow diagram shown in FIG. .
[0072]
When the web browser of the corporate PC 51a is activated by the educator of the company and accesses the URL for the educator, that is, the web page for the educator in the course information management server 11, the course information management server 11 transmits the web information to the web server. The education staff login screen shown in FIG. 25 (E) is displayed on the browser (hereinafter, in the description of the course narrowing process, the display means the display on the monitor of the corporate PC 51a) (step s1).
[0073]
When the ID and the password are input to the educator by the keyboard and the OK button is clicked by the mouse, the course guidance management server 11 refers to the user table 20A and checks the registered ID and password against the registered ID and password to determine whether or not authentication is possible. (Step s2). If the authentication is unacceptable, an error message is displayed and the process ends (step s3).
[0074]
If the authentication is OK, the control panel shown in FIG. 25F is displayed, and the educator selects a process (step s4).
[0075]
When the course search form is selected by the educator on the control panel, the controller 13 displays the educator course search form shown in FIG. 26 (step s5). Note that the category here is simply described in HTML and is displayed statically.
[0076]
The controller 13 allows the educator to select a search method (step s6). If a keyword search in which a keyword is entered and a search button is pressed is selected, the course data is converted to a keyword by referring to the course table 20B. Extract based on The extraction is performed by extracting and executing the course data in which the input keyword exists in the data (the course name, the purpose, the curriculum, the special notes, the contents of the teaching material, the category, the additional keyword, etc.), and the extraction result is used as a search result. The course search result and the adoption form shown in FIG. 27 are displayed (step s7). At this time, the control device 13 also refers to the company adoption course table 20C, and if there is a course that has already been adopted, displays the check box of the adoption of the course that has been adopted.
[0077]
When a category is selected in step s6, the course table 20B is referenced to extract the course data in which a category matching the input category exists in the category item (for example, a language category). A list is displayed as shown (step s8). By classifying the course data in this way, it is possible to easily search for the desired course data. At this time, as in the case of the step s7, a check is made in the adoption check box of the course which has already been adopted and displayed.
[0078]
FIG. 27 shows a case where the registration button or the update button in FIG. 28 is pressed (step s9), and the course ID of the course data whose recruitment check box is checked is replaced with the company ID of the company to which the education staff belongs. At the same time, it adds (Add) to the company recruitment course table 20C, and deletes (Delete) a course that has been unchecked among courses that have already been checked (Step s10).
[0079]
When the reset button is pressed, the control device 13 refers to the company employment course table 20C, checks only the employment check box of the course currently adopted, and redisplays it.
[0080]
When the adopted course list display of FIG. 25 (F) is selected in step s4, data matching the company ID is extracted from the company adopted course table 20C, and the course matching the remaining course ID after the extraction is extracted. The course data in the table 20B is displayed as an adopted course list shown in FIG. 29 (step s11). At this time, all the adoption check boxes are checked and displayed.
[0081]
When the update button is pressed by the educator (step s12), the checked course is adopted, and the unchecked course is rejected, and the company adopted course table 20C is updated (step s13). In other words, the unchecked course is deleted (Delete) from the company adoption course table 20C, and only the checked course is updated to be stored in the company adoption course table 20C. When the reset button is pressed, all courses (that is, courses currently adopted) are checked and redisplay is performed.
[0082]
When a course name (course name) is selected on each screen shown in FIGS. 27 to 29, the contents of the course are displayed in detail as shown in FIGS.
[0083]
If the student list display shown in FIG. 25 (F) is selected in step s4, the data whose company ID matches the company ID of the person in charge of education with reference to the application history table 20D (FIG. 6). Is extracted and the student list shown in FIG. 32 is displayed (step s14).
[0084]
With the above operation, the educator of the company can carefully select and select the education course recommended for the employee of the company. At the time of this selection, a search by a keyword or a search by a category can be used, and a plurality of similar courses can be compared, so that it is possible to narrow down the search very conveniently.
[0085]
In the case of the conventional booklet, the description format was almost completely different depending on the educational organizations, but by displaying the course data of all educational organizations unified by item, the contents of the educational courses of multiple educational organizations This makes it easier to see, and it is possible to quickly and accurately compare and narrow down.
[0086]
Next, referring to the screen image explanatory diagrams of FIGS. 34 to 38 together with the processing flow diagram shown in FIG. 33, the narrowed course browsing process executed by the control device 13 of the course guidance management server 11 according to the narrowed course browsing program 20H. explain.
[0087]
When the employee of the company activates the web browser of the company PC 51b and accesses the URL for the employee, that is, the web page for the employee in the course information management server 11, the course information management server 11 instructs the web browser to execute the process shown in FIG. Is displayed (step t1). (Hereinafter, in the description of the narrowed-down course browsing process, display means display on the monitor of the corporate PC 51b).
[0088]
When the employee inputs the ID and password with the keyboard and clicks the OK button with the mouse, the course guidance management server 11 refers to the user table 20A, checks the registered ID and password, and determines whether or not authentication is possible ( Step t2). If the authentication is unacceptable, an error message is displayed and the process ends (step t3).
[0089]
If the authentication is OK, the employee course search form shown in FIG. 35 is displayed (step t4). Note that the category here is simply described in HTML and is displayed statically.
[0090]
The control device 13 prompts the employee to select a search method (step t). If a keyword search in which a keyword is entered and a search button is pressed is selected, the controller 13 refers to the course table 20B and narrows down by the course narrowing process described above. The course data is extracted based on the keywords in the selected course.
[0091]
In other words, the user refers to the related ID corresponding to the user's logged-in user ID from the user table 20A, and extracts the course data whose course ID matches the related ID from the course table 20B. In the extracted course data, extract and execute the course data in which the input keyword exists in the data (course name, aim, curriculum, special instructions, teaching material contents, category, additional keywords, etc.), and execute the extraction result. The course search result and the attendance application form shown in FIG. 36 are displayed as the search result (step t6).
[0092]
When a category is selected in step t5, the course data is extracted (for example, a language category) in which a category matching the input category exists in the category item with reference to the course table 20B. A list is displayed as shown (step t7). When a course name (course name) is selected on each screen shown in FIG. 36 or FIG. 37, the contents of the course are displayed in detail as shown in FIG. 30 and FIG.
[0093]
When the check box of the application is checked (for example, travel English conversation) on the screen shown in FIG. 36 or 37 and the application button is pressed, the control device 13 displays the attendance application form shown in FIG. 38 (step t9). ). When the reset button is pressed, all application check boxes are unchecked and the application is displayed again.
[0094]
Here, when the name and the like are input and the application button is pressed, the control device 13 executes an application process such as adding application data to the application history table 20D (insert into) (step t10). When the reset button is pressed, the input name and the like are blanked and displayed again.
[0095]
Through the above operation, the employee can find out and apply for an education course he / she wants to attend from among the education courses narrowed down by the in-house education staff.
[0096]
In each of the above processes, it is preferable to use a Cookie to identify the user after logging in. That is, by using the Cookie stored in the hard disk of each terminal (the group PC 31, the company PC 51a, the company PC 51b, and the terminal PC used by the system administrator), it is possible to recognize the terminal that has accessed and perform appropriate processing. it can.
[0097]
Although the categories are simply described and displayed in HTML, a category table is created in the course database 20 in consideration of extensibility, and the CGI is used to refer to the category table to search for a course search form for educators. May be dynamically generated. In this case, the addition, change, and deletion of the category can be performed accurately. For example, even though the category to be stored in the course table 20B has been added, the added category is not displayed on the screen due to forgetting to correct the HTML description. Can be prevented.
[0098]
With the educational course guidance system 1 constructed as described above, if an educational organization manages course data on its own educational course, it does not have to create a catalog (booklet) every year and start sales to a company. It is possible to receive a candidate for a course adopted by a company.
[0099]
In addition, there is no need to produce a catalog for each company, and the cost required for catalog production and printing can be drastically reduced, thereby achieving cost reduction. That is, although the same educational course requires processes such as design production, character proofreading, plate making, printing, and bookbinding for each catalog, only the characters of the course data to be registered in the course table 20B for each educational course need to be checked. That would be good.
[0100]
In addition, since the educator of the company can always browse the latest course data and refine it, there is no need to wait for the catalog of the educational organization to be completed, and a recommended course guide catalog to be distributed to employees Since the time required for the training can be reduced, it is possible to easily narrow down the education courses with plenty of time.
[0101]
It is also possible to provide flexibility when an educational organization wants to add, change, or delete a course scheduled to be opened after creating a catalog, or when adding or changing a course at the request of a company.
[0102]
In addition, employees are freed from the hassle of comparing and comparing several pages while viewing the pages of the recommended course guide catalog. It is possible to open multiple windows on a web browser and compare multiple educational courses side by side. It becomes possible.
[0103]
In this way, it is possible to greatly reduce the burden on the course managers, educators, and employees of the educational organization, and to provide an efficient and convenient guide environment for educational courses.
[0104]
Instead of storing the course data in the course table, an HTML sentence created by the course manager of the educational organization may be stored as text. In this case, the course manager of each educational organization can create a free web page layout.
[0105]
In addition, an item of “starting course / discontinued course” may be provided in the course table 20B so that when the discontinued course button is checked, the corresponding course data is made invisible on the company side. In this case, the temporarily interrupted course may be temporarily discarded, and when the course is restarted, the course can be returned to the open state by simply removing the check.
[0106]
The server that stores the course database 20, the server that can execute the CGI, and the WEB server that can be accessed by specifying the URL may be configured as separate servers, and may be configured to be able to communicate with each other. As a result, security can be maintained for each server, and data tampering or the like due to unauthorized access can be effectively prevented.
[0107]
The web server responds to a request from the web browser, such as by incorporating an IIS (Internet Information Server) instead of Apache into the course guide management server 11 and creating a program using ASP (Active Server Pages) instead of CGI. Can be transmitted.
[0108]
Further, encryption technology such as SSL (Secure Socket Layer) may be used for transmitting personal information at the time of user registration and transmitting ID and password at the time of user authentication. This makes it possible to prevent information such as an ID and a password from being leaked and to prevent unauthorized access to the course guidance management server 11.
[0109]
In addition, the list of all registered courses, all applicants, and search results are displayed in a system such as ascending or descending order, which includes the names of educational courses, students, educational organizations (implementing organizations), and tuition fees. It may be configured such that it can be rearranged and displayed in a form desired by an administrator, an educator, or an employee. This improves the convenience for system administrators, educators, or employees.For example, educators want to display courses with similar contents by tuition fee and narrow down the courses recommended to employees, or employees want to take courses It is possible to display an educational course according to a course period and make a course plan.
[0110]
The course database 20 may store not only data related to the guidance of the education course but also course data such as text, audio, and video used in the course. Thereby, depending on the education form of the course, the course from the guidance of the education course to the implementation of the education can be completed only by the education course guidance system 1. Further, a test function such as a completion test may be provided so that the educational effect can be determined.
[0111]
In addition, the system administrator, the educational organization, the person in charge of education, and the employee use the common ID and the common password for the ID and the password. However, the ID and the password may be issued for each individual.
[0112]
As a result, for example, it is possible to prevent the information leakage in a form in which the employees verbally confirm the ID and the password between the employees and are asked by a third party. Further, for example, if an employee is registered for each individual, it is possible to omit the trouble of inputting a name, an address and the like every time when applying.
[0113]
In addition, a configuration may be employed in which employees can list and confirm courses that they have applied for. Thereby, double application can be prevented.
[0114]
Further, when an application process is performed by an employee, an application confirmation may be transmitted to the employee by e-mail. Thus, the employee can confirm that his / her application has been executed normally.
[0115]
Further, the present application may be configured to perform the main application via an approval route on a company intranet by using the application confirmation in the E-mail. In this way, for example, in a case where the attendance application requires approval from a supervisor or the like in order to issue a subsidy in a company, the main application can be made after the necessary approval.
[0116]
In addition, the process of counting the employees who have completed this application in the application history table 20D and issuing a bill for each company or each employee can be executed by the course guidance management server 11 or a terminal PC that can access the application history table 20D. May be configured. In this case, if the request is made on a company basis, the billing process may be executed in accordance with the convenience of the company, such as making a request at the closing date or making a request each time this application is received. As a result, it is possible to reduce paperwork related to issuing a bill.
[0117]
In addition, not only the bill but also electronic settlement by electronic money may be executed, the tuition fee may be deducted from the company, and the course provision fee may be transferred to the educational organization. In this case, the system usage fee may be subtracted from the account providing fee to be transferred to the educational organization, and the system management company may acquire the system usage fee. As a result, the settlement can be executed quickly and accurately, and the paperwork can be reduced.
[0118]
Further, a discount table for providing a specific company at a discount price for each educational organization may be provided. As a result, the educational organization can provide the customer with a discount service, and the person in charge of education and the employee can browse the educational course in which the discount price is displayed.
[0119]
In addition, as a storage process, the application history table 20D (or the main application history table when the main application is performed separately) is used to collect application data on the closing date for each company and issue a bill for the tuition (or bank debit). Etc.) or an invoice for a tuition fee may be issued to a company or / and an employee when an application is received (or a fee may be charged by bank debit or the like). As a result, billing (collection) can be performed so that there is no omission or error from the application data, and the labor required for billing processing can be reduced.
[0120]
Further, an application possible period may be set, and the application possible period may be limited for each educational course. As a result, the educational organization can grasp the number of attendees before the course starts, and can smoothly give a lecture.
[0121]
Further, the level of the subject to be attended may be set for each educational course, and this may be displayed by a number, a character, a graph, or the like. As a result, for example, it is possible to display a difficulty level, a display for managers, a leader, or a general employee. Note that the attendee level may include a notation customized for a specific company in the education course.
[0122]
Further, the Internet 2 may be constituted by a dedicated line or a local area network such as an intranet.
[0123]
The course guidance management server 11 is not limited to a personal computer, but may be a workstation.
[0124]
Further, the course narrowing program 20G may be configured to be executed not by the control device 13 of the course guidance management server 11 but by the control device of the company PC 51a.
[0125]
Further, the narrowed-down course browsing program 20H may not be executed by the control unit 13 of the course guidance management server 11, but may be executed by the control unit of the company PC 51b.
[0126]
Further, the system management program 20E may be configured so that it can only be directly executed by the course guidance management server 11 and cannot be accessed from another PC terminal. Thereby, data tampering and leakage of personal information via the Internet 2 can be prevented.
[0127]
Further, the course management program 20F may be configured not to be executed by the control device 13 of the course guidance management server 11, but to be executed by the control device of the group PC 31.
[0128]
The course database 20 is not limited to the SQL database, but may be another database such as Oracle.
[0129]
Further, each table of the course database 20 may be divided for each educational organization, educator, and employee, or may be composed of a text file instead of the database table. In the case of using a text file, the database engine may be omitted, and the educational course guidance system 1 may be configured using CGI.
[0130]
The installation CD-ROM 21 may be a recording medium such as a floppy disk or an MO, or a hard disk of a computer connected to a network such as the Internet. In the case of a hard disk, it can be downloaded and installed.
[0131]
The group PC 31, the corporate PC 51a, the corporate PC 51b, and the terminal PC may be configured by a desktop computer, a notebook computer, a portable information terminal such as a PDA (Personal Digital Assistance), a mobile phone, or a plurality of these. When the course data is configured to be able to be viewed on a portable information terminal such as a PDA or a mobile phone, it is preferable to use PHP (Hypertext Preprocessor) or to determine the browser by using JavaScript.
[0132]
The narrowed course browsing process may be set so as to display not only the narrowed courses but also all courses and display whether or not the application is possible. In this case, the employee can view the course that cannot be applied, so that the employee can submit a request to the educator to be included in the narrowed course.
[0133]
In addition, each program (20E to 20H) is not limited to CGI and may be created in another language such as JAVA or C language.
[0134]
In addition, a recording medium such as a CD-ROM in which the course database 20 can be installed or executed together with the programs (20E to 20H) is created, and the recording medium is distributed to the company at intervals of, for example, every year or every six months. good.
[0135]
In this case, the recording medium can be used on a stand-alone PC, or can be used on an in-house PC having an intranet. This makes it possible to reduce or eliminate communication via the Internet 2 as much as possible, thereby improving the processing speed and the security level. Further, the program can be customized for each company, and can be incorporated into groupware such as notes.
[0136]
Further, in this case, it is possible to select a department or position by a check box, or to omit entry of an address or name by inputting an employee number, thereby improving the convenience of employee application. This improvement in convenience can be realized by customizing the attendance application form (FIG. 38) for each company if the system configuration uses the Internet described above with reference to the drawings.
[0137]
Further, each data recorded in the course database 20 may be configured to be output in a general-purpose format such as a CSV (Comma Separated Values) format based on the access right. This makes it possible for the company to freely use the data on a secondary basis, for example, to use the special course when communicating in an in-house newsletter.
[0138]
Further, in the distribution of the recording medium, the course database 20 may be configured to be updated by each educational organization by using the course guidance management server 11 storing the course database 20 and the group PC 31.
[0139]
Alternatively, the system management company receives the course database 20 independently created by each educational organization based on a predetermined format by data communication (or recording medium) or the like, and the system management company sends the course data of each education organization. The above-described recording medium may be collectively created and distributed to a company.
[0140]
As a result, the efficiency of creating the course database 20 storing the course data of each educational organization can be increased, and security can be ensured in a company using a recording medium instead of the Internet.
[0141]
In addition, education course,
1) Lecture-style education courses in which participants are gathered at the venue and educated,
2) Seminar-style education courses that invite instructors to enhance knowledge,
3) Education courses to send distance learning by sending educational materials such as videos and texts,
4) CBT (Computer Based Training), which mainly provides education using teaching materials based on CD-ROM,
5) WBT (Web Based Training), which allows you to learn with the latest teaching materials according to your progress at your free time using the network.
, Or a plurality or all of them. By providing various types of educational courses in this way, the number of educational formats that can be selected by educators and employees of the company can be increased, and the satisfaction of educators and employees of the company can be improved.
[0142]
In correspondence between the configuration of the present invention and the above embodiment,
The network of the present invention corresponds to the Internet 2 of the embodiment,
Similarly,
The server corresponds to the course information management server 11,
The database corresponds to the course database 20,
The access right setting means corresponds to the control device 13 that executes the system management program 20E,
The course maintenance means corresponds to the control device 13 that executes the course management program 20F,
The course narrowing-down means corresponds to the control device 13 that executes the course narrowing-down program 20G,
The course browsing means corresponds to the control device 13 that executes the narrowed course browsing program 20H,
The recording medium corresponds to the installation CD-ROM 21,
The terminals correspond to the group PC 31, the company PC 51a, the company PC 51b, and the terminal PC,
The narrowing down process corresponds to the course narrowing down process,
The browsing process corresponds to the narrowing course browsing process,
Education course guidance program corresponds to course narrowing program and narrowing course browsing program,
Course providers respond to educational organizations,
The education manager responds to the educator,
Students who wish to attend will respond to employees,
The present invention is not limited to the configuration of the above-described embodiment, but can obtain many embodiments.
[Brief description of the drawings]
FIG. 1 is a system configuration diagram of an education course guidance system.
FIG. 2 is a circuit block diagram of a course guidance management server.
FIG. 3 is a diagram illustrating a data structure of a user table 20A.
FIG. 4 is a diagram illustrating a data structure of a course table 20B.
FIG. 5 is an explanatory diagram of a data structure of a company employment course table 20C.
FIG. 6 is an explanatory diagram of a data structure of an application history table 20D.
FIG. 7 is an explanatory diagram of access rights of each user.
FIG. 8 is a processing flowchart showing the operation of the course guidance management server during the system management processing.
FIG. 9 is an explanatory diagram of a screen image.
FIG. 10 is an explanatory diagram of a screen image of a control panel.
FIG. 11 is a diagram illustrating a screen image of an ID password issuance screen for an educational organization.
FIG. 12 is an explanatory diagram of a screen image of an ID password issuance screen for a company representative.
FIG. 13 is an explanatory diagram of a screen image of an employee ID password issuance screen.
FIG. 14 is an explanatory diagram of a screen image of a list of all registered courses.
FIG. 15 is an explanatory diagram of a screen image of a detailed screen of an educational course.
FIG. 16 is an explanatory diagram of a screen image of a list of all applicants.
FIG. 17 is an explanatory diagram of a screen image of an application status management form.
FIG. 18 is a processing flowchart showing the operation of the course guidance management server during the course management processing.
FIG. 19 is an explanatory diagram of a screen image of an educational group login screen and a control panel.
FIG. 20 is an explanatory diagram of a screen image of a course registration form.
FIG. 21 is an explanatory diagram of a screen image of a registered course list.
FIG. 22 is an explanatory diagram of a screen image of a detailed screen of course contents.
FIG. 23 is an explanatory diagram of a screen image of a course change form.
FIG. 24 is a processing flowchart showing the operation of the course guidance management server during course narrowing processing.
FIG. 25 is an explanatory diagram of a screen image of an education staff login screen and a control panel.
FIG. 26 is an explanatory diagram of a screen image of a course search form for an educator.
FIG. 27 is an explanatory diagram of a screen image of a course search result and an adoption form.
FIG. 28 is an explanatory diagram of a screen image of a list display by category.
FIG. 29 is an explanatory diagram of a screen image of an adopted course list.
FIG. 30 is an explanatory diagram of a screen image showing details of course contents.
FIG. 31 is an explanatory diagram of a screen image showing details of course contents.
FIG. 32 is an explanatory diagram of a screen image of a student list.
FIG. 33 is a processing flowchart showing the operation of the course guidance management server during the narrowed course browsing processing.
FIG. 34 is an explanatory diagram of a screen image of an education staff login screen.
FIG. 35 is an explanatory diagram of a screen image of a course search form for employees.
FIG. 36 is an explanatory diagram of a screen image of a course search result and a course application form.
FIG. 37 is an explanatory diagram of a screen image of a list display by category.
FIG. 38 is an explanatory diagram of a screen image of a course application form.
[Explanation of symbols]
1. Education course information system
2. Internet
11: Course information management server
13 ... Control device
20… Course database
20E: System management program
20F… Course management program
20G: Course narrowing program
20H… Narrowing course browsing program
21: Installation CD-ROM
31… Group PC
51a… Company PC (for education staff)
51b: Corporate PC (for employees)

Claims (6)

Store multiple course data related to education courses in a database,
From the database, the education manager allows a narrowing process of narrowing down necessary course data by a course narrowing means,
An educational course guidance method for guiding the educational course by allowing the applicant who wants to attend the course data to be browsed by the course browsing means. Storing the database on a server,
Permitting the setting of the access right to the server by the access right setting means,
2. The education course guidance method according to claim 1, wherein the education manager and the student who want to take the course, to which a predetermined access right is set, are allowed to access the server with a terminal via a network. The course data as each course data provided by a plurality of course providers,
3. The education course guidance method according to claim 2, wherein the course maintenance company to which a predetermined access right is set allows addition, deletion, and / or change of course data to be provided by course maintenance means. The method for guiding an education course according to claim 1, 2 or 3,
An education course guidance system configured to be executable including the database, the course narrowing means, and the course browsing means. A narrowing-down process capable of narrowing down necessary course data from a database in which a plurality of course data related to an education course is stored;
An educational course guide program in which browsing processing capable of browsing the narrowed course data is set. A recording medium for recording the course data used in the method for guiding an education course according to claim 1, 2 or 3, and / or the program for guiding an education course according to claim 5.

Images