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.
   • The first part will allow you to have a cheat sheet. One 8 1/2 by 11 inch sheet of paper can be covered front and back with any notes you want. When you finish this portion of the test, you will turn in your test and put away or turn in your cheat sheet.

     One type of question you can definitely expect is that of modifying some VBA code that is in front of you so that it does something slightly different from what it does, and/or so it does something in a different way than it did it before.

     For example, the Cells(r, c) property is something I just learned this fall. You can use the Cells() like this to modify the 23 birthday's macro code: Yellow and No Fill and using Cells(row, column) for another approach to Coloring the repeated birthday's YELLOW.

   • The second part of the test will be closed book, no cheat sheet.

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
      3
     19
     29
     35
     45       
     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
    359       25-Dec   <------------ or 12/25 and Merry Christmas to you too! 
    361
   
   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
   31
   math-cs:~/web> 
   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
   365
   

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.