CN107562887B - Resource reference system and method for assisting PPT course preparation - Google Patents

Abstract

The invention relates to a resource reference system and a resource reference method for assisting PPT lessons preparation, which realize that multimedia resources are introduced into PPT courseware by one key and comprise a client, wherein a PPT plug-in program is installed inside the client; and the background server comprises an application program server, a database server, a file server and a streaming media server. The invention has the advantages of introducing high-quality multimedia resources and exercises by one key, achieves the effect of conveniently, quickly and directly introducing courseware by compounding the multimedia resources and the exercises, and realizes zero-distance contact between the resources and the classroom.

Description

Resource reference system and method for assisting PPT course preparation

Technical Field

The invention relates to a resource convenient and fast quotation system and method for assisting PPT course preparation, and belongs to the technical field of teaching assistance. In particular to a convenient resource reference system and a convenient resource reference method suitable for primary and secondary school teachers to prepare PPT teaching plans or prepare lessons.

Background

Under the condition of education informatization, enterprises or tutoring institutions for providing multimedia resources for teachers in middle and primary schools are many, but the enterprises or tutoring institutions can not directly apply the multimedia resources to the class. The traditional PPT document editing content is single in form, the reference operation of complex materials such as flash, video, sound and the like is complex, and the multimedia composite material cannot directly enter a PPT page and can only be combined by a teacher. If the page content is more, new pages need to be added continuously, and therefore the connection between the contents is cut off.

Disclosure of Invention

The technical problem to be solved by the invention is as follows: the system and the method have the advantages of introducing high-quality multimedia resources and exercises by one key, achieve the effect of directly introducing courseware by compounding the multimedia resources and the exercises conveniently and quickly, and realize zero-distance contact between the resources and a classroom.

The technical solution of the invention is as follows: a resource reference system for assisting PPT lessons preparation comprises a background server and a client, and is characterized in that: multimedia lesson preparation resources and exercises in various forms are stored in the background server; the multi-form resources and exercises refer to multimedia resources or exercises composed of one or more of characters, sound, flash, video, a single picture and multiple pictures;

the client internally installs a PPT plug-in which is integrated with the research and development of COM technology, ATL technology and database technology, calls multimedia lesson preparation resources and exercises in the background server through the PPT plug-in depending on personal authority, integrates the multimedia lesson preparation resources and exercises with a lesson preparation tool PPT, and then introduces the resources and the exercises into a new page of the PPT;

the PPT insert comprises: the system comprises an ActiveX control A used for interaction between a PPT plug-in and a user and an ActiveX control B used for persistence and display of teaching resources, wherein the control A needs to call a PPT development interface IRibbon extension to realize loading of a PPT menu and menu response, call a PPT development interface ICustomTaskPaneConsumer to load a resource list, and call an AddOLEObject interface in MSPPT. The control B needs to realize serialization, deserialization, persistence and display of teaching resources; the starting sequence of the PPT plug-ins is realized by controlling the registry entries, and the key value of the registry entry LoadBehavior is set to d '00000003', so that the PPT plug-ins can be automatically loaded when the PPT is started;

the background server comprises an application program server, a database server, a file server and a streaming media server;

the application server communicates between the client and the database server to provide resource retrieval and service processing services for users, and after receiving a user request from the client, the application server analyzes the received request, wherein the analyzed request comprises data and operation, and the data comprises: the method comprises the following steps of user data, subject data, chapter directory data, resource list data, resource index data and resource use condition data, wherein the operations comprise: add, delete, modify, and query; the application program server uses the operation and data in the analysis result to organize SQL sentences, connects the database server and sends the SQL sentences to the database server, the application program server receives the operation result returned by the database server, and the application program server sends the operation result to the client;

the database server is communicated with the application program server, provides and stores user data, subject data, chapter catalog data, resource list data, resource index data and resource use condition data, and provides addition, deletion, modification and query operations for the user data, the subject data, the chapter catalog data, the resource list data, the resource index data and the resource use condition data; the database server receives a connection request of the application program server and establishes connection with the application program server, the database server receives an SQL (structured query language) statement sent by the application program server, and the database server executes the SQL statement and sends an operation result to the application program server;

