Powerful PowerPoint Book Cover
Home
Buy the Book
Examples by Chapter
Examples from Real People
More Tricks
Errata
About the Author
Contact the Author
Other Resources
Powerful PowerPoint for Educators:
          Using Visual Basic for Applications to Make PowerPoint Interactive
          by David M. Marcovitz

Powerful PowerPoint Home Page

News Flash! Powerful PowerPoint for Educators, 2nd Edition, is on the way, due to be released in May 2012. It will be fully updated for PowerPoint 2010 and 2011 and include additional information on the basic level (explaining more non-VBA interactive features) and the advanced level (explaining a few more advanced VBA tricks).

This is the companion Web site to the book, Powerful PowerPoint for Educators: Using Visual Basic for Application to Make PowerPoint Interactive by David M. Marcovitz. This site contains examples from the text and examples from other contributors. If you do not own the book, click on the Buy the Book button on the left to find out how you can get it.

Click on the links below or the buttons on the left. Click:

  • Buy the Book - to find out options for purchasing the book.
  • Examples by Chapter - to find electronic versions of the examples in the book, suitable for downloading and editing for your own purposes.
  • Examples from Real People - to find examples from real people, including example made by the author's students and other contributors to this site.
  • More Tricks - to find more PowerPoint VBA tricks that were not included in the book (maybe in the 2nd edition).
  • Errata - to find corrections for any errors in the book.
  • About the Author - to find out information about Dr. David M. Marcovitz, the author of this book.
  • Contact the Author - to find out how to contact the author to ask questions or just to tell him how great the book is.
  • Other Resources - to find other resources about PowerPoint and VBA.

If you don't own the book, here is some detailed information about the book from the preface.

New Videos for Some 2007 Differences

PowerPoint 2007 brought about many changes in version 2007, including introducing some bugs. Some of that is discussed in the Errata section of this Web site, but I have not revised the book to update it for 2007 (and 2010). To hold you over until that happens, here are some videos that go over some things that might be helpful. Most of them relate to differences between 2007 and earlier versions.

Excerpts from the Preface (including an annotated Table of Contents)

Most educators have created simple presentations with PowerPoint. PowerPoint is a fine tool for adding media to a lecture, but it falls flat when creating interactive lessons for students to use while sitting in front of the computer. That is, it falls flat unless you use the built-in scripting features of PowerPoint.

Starting with PowerPoint version 97, every copy of PowerPoint comes with Visual Basic for Applications (VBA). VBA can be used to add to the functionality of Microsoft OfficeŽ applications, including Microsoft PowerPoint. With the advent of PowerPoint 97, teachers can put limited interactivity into their presentations using Action Settings, Hyperlinks, and buttons. These features allow you to

  • add buttons to control navigation (start your slide show with a menu, for example, rather than requiring linear navigation, from slide to slide to slide);
  • jump to other PowerPoint presentations, other files, or Web pages; and
  • create rudimentary multiple-choice tests (clicking on a button with the correct answer takes the student to a slide that says “correct,” for example).

While this interactivity is useful, it is also very limited. VBA extends this to nearly unlimited dimensions. With VBA, you can change the content and appearance of slides based on student input, ask for and process typed input, add additional slides, hide and show graphics, and much more.

“Wait!” I hear you cry. VBA is a sophisticated programming language. Can teachers become programmers? Certainly, many teachers can become programmers, but the goal is not to create programmers but rather scripters. A programmer learns all the subtleties of a computer language in minute detail. A scripter might learn some of the details of the language but, more important, learns a few easily modifiable scripts that can perform important tasks. Scripting is well within the reach of many teachers, and taking advantage of the power of authoring systems like PowerPoint is an important part of the International Society for Technology in Education (2001) standards for programs in technology facilitation:

  • Standard III.A.7-Use methods for teaching concepts and skills that support use of web-based and non web-based authoring tools in a school environment.
  • Standard III.C.1-Use methods and facilitate strategies for teaching problem solving principles and skills using technology resources.
  • Standard V.C.7-Use examples of emerging programming, authoring or problem solving environments that support personal and professional development

Scripting might not be a useful technique when used with a stand-alone programming language, but the real power of using VBA with PowerPoint is not merely that VBA is an accessible scripting language but that it is built into PowerPoint. One of my students created a presentation about Hawaii. It included pictures, videos, recorded voices, and links to Web sites. All of this used traditional PowerPoint technology (no scripting required). On top of that, it added an interactive menu and a quiz with feedback about how well the user did on the quiz. Building all of this from scratch with a programming or authoring tool could be an overwhelming task, but 95 percent of the presentation was done with traditional PowerPoint tools (things most teachers already know how to do or can learn within a couple of hours). When a few scripts are added on top of the traditional PowerPoint tools, the results are rich not only with media but also with interactivity.

