PowerPoint With VBA Project

The PowerPoint With VBA Project should be a small project that uses some of the VBA scripts discussed in class to control interactivity in your project. This project is designed to get you comfortable with using VBA in conjunction with PowerPoint. For this project, you are going to create a small PowerPoint presentation that is designed to be used interactively by a student sitting at a computer. You should incorporate at least four VBA "tricks" in your presentation from the things we learned in class. The kinds of "tricks" you should put in your project include:

These are the main things that we have learned how to do in VBA. Choose some or all of these or come up with some of your own.

This project should be built around a presentation of some sort. You might pick a topic that you want to teach your students and create something that you will use in your class, but don't worry about making it a perfect lesson. This project concentrates on technical features, not on content, so don't worry if your content is not significant. Once you have mastered some technical features, you will be able to incorporate them into other more significant projects (such as the final project).

Most of the scripts that you will need for this project can be taken with little or no modification from the VBA textbook. Don't let yourself get overwhelmed and think that you have to become a VBA expert. You should be able to use a few scripts fairly easily. If you get more involved with VBA, you will find that you can do even more.

Once you have completed the project, clearly list and enumerate the VBA tricks you used and how they can be accessed, and write a brief description of the tricks. This is strictly for grading purposes so that your instructor doesn't miss anything. Just because it is in your presentation does not mean that your instructor will know where to find it or recognize what it did.


What To Hand In

Note that not all the tricks listed are of comparable complexity. Using four simpler tricks (such as inputing a name to be used in feedback) will tend to give your project a grade of B, and using at least two more-complex tricks will tend to give your project a grade of A. Some examples of complex tricks include but are not limited to: menus with feedback, keeping score using any example beyond the simple multiple-choice question that can be answered once (e.g. allowing multiple tries, including short-answer questions, etc.), including a printable page with right and wrong answers (this can count as a separate tricks from keeping score so "complex" score-keeping with a printable page can count as two tricks), successfully using timing in a sophisticated way that goes beyond the simple HelloWaitGoodbye procedure.

Also note that if something is counted as a complex trick, it's parts cannot also be counted as simpler tricks. For example, a quiz that keeps score and allows multiple tries of each question could not count the score-keeping and multiple-choice quiz as separate tricks; it would be one complex trick.

Click here to view the grading rubric.

Return to ET620 Home Page.

This page was prepared by Dr. David M. Marcovitz.

Last Updated: May 9, 2013