IOT Project: QuizPi

A quiz made with Flask and Python, connected to a Raspberry Pi and a MySql database. The concept of the product is that you can play a quiz of 10 questions long, when you are done with the quiz you see your score. The quiz starts after you pressed the start button and you can watch your score after you pressed the stop button.

Step 1: Step 1: Parts

You need the following parts:

• Massive Arcade Button with LED - 100mm Red -> $ 12,95
• Buzzer 5V - Breadboard friendly -> $ 3,95
• Vilros Raspberry Pi 3 Ultimate Starter Kit -> $ 79,99
• Chipboard

Step 2: Step 2: Schematic - Wiring the Raspberry Pi

This is the schematic i used. There are no resistors in my schematic because the are built-in the massive arcade buttons.

Step 3: Step 3: Normalised Database Structure

First of all you'll need to create a new database on your Raspberry Pi as shown on the picture.

Step 4: Step 4: Make the Quizquestions

Here is the file with the data for the database. Import this data into your MySql database.

Step 5: Step 5: Make Your Flask App

When you imported all the data to your database you should upload it to your Raspberry Pi.

Then download all the folders from github, then upload all the folders to your Raspberry Pi.

Github link: https://github.com/lennert03/website

Then run the website.py file and surf to your Raspberry's Pi IP address followed by :8080 If everything went ok you should see the home page of the QuizPi.

Step 6: Step 6: Make the Enclosure

The dimension of my housing is 24 x 78 x 19, but you can choose the dimension that you want of course.

So first I made the four plates and then I drilled 2 holes in it for the buttons. And i glued them to stick to the plate.