Final exam study guide (Fall 1999)

  1. Practice questions for the final exam. There are 37 links from this practice questions exam review page. Many of these questions or questions inspired by these pages will be included on the final exam.

  2. Final will cover will cover Lessons 9, 10 and 11 of the textbook and related lab experieces and handouts. You have done the Invoice Maker user interface program as well as Rock, Paper, Scissors, so userforms and Lesson 11 experience is a cinch to be on the test.

  3. The test will cover your VBScript/gifmerge/PhotoShop/chaos/Unix/web page experiences. You now have experience with Frames and scripts and form elements and making web pages interactive.

  4. Here are some screen snapshots of code needed for reviewing the InStr, Left, Right, Len, Mid, Int and Rnd functions of VBA.

    • You should know what these 7 functions do.
    • The InStr, Left, Mid, and Right functions were used in my VBScript web page so that users could answer:
                 Ctrl + Shift + *    or
                 Ctrl+Shift + *      or
                 Ctrl+Shift+*
    
    Try the Mark's 1st example.  Tue/12/7 class. link to see it in action.
    
    Here is what the code looks like:
    
           correct = 0
           blankPosition = InStr(txtCurrentRegion.Value, " ")
           do while blankPosition > 0
              txtCurrentRegion.Value = Left(txtCurrentRegion.Value, _
                                                 blankPosition - 1) _
                                          &                         _
                                       Mid(txtCurrentRegion.Value, _
                                                 blankPosition + 1)
    
              blankPosition = InStr(txtCurrentRegion.Value, " ")
           loop
    
           txtCurrentRegion.Value = LCase(txtCurrentRegion.Value)
    
           If txtCurrentRegion.Value = "ctrl+shift+*" Then
              correct = correct + 1
           End If
    
  5. Review the racing rectangles game, so you are familiar with its techniques. Its a good example of VBA controlling and using objects in an application, whether it be spreadsheet cells or graphic objects like rectangles and lines.
    1. The user interface for racing rectangles. How do you declare a name for a rectangle or a cell or a range? Where does it show up?
    2. See another user interface snapshot, the exciting finish of the one of the races.
    3. See the RaceEm macro code.
    4. See the ResetRace macro. This little macro is easy enough to reproduce on an exam.