1 / 40

Advanced PowerPoint Techniques and Introduction to VBA Coding

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

tracen
Download Presentation

Advanced PowerPoint Techniques and Introduction to VBA Coding

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced PowerPoint Techniques and Introduction to VBA Coding Dr. Steve BroskoskeMisericordia University EDU 533 Computer-based Education

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

  3. Advanced PowerPoint Techniques to Deliver CBT

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

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

  6. Basics of Trigger Animation The cow jumped over the moon.

  7. Play on Trigger See the bee fly to the flower.

  8. DEMO: Trigger with Text Boxes Click an below to view its chemical formula. H2O Water. HCl Hydrochloric acid. Table salt. NaCl

  9. TRY IT: Trigger with Text Boxes Click an below to view its chemical formula. H2O Water. HCl Hydrochloric acid. Table salt. NaCl

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

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

  12. DEMO: Provide Feedbackwith Triggered Animation Which of the following is the correct chemical formula for water? HO H2O H2O2 Try again! Correct! Try again!

  13. 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!

  14. Introduction to VBA Coding

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

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

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

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

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

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

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

  22. 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”

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

  24. Variable Data Types

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

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

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

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

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

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

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

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

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

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

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

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

  37. Assignments

  38. Assignments • Set up PowerPoint so that you can access the VBA editor and access macros within PowerPoint.

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

  40. Next Week • Creating embedded formative assessment. • Working with variables. • Working with conditional statements. • Working with object properties.

More Related