810:021 Final Exam 3 p.m. Wednesday May 3rd, 2006

- World Wide Web and html experience. HTML tags. Writing
the HTML that is causing a certain web page display.
See midterm test one HTML question. IMG SRC tag, Anchor tag to make hypertext link(A HREF=""), making a graphic be a link, Horizontal Rulers, numbered and bulleted lists OL and UL, TITLE, BGCOLOR, BACKGROUND graphics (instead of BGCOLOR), BODY, HTML, HEAD, DL, DD, DT for definition lists, definition terms and definition definitions.

- Ghostbuster's handout and take home test concepts, as it
relates to problem solving, especially as it relates to Excel
and to PhotoShop and to web/html problem solving, software
development and slimers.
Know the four steps of the problem solving programming process. Understand it, Plan it, Code it, Test and debug it (aka deslime it to get rid of slimers).

Bees. Waggle dancing out the direction, distance and desirability on one possible solution to a problem. How does it relate to Ghostbusters and problem solving?

- Microsoft Excel handouts, readings, labs, assignments and lecture
notes.
- The functions for generating a random number, for finding
the sum or average of a range,
the Text functions such
as RIGHT, LEFT, MID, CONCATENATE, LEN. RAND, INT, SUM,
=AVERAGE(B4:D8) would find the average of how many numbers?, etc.
- The =INT(RAND() * 6 + 1) Excel formula for generating
the result of a die toss (one of a pair of dice for
Yahtzee or Monopoly is called a die).
- Relative, Mixed and Absolute cell references in formulas.

A2 or H$2 or $C3 or $J$2 for examples. Which is relative, which is mixed, which is absolute? Use the F4 function key to go through the four possible ways to reference a cell. - The =IF() function to decide between one of two actions
or outputs:
=IF(A2 = 1, "Heads", "Tails")

to simulate a coin toss, if we assume that cell A2 (and column A)

has 1 for H=heads and 2 for T=tails after flipping a coin with: =INT(RAND() * 2 + 1)

- The functions for generating a random number, for finding
the sum or average of a range,
the Text functions such
as RIGHT, LEFT, MID, CONCATENATE, LEN. RAND, INT, SUM,
=AVERAGE(B4:D8) would find the average of how many numbers?, etc.
- Basics of binary (base two) and bits and base 16 (hexadecimal).
- What is the decimal value of the
binary number 1001011101?
- What is the decimal number 2,518 in binary?
- What is the value of the base 16 number 1E?
- What would the base ten number 34 look like in base 16 (hexadecimal)?

- What is the decimal value of the
binary number 1001011101?
- The diagram of the computer with Mp, Ms, CPU (with ALU and control
unit and registers), Bus, Input, Output as the 6 components as
used in class from time to time.
Be able to draw the diagram showing the six essential
categories of components for a computer.
- Graphics, including but not limited to the Word or Excel Drawing
toolbar, PhotoShop basics (Gradients and myButton.gif assignment).
- PAINT: Bitmapped graphics, RGB graphics, pixels and
phosphors
1 bit for black and white or two color graphics, 2 and 3
bit gray scale, 8 bit 256 color and 24 bit True color
(16 million plus colors) graphics. PAINTING programs
use bitmap graphics and have erasers. MacPaint or
Windows Accessories group Paint program. See handout.
- DRAW: Object oriented graphics (Vector graphics) from
Microsoft Excel or Word DRAWING toolbar. MacDraw and
Drawing software. Working with lines, circles,
rectangles and points instead of pixels and bitmaps.
Great resolution on any device. See handout.

- PAINT: Bitmapped graphics, RGB graphics, pixels and
phosphors
1 bit for black and white or two color graphics, 2 and 3
bit gray scale, 8 bit 256 color and 24 bit True color
(16 million plus colors) graphics. PAINTING programs
use bitmap graphics and have erasers. MacPaint or
Windows Accessories group Paint program. See handout.
- Four generations of computers. Vacuum tubes, transistors,
integrated circuits, microprocessors. Moore's Law and the
18 months to double number of transistors on one chip of
silicon.
- Fetch/Execute cycle handout.