Remember, the more you know, the more you can do. With a few scripts, you can add short-answer questions (with feedback about right and wrong answers) and keep score. Add a few more scripts and you can have a menu that keeps track of which sections of your presentation have been visited and only shows the button to take the quiz when all sections have been visited. Add a few more scripts and you can have the user type things that change the slides in the presentation. The possibilities are endless.

The more you know, the more you can do. And you can always add more traditional PowerPoint without knowing any more VBA.

I have been using this material (before writing a book about it) with my students, who are mostly teachers, enrolled in a graduate course in multimedia design for the classroom, for about four years. They have created powerful projects for their students (like the Hawaii project mentioned earlier). In addition, I have been speaking about this at conferences and workshops. The overwhelming reaction I get is, “That’s great! I didn’t know you could do that.”

While this book is not accessible for computer novices, teachers who are beyond the level of computer beginner can use this technology to create powerful material for their students, material that goes beyond a simple page-turner.

For the professional multimedia designer, PowerPoint might not be the right choice. However, expensive and complicated tools are not common in schools. Using PowerPoint as a framework, teachers are able to add as much or as little interactivity as their skills allow and their needs require. Thus, PowerPoint is an appropriate multimedia tool for teachers and a powerful addition to a multimedia design class.

This book can be used as a stand-alone book in a multimedia design class for educators or as a companion for books like Ivers and Barron (2002) or Agnew, Kellerman, and Meyer (1996), which focus on multimedia design and using multimedia projects in classrooms but do not deal with a specific technology for implementing the projects. It also stands by itself without a class. Anyone with basic PowerPoint skills can sit down with this book and begin to create powerful educational material for themselves, their colleagues, their students, or their own children.

Chapter 1 begins the book with some important principles of instructional design, including how to design your own projects and create assignments for your students to design their projects. If this book is used in conjunction with a book about design, the first chapter will provide an overview of what you will find in the design books, but if this book is used by itself, this chapter is very important. Jumping in and creating things is fine when you are playing around, but serious projects require some planning and design work, and Chapter 1 will give you a foundation in that.

Chapter 2 begins to explore some of the traditional interactive multimedia features of PowerPoint. Adding pictures, sounds, buttons, and hyperlinks is not difficult, but many PowerPoint users have never used those features before.

Chapter 3 introduces VBA. You’ll understand how VBA fits into the world of object-oriented programming and how that affects you as a scripter. As a scripter, you won’t have to understand all of VBA and object-oriented programming, but understanding objects and how to manipulate them will help you understand your scripts.

Chapter 4 begins the heart of the book as you start to learn about scripting with VBA. You’ll learn how VBA is connected to PowerPoint and how to write and run your first script. You’ll also learn about keeping your scripts private so your students can’t look for the answers in your scripts.

Chapters 5 and 6 build your bag of scripting tricks. As a scripter, you will be interested in taking scripts directly from these chapters and applying them to your own purposes.

While each chapter contains examples that you can use right away, Chapter 7 focuses on examples that you will be able to use to create quizzes and tests.

Once you have completed Chapter 7, you will have a large bag of tricks that you can use by copying scripts directly from the book and possibly creating some on your own. Chapter 8 describes some more tricks that you can use, particularly if you are ready to modify some of the ideas in the book for your own purposes. It ends with a powerful example that I use with my daughter as she is learning to read.

Once you have mastered a large bag of tricks, you might need some help correcting your mistakes. Whenever you write scripts, even if you just copy them from the book, you are likely to make a few mistakes. Fixing mistakes is called debugging, and you will learn some of the secrets of debugging in Chapter 9.

By the time you finish Chapter 9, you will be excited to create things yourself, but you might want to share your knowledge with your colleagues and your students. Some of them will share your enthusiasm and borrow your copy of this book (or better yet, buy their own copy) and dive right into powerful PowerPoint. Others won’t be ready for the technical challenge. Chapter 10 describes how you can use templates, so your colleagues and students can take full advantage of the power of VBA scripting without knowing any of it. You can use what you learn in Chapter 10 to provide a template for your colleagues or students with the scripting already done for them (by you).

When you have completed the book, you might not be an expert at using VBA to create powerful interactive multimedia projects, but you will have a large bag of tricks that can help you do more with technology to make you a better educator.


This page was created by Dr. David M. Marcovitz.
Last updated: October 10, 2011