the file server is communicated with the client and provides storage service for the resources in various forms and the content of the exercises except the video class; providing uploading and downloading services of resources for the client; the file server receives the client uploading request, receives the resources uploaded by the client and stores the resources to the storage device of the file server; the file server receives the downloading request of the client, reads the resource file stored in the file server equipment and sends the resource content to the client;

the streaming media server is communicated with the client, provides storage service of the resources in various forms and video contents in the exercises, provides uploading service of the video resources and provides online on-demand service of the video resources; the streaming media server receives the client video resource uploading request and stores the uploaded video resources in the storage device of the streaming media server; and after receiving the on-line on-demand request of the client, the streaming media server sends a video stream to the client.

The invention discloses a resource reference method for assisting PPT lesson preparation, which comprises the following steps:

step S1, the client terminal transmits data to the application program server after acquiring the user name and the password, and the application program server analyzes the data to perform login authentication; after the authentication is passed, sending the analysis result to the database server; the database server calls user data according to the acquired analysis result and transmits the user data to the application program server, and the application program server analyzes the user data and transmits the user data to the client;

step S2, the client automatically loads the PPT plug-in when the user runs the PPT; after the PPT plug-in is started, the client requests chapter directory data from the application program server, the application program server analyzes the request and transmits the request to the database server, the database server returns the chapter directory data to the application program server, and the application program server transmits the chapter directory data to the client for selection by a user;

step S3, the user selects a chapter catalog, the client requests the resource list data from the application program server, after the client receives the resource list data returned by the application program server, the PPT plug-in analyzes the resource list data and displays the resource list to the PPT for the user to use; the PPT plug-in receives a request of a user for checking the resource, acquires resource index data stored in a resource list, and sends the resource index data to a file server for downloading request; after the client receives the resource content sent by the file server, the PPT plug-in decrypts the resource content, caches the resource content to a terminal computer, and displays the cached content to a user; when a user views the resources, the user can edit and modify the resources, and after the editing and modification, the display window is closed, so that the PPT plug-in automatically stores the contents edited by the user in a local cache;

step S4, the user refers to the resource, the PPT plug-in obtains the resource index data stored in the resource list, and the client sends the resource index data to the file server for downloading request; the client receives the resource content sent by the file server, the PPT plug-in decrypts the resource content and caches the decrypted resource content to the terminal computer; meanwhile, the PPT plug-in serializes data in the cache of the terminal computer into a binary object, and inserts the binary object into the PPT as a new page of the PPT; the object uses the resource content screenshot as an output picture; a user opens a resource editing window through resources in the PPT, the user performs arbitrary addition, deletion and modification operations on resource data contents, and after the user closes the display window, the PPT plug-in automatically stores the contents edited by the user in a local cache and updates serialized data in a binary object;

step S5, when the user shows the binary object generated by the PPT plug-in, the binary object will be serialized to the local cache, and the resource is loaded and displayed;

step S6, the PPT automatically saves the binary object generated by the PPT plug-in into the PPT document in the process of saving the PPT courseware; when a user opens the document in a computer with the PPT plug-in, the PPT plug-in can automatically analyze and load the binary object to support the display and modification functions of resources.

Compared with the prior art, the invention has the advantages that:

(1) the invention carries out deep secondary research and development by utilizing COM technology, ATL technology and database technology, changes the current situation that the research and development of resource libraries and question libraries and the course preparation tool PPT are completely split, integrates high-quality question libraries, resource libraries and the course preparation tool PPT, and realizes a set of integrated system for conveniently and rapidly quoting resources.

(2) The invention changes the existing situation that the traditional multimedia composite material can only split the content, and the PPT plug-in developed by COM technology, ATL technology and database technology is used to open the channels between the high-quality lesson preparation resource library and the question library and the lesson preparation tool PPT without affecting the normal use of the lesson preparation tool PPT in the current situation that PPT is displayed on different pages one by one, and allows the multimedia resources and exercises in the question library and resource library to be introduced into a single PPT page as an independent composite resource one key, and simultaneously realizes the normal play and use of the multimedia resources in the PPT playing state. On the basis of saving the training time of the teacher, the lesson preparation time of the teacher is greatly shortened, the lesson preparation burden of the teacher is lightened, and the direct first-line education service of the technology is really realized.

Drawings

FIG. 1 is a block diagram of the system of the present invention;

