SAVE POWERPOINT QUIZ RESULTS TO EXCEL SHEET​

Screenshot 318 - SAVE POWERPOINT QUIZ RESULTS TO EXCEL SHEET​

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!

SHUFFLE QUESTIONS SLIDES & ANSWER ORDER RANDOMLY IN PPT QUIZ GAME​

shuffle slides

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.

POWERPOINT QUIZ GAME WITH TIMER

timer in ppt quiz - POWERPOINT QUIZ GAME WITH TIMER

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.

Interactive PowerPoint Quiz Game with Points and Scores

ppt quiz points score game - Interactive PowerPoint Quiz Game with Points and Scores

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.