Method of executing multi-player, simulation-based educational games from spreadsheets

11491399 · 2022-11-08

    Inventors

    Cpc classification

    International classification

    Abstract

    A method of converting one or more datasheets into a multi-player simulation-based game.

    Claims

    1. A system for transforming one or more electronic datasheets into an electronic multi-player simulation-based game, the system comprising: a processor, and a memory comprising computing device-executable instructions that, when executed by the processor, cause the processor to implement: a communications interface for accessing a simulation platform over a network; an admin user interface for displaying and interacting with the simulation platform; a plurality of player user interfaces for displaying and interacting with the simulation platform; a game builder module for transforming the one or more electronic datasheets to game media for the electronic multi-player simulation-based game, wherein each electronic datasheet comprises metadata including a table of factors, a table of actions, and a table of pages; wherein the game media comprises: an activity sheet created by the game builder module based on the table of actions; and a game result sheet created by the game builder module based on the table of factors; and a game framework module for automating the electronic multi-player simulation-based game so as to electronically generate a game play on the plurality of player user interfaces so as to create game results based on the activity sheet and the game result sheet, wherein the game framework module is configured to automatically determine a sequence of turns in the game play as a function of table of pages.

    2. The system of claim 1, further comprising a record module for converting the game results into an exportable record.

    3. The system of claim 2, wherein the sequence of turns created by the game builder module is based on a list of skills defined in a row-column format of the table of pages.

    4. The system of claim 3, wherein the game media further comprises an assignment of one or more teams created by the game builder module based on the table of pages.

    5. The system of claim 4, wherein each electronic datasheet further comprises a scoring instruction, and wherein the record module provides an electronic scoreboard on the plurality of player user interface for each team based on the scoring instruction.

    6. The system of claim 5, further comprising a collaboration module for generating, between the plurality of player user interfaces, a collaboration message of the game play, wherein the collaboration message comprises a plurality of shared text message.

    7. The system of claim 6, further comprising an assessment module for measuring an amount of time each player user interface generated an associated collaboration message.

    8. The system of claim 7, wherein the table of factors comprise a plurality of variables and equations, wherein the game framework module is configured to identify the plurality of variables and equations and create the activity sheet and the game result sheet therefrom.

    9. The system of claim 8, wherein the game framework module is configured to modify one or more of the variables of the plurality of variables the activity sheet and the game result sheet automatically in response to the plurality of player user interfaces interacting with the game play.

    Description

    BRIEF DESCRIPTION OF THE DRAWINGS

    (1) FIG. 1 is a diagrammatic view of an exemplary embodiment of the present invention, illustrating the distribution of work books in a classroom;

    (2) FIG. 2 is a diagrammatic view of an exemplary embodiment of the present invention, illustrating a yearly throughput of data for a facilitator without the invention and the impact of the invention on this effort;

    (3) FIG. 3 is a diagrammatic view of an exemplary embodiment of the present invention, illustrating various elements thereof;

    (4) FIG. 4 is a flowchart of an exemplary embodiment of the present invention, illustrating a game being built through the system application;

    (5) FIG. 5 is an exemplary view of a prior art spreadsheet or electronic worksheet;

    (6) FIG. 6 is a list of required information recorded in the metadata for the system application;

    (7) FIG. 7 is a flow chart of an exemplary embodiment of the execution of the present invention;

    (8) FIG. 8 is a list of description for the student result sheets;

    (9) FIG. 9 is a diagrammatic view an exemplary embodiment of the present invention, illustrating the class room using the game creation application;

    (10) FIG. 10 is a diagrammatic view of an exemplary embodiment of the present invention, illustrating the workings of the game with meta data;

    (11) FIG. 11 is a diagrammatic view of an exemplary embodiment of the present invention, illustrating the workings of the application described with spreadsheets; and

    (12) FIG. 12 is a diagrammatic view of an exemplary embodiment of the present invention, the workings of the application described with spreadsheets as information from each game is organized on a larger scale.

    DETAILED DESCRIPTION OF THE INVENTION

    (13) The following detailed description is of the best currently contemplated modes of carrying out exemplary embodiments of the invention. The description is not to be taken in a limiting sense, but is made merely for the purpose of illustrating the general principles of the invention, since the scope of the invention is best defined by the appended claims.

    (14) Broadly, an embodiment of the present invention provides a method of converting one or more datasheets into a multi-player simulation-based game.

    (15) The ordered combination of various ad hoc and automated tasks in the presently disclosed platform necessarily achieve technological improvements through the specific processes described more in detail below. In addition, the unconventional and unique aspects of these specific automation processes represent a sharp contrast to merely providing a well-known or routine environment for performing a manual or mental task.

    (16) Referring to FIGS. 1 through 12, the present invention may include at least the three systemic components: (1) a tool set to convert electronic spreadsheets into media for use as a multiplayer game; (2) a framework to automate the use of the converted spreadsheets in the classroom; and (3) a mechanism to collect game results, student actions, student assessments and other data from the execution of the game and convert into student records for integration with other learning management systems.

    (17) The three systemic components enable a facilitator (e.g., an educator) to deliver simulation-based games with far less effort and much higher quality assessment results than they could achieve without the present invention. The automation of the game follows a standard pattern of “Training”, “Game Play” and “Assessment.” The present invention relates to the complex algorithms and data driven flow software that automates this sequence and allows the facilitator to manage the execution flow. The present invention may include at least one computer with a user interface. The computer may include at least one processing unit coupled to a form of memory. The computer may include, but not limited to, a microprocessor, a server, a desktop, laptop, and smart device, such as, a tablet and smart phone. The computer includes a program product including a machine-readable program code for causing, when executed, the computer to perform steps. The program product may include systemic software which may either be loaded onto the computer or accessed by the computer. The loaded systemic software may include a systemic application on a smart device. The systemic software may be accessed by the computer using a web browser. The computer may access the systemic software via the web browser using the internet, extranet, intranet, host server, internet cloud and the like.

    (18) The present invention includes at least one critical datasheet that contains the “metadata” for the game execution. The structure and content of each critical datasheet are used by all of the execution elements to control the information that is provided to the user and the sequence of activities related to game initialization, user training, turn execution, game completion and student assessment.

    (19) A method of using the present invention may include the following. The systemic application disclosed above and in the figures may be provided. A facilitator can use the systemic application to create games or purchase games that are already built. They then load a list of students (typically from an existing learning management system) and then use the systemic software application to execute the game sequence. A game will typically last 4-5 hours which will include multiple turns for every team which will be spread across a week or sessions of a predefined time period, e.g., one hour, forty-five minutes, etc. The platform uses the metadata to determine which variables in the datasheet correspond to scoring variables and which single variable corresponds to the overall score. The software uses this information to show the progress of each team after each turn and overall winning team at the end of the game. Between each turn, the facilitator can review results and show a scoreboard indicating the progress of each team. Appropriate scoring variables are unique for each game scenario, but examples include Total Revenue, Total Profit, Total Population, Population Health, etc.

    (20) In addition to the execution of the basic game mechanics, the platform uses the metadata to control events in the game sequence where additional collaboration is provided by the platform in the form of text messaging and chat and through the use of video conferencing session. The metadata provides controls to the user to initiate or schedule collaboration sessions needed to complete that portion of the game.

    (21) When the game is done, the facilitator can download the student result data to assess the performance of each student in terms of academic achievement and interpersonal skills. These assessments include but are not limited to:

    (22) measurement of time spent by each student on each activity;

    (23) measurement of the percentage of time each student participated in shared activities;

    (24) measurement of the percentage of shared text message content was contributed by each student;

    (25) measurement of the score for each individual activity assigned to the student;

    (26) measurement of the relation of the shared activity scores for each team to which a student has been associated in comparison to the classroom average for those activities.

    (27) Measurement of relation of student survey results for each team to which a student has been associated in comparison to the classroom average for surveys for the same activities.

    (28) Additionally, while the primary focus of the invention is for use in educational classroom settings, the systemic software can be used for worker training, veteran return and prisoner release training scenarios. Facilitators can use the present invention to produce ready-to-run games for sale or trade with other educators.

    (29) The computer-based data processing system and method described above is for purposes of example only, and may be implemented in any type of computer system or programming or processing environment, or in a computer program, alone or in conjunction with hardware. The present invention may also be implemented in software stored on a computer-readable medium and executed as a computer program on a general purpose or special purpose computer. For clarity, only those aspects of the system germane to the invention are described, and product details well known in the art are omitted. For the same reason, the computer hardware is not described in further detail. It should thus be understood that the invention is not limited to any specific computer language, program, or computer. It is further contemplated that the present invention may be run on a stand-alone computer system, or may be run from a server computer system that can be accessed by a plurality of client computer systems interconnected over an intranet network, or that is accessible to clients over the Internet. In addition, many embodiments of the present invention have application to a wide range of industries. To the extent the present application discloses a system, the method implemented by that system, as well as software stored on a computer-readable medium and executed as a computer program to perform the method on a general purpose or special purpose computer, are within the scope of the present invention. Further, to the extent the present application discloses a method, a system of apparatuses configured to implement the method are within the scope of the present invention.

    (30) It should be understood, of course, that the foregoing relates to exemplary embodiments of the invention and that modifications may be made without departing from the spirit and scope of the invention as set forth in the following claims.