FIG. 2 is a system architecture diagram of the present invention;

FIG. 3 is a database entity relationship diagram of the present invention;

FIG. 4 is a system flow diagram of the present invention;

FIG. 5 is a data flow diagram of the present invention;

FIG. 6 is a user login of the present invention;

FIG. 7 is a chapter directory selection of the present invention;

FIG. 8 is a diagram of the present invention for finding and displaying resources and problems;

FIG. 9 is a diagram of the present invention referencing a resource and generating a PPT page;

FIG. 10 is a resource edit of the present invention;

FIG. 11 is a playing PPT of the present invention;

figure 12 is a diagram of the stored PPT of the present invention;

FIG. 13 is an example of lesson preparation resources in the present invention;

fig. 14 and 15 show examples of lesson preparation exercises according to the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

As shown in fig. 1 and fig. 2, a resource reference system for assisting PPT lesson preparation provided by an embodiment of the present invention includes:

and the client is internally provided with a PPT plug-in which is integrated with the research and development of a COM technology, an ATL technology and a database technology. And the PPT calls lesson preparation resources and exercises in the background server through the PPT plug-in unit depending on the personal authority of the client, integrates the lesson preparation resources and the exercises with a lesson preparation tool PPT, and then introduces the resources and the exercises into a new page of the PPT.

And the client is internally provided with the PPT and the PPT plug-in. And the PPT calls lesson preparation resources and exercises in the background server through the PPT plug-in unit depending on the personal authority of the client, integrates the lesson preparation resources and the exercises with a lesson preparation tool PPT, and then introduces the resources and the exercises into a new page of the PPT.

The PPT plugin comprises an ActiveX control A and an ActiveX control B, wherein the ActiveX control A is used for interaction between the PPT plugin and a user, the ActiveX control B is used for persistence and display of teaching resources, the control A needs to call a PPT development interface IRibbon extensivenity to realize loading of a PPT menu and menu response, call a PPT development interface ICustomTaskPaneConsumer to load a resource list, and call an AddOLEOBject interface in MSPPT. And the control B needs to realize serialization, deserialization, persistence and display of the teaching resources. The starting sequence of the PPT plug-ins is realized by controlling the registry key, and the key value of the registry key LoadBehavior is set to d '00000003', so that the PPT plug-ins can be automatically loaded when the PPT is started.

The background server is internally stored with multimedia lesson preparation resources or exercises in various forms, wherein the various forms comprise one or more of characters, sound, flash, video, a single picture and multiple pictures. The background server comprises an application program server, a database server, a file server and a streaming media server.

And the application program server is communicated between the client and the database server and provides resource retrieval and service processing services for the user. After receiving a user request of a client, an application program server analyzes the received request, wherein the analyzed request comprises data and operation, and the data comprises: the method comprises the following steps of user data, subject data, chapter directory data, resource list data, resource index data and resource use condition data, wherein the operations comprise: add, delete, modify, and query; the application program server organizes SQL sentences by using the operation and data in the analysis result, connects the database server, sends the SQL sentences to the database server, and sends the operation result to the client after receiving the operation result returned by the database server;

the database server is communicated with the application program server, provides storage for user data, subject data, chapter catalog data, resource list data, resource index data and resource use condition data, and provides operation for adding, deleting, modifying and inquiring the user data, the subject data, the chapter catalog data, the resource list data, the resource index data and the resource use condition data; the database server receives a connection request of the application program server and establishes connection with the application program server; after receiving the SQL statement sent by the application program server, the database server executes the SQL statement and sends the operation result to the application program server

The file server is communicated with the client and provides storage service for the resources in various forms and the content of the exercises except the video class; providing uploading and downloading services of resources for the client; the file server receives the client uploading request, receives the resources uploaded by the client, and stores the resources to the storage device of the file server; and the file server receives the downloading request of the client, reads the resource file stored in the file server equipment, and sends the resource content to the client.

The streaming media server is communicated with the client, provides storage service of the resources in various forms and video contents in the exercises, provides uploading service of the video resources and provides online on-demand service of the video resources; the streaming media server receives the client video resource uploading request, and the video resources uploaded by the streaming media server are stored in a storage device of the streaming media server; and the streaming media server receives the on-line on-demand request of the client, and sends the video stream to the client.

