advanced powerpoint techniques and introduction to vba coding n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Advanced PowerPoint Techniques and Introduction to VBA Coding PowerPoint Presentation
Download Presentation
Advanced PowerPoint Techniques and Introduction to VBA Coding

Loading in 2 Seconds...

play fullscreen
1 / 40

Advanced PowerPoint Techniques and Introduction to VBA Coding - PowerPoint PPT Presentation


  • 194 Views
  • Uploaded on

Advanced PowerPoint Techniques and Introduction to VBA Coding. Dr. Steve Broskoske Misericordia University EDU 533 Computer-based Education. Outline. Advanced PowerPoint Techniques to Deliver CBT Using triggered animation to provide feedback and interactivity. Introduction to VBA Coding

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Advanced PowerPoint Techniques and Introduction to VBA Coding' - tracen


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
advanced powerpoint techniques and introduction to vba coding

Advanced PowerPoint Techniques and Introduction to VBA Coding

Dr. Steve BroskoskeMisericordia University

EDU 533 Computer-based Education

outline
Outline
  • Advanced PowerPoint Techniques to Deliver CBT
    • Using triggered animation to provide feedback and interactivity.
  • Introduction to VBA Coding
    • Set up.
    • How VBA works: The basics.
    • Variables.
    • Concatenation with strings.
introduction
Introduction
  • Not all CBT tasks will require VBA.
    • If PP can accomplish something without VBA, don’t reinvent the wheel.
    • Examples:
      • Triggering animations.
      • Providing basic interactivity on a slide (vs. just reading slides passively).
      • Navigating to various slides.
how to trigger animations
How to Trigger Animations

How to Do It

  • Animate an object as usual.
  • Specify a trigger object.
    • Select the drop-down arrow from the play-listed item. Select timing.
    • Select trigger--start on click of an object.
    • Select trigger object. (Realize that clipart will be named as a number.)
basics of trigger animation
Basics of Trigger Animation

The cow jumped over the moon.

play on trigger
Play on Trigger

See the bee fly to the flower.

demo trigger with text boxes
DEMO: Trigger with Text Boxes

Click an below to view its chemical formula.

H2O

Water.

HCl

Hydrochloric acid.

Table salt.

NaCl

try it trigger with text boxes
TRY IT: Trigger with Text Boxes

Click an below to view its chemical formula.

H2O

Water.

HCl

Hydrochloric acid.

Table salt.

NaCl

demo trigger with buttons provide options to learner
DEMO: Trigger with Buttons(Provide Options to Learner)

See the definition.

Text number 1. If a learner presses the first button, this text box will appear.

Read more about it.

See a picture.

Answer a question.

try it trigger with buttons provide options to learner
TRY IT: Trigger with Buttons(Provide Options to Learner)

See the definition.

Text number 1. If a learner presses the first button, this text box will appear.

Read more about it.

See a picture.

Answer a question.

demo provide feedback with triggered animation
DEMO: Provide Feedbackwith Triggered Animation

Which of the following is the correct chemical formula for water?

HO

H2O

H2O2

Try again!

Correct!

Try again!

try it provide feedback with triggered animation
TRY IT: Provide Feedbackwith Triggered Animation

Which of the following is the correct chemical formula for water?

HO

H2O

H2O2

Try again!

Correct!

Try again!

set up enabling macros
Set-up: Enabling Macros
  • To get VBA to work in PP, you must enable macros.
    • 2007: Office button – options – trust center – trust center settings:
      • enable all macros
      • trust access to VBA project module
    • 2003: Tools – options – security tab (or general tab in old versions of PP)Enable macros here.
set up finding the visual basic editor
Set-up: Finding theVisual Basic Editor
  • To begin, you need to be able to access the Visual Basic editor.
    • 2007: Office button – options – popular – show developer tab
    • 2003: Press alt-F11 OR tools—macro—VB editor

After entering the VBA editor, insert a module to begin.

how vba works the basics
How VBA Works: The Basics
  • Step 1: Type VBA code in the VBA editor.

“Sub” starts every VBA subroutine.

“DisplayMsgBox()” is the name of this subroutine.

