|Topic was automatically imported from the old Question2Answer platform.
Too long to read? You can skip directly to the question. Scroll down to → Question about Data collection
Important: Data collect as already been approved by the University’s Ethic comity
First, you must understand that we are not collecting sensible data, in fact we mostly need some data from the game itself. Nothing like credit cards and so.
We are creating a coop game that would facilitate and make more enjoyable the acquisition of music improvisation skills. It’s a card based coop game where you first have to choose some thematic cards and some constraint cards to finally improvise some music (on any instrument) about these cards.
So, if you select the “Kitten” theme card and the “2/4” constraint card, you must musically improvise something that correlates with the chosen cards. Your partner must properly guess the cards you previously chose. Then, it’s your partner’s turn. When enough cards have been guessed, you both win the game. But if the timer goes to zero, you both loose.
I may not be able to work on this project forever. Therefore, I need to find the easiest way to collect and modify data from a very easy to use db. (If a beginner coder works on the project, I want him to be able to understand and maintain the code).
Here is what I would like to do if possible. I’d like to use a service like:
- Google Sheet (from GDrive) or;
- Microsoft Excel (from OneDrive).
In the sheet, there would already be the names of the research participants. From this file, I’d like to be able to access the data and modify them from the game itself.
Ex: User enter his unique code in the game, the game would fetch the code in the Excel or Google Sheet DB. Then the user would play a game and some of its data would be written in the file. (Data examples : The chosen cards, the failed one, etc.)
This way, my boss would be able to generate some of his research statistics.
How would you consider achieving that?