CS 13
Final Examination

---

---

1. VISUAL BASIC:
   Create a Visual Basic form with two textBox inputs, one listBox output area, and appropriate buttons and labels.
   Place a label with you name, in the lower left corner of your form, and be sure to place a COMMENT at the beginning of each handler or sub in your code.
   Write handlers to do the following:
   • When the "PLUS" button is clicked, add the two numbers together, and output the result (along with some text that says what it is).
   • When the "SQUARE" button is clicked, multiply the first input value by itself, and output the result (appropriately described).
   • When the "BIG" button is clicked, output whichever value is larger.
   • When the "GREEN" button is clicked, change the form's background to green.

   When your VB program is done, upload the "form1.vb" source only (but NOT the Designer file), but name it "XYZfinal.vb" (where XYZ is your initials), and also print it out.

   
   

   ---

2. Spreadsheet:
   Using formulas to fill the cells, create a spreadsheet that has the following columns:
   1. The even numbers: 2, 4, 6, 8, ... thru 20
   2. The square of the number to the left. (i.e. 4, 16, 36, ..., 400)
   3. Ten times the first number (i.e. 20, 40, 60, 80, ...)
   4. The difference between the two previous numbers (i.e. 20-4, 40-16, 60-36, ..., 400)
   At the bottom of each column, compute the sum of all the numbers in the column.

   When your Spreadsheet is done, print it out, then press Ctrl-~ to display the formulas and print it again. Also upload a cut-and-paste of the formulas as "XYZexcel.txt". (where XYZ is your initials),

   
   

   ---

3. HTML (and Javascript): Create a web page named XYZfinal.html (where XYZ are your initials), illustrating each of the following HTML tags or Javascript features.

   When your web page is done, upload it to XYZfinal.html and also print it out.

   
   
   • At the upper right corner of the page, display your name in green, underlined.
   • Make a centered heading that says "CS13 Final" using the largest possible text size.
   • Demonstrate at least eight different text markup tags (including text that is affected by the tag and some text that says what the tag does).
   • Display an image that changes its source when the user clicks on it.
   • Draw three horizontal lines across the page..
   Then, make an ordered list (1, 2, 3, ..., 8) of at least eight metric prefixes (NOT including "nano") in order from largest to smallest, each followed by a number (or fraction) describing how big or small it is.

   Next, make an unordered list of (approximate) hexadecimal color codes for the following colors. The list is unordered, but the codes must be listed in order, from lowest to highest:

   			Pink
   			Dark gray
   			Green (with no other colors present)
   			Dark blue (with no other colors present)
   			Bright blue
   			Yellow
   			Black
   			White

   Make an ordered list, with labels A, B, C, D, etc. of at least eight different ways of storing binary data (bits) for later use in a computer -- other than on a floppy diskette. List them in order from the most expensive to the least expensive, and indicate a TYPICAL size in bytes for each one.

   Finally, use TABLE tags to display a 4-by-4 table, similar to the following, but with answers to the the questions in the appropriate cells.

   		  _____________ _____________ _____________ ___________
   		 |A1           |B1           |C1           |D1         |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |_____________|_____________|_____________|___________|
   		 |A2           |B2           |C2           |D2         |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |_____________|_____________|_____________|___________|
   		 |A3           |B3           |C3           |D3         |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |_____________|_____________|_____________|___________|
   		 |A4           |B4           |C4           |D4         |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |             |             |             |           |
   		 |_____________|_____________|_____________|___________|
   QUESTIONS:
   	A1:  Express the bits 10100101 in hexadecimal.
   	B1:  Express the HEX (hexadecimal) value "5A" in binary.
   	C1:  What is the DECIMAL value of hex "5A" ?
   	D1:  What ASCII character is hex "5A" ?
   
   	A2:  How many Kilobytes are in a Gigabyte?
   	B2:  How many milligrams are in a Kilogram?
   	C2:  How long does it take a 200 MHz processor to do one cycle?
   	D2:  How many bits are needed to represent 5000 different values?
   
   	A3:  Name three devices, other than a "null-modem", that are used to connect computers in a network.
   	B3:  Computers usually chop up long messages into several chunks, each of which might be sent via a diffent route.  What is a two-word name for this?
   	C3:  What must be added to the end of a network cable, and why?
   	D3:  In a spreadsheet, what two things (in proper order) correspond to database fields and records (respectively).
   
   	A4:  The "R" in "RAM" stands for "random.  What is the general term for storage that is NOT random?  Give a specific example of a type of non-random storage medium.
   	B4:  What are the TLAs (three-letter-abbreviations)for:
                      - The component of a computer that decodes and executes instructions.
                      - The part that adds, subtracts, does logic, etc.
                      - The way that an anchor tag identifies the resource that it wants to download.
                      - The service that translates a domain name into an IP address.
                      - A company that rents you an IP address to use.
   	C4:  Name three operating systems (OS), other than Linux and Windows.
   	D4:  What does an OS do?