Sub DisplayMsgBox()MsgBox (“Text in a message box.")End Sub

“End Sub” finishes every VBA subroutine.

Place coding between “subs.”

Indent lines.

how vba works the basics1
How VBA Works: The Basics
  • Step 2: Enter “action settings” in a button.
    • Leave the VBA editor.
    • Locate a button.
    • Select its action settings.
    • Under “run macro,” select a VBA subroutine.
how vba works the basics2
How VBA Works: The Basics
  • Step 3: Save a PP file that contains macros (VBA).
    • Select the following save type: macro-enabled presentation.
    • This saves as: filename.pptm
    • After the initial save, just hit the save button to save again.
coding tips
Coding Tips
  • Indent code.
    • Hit tab to indent coding. VBA coders indent coding to make it easier to read.
  • Take VBA editor suggestions.
    • As you type, the VBA editor will suggest words. To take a suggestion, press space bar.
  • Make comments.
    • The single quote character at the end of a line allows you to make comments that are disregarded by the editor.
try it
TRY IT
  • Let’s type our first VBA coding, and make it work with a button.

Output some textin a message box.

Try it again.

what is a variable
What is a Variable?
  • variable: Named location in program code for storing data. Analogous to the memory function on a calculator.

A variable in VBA is like saying in Algebra:

x = 5 OR x = “Dr. Steve”

declare a variable
Declare a Variable
  • To use a variable, start by declaring it with a dim statement.
    • Dim variableName As data_type

Make up a name for a variable. Use capital letters or underscore (_) for compound names.

Type of variable determines what kind of info. the variable will hold.

examples of variable declarations
Examples of Variable Declarations
  • How to declare a variable:

Dim n As Integer

Dim n As Single

Dim myName As String

Dim flag As Boolean

  • How to assign a value to a variable:

n = 15

n = 2.146

myName = “Dr. Steve”

flag = true

Most commonly used variable types.

examples of variable declarations1
Examples of Variable Declarations
  • You can also declare several variables in the same statement:

Dim n As Integer, myName As String

Dim a, b, c, n As Integer, total As LongDim n As Integer

try it1
TRY IT

Declare a variable to hold a whole number.

Assign a value.

Output in a message box.

Declare a variable to hold text.

Assign a value.

Output in a message box.

Declare a variable to hold a decimal number.

Assign a value.

Output in a message box.

Declare a variable to hold a true/false value.

Assign a value.

Output in a message box.

local vs public variables
Local vs. Public Variables
  • Where a variable is declared affects how it functions.
    • public variable: A variable that is declared as public is “alive” and available to all subroutines throughout the project. Declare a public variable at the top of the form.
    • private variable: A variable that is declared within one subroutine is “alive” only as long as the subroutine is running. Declare a private variable within one subroutine.
local vs public variables1
Local vs. Public Variables
  • Declare a variable according to when you need to use it:
    • Local: Declare a local variable if you only need to use this variable within this one procedure only (e.g., to count something while this procedure runs, or to temporarily store something).
    • Public: Declare a public variable if you want to assign or recall its contents out side of one procedure (i.e., on more than one slide). It’s like a calculator memory.
try it2
TRY IT

Declare a public variable.

Assign a value.

Output in a message box.

Declare a local variable.

Assign a value.

Output in a message box.

Output a variablein a message box.

concatenation with strings
Concatenation with Strings
  • If you want to add 2 strings together, use concatenation (the & character).
    • Add a string and a string variable.Dim userName As StringuserName = “Dr. Steve”MsgBox ("Your user name is " & userName)

Notice blank space.

try it3
TRY IT
  • ConcatLocal()
  • ConcatPublic()

Declare a LOCAL string variable.

Assign a value.

In msgbox, concatenate text and variable for output.

Declare a PUBLIC string variable.

Assign a value.

In msgbox, concatenate text and variable for output.

concatenation with strings1
Concatenation with Strings
  • You can add additional strings of text to a string variable.
  • Dim sentence As StringSub addStrings() sentence = “Hi.” sentence = sentence & “How are you?” sentence = sentence & “Take care.”End Sub
try it4
TRY IT
  • Declare sentence a public variable to hold text.
  • initializeSentence()
  • addToSentence()
  • printSentence()

Assign an initial value to sentence.

Output the value of sentence in a message box.

Add a value to whatever is already contained in sentence.

try it5
TRY IT
  • Declare public variables:
    • age and maxcount to hold whole numbers
    • longSentence to hold text
  • initializeVariables()
    • Assign values to age and maxcount.
  • makeLongSentence()
    • Print out child age and how high they can count in a sentence.

Initialize variables.

Print out sentence.

reminder saving
Reminder: Saving
  • Remember that you once you add VBA to PP, you must save the PP file as one that contains macros (VBA).
    • Select the following save type: macro-enabled presentation.
    • This saves as: filename.pptm
    • After the initial save, just hit the save button to save again.
assignments1
Assignments
  • Set up PowerPoint so that you can access the VBA editor and access macros within PowerPoint.
assignments2
Assignments
  • Download the homework assignment from our Web page. It asks you to do the following:
    • Non-VBA activities:
      • Trigger animations.
    • VBA activities:
      • Declare and output in a MsgBox the following types of variables: string, integer, short, and Boolean.
      • Concatenate a string variable.
      • Save the application appropriately.
next week
Next Week
  • Creating embedded formative assessment.
    • Working with variables.
    • Working with conditional statements.
    • Working with object properties.