Advanced PowerPoint Techniques - PowerPoint Presentation

Slide1

Advanced PowerPoint Techniques and Introduction to VBA Coding

Dr. Steve Broskoske

Misericordia University

EDU 533 Computer-based EducationSlide2

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.Slide3

Advanced PowerPoint Techniques to Deliver CBTSlide4

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.Slide5

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.)Slide6

Basics of Trigger Animation

The cow jumped over the moon.Slide7

Play on Trigger

See the bee fly to the flower.Slide8

DEMO: Trigger with Text Boxes

Water.

H

2

O

HCl

NaCl

Hydrochloric acid.

Table salt.

Click an below to view its chemical formula.Slide9

TRY IT: Trigger with Text Boxes

Water.

H

2

O

HCl

NaCl

Hydrochloric acid.

Table salt.

Click an below to view its chemical formula.Slide10

DEMO: Trigger with Buttons(Provide Options to Learner)

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

See the definition.

Read more about it.

See a picture.

Answer a question.Slide11

TRY IT: Trigger with Buttons(Provide Options to Learner)

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

See the definition.

Read more about it.

See a picture.

Answer a question.Slide12

DEMO: Provide Feedbackwith Triggered Animation

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

HO

H

2

O

H

2

O

2

Correct!

Try again!

Try again!Slide13

TRY IT: Provide Feedbackwith Triggered Animation

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

HO

H

2

O

H

2

O

2

Correct!

Try again!

Try again!Slide14

Introduction to VBA CodingSlide15

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.Slide16

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.Slide17

How VBA Works: The Basics

Step 1

: Type VBA code in the VBA editor.

Sub

DisplayMsgBox

()

MsgBox

(“Text in a message box.")

End Sub

“Sub” starts every VBA subroutine.

“

DisplayMsgBox

()” is the name of this subroutine.

“End Sub” finishes every VBA subroutine.

Place coding between “subs.”

Indent lines. Slide18

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.Slide19

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.Slide20

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.Slide21

TRY IT

Let’s type our first VBA coding, and make it work with a button.

Output some text

in a message box.

Try it again.Slide22

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”Slide23

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.Slide24

Variable Data Types

Data Type

Description

Range

Integer

16-bit integer

-32768 to 32767

Long

32-bit integer

±2 billion (10

9

)

Single

16-bit floating-point value

±3.4 x 10

38

Double

32-bit floating-point value

±1.8 x 10

308

String

characters/text

up to 2 billion characters

Boolean

true or false

false, true

Currency

fixed-point fractional value

±10

15

with 4 digits of precision

Date

date and time

Jan. 1, 100 to Dec. 31, 9999

Select specific data type to increase storage efficiency and to restrict type of data stored.Slide25

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.Slide26

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 Long

Dim n As IntegerSlide27

TRY IT

Declare a variable to hold a

whole number

.

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

text

.

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. Slide28

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.Slide29

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.Slide30

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 variable

in a message box. Slide31

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 String

userName

= “Dr. Steve”

MsgBox

("Your user name is " &

userName

)

Notice blank space. Slide32

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.Slide33

Concatenation with Strings

You can add additional strings of text to a string variable.

Dim sentence As String

Sub

addStrings

()

sentence = “Hi.”

sentence = sentence & “How are you?”

sentence = sentence & “Take care.”

End SubSlide34

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

.Slide35

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.Slide36

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.Slide37

AssignmentsSlide38

Assignments

Set up PowerPoint so that you can access the VBA editor and access macros within PowerPoint.Slide39

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

.Slide40

Next Week

Creating embedded formative assessment.

Working with variables.

Working with conditional statements.

Working with object properties.