Date: Wed, 01 Oct 2003 12:46:02 -0500 (CDT)
   From: Mark Jacobson <jacobson@math-cs.cns.uni.edu>
     To: 810-022-01@uni.edu
Subject: [810-022-01] Quiz Number One on Friday...

As stated in class today, Quiz Number One will NOT include any photoshop.
                                               ---

It will cover all the Excel and Macros topics we have been doing
in lectures and labs and in the assignments.

It will include some True/False,
                some Fill in the Blank,
                some short answer,
                some screen snapshots to look at
                     and answer questions about,
                and a little bit of
                     VBA coding.

Today in class we reviewed the

          Sub pause( pauseNumberOfSeconds As Single )

          End Sub

      and
          Sub doOneSecondPause()

          End Sub

          VGA code and concepts.

      We also reviewed the =INT(RAND()*365 + 1) Excel formula
                                                for birthdays,
          and discussed how you make one to
              get dice throws or make one to get
              numbers between -20 and 20 inclusive, say for an
              x or y coordinate where the x-axis goes from -20 to 20,
              and the y axis is the same, and the origin is as 0, 0
              for the x-y axis system, as is standard.

         You multiply by 41, NOT by 40.
         You add -20 instead of adding 1.  Or subtract 20 works too!

      =INT(RAND() * 41 - 20)  <---- Excel formula to get -20 thru 20
                                                  range of INTeger numbers.

      =INT(RAND()*6 + 1)      <---- Excel formula to get a dice throw
                                    value for a game.
                                    Die = 1, 2, 3, 4, 5 or 6

      4H clubs of Iowa.

      For Each theCell in Range("A2:C:24")
         theCell.Value = theCell.Value + 1
      Next theCell

      or

      For Each theCell in Selection
         theCell.Value = theCell.Value + 1
      Next theCell

      or For Each theRectangle

          see http://www.cns.uni.edu/~jacobson/RacingRects.html

     See the web page to review for the quiz too.

              http://www.cns.uni.edu/~jacobson/c022.html

     Your assignment for Toolbars is due on Friday.  If you did not
get your diskette back today or Monday, see me during office hours
today or tommorrow, or just bring another diskette with the three
toolbars ATTACHED and saved to the Workbook.  VIP!!!!!!!!!!!!!!
         --------

     Remember to name your toolbars with your THREE INITIALS included!

             SHOW/HIDE OPTIONS MFJ
                               ---   Your 3 initials on EACH toolbar
                                     to make its name UNIQUE for the
                                     entire class.
     Mark