1. technology and computing
2. programming languages
3. visual basic

Welcome to
Transforming PowerPoint: Creating an
Interactive Environment using VBA
• Log onto computer
• Open Internet Explorer
• URL - http://dtsdtechtraining.wikispaces.com
• Open My Computer
– Go to Curriculum on dtsd files Drive (X:)
– Wiscount folder
– VBA PPT folder
Transforming PowerPoint: Creating
an Interactive Environment using
VBA
DTSD C.A.R.A.T.S. Teacher Training
Melanie Wiscount
mwiscount@hershey.k12.pa.us
Transforming PowerPoint
Creating an Interactive Learning
Environment
Some information in session is from:
• PETE+C 2008 – February 10, 2008
• Dr. P. David Lees
– Director, Instructional Technology & Distributed
Learning
• St. Joseph’s University
Objective
• Create interactive presentations
adding Visual Basic scripting and
tools in Microsoft PowerPoint to:
– gather student input
– create quizzes
– turn PowerPoint into more than just
a presentation of information
What is Presentation Software?
• Create interactive presentations containing
text, art, animation, and audio and video
elements
• Application program used to create
sequences of words and pictures
–
–
–
–
Informative presentations
Storytelling presentations
Persuasive presentations
Interactive presentations
What is MS PowerPoint?
• A presentation program developed by
Microsoft
• Part of the Microsoft Office system
• Runs on Microsoft Windows and the Mac OS
computer operating systems
• Most commonly-used presentation software
• Easy to learn & relearn
What is MS Visual Basic?
• An event driven programming language by
Microsoft
• Derived from BASIC
• Enables the RAD (Rapid Application Development)
– Of GUI (Graphical User Interface)
• Using:
– ActiveX controls (COM developed by Microsoft for
Windows platforms)
– VBA (present in Microsoft Office applications)
– VBScript (Visual Basic code object)
What is VBA?
• Visual Basic for applications
• Application edition of Microsoft's Visual Basic
programming language
What Are The Benefits Of Using
Presentations In The Classroom?
• Appeals to our digital native students
• Introduces and reinforces content with
meaningful graphic support
• Create interactive presentations containing
text, art, animation, and audio and video
elements
What Are The Benefits Of Using
Presentations In The Classroom?
• Present information or instruction to an entire class
• Create graphically enhanced information and
instructions for the learning centers
• Create tutorials, reviews, or quizzes for individual
students
• Display student work and curriculum materials or
accompany teacher presentations at parent open
houses or technology fairs
How to Use Interactive Presentations
in the Classroom
• Present Content in an interactive way
–
•
Student Interaction Creation
–
•
Teacher to Audience
Teacher to Student
Student Assessment
–
–
–
–
Type on Slides
Quizzes
Interactive activities
Application of knowledge
•
Student to Audience
PowerPoint + VBA
•
•
•
•
•
•
Ask and evaluate questions
Evaluate questions
Track responses
Store information
Provide feedback
Generate reports
Ready to Start
Let’s create Interactive
PowerPoint Presentations
using VBA!
• Open PowerPoint
• Start a New Presentation
• Save As VBA_PPT and save on Desktop
Visual Basic Application (VBA)
1. Design Form (Control Toolbox)
2. Set Properties (Properties)
3. Create Code (Visual Basic Editor)
Getting Started
• Controlling Navigation
– Turning on Kiosk Mode
• Enabling Macros
– Changing Security Setting
Kiosk Mode
• Controls navigation
• Viewers/Students navigate through
Buttons and Hyperlinks
• Only automatic animations will work
• Save presentation as a PowerPoint
Show - .pps
Kiosk Mode
1
2
1. Slide Show Menu
2. Select Set-up Show
• Click “Browsed at a Kiosk (full screen)” & OK
Security Settings –
Change Macro Settings
1
2
1. Tools Menu
2. Options
• Macro Security Button
• Choose Level – Medium or Low
ActiveX Controls
Fun with the Control ToolBox
Active X Control Toolbar
• View
• Toolbars
• Control ToolBox
Active X Control Toolbar
View
Code
Properties
Textbox
Option
Button
Check Command
Box
Button
Combo Spin
Box Button
List
Box
Label
Toggle Scroll
Button
Bar
More
Controls
Image
Type On Slides
Great Assessment Tool!
How to Create a “Type-On” Slide
Recording Responses during a
Live Presentation
Type on Slides
• Add a picture
• Add textboxes to label parts of the picture
Type on Slides
Find a picture that you would like students to
identify parts/components and paste it to
a slide
1. Draw Textbox Control beside each part to
identify
2. Click on Properties Control
Type on Slides
1. Draw Textbox Control
2. Click on Properties Control
Type on Slides
1. Select True in Properties for EnterKeyBehavior
and Multiline
Textbox
Control
Type on Slides
1.
Click on Label control & draw over Textbox Control
2.
Click on Properties & add text to Label Control Caption
property
In 2007, what was the special anniversary Hersheypark celebrated?
Type on Slides
1. Change the following
properties:
• Back color
• Font
• Fore Color
• Text Align
In 2007, what was the special anniversary Hersheypark celebrated?
Type on Slides
Type on Slides
1.
Click on Action Button & draw under Textbox Control
2.
Click on Properties & change Back Color, Caption, Font,
Fore Color
In 2007, what was the special anniversary Hersheypark celebrated?
Submit
Type on Slides
To add actions to the ActiveX controls:
1. Double-click the command button control
to display the Visual Basic Editor
2. Set a reference to the Microsoft Scripting
Runtime
– On the Tools menu, click References, and
then select the Microsoft Scripting Runtime
check box
Type on Slides
• Insert the code between "Private Sub
CommandButton1_Click()" and "End
Sub“
– Copy and paste the code in the .txt file
Type_On_Slide_VBA_Code
•
•
•
•
Click on SAVE & Close Visual Editor
Click on SAVE & Run the Show
Take the quiz
Look for results
Type on Slides
• How to improve quiz?
– Add Name Label & Textbox controls
– Add option button questions
• Add label
– May “Copy & Paste”
– Add option button controls
– Edit properties
•
Textbox - Select True in Properties for EnterKeyBehavior
and Multiline
– Edit code
VBA Scripting
Screen Shot of Visual Basic Editor
Visual Basic for Applications
• Object-Oriented Programming (OOP)
– Classes = Types of Things
– Objects = Specific Things
– Methods = What You Do With Things
Class -> Object -> Method
Cars = Class of Thing
Toyota Corolla = Specific
Object in Class
Driving in my car = Specific method to do
with my car
VB Keywords
• Sub = Subroutine
• Dim = Declared Variable
• Variable Types
– String
– Boolean (True or False values)
• ‘ before a comment (turns green)
Good Programming Practice
• Use LOTS of comments
– what your code does and why
• Comment each subroutine and function
with a description
– what it does
– what input and output it takes
Convert to VBA
Dim myCar as Corolla
myCar.Drive (“Hershey”)
Setting Variables
• myCar = Object of Class Cars
• myCar.Drive = Method/Action that can be done on
Object of Class Cars
• “Hershey” = the Argument for the Method –
Where I am driving to
40
Macros
• An action or a set of actions you can use
to automate tasks.
• Macros are recorded in the VBA code
VBA –Message Box
• Hold Alt and F11
• Insert Module – If not there
• Type
Sub SayHello()
MsgBox (“Hello”)
End sub – (Will Appear Automatically)
• Run Script
• Run Menu
Add VBA Script to Button
Assign the Hello macro to an action
button
• Draw Button from AutoShapes – Action
Buttons
• From Action Settings Select Run Macro
• Right Click on Button and Select Add
Text
• Add text to Action Button
VBA –Input Box
• Hold Alt and F11
• Insert Module – If not there Type
Sub YourName()
userName = InputBox(Prompt:="Type your name", _
Title:="Input Name")
End Sub
• Run Script
• Run Menu
Quiz
• See Examples
• Create your own Quiz with:
– Interactivity
– Feedback
– Results
– Print Report
Any Questions?
Thank you!!!