Populate A PowerPoint Quiz From Excel With VBA
Import Questions & Answers of a Microsoft PowerPoint Multiple-Choice Quiz Game from Excel with VBA in just one click. Automate your PowerPoint Quiz Games today!
Import Questions & Answers of a Microsoft PowerPoint Multiple-Choice Quiz Game from Excel with VBA in just one click. Automate your PowerPoint Quiz Games today!
We will be exporting/sending the results of the PowerPoint Quiz to an Excel Sheet automatically. The excel sheet shall contain the name of the student which was inputted by them in the presentation along with their location.
We also send the number of correct answers, wrong answers, the percentage and points secured by the student to the same excel sheet.
However the best feature is that we export all the questions of the PowerPoint Slide along with the answer which was attempted by the student to the same excel sheet! All of this is done automatically!
We will be shuffling the order of the questions such that all the questions are shown to the students with no repetition. We achieve this by generating random orders and moving slides to a random position within a given range.
To generate the order of those multiple choice answer boxes, we rename those four boxes as “a1, a2, a3, a4”. And then, we make an array and shuffle that to get all the 16 combinations of “1,2,3,4”. Based on the order of the sequence, the answer boxes: “a1, a2, a3, a4” are arranged in slide-show mode.
As soon as the time limit is up, the student is redirected to their result slide report card. This brings excitement to the quiz game and allows the students to be more engaged and focused in their task of answering the questions prepared by the teacher in the PowerPoint Quiz Game.
Collect student’s name via an input field and use VBA to calculate percentages and generate a certificate in your PPT Quiz Game
In this PowerPoint Quiz Game, we will calculate the number of correct and wrong answers, total and passed questions and then generate the Percentage.
In this PowerPoint Quiz Module, we will be designing our module and adding an ActiveX Element – Label to keep count of the student’s score. The Label is placed inside a slide-master.
We increase the Points Label by 10 points every time a correct answer is pressed. We decrease the Points Label by 5 points every time an incorrect or wrong answer is attempted.
We also have a message box which will pop-up indicating whether your answer is correct or incorrect.