Forum Discussion

GustavoAngulo's avatar
GustavoAngulo
Community Member
10 years ago

Simple Game that saves data into a Spreadsheet - Try it !

Hi.

I am a graduate student in Educational Technology. Next October I will be participating in a conference on educational games.
My communication is about Educational Games Analytics. Basically I explain how you can save data on the use of a game and then do statistical analyzes that allows improve the game and know the performance of the players.

To illustrate the concepts I explain, I developed a simple game in SL2. I used triggers JavaScript to send data to a spreadsheet for statistical analyzes.

You can explore the game here (it's in French but easy to understand):

Bien se conduire - Drive well 

The spreadsheet where data is stored is this:

Google Drive DB - Game Analytics

Raw data are stored in the "DATA" tab. Then with Google scripts, data are separated into two tabs: men (Hommes), women (femmes) and people who did not give their sex (NRP). The calculations are made with google spreadsheet formulas in Totals tab (Totales).  Finals results are presented in dashboard tab (DashBoard).

It's funny to see our data recorded in real time !

Try it !

9 Replies

  • SerkanOkur's avatar
    SerkanOkur
    Community Member

    Hi Gustavo,

    the title got my attention but the game link doesn't work. can you update?

    Thanks.

    • GustavoAngulo's avatar
      GustavoAngulo
      Community Member

      Hi Serkan.

      Links have been updated.

      Thanks for your interest ;)

      Best,

      Gustavo

  • Oh no, Serkan!

    Hopefully Gustavo is still subscribed to get your reply here, but you are certainly welcome to reach out to the user directly via the 'Contact Me' option on the user profile if you do not hear back soon.

  • YaachYaach's avatar
    YaachYaach
    Community Member

    Hi Gustavo, could you tell us about the integration you did to send data from the game to Google Sheets.

  • Hi, Yaach.

    Gustavo might not be subscribed to this discussion, but you're welcome to contact them directly through their profile by clicking on their name and selecting Contact Me