810:022 Final Exam - Tuesday 12/12/2006 at 10 a.m.

As of 11:47 PM Friday 12/08 - this study guide is DONE

math-cs:~/web> date
               Fri Dec  8 22:46:48 CST 2006

  1. The test will be in two portions.

  2. Know the birthday problem. Go through the PowerPoint slide show and study the 23 birthday's problem in depth. We studied this at the beginning of the semester.

    As you go through the PowerPoint slides again, and the Notes for some of the slides, you should be able to get a fairly deep appreciation of the techniques used.

    Notice also the evolution of the application from displaying Repeat or no in column B, to showing the YELLOW for repeated birthdays and allowing the user to run the macro 100s of times and see the overall count of how many repeats. (48 out of 100, or 321 out of 600 for example).

    Could you put the actual mm/dd month/day date in column B when there is a repeated birthday in column A that is colored YELLOW?

    Birthday  MM/DD if repeat
      45       14-Feb   <------------ or 2/14 depending on which Excel Format
      60                                      (Look for Dinosaur Treats 
     ...                                       in 810:023 on or near 2/14/2007)
     359       25-Dec   <------------ or 12/25 and Merry Christmas to you too! 
    math-cs:~/web> cal 12 2006
       December 2006    
    Su Mo Tu We Th Fr Sa
                    1  2
     3  4  5  6  7  8  9
    10 11 12 13 14 15 16
    17 18 19 20 21 22 23
    24 25 26 27 28 29 30
    math-cs:~/web> cal -j 12 2006
           December 2006       
     Su  Mo  Tu  We  Th  Fr  Sa
                        335 336          <--------- Julian dates
    337 338 339 340 341 342 343
    344 345 346 347 348 349 350
    351 352 353 354 355 356 357
    358 359 360 361 362 363 364
  3. Know the Budget.xls Views problem with the CustomForms.txt handout. Know it very well. I may have you modify some of its code, or adapt some of its code. Of course also knowing how the Views were created (Detail, All, and Summary) and so on is part of your Excel expertise now. Edit menu, Go To command, Special Button, Constants (or Blanks). Who knew such things were possible? :-) Very few knew, but you do!

  4. Flash questions:

    1. Hour 8: Using Motion Tweens to Animate: Understand the three Quiz questions in the Workshop on pages 201 and 202.

    2. Hour 14: Making Buttons for the User to Click. Know question 3, page 320. Know what the four different states of a button are for. (Up, Over, Down, Hit). Know how to make an extra large Hit state for a button.

    3. Hour 6: Understanding Animation. Page 166. Understand and take the Quiz. Know the difference between a Keyframe and a Blank Keyframe.

    4. Hour 9: Using Shape Tweens to Morph. Know the Quiz questions on page 216.

    5. Hour 11: Page 244-6, Figure 11.3 Layer Properties That Help You Edit.

      • The Figure 11.3 quick overview properties you will be responsible for are: Layer Name, Show/Hide Layer, Lock/Unlock Layer, Normal Layer, Guide Layer(regular), Motion Guide Layer, and Guided Layers.

      • You do not need to know anything about Show Layer as Outlines or Masked Layers or Folders and Layer Folders.

      • You saw these demonstrated quite a few times in class. Just know what each is for and what the icon looks like for it or to invoke it (Hide or Show it, for example).

  5. Be able to write a function, a VBA function to do a simple task. Your function will have arguments (parameters). Be able to explicitly declare the TYPE for the arguments and for the function result in the Function header line.

    Here is an example you received as an email note, and is the function I meant to ask on test two, but accidently did not demonstrate the 3rd argument as whereToStop, cause I was too used to it as howMany (from the Mid() function which is built into Visual Basic for Applications.

    Function SliceOfFromWhereToWhere(theString As String, _
                                      whereToStart As Integer, _
                                      whereToStop As Integer) As String
         answer = ""
         For i = whereToStart To whereToStop
             answer = answer & Mid(theString, i, 1)
         Next i
         SliceOfFromWhereToWhere = answer
    End Function
  6. You do NOT need to worry about Hangman.xls. With the Wheel of Fortune guess the letters game and its array of letters and its 2D array (matrix) or what words have been played so far, you might be a bit too challenged and we did not spend enough time on it. So no worries, we'll skip that.