810:022 Fall 2004
Microcomputer Applications and Systems Integration

  1. VERY HELPFUL: PERL FAQ page for Wright Hall students. How to figure out errors, how to use pico, what are some of the Unix (cowboy) commands like cd and cd .. and chmod and ls -l, what is the cause of a bareword error, etc...

  2. Friday lecture followup example. Covered partly on Monday 11/22 and 11/29 in class. Was handed out on Monday, November 29th in class. Happy Thanksgiving. Get a copy from my office door, if you missed class.

    Cooler version: variation followup example. Colors the repeated frequencies, along with making them BOLDly COLORful too.

  3. Row TEN, Column one, two or three for FREE SSH software download: Download Secure Telnet (I prefer and use ssh - SSH Secure Shell) for your home computer.

  4. After you install ssh, you will be able to connect to: bebop.cns.uni.edu or julia.cns.uni.edu or jet.cns.uni.edu or spike.cns.uni.edu or faye.cns.uni.edu (any one of the cowboy.cns.uni.edu computers [COWBOY is a CLUSTER of 5 computers]).

  5. We use ssh and connect to cowboy cluster computers in our PERL hands-on classes. Recall cd, chmod, ls, ls -l, logout, cd web, cd cgi-bin, cd .., w, who, finger, pico myWebPage.html, pico myPERLscript.cgi, etc.

Monday, November 1st forms example. (You have the HTML as a handout).

CGI functions and the HTML they generated, side by side. Also, using the param() CGI :standard function without ANY parameters.

Colors for your web page.

PERL CGI script handed out on Monday, October 18th.

Colors by the day of the week can be done in PERL too.

Sub pauseTwoSeconds()                         Sub PauseOneHalfSecond()
   stopTime = Timer + 2                          stopTime = Timer + 0.5
   currentTime = Timer                           Do While Timer < stopTime
   Do While currentTime < stopTime                  DoEvents
      DoEvents                                   Loop
      currentTime = Timer                     End Sub
End Sub

Any version of Excel from Excel 95 or Excel 97 to Excel 2000 will suffice to do the assignments for this class. You do NOT need to have Excel 2002 version! Click the textbook to link to a larger photo at www.amazon.com, if you wish.

Past five year's 022 web pages.

  1. Fall of 2003.
  2. Fall of 2002.
  3. Fall of 2001.
  4. Fall of 2000.
  5. Fall of 1999.
  1. I assume no previous Excel experience, so don't worry if you did not do much or any Excel in the past. You will be fine. The course covers lots of graphics and animation concepts, such as are useful for PhotoShop and Flash and clipart. It covers HTML and gives further web page experience, databases, and some authoring software. Also covers PowerPoint basics and beyond.

  2. Excel VBA Macros PowerPoint presentation covers all the basics, using the Birthday problem. We will start this on Friday, August 27th.

  3. The 23 BIRTHDAYS MACRO is your first assignment. It will be due on Friday, September 17th. Your 23 birthdays macro should include buttons to run it once, or 100 times, as well as buttons to reset the total counts. It should include ALL the features, including color them yellow and show the actual month and day of any duplicated birthday. Basically, it requires you to implement and develop the most advanced version of the birthday macro shown on the PowerPoint presentation.

  4. REVIEW and SCREEN SNAPSHOTS of Wednesday, Sept 17th (2003) class.

    • Code for ShowDuplicates to color them yellow, track if there is a repeat birthday with a BOOLEAN TRUE/FALSE variable. This code calls a couple of other macros.
    • Birthdays macro recorded during class on Wednesday, September 17th, 2003. This macro calls the ShowDuplicates macro.
    • How do I update the totals? updateTotals macro VBA code and how and where it is used (at the end of showDuplicates macro).

  5. Here is a note (from Fall 2003) about the .Offset() technique and adapting it to checking for repeats to eliminate the need for an extra variable and a couple lines of code. It also covers the ReportResult() macro code and how you could use the version that has a BOOLEAN argument instead of the zero argument TallyTheResult() macro. WE MAY NOT EVEN LOOK AT THIS BY THE END OF THE 2nd WEEK!!!

  6. Here are your Racing Rectangles Resources. By the end of the 4th week, you will have a good understanding of the racing rectangles macros.

  7. EXAM ONE is on Friday, October 1st.

    EXAM TWO is on Friday, November 5th.

    EXAM THREE is Wednesday, December 3rd.