How can I make student answers on a quiz user based?

Ask for Help
1

Hello everyone,
Again, I am part of a research team in my school this summer, and we are currently developing a chemistry app inspired by Duolingo. We’ve successfully set up bottom navigation tabs on our phone screens. Different items that include information on different chemistry topics.

Now, the part we have been working on has been a section where students are able to practice questions. This is how we’ve set it up (see pictures below.)

image
image494×980 35 KB

This is the data being displayed (image below):

image
image1398×307 50 KB

Basically my question is: is there any way in which the answers could be submitted based on the user? For example let’s say a student named Alex gets said question correct, but his peer Olivia gets it wrong. Could there be a way in which those choices stay user-specific?

By the way, I’m sorry if my question is kind of confusing. I’m just trying to reach out for help. Thank you for reading!

2

The simplest way to deal with this is to make the Response column User Specific. The only downside with that is that there would be no way to summarise or aggregate the responses from all users. I don’t know if that would be a problem?

3

I guess it might? Since the mentor of this project wants my group to develop someway to show a weekly leadership/ranking board. So I thought that first we need to understand how to compile user specific answers.

4

It’s not possible, so a different approach will be required.

I think what you need to do is separate the questions from the responses. That is, a separate table for responses, with one row per student, and a column that identifies the student. For the actual responses, there are two further options. One column would be to have one column for each response. That’s relatively easy to do, but would be a lot of columns and difficult to maintain - any time you added/edited/removed a question you’d need to modify the columns. A better way (and what I would probably do) would be to use a JSON structure to store all responses for each student in a single column. It would look something like this:

[
  {
    "question": "Type the symbol for bromine",
    "response": "Br"
  },
  {
    "question": "Type the symbol for selenium",
    "response": "Se"
  }
]

Glide provides some good tools for working with JSON. If you are not familiar with JSON, there are a few tutorials around to get you started.

1 Like