Tweet

PowerPoint for Educators: How to Make Multiple-choice Quizzes with PowerPoint via VBA

Written by: sunny qing

Article Overview: PowerPoint is a great assessment tool to create quizzes. This article will teach you how to create multiple-choice quizzes in PowerPoint via VBA with step-by-step illustrations. The VBA feature in PowerPoint gives educators an accessible way to easily create interactive multimedia quizzes.

PowerPoint for Educators: How to Make Multiple-choice Quizzes with PowerPoint via VBA

PowerPoint is a multimedia courseware to create multimedia courses to enhance the classroom experience. Also, it is a great assessment tool to create quizzes. The VBA (Visual Basic for Applications) feature in PowerPoint gives educators an accessible way to easily create interactive multimedia quizzes. Here I will teach you how to create multiple-choice quizzes with VBA in PowerPoint with step-by-step illustrations.

Supposing you want to create a quiz with 10 multiple-choice questions and only one correct answer for each question. Take PowerPoint 2007 for example, here are the details.

Step 1 - New a blank presentation

Step 2 - Customize feedback to each question with macro

You may be confused with the first step because the first step in all of the related quiz tutorials online is creating questions and answers. In order to simplify the steps to create multiple-choice quizzes, in this tutorial, I bring forward the feedback customization.

1. Set security options

Before you can run VBA code, you need to set PowerPoint's security options to permit macros to run.

Click the Office button -> PowerPoint options.

On the left of the PowerPoint Options dialog box, Click Trust Center, then click Trust Center Settings on right.

Click Macro Settings on the left of the dialog then choose Disable all macros with notification.

2. Start the VBA Editor.

Please press Alt+F11 to start the VBA Editor.

3. Customize feedback to wrong answer and right answers

In the VBA editor, Choose Insert -> Module, and then insert a code module for feedback to wrong&right answers.

Customize feedback to wrong answers:

In the big blank space on the right, type the following 3 lines:

Sub Wrong()

MsgBox ("Sorry, that's not right. Please try again.")

End Sub

Customize feedback to right answers:

Sub Right()

MsgBox ("That's right! You are so smart!")

SlideShowWindows(1).View.Next

End Sub

This code for right answer is similar to the wrong answer, except for its "SlideShowWindows" line, which advances the quiz-taker to the next slide.

4. Return to PowerPoint from the VBA Editor

Please press Alt+F11 to return to PowerPoint. Leave the Visual Basic Editor open in the background. In PowerPoint, save the presentation, this will save the new macros as well.

Step 3 - Create questions and answers

1. Create question slides

Within PowerPoint, start a new slide using the Title Only slide layout. Type the first question in the title-text placeholder.

2. Add multiple-choice answers

From the Insert menu, click Autoshapes -> Action Buttons. Then choose the blank action button.

Resize and position the button on the slide.

Right click on the button, choose Add Text from the subsequent menu, and type the first answer. Now select the button, copy and paste the button for the remaining answers you'll need on the slide.

3. Add macro to answers

Right click on the button, select Hyperlink. The Action Settings dialog box will appear.

Choose the Mouse Click tab, and from the "Action on click" area, check the "Run macro" radio button and select "Wrong" macro from the drop-down list. Click OK. Repeat the same setting to other remaining answers.

4. Duplicate the slide to as many as 10 slides.

Duplicate the slide and substituent the questions and answers to other questions.

Repeat this step 3 to the right answers for each question, and select "Right" macro from the drop-down list.

Step 4 - Save the quiz presentation

Press F5 to preview the quiz presentation and save it to PPSX format. Now everything is ok, you create a quiz PowerPoint slideshow successfully.

Besides creating quiz with VBZ via PowerPoint, you also can make more interactive Flash quiz for your PowerPoint presentation with 3rd party Flah quiz maker that can generate stand-alone Flash quiz. Wondershare QuizCreator is such a Flash quiz maker to help educators create multimedia Flash quizzes for teaching.

Related Articles
  How to Convert PowerPoint to MPEG
  Main Approaches of PowerPoint to Video Solution
  Can Moodle Do A Good Job In Importing PowerPoint
  Convert Your PowerPoint to Podcast
  Three Ways to Convert PowerPoint to Video for Free

