Scratch

Access database?

If you're referring to an outside program, you can't really do that--the best you can do is save results to a list and export as a .txt file 

As for the program itself, there are quite a few ways to accomplish this, either text-based (with a list displaying questions/answers) or with sprites (one that shows all the questions, and one per choice that shows all the answers) that are synchronized with broadcasts.

I'm heading to sleep soon, but I could probably make a quick prototype tomorrow if you want (if I'm not busy), unless someone else beats me to it first--there's a lot of helpful Scratchers ^^

Well, good luck with Scratch, and I'll see what I can do to help. 

mantral wrote:

Hi Guys

I am trying to find a quiz type game of multiple choice.

I am trying to create a quiz for my kid where in she has to choose the correct answer.

Get the score and possibly export or link to an Access database.

Thanks

I'll be able to create a template for you tomorrow if not tonight. I'll allow it to be customizable with lists.

Here you go!

To use it:
1. Go to the "stage".
2. Go to the bottom.
3. Click the very bottom script that says "Click this script if you want to clear all the questions and answer choices."
4. Make .txt files for each of the following:
Question
Answer (the correct one, either A, B, C, or D)
Answer1 (the first choice)
Answer2
Answer3
Answer4
Make them in the style of:

What is 2+2?
What is 3+3?

Each enter is a new question/answer.
5. One by one, follow these steps for the six lists listed above: Click the checkbox next to the name of the list (under the "variable" palette). Right click on the list (the one on the screen of the quiz) and click "import". Import the respective list. Uncheck the box you just checked to hide the list. Do this for the rest of them.
6. It should work. Try running it. (probably in presentation mode so your daughter doesn't mess with the scripts. It's the top rightest button on the screen, looks like a T.V.)

If it doesn't work, either because you don't know if you're doing it right or not, or if I made a mistake in the programming, just tell me what looks wrong and I will try to fix it.

If you want to know how things work, just ask me.

Also, to export the correct answers and stats:
1. After the quiz is completely over and the black "test over" screen appears, click the checkbox next to the name of the list, either stats or "chosen answer" (under the "variables" palette).
2. Right click the list and press "export".
3. Choose location.
4. Done. Make sure to recheck the checkbox by the list to hide it again.
Warning: the chosen answer will reset itself upon "green flag clicked". Make sure to export the list before pressing the green flag.
Tip: The stats is cumulative and will not reset itself unless you do (go to the stage, scroll to the second to last script, click it to reset), so you can export it at the end of the week, or something, or after 5 tries...

Note: Don't make the question/answers too long or else they go off the box/screen.

Have fun!

BTW, it's kayybee 

BTW again, "unless someone else beats me to it first". That someone is me, CPU 

Anyways, once you get the hang of using variables, lists, and operators in combination, you can make many things. You probably can get it yourself, but if you want I can tutor you. (which you probably don't need).

i made a quiz game in bingo which uploads the score to a mySQL database through php i will help you if you want...