810:022 Fall 2004
Microcomputer Applications and Systems Integration

Toolbar with SIX buttons: Customized Toolbar assignment, handed out in early October or before. Be sure your toolbar is attached to your workbook and TEST THAT OUT on the diskette on a different computer from the one you originally did the work on. The toolbar must be ATTACHED to the workbook on your diskette!

Metals assignment from the Reed Jacobson Excel VBA textbook car calculator Lesson, which has to be done first. You received this assignment as a handout back in October.

Non-traditional final exam details will be announced here soon. We will not have the usual type of final exam, but I am having trouble deciding what to do regarding activity. Some of you still have some Excel macros projects to finish, anyway, so it will be a non-stressful 022 final also so you can finish those, or turn them in if you finished them long ago.

Calendar Program to try out.

Show Vertical CGI PERL program, and how to test it at the command prompt.
Try out the Vertical Printing CGI program that we covered in class on Monday, December 6th.

Taking full advantage of the PERL CGI library, including a nice Power Point slide show.

Random Quotes and more Random quotes, where you can specify which ones to see, or see all of them.

Test two: EXAM TWO will be take home and WAS handed out in class on November 17th.

TEST TWO: IS NOW made available HERE (EXAM TWO - take-home) TODAY (Wednesday, November 17th).

It will be due on WEDNESDAY December 8th in class or else by 5 p.m. Sorry this is such a tough one!
Every once in a while I FORGET and NEED a REMINDER of how tough programming is for beginners! :-)

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...

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.

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.

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]).

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
   Loop
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.

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.

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

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.

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).

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!!!

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

EXAM ONE is on Friday, October 1st.
EXAM TWO is on Friday, November 5th.
EXAM THREE is Wednesday, December 3rd.

810:022 Fall 2004 Microcomputer Applications and Systems Integration

810:022 Fall 2004
Microcomputer Applications and Systems Integration