810:022 Fall 2002
Fall 2002 - Microcomputer Applications and Systems
- Here are 022 student's
practice questions for final exam review. There are 20 of 23 of
them present. Please email me your URL if you are one of the
three students who has not finished yet or is not listed.
checkboxes, 4 select menu choices, 3 questions, 2 frames and
- Animation of cycling images using
the next image in the animation.
- Illustrating the
toLowerCase() method used to ease the
of fill in the blank questions.
- How would you write to a frame from another frame? See this example.
Write to lower frame from upper frame.
Illustrates Textboxes and command buttons too.
- How to do an ANIMATION
speed buttons and features.
- Here is a
that is not in frames. It illustrates selection menus (multiple choice
questions with only one correct answer), fill in the blank and checkboxes
- Here the Simple Java Example
handed out and modified in class on Monday, December 9th.
- Here is the FRAMES
Example from Monday, December 9th.
- Here are five Java examples.
- Variant variables are SLOW
and the Timing exercise to verify that they are slower than
Single, Long and Integer types. Variant is a type, but one that
can be any Type that is needed by your program. They take up
more memory and they are SLOWER to access.
This is a Wednesday, November 20th handout.
- Here is a 4 frame sample quiz
The animation is an animated GIF, which is a different approach than
- Here is a simpler, 2 frame sample
quiz from fall of 1999. The animation is an animated GIF.
- Practice exam page will look like
The 8 questions web site assignment
is due: Wednesday, December 11th by 11 p.m. Send the URL of your page.
Access database introduction
using the Northwinds database as an example.
- Here is the ClipArt customization
and Object-Oriented graphics page.
- Where and how do I
find the A.wmf ClipArt file when it
is not in the standard ClipArt folder?
- How to use it: Use Insert menu, Picture command,
From File... subcommand instead of Insert menu, Picture, ClipArt...
- Download it: Take the A.wmf file home with you on
a diskette, if needed.
practice questions and
PhotoShop display of works.
Opening a new browser window using
October 23rd: Photoshop and making a command
for your web page. Note: There will be some differences for the
newest version of PhotoShop. Hands-on class on Friday, October 25th
in Wright 112 lab.
Renaming the Sheet1 worksheet to
Metals is VIP. How to do it. Why the error message
says "subscript out of range" is explained too.
Gold, Silver, Diamonds, Tin, Bronze and Copper bargains:
Metals, which is the Lesson 10 Used Automobiles based assignment
will be due on a diskette, along with your Customized Toolbars
workbook on Wednesday, October 9th.
I will hand out envelopes
during class on Monday, October 7th, so you can put the diskette
and printouts into the manilla envelope.
Be sure that your Toolbars all have named that include your
3 initials, and that they are attached to the to the Toolbars.xls
workbook (or whatever you call that workbook).
For example, my Show/Hide Options toolbar would be called
Show/Hide Options MFJ
My Move Objects toolbar would be ---> Move Objects MFJ
and Align Objects would be named ---> Align Objects MFJ
The initials should make your toolbar name unique and make it
possible for me to grade and check all 28 toolbars from one
If two students have the same three initials, I will gladly deal
with that, but its not very likely to happen.
First class on HTML and
Quiz on WEDNESDAY, October 9th,
not on Friday October 4th. QUIZ #1 is on Oct 9th, Wednesday.
Monday, September 30th group
solution. Learn the Chr(), Rnd(), Int() functions, review For loops,
and yet another Chapter 8 example of extending Excel with a Custom
Postlab assignment due Friday,
at the START of class. You also received this as an email note.
VIP email about assignment:
PrintScreen for finished race is
enough, since it seems to give problems while graphics are changing!
Friday, September 6th hands-on class
CHECKLIST for WRT 112 lab class.
What to read in Reed, what to bring with you, what to do ahead of time
if you get the chance.
August 22 022 email note. If you
did NOT receive this, send email to firstname.lastname@example.org when you read
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 three year's 022 web pages.
- Fall of 2001.
- Fall of 2000.
- Fall of 1999.
- 810:022 detailed course
but without some of the
awesome graphics from the printed version.
- The syllabus will be
handed out on the first day of class.
Use this to verify the course covers alot more than spreadsheets and macros.
- 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.
web published version of the
syllabus, with hypertext
links created using Word Insert Hyperlink button from the Standard
Toolbar. The WordArt object is GONE from this version.
- Excel VBA Macros PowerPoint presentation
covers all the basics, using the Birthday problem. We started this
on Friday, August 30th. It will be the basis for an assignment to
be handed out on the Wednesday after Labor Day.
Here are your Racing Rectangles Resources,
and your first assignment for next Wednesday, September 11th will
be posted here soon. It was handed out in class on Friday, September