1 / 42

Creating Embedded Formative Assessment

Creating Embedded Formative Assessment. Dr. Steve Broskoske Misericordia University EDU 533 Computer-based Education. Outline. Review of Variables Personalizing CBT New object: InputBox Creating embedded assessment with variables Providing feedback with MsgBox Counting variable

tanaya
Download Presentation

Creating Embedded Formative Assessment

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. Creating Embedded Formative Assessment Dr. Steve BroskoskeMisericordia University EDU 533 Computer-based Education

  2. Outline • Review of Variables • Personalizing CBT • New object: InputBox • Creating embedded assessment with variables • Providing feedback with MsgBox • Counting variable • Working with conditional statements • Advanced MsgBox properties • Navigating

  3. Review of Variables

  4. What is a Variable? Review • 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”

  5. Declare a Variable Review • To use a variable, start by declaring it with a dim statement. • Dim variable_name As data_type long single Boolean string Make up a name for a variable. Use underscore (_) for compound names. Variable types are either text (string) or a numerical type.

  6. Local vs. Public Variables Review • 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.

  7. Concatenation with Strings Review • Add additional strings to a string variable.Dim age As Integer, maxcount As IntegerDim sentence As stringage = 5maxcount = 100sentence = “I am ” & age & “years old.”sentence = sentence & “I can count to ” & maxcount

  8. Do Not Duplicate Names Review • As you create names for procedures and variables, be careful not to: • Name 2 procedures by the same name. • Name 2 variables by the same name. • Name a procedure the same as a variable, or vice versa.

  9. Personalizing CBTwith an InputBox and a Variable

  10. Personalizing CBTwith an InputBox and a Variable • VBA allows teachers to personalize the application. • Let’s write the following procedures: • Remember user name (stores name in a variable). In the process, let’s compare local vs. public variables. • Prompt a user to enter his/her name. • New object: InputBox.

  11. Elements We Need • Sub Name()scripting goes hereEnd Sub • Dim userName As String • Place within procedure to create local. • Place on top of form to create public. • userName = “Dr. Steve” 'Comments after quote. • MsgBox ("Your user name is " & userName) • Must concatenate new text and a string variable.

  12. New Object • InputBox: Prompts user to enter something. Entered material must be stored in a variable. • Syntax:Variable = InputBox(Prompt:=“text”, Title:=“title bar text”)

  13. TRY IT • enterUserName() • printName() Enter User Name Print name using MsgBox

  14. TRY IT • Have students enter name using a public variable (you already scripted this code; reuse this macro). • Create personalized student feedback. Enter Name Using Public Variable (Use VBA already created.) Give PersonalizedPositive Feedback

  15. TRY IT • enterUserName() [Reuse this code. Realize that if this PP was one continuously running application, we would not have to prompt user to enter name again. The variable would already contain in.] • enterAge() • enterBooksRead() • printNameAgeBooks() [Use a MsgBox to print out personalized information.] Enter Name(reuse code) Enter Age Enter Books Read Print Name, Age, Booksin a Personalized Way

  16. Creating Embedded Assessment with Variables

  17. Importance of Embedded Assessment • In CBT, we want to have: • Make learners interact vs. just passively read. • Rehearse small chunk of material already learned. In a live classroom, teachers don’t simply teach at students. We provide examples, ask questions, review important items, and provide opportunities to rehearse and apply material.

  18. Providing Feedback withStandard PP Tools Pick the farm animal that gives us milk. Remember that graphics and even text boxes can have action settings applied. You could use buttons here in place of graphics.

  19. Feedback Screen INCORRECT. Please try again. Try Again

  20. Feedback Screen CORRECT. A cow provides milk. Good job! Continue

  21. Providing Feedback with VBA • With VBA, we can provide feedback by using MsgBoxes. • If we create a standard message, we can simply call the same procedure at different times without having to do extra work.

  22. Providing Feedback with VBA • enterUserName() [You already created this code. Just use what you already made.] • doingWell() • doingPoorly() Enter User Name (reuse code) Correct Response Incorrect Response

  23. Providing Feedback with VBA • You can now call these procedures from another slide. (Start the show from the previous slide so the student’s name will be available.) a. This is an INCORRECT response to this item. b. This is the CORRECT response to this item. c. This is an INCORRECT response to this item.

  24. Adding a Counting Variable • You can add a counting variable to keep track of how many times a student has taken to locate the correct response. • Dim tries As Integertries = tries + 1

  25. Adding a Counting Variable • Declare a public variable to keep track of tries. • Simply increment the counter in each procedure. • Later, we can take some action depending on the number of tries taken. (Requires more code.) • Note: It’s a good practice to initialize variables. We’ll look at this shortly. a. INCORRECT response to this item. Show Number of Tries to Teacher b. CORRECT response to this item. c. INCORRECT response to this item.

  26. Working withConditional Statements

  27. Conditional Statements • Much of the power that VBA adds to PP is the capacity to make decisions based on student input. • We can evaluate student input/responses and then make decisions and take actions.

  28. Conditional Statements • Syntax for a conditional statement:If condition Then codingElse codingEnd If

  29. Conditional Statements If tries>2 ThenMsgBox(“Statement”) ElseMsgBox(“Statement”) End If If overLimit=false Then code to do somethingElse code to do somethingEnd If

  30. TRY IT • Reapply macros already created to this slide. • displayProgress() • If tries is less than 3, then give positive feedback in a MsgBox. • If tries is anything else (meaning greater than 3), give a comment that the student needs improvement. a. INCORRECT response to this item. Review Progress b. CORRECT response to this item. c. INCORRECT response to this item.

  31. If Statement withAdvanced MsgBox • You can customize the buttons displayed in a message box to help gather user input. (MsgBox now functions like a simple InputBox.) • If you add an “IF…THEN” statement to evaluate this user input, you can then have more powerful decision-making at your disposal.

  32. Making Decisionwith Message Boxes • Displayed button options: • MsgBox(“question”, vbYesNo) • MsgBox(“question”, vbRetryCancel) • Just as with an InputBox, let a variable equal the input. • The variable will contain “yes” or “no” or “retry” or “cancel”.

  33. Making Decisionwith Message Boxes • Dim readyOrNot'Does not need type: constant.readyOrNot = MsgBox(“Are you ready to try the assessment?”, vbYesNo)If readyOrNot = yes ThenMsgBox(“Good. You are prepared.”)ElseMsgBox(“Sorry you do not feel ready.”)End If

  34. TRY IT • finishedWithHomework() • Create a variable homeworkDone to hold user input from the constant from vbYesNo in a MsgBox. • Give feedback with MsgBox using If…Then. Answer a Question

  35. Navigating • Action settings allow you to navigate to a specified slide. With VBA and conditional statements (If…Then), you can control where a student navigates next. • Syntax:ActivePresentation.SlideShowWindow.View. • GotoSlide (num) • Next • Previous

  36. TRY IT Navigate to the previous slide Navigate to the next slide Navigate to a numbered slide

  37. TRY IT • Question 3: Incorrect Correct Direct Userbased on answer

  38. Assignments

  39. Assignment • Using VBA, create a brief assessment in PP with the following parameters: • 3 questions (items) • Each item can have 2 possible responses. a Possible answer number 1. b Possible answer number 2.

  40. Assignment • On the first slide, use an input box to enter the learner’s name in a public variable. • When the user clicks a response: • Navigate to the next slide to view the next question. • Increment a public variable that keeps track of how many questions the learner answered correctly.

  41. Assignment • On the last slide, create a button that provides personalized input: • Use a message box to display information. • List user’s name. • Display number of corrections that the user got correct.

  42. Next Week • Working with object properties. • More advanced work with variables. • Looping.

More Related