810:022 Final Exam - Tuesday 12/12/2006 at 10
As of 11:47 PM Friday 12/08 - this study guide is DONE
Fri Dec 8 22:46:48 CST 2006
- 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.
- 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
Su Mo Tu We Th Fr Sa
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
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
- 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!
- Flash questions:
- Hour 8: Using Motion Tweens to Animate: Understand the three
Quiz questions in the Workshop on pages 201 and 202.
- 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.
- Hour 6: Understanding Animation. Page 166. Understand and take the
Quiz. Know the difference between a Keyframe and a Blank Keyframe.
- Hour 9: Using Shape Tweens to Morph. Know the Quiz questions on
- Hour 11: Page 244-6, Figure 11.3 Layer Properties That Help You
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
each is for and what the icon looks like for it or to invoke it (Hide or
Show it, for example).
- 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)
SliceOfFromWhereToWhere = answer
- 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.