Multiple choice quiz retrieving questions and answers from google sheets or csv

MIT App Inventor Help
,
#1

Hello everyone
I have made a simple quiz with 4 multiple choice answers and at the end, it shows how many points you got from correct answers ( at the moment I have only 4 questions as a sample BUT my aim is to have let's say 30 questions from each category. it will have 5 categories)
my question is how can I retrieve the question, the possible answers, and the correct answers.
I have made a sample sheet with columns: question, possible answers,

block 2
block 2995×413 79.6 KB
block1
block1886×345 43.5 KB
block3
block3960×565 47.2 KB
csvfile
csvfile697×263 38.4 KB
and correct answer

I am showing all my code in blocks and my designer which includes a listview, a label that shows the text of the question, a label that shows if you win (invisible at the start), a label that shows up with the score at the end of the game and a button Ok to go on.

Any help it will be appreciated. i have seen a lot of thing in the forum but i got confused

#2

A Multiple Choice Quiz: How to work with the advanced features

Taifun

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by icon24 Taifun.

#3

See this video :wink:

Ignore the title, it covers getting all sheet content as well
(excuse the need to reload the companion, I only live streamed it earlier today)

Also:

Get a Single Cell from a Google Sheet

and

Use gviz to get and query google sheet data

Database. Tag with multiple data
#4

as @TIMAI2 already mentioned, use the Google Visualization API to query your spreadsheet, see also
https://puravidaapps.com/spreadsheet.php#select

to get the questions:
select A

to get the answers (and let me suggst to have the correct answer always in column B, you do not need an additional column F with the correct answers...)
select B,C,D,E

Taifun

#5

For more help you could watch today in Youtube

1 Like
#6

And i think @TIMAI2 will also be available to answer any questions after or during his presentation.

#7

The correct time is diplayed here
2021-02-07T11:05:00Z
Query a Google Sheet using Google Visualisation (gviz) and return results to App Inventor App by @TIMAI2
https://youtu.be/I_nRnsNSyQg

So for me it will start in 25 minutes already.

1 Like
#8

Greetings, I think that one of the main and potential benefits of quizzes done on mobile phones is that, when you change the screen or minimize it, or more clearly that they try to find the answer on another screen such as Google or chats, then the exam is closed and I can't enter again

#9

To find it out, use the ActivityChanged event from the tools extension

Taifun

1 Like
#10

Regards. the truth, I looked for it and I did not find it.
How can I get it?

#11

Read the large green box on the bottom of this page and find the Download link below that box

Taifun