Powerful PowerPoint for Educators: Using Visual Basic for Applications to Make PowerPoint Interactive

7
Quizzes and Tests
In tro duc tion
In Chapter 6 you learned a number of powerful tricks. In fact, you now have
most of the basic skills you need to create a wide range of in teractive projects. If
you fancy your self a pro grammer, you can stop here and fig ure everything else
out for yourself. However, since this book is for scripters, we will con tinue with
a few more tricks and many more examples.
In this chap ter you will learn about dif ferent ways to create quiz zes and
tests with VBA. We’ll start with sim ple mul tiple-choice tests, add scripts to keep 
score, give op tions for tests that only allow one try to get the right an swer or al-
low multiple tries, add short-answer questions, add a script that creates a new
slide with com plete test re sults suit able for print ing, and add a mul tiple-part tu -
torial that won’t let your students take the test un til they have completed the en-
tire tu 
torial. By the time you fin 
ish this chap 
ter, you will have the skills
necessary to cre ate tests in a variety of different ways.
Vo cab u lary
•
ActivePresentation.Slides.Add
•
numIncorrect
•
LCase
•
Round
•
numCorrect
•
Trim

---

Sim ple Mul ti ple-Choice Tests
In Chapter 2 you learned about but tons and hyperlinks. This gave you the
power to cre ate a simple mul tiple-choice test with feedback. With out us ing
VBA, you could create a text ob ject and type the question in the text ob ject. Be-
low the text ob ject, create but tons with pos sible answers. Link the button with
the cor rect an swer to a slide that has a text ob ject that tells the student that the an -
swer is correct. Link the but tons with the in correct an swers to a slide that has a
text ob ject that tells the student that the an swer is in correct. On the (cor rect and
incorrect) feedback slides, create a but ton that leads to the next question, and re -
peat these steps for each question. This works, but it is a lit tle bit cumbersome.
With a lit tle bit of VBA from Chap ter 4, you could eliminate the feedback
slides and use a simple