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

Dim statements, 163–164
pro ce dure names, 162–163
stu dent an swers, 100–101
in
Sub statements, 163–164
variable names, 162–163
VBA stuff, 163–164
Chr$(13), 80, 83, 86
Classes, 35–37
Clip art. See Pic tures, in sert ing; Me dia,
pic tures
tying scripts to, 45
Clip or ganizer, 16, 20. See also Pic tures;
Sounds
Com ment char ac ter ('), 64, 160
Com ment ing out. See De bug ging,
com ment ing out
Comments, 64, 160–161
Com pile er ror. See Er rors, compile
Com pil ing, 161

---

Computerese, 35
Con cat e na tion, 54
Con di tion als, 56–58, 118–120, 164–166
Con stants, 66–67
color, 77, 84
in
MsgBox, 66–67
shape, 76
Con tin u ing lines. See Un der score
Copyright, 17, 18
Cre at ing shapes. See Shapes, add ing
Cur sor
ar row, 24
hand, 24
I bar, 27
plus sign, 25
text, 27
Cus tom an i ma tion, 71–72, 126, 127
Data struc tures, 134
DDD-E Model, 3–5
de cide, 3–4
de sign, 4
de velop, 4
eval u ate, 3–4
Debugger, 162
De bug ging, 150, 153–172
com ment ing out, 160–161
com pil ing, 161
with
MsgBox, 158–159
De cide. See DDD-E Model
De clar ing. See
Dim
De lay. See Tim ing
De let ing slides, 108
Design, 1, 2–11. See also DDD-E
Model
Design Tem plate (.pot) File. See File
types, De sign Template (.pot)
De velop. See DDD-E Model
Di a log box
Action Settings, 26, 28, 29, 44–45,
46
Cus tom An i ma tion, 71, 72
Do you like chocolate?, 67
en able mac ros, 38
Hello, 42
Insert Hyperlink, 22–23
Macro Se cu rity, 38–39
Pass word. See Di alog box, Project
Prop er ties
Pro ject Prop er ties, 47
Record Sound, 19
Save As, 30–31, 176
Set Up Show, 29–30
Sound Ob ject, 21
Dim, 51–53, 135, 168, 169, 170
Dirty, 128, 129–130
DoEvents, 126
Dot, 36. 79, 166
Drawing toolbar, 15, 45
Du pli cates, 168–169. See also Bugs,
com mon
mod ules, 168
pro ce dures, 169
vari ables, 169
Edit View, 13, 24, 27, 30, 45, 132, 133,
158, 182
Elements of an array. See Ar rays
Em bed ded el e ments, 15, 18. See also
Sounds, in sert ing; Pic tures,
in sert ing
Empty string, 56, 82
End Sub, 42, 162
Equal sign (
=). See As sign ment op er a tor
Error messages, 154, 155, 156, 157
Er rors. See Bugs; De bugging
com pile, 156 –158, 161
pre vent ing, 159
cap i tal iza tion, 162–164. See also
Cap i tal iza tion
in dent ing, 164–166. See also
In dent ing
red, 155–158, 161
run time, 161
testing for, 154–155
Escape key, 29, 30, 45, 126
Eval u ate. See also DDD-E Model;
Eval u a tion
Eval u a tion, 4–5
for ma tive, 4
summative, 4–5
Ex am ples
An i mal Pro ject tem plate, 174
in ter ac tive story, 80–81, 150
mys tery, 85–89
190 In dex

---

pool of questions, 146–150
asking how many questions, 149
keeping score, 149–150
quiz zes
mul ti ple-choice with mul ti ple
tries, 95–99
mul ti ple-choice with
scorekeeping, 93
multiple-choice with stars for
feed back, 70
print ing re sults, 102–108
printing re sults with ar rays,
139–142
ran dom prob lems, 145–146
ran dom prob lems with mul ti ple
tries, 146
short-an swer, 99–100
sim ple mul ti ple-choice, 55
Pick-A-Part ner, 176–182
ran dom prob lems, 144–145
signs of spring, 81–82
tutorial and quiz, 109–115
hiding the quiz but ton, 113–115
menu with feed back, 109–112
on the Web site, 185, 186
Fair use, 17, 18
Fair Use Guidelines for Educational
Mul ti me dia, 17
Feedback, 49, 54–55, 89, 92. See also
Pro ce dures, 
Feed 
back;
Re port ing scores
File types
Design Template (.pot), 175–176,
183
PowerPoint Pre sen ta tion (.ppt), 175
PowerPoint Show (.pps), 30–31, 32
Flowchart, 7–8
Force quit, 124
For ma tive eval u a tion. See Eval u a tion,
for ma tive
GetStarted, See Pro ce dures,
GetStarted
Going to slides. See Mov ing from slide
to slide
GraphicConverter, 16
Groups, 10
Ha waii, xii
Help, 168
Hiding ob jects, 68, 71, 75, 112,
113–115, 128
Hyperlinks, 13, 21–27, 34, 64–65
files, 24–25
Web pages, 24–25, 27
within a pre sen ta tion, 21–22, 26
Hyperspace, lost in, 5, 109
Hy per text 21–25, 45. See also
Hyperlinks
Icon, sound, 28
Icons, button. See Buttons, icons for
If. See Con di tional
nested, 119–120, 131, 165–166
Indenting, 120, 131, 164–166
In fi nite loops. See Loops, infinite
In her i tance, 36
Ini 
tial 
ize. See Pro ce dures,
Ini 
tial 
ize
Initializing, 68–70
In put, 49
InputBox, 50–51. See also
Pro ce dures, 
Question3;
Pro ce dures, 
YourName;
Quiz zes, short-an swer
Int, 143–144. See also Ran dom
num bers
In te ger. See Vari ables, type, In teger
Interactivity, xi, xii, 2, 13, 24, 34
In ter na tional So ci ety for Tech nol ogy in
Ed u ca tion, xi–xii
Keeping score, 93–99
mul ti ple tries, 95
Kiosk mode, 5, 13, 29–30, 32, 47, 155
Land marks, 109
LCase, 100–101
Learn ing en vi ron ments, 8
constructivist, 8
stu dent-cen tered, 8
Learning styles, 2
Link sounds with file size greater than.
See
PowerPoint, settings
Linked files, 15, 25
Lock pro ject for viewing, 47
In dex 191

---

Long. See Variables, type, Long
Loops, 56–57, 120–124
Do, 122–123
In fi nite, 124, 126
For Next, 120, 123
stop ping con di tion, 120–124
While, 56–57, 120–122, 124
Low er case, 100–101
LTrim, 101
Macro, run ning. See Pro ce dures,
run ning
Macro vi rus pro tec tion, 37–38
Ma nip u lat ing text, 68, 77–78, 79–89
adding text, 80
bold, 83
char ac ters, 83
color, 82–83, 84
copy, 84–85
count, 85
cut, 84–85
de lete, 84–85
italic, 83
length, 85
name of font, 84
para graphs, 83
paste, 84–85
range, 83
size, 84, 107, 142
un der line, 83
words, 83
Max i mum num ber of undos. See
PowerPoint, settings
Media, xii, 3, 10, 13
clip art, 16
pic tures, 16
sounds, 18–21, 28–29
spoken words, 2, 19
vid eos, 20
Me dia lit er acy, 10, 186
Menu. See Or ga ni za tion, menu
Metaphor, 1, 3, 4, 7, 9
Meth ods, 35–37
Mod ules
de let ing, 43
in sert ing, 42
mul ti ple, 43, 168
win dow, 43
Mo ti va tion. See Mul ti me dia, ben e fits
Mov ies. See Video
Moving from slide to slide, 64–66, 68,
92, 134
MsgBox, 66–68, 124
for de bug ging, 158–159
msoFalse, 68
msoTrue, 68
Mul ti me dia
benefits, 1, 2, 8, 9, 173–174,
185–186
def i ni tion, 2
Mu si cal In stru ment Dig i tal In ter face
(.midi or .mid), 20
Names
ob jects, 73–74, 130–132
slides, 66, 133–134
sounds, 19, 28–29
Nav i ga tion, 7, 64–66, 68. See also
Or ga ni za tion; Mov ing from slide
to slide
con trol ling. See Ki osk mode
Nested
If. See If, nested
New para graph. See
Chr$(13)
News print, 7
Nor mal View. See Edit View
Num bers
of ob jects, 71–73, 112
ran dom. See Ran dom numbers
of slides, 65–66, 74–75, 106, 133,
136
Ob ject-ori ented pro gram ming, 34–37
Ob jects, 35–37
add ing. See Add ing ob jects
ref er enc ing by name, 73–74,
130–131, 133
ref er enc ing by num ber, 71–73
OOP. See Ob ject-ori ented pro gram ming
Op tions. See PowerPoint, settings
Or ga ni za tion, 1, 3, 4, 5–6
linear, 5, 31, 34, 109
menu, 5–6, 22, 24, 34, 109–115
hi er ar chi cal, 5
templates for, 8, 174–175. See also
Tem plates
192 In dex

---

Pa ram e ters, 35, 124–125, 138, 161,
166–167, 168, 181, 182
de fault val ues, 167
in pa ren the ses, 181
MsgBox, 66–67
re quired, 167
Password, 47, 48
Paste key board shortcut, 25
Photoshop, 16
Pick-A-Part ner Pro ject. See Ex am ples,
Pick-A-Part ner
Pic tures
for mats, 15–16
.bmp, 15
.gif, 15
.jpg, 15
.tif, 15
in sert ing, 15–18
clip art, 15, 16–17
copying and pasting, 15, 17–18
drawing tools, 15
from file, 15, 16
tying scripts to, 45
Place holder, 81–82
Planning, 1, 3, 7
Pool of questions, 146–150
Poster board, 7
PowerPoint
set tings
Allow fast saves, 14
Browsed at a ki osk, 29–30
Link sounds with file size greater
than, 15, 20
Lock pro ject for viewing, 47
Maximum num ber of undos, 15
tra di tional fea tures, xii, 13–32,
148–149, 178
versions, 14, 34, 35, 51, 71–72, 107,
168
PowerPoint Show (.pps). See File types,
PowerPoint Show (.pps)
Pref er ences. See PowerPoint, settings
Printable page, 106–108
Print ing, 106–108
Pro ce dures
AddAnimals, 81
AddHello, 80
AddNextSlideButton, 179, 182
AddPlants, 81
AddRectangle, 75
AddStar, 156, 157, 158, 159, 160
AddWorkTogetherSlide, 179
Answer1AbrahamLincoln, 103
Answer1GeorgeWashington,
103
Answer2Four, 104
Answer2Two, 104
BadProcdure
BrickPig, 80–81
calling, 60, 180
Choc 
o 
late, 67
Do 
ing, 125
DoingPoorly, 55, 93, 96, 98, 103,
111, 144, 147
DoingWell, 54, 55, 60, 93, 96, 98,
103, 111, 144, 147
DoWeShowQuizButton, 114
EyeColor, 87
Feed 
back, 93, 96, 98
GetNameEmailIdea, 179
GetObjectName, 130, 132
GetSlideName, 133
GetStarted, 69, 70, 78, 87, 93,
95, 97, 103, 111, 114, 144,
147
GoToPartners, 179