Article Tags: amp, assessment tool, blank presentation, blank space, center settings, choice quizzes, classroom experience, correct answer, interactive multimedia, multimedia courses, multiple choice questions, questions and answers, quiz, set security options, step 1, step illustrations, trust center, vba visual basic, visual basic for applications, wrong answer



Related Forum Posts
Re: Is A Business Plan A Waste Of Time? - If you require funding a business plan is an absolute must. A formal written business plan, not a PowerPoint slide show. A few yrs ago I attempted to start a brick and mortor, original start up and required $300K. When I learned I would need a business plan I panicked and put the idea to bed. Two yrs later the idea was aching to be born so I studied and researched and wrote my own bp. It took me only 3 wks from start to finish complete with all financials. When I took it to the SBDC the counslors were floored that I'd it myself with no canned templates or software. They loved it and sent me to local banks for funding. The loan officers I met with were thrilled that I came in with a complete, formal business plan. They said they were appalled at the number of people that walk in asking for loans to start a business and they didn't even bother with a bp. Since then I have always written my own business plans. When searching for franchises I wrote a bp for each franchise I was interested in to have cold hard facts in hand and know which was the most viable. Handy little things those dreaded business plans...
Re: Quote of the Day - "The only people witho - Thanks for sharing this Evan, there are some very powerful quotes in there, I particularly like this one:- You are now at a crossroads. This is your opportunity to make the most important decision you will ever make. Forget your past. Who are you now? Who have you decided you really are now? Don't think about who you have been. Who are you now? Who have you decided to become? Make this decision consciously. Make it carefully. Make it powerfully. regards, Mal.
List of a few legitimate online business - Well My main methods to make money so far are adsense,affiliate marketing and freelancing and I think these are some more sites that can help me to make some more money.Your reviews are welcome: ::linkworth dot com>This site is awesome and offer lots of ways to make money. ::mturk dot com>complete simple mini task and get paid ::microworkers dot com>complete simple mini task and get paid ::shorttask dot com>complete simple mini task and get paid ::istockphoto dot com>sell stock photos ::eHow dot com>Make money writing ::Bukisa>Make money writing ::Associate Content>Make money writing ::Triond>Make money writing ::fiverr dot com>$5 freelancing job ::cpalead dot com>make money by completing offer ::peerfly>make money by completing offer
Re: 10 Tips to Start an Online Business - [quote="Anya101":1y6il6zm] 5. Make it very easy for people to order your products. The easier the order process, the more orders you will get. Make sure your payment pages are secured. If you accept payment online, it is [/quote:1y6il6zm] *This* is very good advice. I went to a site a couple of weeks ago to order a DVD, an independent movie, and instead of having Paypal, I had to jump through hoops to sign up for their payment system. It would have taken me more minutes than I cared to spend, so I just didn't bother!
Re: May Traffic Drop Off from Google's Update - I feel that the best way to make your website click is to target both SEO and other marketing channels. In case it is not possible for website owners or webmasters to invest into other marketing channels, then they must make sure that they are following guidelines laid down by search engines. Whenever there is an update in algorithm, it is only done to filter out artificial websites from the search results. However , it is observed that on several occasions innocent people fall victim to the update in algorithm. If you have an article website and your member copy pasted article from some other website, there is very little you can do to avoid duplicate penalty. The latest tips to avoid your rankings going into roller coaster ride is to make sure :- a) That your website is having genuine and unique content b) Make sure you do not use any automated SEO tools. c) Make sure that your back linking pattern is not a pre-defined targeting same set of keywords again and again. d) Add useful content to your website every single week or fortnight ( if possible) e) Abstain from artificial keyword density f) Abstain from empty pages on your website or doorway pages with empty or duplicate content. g) Make sure you to not have HTML errors in your coding ( If your H1 tag is left open, then it can trigger SPAM ALERT on Google.)


Share this article with your friends. Fund someone's dream.

Leave a comment below or share on the left and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.

Tweet

Newsletter

Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!

Name:
Email:

Popular Articles

TRADE SHOW FOLLOW-UP: HOW MUCH IS TOO MUCH?

An Intelligent Contact Sheet

Are You Remarkable Enough?

Suggestions

Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.