Nigel Galbraith - Quiz Creator

Quiz Creator

This project is a self-contained quiz generator that allows questions, answers, and detailed explanations to be added through a structured Excel spreadsheet, then converted into a dynamic, interactive web-based quiz.

I created this tool to provide a simple, offline solution for quiz creation no need to sign up for third-party platforms or rely on internet connectivity. The ability to generate and run quizzes locally makes it ideal for personal study, classrooms, or environments with limited access.

Throughout my study, repetition and practice played a crucial role in helping me retain and apply new information. This project enabled me to create targeted quizzes tailored to my learning needs and pace. It gave me the flexibility to reinforce key concepts through custom questions and revisit topics as often as needed.

While the current version is built around CyberOps content, the design is adaptable users can easily modify or replace the spreadsheet to suit any subject area. Whether it's IT, science, languages, or general knowledge, the tool can be repurposed to match.

Beyond its practical use, this project served as a valuable way to apply and test the tools and skills I was learning throughout my coursework. It involved working with Python for data handling and conversion, Excel integration with pandas, web technologies like HTML, JavaScript, and JSON for the quiz interface, and user-focused design to ensure the experience was intuitive and engaging.

Update Custom Q&A

Add questions and answers to the spreadsheet. Each question includes multiple answers and an explanation of the correct answer.

Update the Webpage

Run the Python program located in the Python-Import folder called Python-Update-Webpage.py.

This script:

Installs the required pandas package if not already available,
Parses the Excel spreadsheet using import-Tool-Data.py,
Cleans and formats the resulting JSON using clean-Tool-Data.py.

Select a Quiz

To run the quiz open the index.html for the best experience, this quiz tool should be opened using Google Chrome or Chromium. Other browsers may cache JSON data differently, which can lead to some pages not being displayed. Using Chrome ensures the quiz always loads the latest data correctly.

Check Each Answer

After answering each question and pressing the "Submit" button, the quiz shows

If your answer was correct or incorrect
A short explanation to help you learn

Quiz Summary

Once all questions are answered, clicking "Submit Quiz" shows a summary of your results.

Custom Quizzes

Although the quiz currently uses CyberOps module questions, you can create new Excel spreadsheets for other topics. Update the Excel file path in import-Tool-Data.py to use the new dataset.