Date: Thu, 02 Oct 2008 10:46:22 -0500 (CDT) From: Mark Jacobson To: 810-022-01-fall@uni.edu Subject: Test on WEDNESDAY, October 8th... Hi 022 students, This will be the first note for a study guide for the first exam. The exam will be next Wednesday. http://www.cs.uni.edu/~jacobson/c022.html 1. Dreamweaver. There will be lots of questions on the DW basics and the user interface and commands. Image maps and the hotspots I imagine was a new DW concept and skill to hopefully a few students in the class. See: http://www.cs.uni.edu/~jacobson/dw/IMaps/imageMap.html because I can imagine more than a couple questions based upon that material. Be able to look at some HTML code and modify it or add to it or show on a sheet of paper what that HTML code with its TAGS would display in a browser window. Know definitions that have been given. A hotspot is ___________. Fill in the blank or finish the definition. What is the D L with Definition List. DL and OL and UL type of lists. A dictionary is made up of terms. DT tag. A term in a dictionary is followed by a definition. DD tag. DL for definition list. No bullets like on UL lists. No numbers like on OL lists. Instead of bullets or numbers, you have: DT Definition Terms There is no LI tag, and that is no LIe. DL DT Red DD This is my favorite color for balloons and lamps. DT Green DD What can you say about green? St. Patrick's Day in Chicago during spring break of 1979 was so awesome. They have a huge parade there in the Windy City. The river channel is dyed green that day. When you walk across the bridge and look down and see the river, you feel like you are on the Yellow Brick Road and in a magic world like the Wizard of Oz. DT UNI Panther volleyball DD This is my favorite UNI sport. My favorite sport at University of Iowa was field hockey. I have been to four different final fours that the Iowa women's field hockey played in. 1992, 1993, 1994 and 1999. I know it will happen someday that UNI makes the elite eight and then makes the final four in volleyball! DL Open up a dictionary and look at a page and see that the dictionary is just a DL, and say what is the DeaL, what is the D L with that. On every page you will see DT followed by DD. What is so hard about learning a little bit of HTML? If you apply yourself to the task and be creative and find ways to get into it and relate to it, its a piece of cake. RGB graphics. FF00FF and RRGGBB and DC8842 and FF00FF. Tricks and techniques to using the user interface. What happens when you type the < symbol when using Dreamweaver was a question that was part of a group exercise a few weeks back. If I owned or managed a web publishing company and was in the hiring process and interviewing candidates, that would be a perfect question to ask if I was expecting and hoping for finding the highest level of skill and productivity with and insight into the Dreamweaver tool. Anyone who answered it completely correctly would stand out from the rest of the applicants who missed aspects of it and only answered it partly correctly. That group exercise a few weeks ago had some other write some HTML questions, including, if I remember right, the DL and DT and DD definition list HTML concepts. Or was it an OL with Roman Numerals? OL TYPE=i i. One for the money, LI One for the money, ii. Two for the show. LI Two for the show, iii. Three to get ready. LI Three to get ready. iv. Go, go, go. LI Go, go, go. /OL How do you specify a very thick Horizontal Ruler or Horizontal Rule in HTML? HR NOSHADE SIZE=21 or HR SIZE=33 2. Photoshop - Channels. R, G, B channels are the default. Alpha channel for creating a 3D button look. How to duplicate a layer? How to crop, two different ways. How to zoom in and zoom out. Gradients in Photoshop. Gaussian Blur. Render, Lighting Effects. How to make a 3D button in Photoshop. RGB graphics. 3. Excel VBA (Visual Basic for Applications). i. Study the birthday problem, the 23 birthdays PowerPoint presentation is available on the web. ii. Study the handouts. Developer tab on the Windows Vista ribbon. Why is it important? How do you make it available? iii. What are relative references? Were the following two or three statements recorded with Relative References ON, or recorded in the default mode with relative references off. How do you turn relative references on? iv. Be able to look at some simple VBA code and show on a spreadsheet and/or describe what it does or show what the output would be. v. Know what the =RAND() function would do all by itself. Know how to write a VBA formula to generate random dice throw values or random numbers between 1 and 100 or random numbers between 1 and 365. Dice: =INT(RAND() * 365 + 1) Numbers from 1 to 100: =INT(RAND() * 100 + 1) Numbers from 0 to 100: =INT(RAND() * 101) Birthdays: =INT(RAND() * 365 + 1) You have an extensive set of notes from one of our classes on the above formulas and about the RAND() function in Excel and that RAND() >= 0 and RAND() < 1 So 6 * RAND() >= 0 and 6 * RAND() < 6 etc. You took notes on this in class, hopefully. To reinforce it, just go into excel and insert function and read the description of the RAND() function. What are the first 3 letters of the word INTeger? What are the first four letters of the word RAND()? Go into View menu, Immediate window in Excel Visual Basic window. Type ?RAND() Type ?INT(3.987) Type ?INT(RAND() * 2) Type ?INT(RAND() * 2 + 1) vi. Know how to write a FOR EACH loop. Understand and read over the loops handout from yesterday. Know how to write a FOR i = 1 to 100 loop. This should give you enough ideas to get started. http://www.cs.uni.edu/~jacobson/c022.html Mark