From jacobson@math-cs.cns.uni.edu Mon Sep 16 13:50:08 2002
Date: Mon, 16 Sep 2002 13:49:49 -0500 (CDT)
From: Mark Jacobson <jacobson@math-cs.cns.uni.edu>
To: 810-022-01@uni.edu
Subject: Postlab for Friday, Sep 13th assignment...

Hi 022 students (12 MWF MASI),

    Here is your Excel VBA assignment as the followup or postlab for
the Friday, 09/13 lab.  It is due on Friday, 09/20.

    1.  You have a handout with the following Chapters (Lessons)
        listed:

        1. Making a Macro Do Simple Tasks
        2. Explore Workbooks and Worksheets
        5. Explore Range Objects
        7. Control Visual Basic
        8. Extend Excel and Visual Basic

        Choose one of these chapters and use it to understand the
        Friday, 09/13 and the Monday, 09/16 classes work on the
        Birthday's macro problem.

        Write up a summary or very informal presentation what you
        learned that directly or indirectly helps you to better
        understand what we have done with Excel VBA macros and/or
        the 23 birthday's problem.

        This question one task should take up at least one half a page
        of paper.  It should quote from or refer to pages in the
        Reed Jacobson textbook that you read.  The best way to learn
        from the textbook, is to do the Lesson on the computer,
        and take some notes or jot down ideas as or after you did it.
        However, taking notes from the textbook before you go to a
        computer or if you don't have access to Excel at home is
        almost as effective, if done correctly.

        Integrate the Reed reading with the lecture and lab notes
        for this chapter.  Write your summary to teach yourself or
        another student in the 022 class more about the macros and
        VBA techniques and concepts.  Your audience is a student in
        the class, NOT the instructor!     --------

   2.   Do this for one of the other listed Chapters (Lessons) that
        is given above.  Look at the Excel PowerPoint presentation
        linked to from the http://www.cns.uni.edu/~jacobson/c022.html
        web page as hypertext:

        Excel VBA Macros PowerPoint presentation
        ----------------------------------------
                  covers all the basics, using the Birthday problem.
                  We started this on Friday, August 30th.

        If you wish, you can make this half-page cover multiple Lessons
        from the Reed Jacobson readings, instead of restricting
        yourself to just ONE Lesson and how it relates to 23 birthdays.

   3.   The 2nd side of your sheet of paper, or the 2nd sheet, should
        fill up the page and be one full page (one side only is required)
        of notes and reflections and rewriting in your own words of
        material from the

        Excel VBA Macros PowerPoint presentation
        ----------------------------------------

        You have this as a handout.  There are alot of related lectures
        and followup handouts.

        Again, your goal is to teach yourself or another beginner or
        person on a similar level to you in the class the concepts.

        Making it fun and interesting is always encouraged.

        Mark