In this embodiment, the database server provides the client with the user rights, chapter directories, resource indexes, and the like according to the corresponding request. The file server provides resource library and question library materials, and the contents of the materials comprise characters, sound, a single picture, one or more of a plurality of pictures and a video packaging file. All material can be edited and modified. The streaming media server provides resource library and question library materials, and the content of the streaming media server comprises videos, flash and the like.

As shown in fig. 3, 4, and 5, a resource convenient reference method for assisting PPT lesson preparation is provided for an embodiment of the present invention, and includes the specific steps of:

step S1, as shown in fig. 6, the user inputs the account UserID and the password, clicks to log in, and the client transmits the account and password data to the application server. The application server analyzes the data to perform login authentication. And if the authentication is passed, the application program server sends the analysis result to the database server. And the database server calls the user data and the authority according to the acquired analysis result and transmits the user data and the authority to the application program server. And the application program server analyzes the user data and the authority and transmits the user data and the authority to the client. And if the authentication is not passed, prompting that the password of the account number is wrong.

In this step, the address of the server to which the client is connected may be configured by a configuration file (hlsdallconfig. ini) under the WINDOWS directory.

And step S2, after the authentication is passed, the client automatically loads the PPT plug-in program when the user runs the PPT program. And after the PPT plug-in is started, requesting the chapter catalog from the application program server according to the user authority data acquired during the previous login. And after receiving the user authority transmitted by the PPT plug-in, the application program server analyzes the user authority and transmits the user authority to the database server. The database server returns the corresponding chapter directory data including the chapter codes VCPID and (chapter name) VCPName to the application server according to the received user subject authority. And after receiving the chapter directory data, the application program server transmits the chapter directory data to the PPT plug-in. The PPT plug-in analyzes the received chapter directory data, namely determines the level and the sequence of (chapter name) VCPName display according to chapter code VCPID, and displays the analyzed level and the sequence to the user for the user to select. As shown in fig. 7, after the user selects the chapter directory to be used, the PPT plug-in transmits the chapter code VCPID corresponding to the selected chapter name VCPName to the application server, and the application server sends the chapter code VCPID to the database server to obtain the knowledge point code KPID corresponding to the chapter, generates the corresponding SQL statement according to the knowledge point code KPID, and sends the SQL statement to the database server to execute the query. And the database server inquires all problems and resources under the knowledge point according to the knowledge point code KPID, including problem indexes such as a problem number ProbID and resource indexes such as a resource number ResID, and returns the inquiry result to the application program server. And the application program server receives the query result returned by the database server and transmits the query result to the PPT plug-in, and the PPT plug-in analyzes the query result and displays the result in the PPT. As shown in fig. 8.

Step S3, after receiving a request of a user for checking resources or exercises, the PPT plug-in obtains resource index data stored in the resource list and transmits the resource index data to the file server, and the file server sends the resource data to the client according to the received resource index data. If the resource is a video, the file server transmits the video package file to the client, the PPT plug-in transmits the received video package file to the streaming media server, and the streaming media server transmits the video resource to the client according to the received package data. And the PPT plug-in decrypts the received resource data, caches the decrypted resource data to the terminal computer, and displays the cached resource to the user.

In this step, the user can view the resource or problem by double-clicking on the resource list or topic list. The PPT plug-in receives a request of a user for checking resources, a resource number or an item number can be obtained through a double-click object of the user, and the resource number or the item number is sent to a file server to request the downloading of resources or exercises; the file server sends the resource content or the topic content to the PPT plug-in according to the resource number or the topic number, and the transmitted content is encrypted serialized binary data; the PPT plug-in receives the serialized encrypted data, firstly decrypts the serialized encrypted data, then stores the decrypted data in an ActiveX control used for playing the resource, the ActiveX control carries out deserialization of the resource data, the deserialized data is stored in a cache of a client, and the ActiveX control loads the resource or exercise data in the cache and displays the resource or exercise data to a user. The user can edit the resources or the exercises by double clicking the ActiveX control, and when the editing window is closed, the ActiveX control can update the cache of the computer terminal and serialize new contents in the cache to the binary object in the ActiveX control.

