🚀 Build a Dynamic Quiz App with Google Sheets! (Admin + Student Login) | C50

An online quiz and assessment platform where the teacher decides what each student sits and the app handles the rest — timing, scoring, review and the record of who took what.

Every student gets their own paper

Allocate categories per student and they see only those; leave the allocation blank and they get everything. Set how many questions that student answers, and the quiz is drawn to that number. Two students opening the same link can therefore sit entirely different tests, which is how one deployment covers several classes.

Timed, with images

Each question runs a countdown — thirty seconds by default, set per category — and moves on by itself when time is up, whether or not an answer was given. Questions carry images, added by uploading a file or pasting an image URL, so diagrams, maps and photographs work as well as text. Students move back and forth with next and previous, and their answers are kept.

After the quiz

The review shows each question with the student's answer beside the correct one, unanswered questions left visibly blank, and the final score. Their profile then tracks average score, high score and total attempts, along with a quiz history listing category, date and score — and badges that arrive on their own for a first attempt, a perfect score, a run of quizzes and so on.

One account, one device

Each login is tied to an IP address, so a shared password is refused with a message saying the account is in use elsewhere. Logins are emailed, and a forgotten password is reset by the student with a one-time code sent to their email.

The admin side

Manage Questions loads a category and lets you add, edit and delete questions with their four options and the correct answer marked. Manage Users covers roles, contact details, allocated categories, question allowances and photos. Students upload their own profile picture from their side.