In step S4, the user selects a resource and clicks the reference button. If the resource user has checked, the resource already exists in the client cache; if the referenced resource user is not checked, the PPT plug-in sends a resource number 'ResID' or a question number 'ProbID' to the file server to acquire the resource and cache the resource to the client. The PPT plug-in serializes the resources in the client cache into a binary object to be stored into an ActiveX control, and inserts the ActiveX control into the PPT to serve as a new page of the PPT; the ActiveX control generates a preview of the resource or problem as an output graphical screen of the ActiveX control. The output screen may be resized or moved according to user control. As shown in fig. 9.

The user can edit the resource by double clicking the binary object in the PPT through the mouse. The PPT plug-in intercepts mouse double-click messages of a user, acquires a binary object of the mouse double-click, deserializes resources in the binary object and stores the resources in the client cache. The PPT plug-in starts a resource editing window and loads resources in the client cache. And the user edits the resources, and closes the resource editing window after the editing is finished. And the resources are automatically stored in the client cache in the closing process of the resource editing window. The PPT plug-in serializes the resources in the client cache into the binary object. As shown in fig. 10.

In this step, inserting ActiveX control in PPT uses development interface AddOLEObject provided by PPT of microsoft.

Step S5, when the user shows the binary object generated by the PPT plug-in, the ActiveX control will automatically create an ActiveX control object, the serialized resources or exercise binary data in the ActiveX control will be deserialized to the computer terminal in the creation process, and the resources or exercise data in the local cache of the computer will be loaded to be displayed to the user after the completion of the deserialization data of the ActiveX control. As shown in fig. 11.

And step S6, storing PPT by the user, wherein the PPT storing process is consistent with the common PPT storing process, the serialized resources and problems are stored in an ActiveX control, and are automatically packaged into a PPT file in the PPT storing process. As shown in fig. 12.

In this step, the courseware saved by the saving method can be played and used on a computer without a client but with the PPT plug-in. When a user opens the document in a machine provided with the PPT plug-in, the PPT plug-in can automatically analyze and load the ActiveX control to support the functions of displaying and modifying resources and the like.

As shown in fig. 8, the PPT plugin calls the load PPT menu and menu response implemented by the PPT development interface iribbonextensability, and calls the load chapter resource list implemented by the PPT development interface icustomtaskpanneconsumer.

As shown in fig. 13, the PPT plugin calls the AddOLEObject interface in the msppt.

As shown in fig. 14, the PPT plugin calls the AddOLEObject interface in the msppt.

As shown in fig. 15, the PPT plugin calls the AddOLEObject interface in the msppt.

The above examples are provided only for the purpose of describing the present invention, and are not intended to limit the scope of the present invention. The scope of the invention is defined by the appended claims. Various equivalent substitutions and modifications can be made without departing from the spirit and principles of the invention, and are intended to be within the scope of the invention.

Claims (1)

1. A resource reference method for assisting PPT lesson preparation is characterized in that a resource reference system for assisting PPT lesson preparation is adopted, and comprises a background server and a client,

the client is internally provided with a PPT and a PPT plug-in which is integrated with the research and development of a COM technology, an ATL technology and a database technology; the PPT calls lesson preparation resources and exercises in a background server through the PPT plug-in unit depending on the client-side personal permission, and after the lesson preparation resources and the exercises are integrated with a lesson preparation tool PPT, the resources and the exercises are introduced into a new page of the PPT;

the PPT plugin comprises an ActiveX control A and an ActiveX control B, wherein the ActiveX control A is used for interaction of the PPT plugin and a user, the ActiveX control B is used for persistence and display of teaching resources, the control A needs to call a PPT development interface IRibbon extensivenity to realize loading of a PPT menu and menu response, call the PPT development interface ICustomTaskPaneConsumer to load a resource list, and call an AddOLEObject interface in MSPPT.

The system comprises a background server, a video server and a multimedia teaching preparation system, wherein the background server is internally stored with multimedia lesson resources or exercises in various forms, and the various forms comprise one or more of characters, sound, flash, video, a single picture and a plurality of pictures; the background server comprises an application program server, a database server, a file server and a streaming media server;

the application program server is used for communicating between the client and the database server and providing resource retrieval and service processing services for users; after receiving a user request of a client, an application program server analyzes the received request, wherein the analyzed request comprises data and operation, and the data comprises: the method comprises the following steps of user data, subject data, chapter directory data, resource list data, resource index data and resource use condition data, wherein the operations comprise: add, delete, modify, and query; the application program server organizes SQL sentences by using the operation and data in the analysis result, connects the database server, sends the SQL sentences to the database server, and sends the operation result to the client after receiving the operation result returned by the database server;

the database server is communicated with the application program server, provides storage for user data, subject data, chapter catalog data, resource list data, resource index data and resource use condition data, and provides operation for adding, deleting, modifying and inquiring the user data, the subject data, the chapter catalog data, the resource list data, the resource index data and the resource use condition data; the database server receives a connection request of the application program server and establishes connection with the application program server; after receiving the SQL sentences sent by the application program server, the database server executes the SQL sentences and sends operation results to the application program server;

the file server is communicated with the client and provides storage service for the resources in various forms and the content of the exercises except the video class; providing uploading and downloading services of resources for the client; the file server receives the client uploading request, receives the resources uploaded by the client, and stores the resources to the storage device of the file server; the file server receives a downloading request of the client, reads a resource file stored in file server equipment, and sends resource content to the client;

the streaming media server is communicated with the client, provides storage service of the resources in various forms and video contents in the exercises, provides uploading service of the video resources and provides online on-demand service of the video resources; the streaming media server receives the client video resource uploading request, and the video resources uploaded by the streaming media server are stored in a storage device of the streaming media server; the streaming media server receives an online on-demand request of the client, and sends a video stream to the client;

the database server provides the client user with the authority, the chapter catalog and the resource index according to the corresponding request; the file server provides resource library and question library materials, the contents of the materials comprise one or more of characters, sound, a single picture and a plurality of pictures and a video packaging file, all the materials can be edited and modified, and the streaming media server provides the resource library and question library materials, the contents of which comprise videos and flashes;

the method comprises the following steps:

step S1, the client terminal transmits data to the application program server after acquiring the user name and the password, and the application program server analyzes the data to perform login authentication; after the authentication is passed, sending the analysis result to the database server; the database server calls user data according to the acquired analysis result and transmits the user data to the application program server, and the application program server analyzes the user data and transmits the user data to the client;

step S2, the client automatically loads the PPT plug-in when the user runs the PPT; after the PPT plug-in is started, the client requests chapter directory data from the application program server, the application program server analyzes the request and transmits the request to the database server, the database server returns the chapter directory data to the application program server, and the application program server transmits the chapter directory data to the client for selection by a user;

step S3, the user selects a chapter catalog, the client requests the resource list data from the application program server, after the client receives the resource list data returned by the application program server, the PPT plug-in analyzes the resource list data and displays the resource list to the PPT for the user to use; the PPT plug-in receives a request of a user for checking the resource, acquires resource index data stored in a resource list, and sends the resource index data to a file server for downloading request; after the client receives the resource content sent by the file server, the PPT plug-in decrypts the resource content, caches the resource content to a terminal computer, and displays the cached content to a user; when a user views the resources, the user can edit and modify the resources, and after the editing and modification, the display window is closed, so that the PPT plug-in automatically stores the contents edited by the user in a local cache;

step S4, the user refers to the resource, the PPT plug-in obtains the resource index data stored in the resource list, and the client sends the resource index data to the file server for downloading request; the client receives the resource content sent by the file server, the PPT plug-in decrypts the resource content and caches the decrypted resource content to the terminal computer; meanwhile, the PPT plug-in serializes data in the cache of the terminal computer into a binary object, and inserts the binary object into the PPT as a new page of the PPT; the object uses the resource content screenshot as an output picture; a user opens a resource editing window through resources in the PPT, the user performs arbitrary addition, deletion and modification operations on resource data contents, and after the user closes the display window, the PPT plug-in automatically stores the contents edited by the user in a local cache and updates serialized data in a binary object;

step S5, when the user shows the binary object generated by the PPT plug-in, the binary object will be serialized to the local cache, and the resource is loaded and displayed;

step S6, the PPT automatically saves the binary object generated by the PPT plug-in into the PPT document in the process of saving the PPT courseware; when a user opens the document in a computer with the PPT plug-in, the PPT plug-in can automatically analyze and load the binary object to support the display and modification functions of resources.

Images