NAME: 701 QUIZ EP

NAME: 701 QUIZ EP
SKILLS TO BE ATTAINED	CHECK OFF
		UNDERSTANDING COMPUTER VIRUSES
		SENTENCE MATCHING
		RESEARCH: IDENTIFYING A SUBJECT, LOOKING IT UP.

HOW TO:

THIS IS AN EXTRA CREDIT ASSIGNMENT, SO IT IS OPTIONAL.

THIS IS BASED ON A STORY IN 99 ABOUT THE `MELISSA EMAIL VIRUS'

YOU MAY BE ABLE TO FIGURE IT OUT ON PAPER.

IF YOU CAN, LOOK IT UP ON THE WEB.

ALSO, on http//auciello.tripod.com there is a COMPUTER VERSION

OF THIS QUIZ THAT SCORES IT!

EP = EXTRA PROJECT = EXTRA 100 POINTS OF CREDIT. LEARNING IS A

LIFELONG JOURNEY - THERE IS NO REST FOR THE WICKED - THIS ASSIGNMENT

IS A REST AREA ON THE SUPERHIGHWAY 0F LIFE. ENJOY IT. "HACK" AWAY

AT IT. BECOME A "HACKER" NOW, AND AVOID THE RUSH!

NAME: 701 SOL
SKILLS TO BE ATTAINED	CHECK OFF
		MOUSE CONTROL
		NAVIGATING MENUS
		CLICK-DRAG,
		COPY-PASTE
		PRINT-SCREEN - IMPORTING GRAPHICS
		CLIPBOARD
		STRATEGY

HOW TO:

HOPEFULLY, sol.exe (SOLITAIRE) IS ON THE GAMES MENU OF YOUR COMPUTER.

(it is also on the INTERNET, YOU MAY WANT TO JUMPSTART YOUR WEB RESEARCH SKILLS BY TRYING TO FIND IT, LATER I WILL SHOW YOU HOW TO FIND IT BY USING A SEARCH ENGINE LIKE YAHOO OR GOTO.

LOAD IT BY CLICKING ITS ICON.

SET OPTIONS TO STANDARD STYLE. USE MOUSE TRAILS, PICK AN CARD COVER

THAT YOU LIKE. (I LIKE THE SWAYING PALM TREE LEANING TOWARD THE BLUE OCEAN ON A WHITE SAND BEACH.)

THEN DEAL YOURSELF A HAND. CHEAT A LITTLE - GO THRU THE DECK AND COUNT

ACES AND KINGS. DO NOT - REPEAT DO NOT - PLAY THIS GAME UNLESS 5 OR MORE

ACES AND KINGS ARE UNCOVERED. START BY BUILDING ACE ROWS (TOP) AND KINGS ROW (BOTTOM). TRY TO DEVELOP A WINNING STRATEGY. Be sure to add several lines about your winning strategy at the bottom on the page. Strategic Planning and documenting it are the most important parts of this assignment.

DESCRIBE THIS STRATEGY, WHEN YOU WIN. WHEN THE CARDS ARE FLYING IN THE AIR, HIT THE <Print Screen> Key (this copies the screen to the clipboard).

THEN OPEN UP WORD PAD [CLICK START - PROGRAMS - ACCESSORIES - WORDPAD]

WRITE YOUR NAME AT THE TOP.

HIT THE <ENTER> KEY ABOUT 15 TIMES. THEN DESCRIBE YOUR STRATEGY.

INSERT THE CURSOR JUST BELOW YOUR NAME, CLICK EDIT - PASTE

(THE IMAGE GETS PASTED ), MOVE THE IMAGE AROUND WITH THE ARROW

KEYS (ASK FOR HELP HERE). CENTER IT NICELY. CLICK PRINT.

PUT IN NOTEBOOK.. YOU JUST EARNED 100 POINTS.

IF YOU CAN'T BEAT SOLITAIRE IN 1 HOUR, SKIP IT, AND COME BACK TO LATER.

[EVENTUALLY, I OR A CYBER-TUTOR WILL SHOW YOU HOW TO DO IT.]

NAME: 701 EMAIL (700 EMAIL)
SKILLS TO BE ATTAINED	CHECK OFF
		GETTING EMAIL ADDRESS
		COMPOSING
		SENDING
		PRINTING

NAME: COMPUTER SKILLS INVENTORY
SKILLS TO BE ATTAINED	CHECK OFF
		INFORMATION COMPETENCY SKILLS
		TABLE PROCESSING IN WORD / EXCEL
		CATEGORIZING / ORGANIZING INFORMATION
		SELF-ASSESSMENT / EMPOWERMENT

HOW TO:

THIS ASSIGNMENT IS SELF-EVIDENT. JUST FOR STARTING IT, AND BEGINNING TO CHECK OFF THE SKILLS THAT YOU HAVE, AND CONTINUING TO UPDATE IT AS THE COURSE PROGRESSES, YOU WILL RECEIVE THE BIG 100 POINTS!

IN THE BUSINESS / MANUFACTURING WORLD, THE MODERN PRACTICE IS SELF-EVALAUTION THAT IS LATER VERIFIED. THIS ASSIGNMENT IS ABOUT YOUR TAKING RESPONSIBILITY FOR WHAT YOU KNOW, AND DON'T KNOW AND TRACKING AND MAPPING IT, AND MOVING FORWARD IN THE INFORMATION CENTURY.

EXTRA CREDIT IS ALSO REWARDED FOR EMAILING ME ANY SUGGESTIONS FOR ADDITIONAL SKILLS THAT SHOULD BE PLACED ON THIS INVENTORY LIST.

AGAIN, FOR STARTING THIS, AND CONTINUING TO UPDATE IT EVERY WEEK,

YOU WILL RECEIVE 100 POINTS.

NAME: 701-FONTS
SKILLS TO BE ATTAINED	CHECK OFF
		UNDERSTANDING THAT A FONT HAS A SIZE,, STYLE, AND SPECIAL PROPERTIES (COLOR, BOLD, ETC)
		UNDERSTANDING APPROPRIATE FONTS FOR BUSINESS.
		SELECTING A FONTS THAT YOU PERSONALLY LIKE. (I LIKE ARIAL - BUT THEN AGAIN, THAT COULD BE PYSCHOLOGICAL.)
		PUTTING STYLE AND CLASS INTO YOUR WORK.
		PROPORTIONAL VS MONOSPACED FONTS.

HOW TO:

IN THE FORMATTING TOOLBAL, USUALLY SAYS "Times New Roman 10", THERE ARE SCROLL BOXES THAT YOU CAN SCROLL DOWN TO SELECT A CERTAIN FONT, THEN

DO THE SAME WITH THE SIZE.

Do (5) very quickly, in different fonts, then then click the big "A" on the same toolbar. Guess What, note that it changes font color. Also you can highlight, (drag mouse over text), making it

Highlighted, then click "Font Color" and make your page very attractive.

There are additional skills here to be learned by those who have an `eye for color' and are artists.

changing background with the Highlight Tool to the left of the big "A" you can achieve dramatic,

and vivid colorful results! Show me, and more importantly, show yourself

what you can do!

NAME: 701-MAP
SKILLS TO BE ATTAINED	CHECK OFF
		USING PAINT / PAINTBRUSH PROGRAM
		PROPORTION, DIRECTION, RIGHT-BRAIN ACTIVITY.
		DRAWING TOOL

HOW TO:

CLICK START -PROGRAM - ACCESSORIES - PAINT - FIND THE "LINE" TOOL (RUN CURSOR OVER TOOLS UNTIL YOU FIND IT - IT IS JUST UNDER THE SPRAY CAN.)

NEXT DRAW A MAP CONTAINING THE LOCATION OF YOUR HOME, AND THE

NEAREST SHOPPING MALL.

KEEP IT SIMPLE. USE STRAIGHT LINES AND CROSS STREETS. CLICK "A" TO

ADD TEXT TO YOUR DRAWING.

EXTRA CREDIT FOR ELABORATE WORK DONE IN PAINT. SHOW WHAT YOU CAN

DO!

ALSO, EXTRA CREDIT FOR GETTING A MAP FROM YAHOO, BASED ON YOUR ADDRESS AND ZIPCODE (GET HELP FOR THIS ONE), AND COPYING AND PASTING IT TO PAINTBRUSH, AND MARKING YOUR HOME AND CLOSEST COLLEGES / UNIVERSITIES.

SHOW ME WHAT YOU KNOW!

NAME: 701-GRAPHICS
SKILLS TO BE ATTAINED	CHECK OFF
		UNDERSTANDING GRAPHIC FILES(.gif, .jpg, .bmp), CLIPART.
		COPYING, CUTTING, INSERTING FROM MENU, AND PASTING GRAPHICS.
		PUTTING TEXT ABOVE & BELOW GRAPHICS (LATER WRAPPING TEXT AROUND).
		UNDERSTANDING GRAPHIC IMAGE AS AN OBJECT THAT CAN BE MANIPULATED, EDITED, ETC.
		SAVE AS (saving files)

HOW TO:

Re: #3. Inserting Graphics. 700/701-GRAPHICS.

Suggest that you type Header (top) lines first, hit <enter> about 25 times, then type

Footer line. Then place pointer just under the Header lines by pointing it there, and

Clicking it. (establishing position with mouse pointer).

The Lion came from clipart - let's do it - Click Insert - Picture - Clipart. Select Image.

Click OK - Lion should be pasted to screen between Header and Footer. Find drag-points

(boxes at corners and midpoints). Point to drag button in upper left hand corner. Size the

image by dragging (point at drag point, hold button down, look for ß à 2 headed arrow,

then size image by moving dragpoint (called `dragging').

Make it look artistic, balance it, position it. Create an appearance at least as good

As the Lion by Lawrence Thomas.

A word on saving. It is smart to save. Smarter still to save often. Save this on your

A: drive or Hard Drive by CLICKING SAVE AS in FILE MENU. Type in

A:\701image.doc (or C:\ for hard drive). You got saved it, and can open it later.

Figure out how to Open it.

NAME: Famous Critical Thinking Assignment (CR3.DOC)
	CHECK OFF
		USING HELP MENU IN WORD.
		TOOLBARS,
		HUGE RANGE, POWER OF WORD.
		GRAPHICS
		RESUME

HOW TO:

BASICALLY, PLACE THE DOCUMENT IN FRONT OF YOU WHILE YOU HAVE `WORD' ON YOUR DESKTOP, AND READ THE QUESTIONS, AND FOLLOW THE SCRIPT. MOST OF THE ANSWERS ARE WRITTEN IN FOR YOU, BUT REVIEW THEM ANYWAY.

TRY TO VIEW WORD AS WORD PROCESSOR WITH A WIDE RANGE OF TOOLS, FUNCTIONS, POWERFUL FEATURES, ALL CONTROLLED FROM THE `TOOLBARS'. LEARN THE TOOLBARS, AND WHAT EACH ICON REPRESENTS!

Note that another student has gone ahead of you and answered some of the questions for you.

I TALKED ABOUT WRAPPING TEXT AROUND A GRAPHICS, BUT I DID NOT DO IT.

BUT PROMISE TO DO SO LATER. TRY IT ON YOUR OWN FOR 50 POINTS EXTRA

CREDIT. CLUE THE `RIGHT HAND' MOUSE BUTTON ALLOWS EDITING OF GRAPHICS, LOOK FOR `TEXT WRAPPING'.

Next, do the Resume. Try to get a copy of CR3.DOC from the classroom or from the CD, and save it to your hard drive, then open it, find the resume, and begin to modify it to become your resume.

Clue: put the Reveal Code (paragraph symbol) on -- looks like a P looking to the left, so that you can better `feel' your way around the resume.

Finishing all the questions in CR3.DOC is 100 points. The Resume printed in perfect form

Gives you another 100 points.

You may need help on this assignment.

NAME: 701-MASTERMIND
SKILLS TO BE ATTAINED	CHECK OFF
		CRITICAL THINKING - SCIENTIFIC METHOD (IF ... THEN ... HYPOTHESIS).
		STRATEGIC PLANNING.
		BOOLEAN LOGIC (AND, OR, NOT-AND, TYPE THINKING.

HOW TO:

YOU WILL NEED TO COME SEE ME OF THE CYBERTUTORS TO ARRANGE TO USE A COPY OF QBASIC.EXE AND MASTER.BAS.

This is a game where you are left on you own to develop a strategy to put the right digit ( 0 - 9 )

In the right position!

If you had qbasic.exe and master.bas on your system, you would start qbasic and open master

As a file. You need to read the help file to figure out how to play it. But the essence is that you

Must `discover' the correct digit and put it in the correct position. This is about strategy and

Logic and reasoning.

100 points for beating the game on each level, starting with 3 numbers, going up to 6 numbers.

I sometimes can win on level 6. Famous people who have won on level 6 include my daughter,

Cyndi, and Toni Lopez. This is an excellent chance for you to "show what you can do."

When you win, hit the "Print Screen" key to capture the screen to the clipboard, open up

Wordpad, write the Header info as shown, then paste the contents of the clipboard to the

Screen. Go!

You may need some help here to get started.

NAME: 700 / 701-DISCOVERY
SKILLS TO BE ATTAINED	CHECK OFF
		Using winfile or explorer to find powerful utility programs "hiding" on the system. Using file managers like winfile / explorer to find any programs.
		Using scandisk,
		Using defrag,
		Using virus checkers
		Running programs from the file manager .

How To:

There are a lot of extremely interesting and powerful programs that are installed as part of

The DOS / Windows Operating System.

Most are helpful, even to the point of making you into a `power user', but several programs,

-- those that can destroy data on your hard drive - require that you know what you are doing. Programs like -- format.com, fdisk, and partition magic - require supervision to use as they

can and will destroy your data if used incorrectly. And if you take your system `down', you

might flunk this course ...

Most programs (called .exe programs) are very interesting. To `discover' them, use a file manager like winfile or explorer or xtree / ztree or even DOS.

To use winfile, from `run' which appears when you click `start', type winfile - and the file manager comes up. Click file - search - then search for *.exe files starting from c:\windows.

(This finds all executable files (executable files end with .exe, or .com, or even .bat)). When you have this list in front of you, check out the following and write on the form what their function is:

calc - cdplayer (I told you this was very cool) - attrib - chkdsk - find - label - mem - move - scandisk - sort - xcopy - defrag - explorer - pbrush - ping - progman - sndrec32 (very cool digital

voice recorder!) -- etc [You can even get into some players that play video files!] I told you that

this was exciting!

For .com files - check out - doskey, diskcopy, mode, edit. [format.com will erase all data from

A disk, and create a new volume with an empty directory]. You can format a floppy disk from

MyComputer.

When you work on a computer, it is important that you are very focussed, and clear-minded!

Also experimentation and discovery is good, but always think about what you are doing. You are

Responsible for your mistakes!

So, `discover' about 10 commands, and log them onto your sheet for 100 points. You may want

To run scandisk or scandskw and defrag to speed up the performance of your hard disk.

Extra credit given for extending this assignment to using any Norton Utility Programs. Just log

It on the EC sheet.

JA.

NAME: 701-QUAKE
SKILLS TO BE ATTAINED	CHECK OFF
		EARTHQUAKE AWARENESS FOR SOUTHERN CALIFORNIANS.
		Internet Research
		Interpreting Data.
		Intro to HTML

How To:

Note on Page 1, there is a `sesmic activity map' with larger dots representing more severe

Activity.

I would like you to find a map, Thomas Map, or a map in the library, and find out the

Latitude and longitude of your home, and its proximity to centers of quake activity.

I would also you like you to find the Earthquake Information Page at CAL Tech on your own. Use any search engine: goto, yahoo, dogpile to find it.

Note the table on page 3. Try to relate lat and long coordinates to where you live.

The strange codes on page 4 are HTML. Say Hyper Text Markup Language.

Read the information.

Where can you get more info? Write answers in book.

Try to answer questions and respond to comments on page 10 for extra credit.

NAME: 700 / 701-Letterhead
SKILLS TO BE ATTAINED	CHECK OFF
		Headers in WORD
		Presentation-level quality. Aesthetics.

How To:

Basically, use the Help key in WORD to find out how to insert a Header.

When you are there, write yourself something like "From the desk of Jayne Smythe ..." and invent some phone numbers and addresses. For security reasons, don't use your real information.

Be aware of giving out unwanted personal information! However, making a real letterhead

For your personal and business use is a great idea!

You may also create a Footer. In fact, I think that this letterhead document will automatically

Open up in WORD, and you can figure out how to edit the information in the header and footer areas. OK, here is a clue: search help for header! (Show me what you can do.)

Save your work every 5 minutes. Apply Continuous Quality Improvement and Innovation

To your work, whatever that means.

NAME: IMPORTANT DEMING ASSIGNMENT
SKILLS TO BE ATTAINED	CHECK OFF
		Understanding a Leader in the Quality Movement
		EC: Relating Quality Movement to Working in a High Tech Environment
		PLAN-DO-CHECK-ACT STRATEGY

I want you to find Deming on the WEB, [use mamma.com or goto or dogpile or your search engine of choice], find out the name of the Award for Quality in Japan. Read enough about W. Edwards Deming so that you understand him. Look up his 14 Principles for Management. Write from 1 to 3 paragraphs or more (like Carlos Monroe did), giving me your reaction to Dr. Deming. It is important that you understand the man, then you give me your reaction, your 'take', your perspective on him. Learning does not take place unless there is a change made. I need you to relate, to connect, to go '1-on-1' with the material. It does not matter whether you agree with the works of Dr. Deming, but only that you 'react' to the material! Deming affected me and my partners to the point that we developed and taught a State Funded course on Quality Management to Manufacturing employees, and wrote a book that included a chapter on "Leadership in the High Performance Workplace", a concept advocated by James Bratt and Ken Nather when they were at the Employment Training Panel for the State of California.

The policy of Continuous Quality Improvement and Innovation (advocated by Juan Cruz of the State Chancellor's Office) derived from Deming's Principles. {Try to make the connection for yourself). Greg McKinney, a former student, has combined the Quality Concepts with Network Engineering to move dramatically ahead in his career.

NAME: INTERNET SEARCH -- (701 INTERNET)
SKILLS TO BE ATTAINED	CHECK OFF
		SEARCH ENGINES
		UNDERSTANDING WEB ADDRESSES (URL)
		INTRODUCTION TO SEARCHING

Using mamma.com or goto.com, enter "Jim Rome" in quotes for the search field, and of course press

. I am interested if you can find web pages of individuals. And it does not hurt to know something about these individuals. Search for "Dr. Bernie Siegal" who offers a compendium of medical advice, that my mother happily uses as a medical encyclopedia. Others are Gen George Patton, etc. [choose a couple]. This would be a good time to search for your own name. Hopefully, this will trigger connecting to a geneology data base, and even finding some family members. One student showed off her son's web page -- he is a starting football player for a university. Do several searches to verify that you have the skill down. Putting names in quotes, like "Jim Rome" ensures that you get exactly that. If you type Jim Rome without quotes, you could get everyone named Jim and every reference to Rome. "Have a good take."

NAME: INTERNET RESEARCH (1) -- INTERNET ACTIVITY LOG
SKILLS TO BE ATTAINED	CHECK OFF
		syntax of email and web addresses
		'bookmarking' -- building a directory

This is an early INTERNET assignment, and because everyone is
using  addresses well, it has value only because it forces you
to look at the  special characters in addresses, such as --

Brent_W_Oakes@hotmail.com  

[Note the 3 capital letters, the underscore, next to the '0' key, 
which requires the SHIFT Key, and the @ symbol -- which is a SHIFT '2'].  

Complete this assignment by writing correctly some email addresses,
and web addresses, which you can find in the 'location' line of any
web page.  Use symbols like  '//' (forward slash) and tilde (~) correctly.
And of course, the famous  dot is a period.
 
Just do about 4 - 6 to demonstrate that you have the learned the skill.







 
 
 


NAME:     HOMEPAGE TEMPLATE



SKILLS TO BE ATTAINED

 
 
 

CHECK OFF


 



HTML




FONT COLOR, BACKGROUND COLOR




PAGE CONTENT (SAY SOMETHING)




PAGE APPEARANCE (GOOD SHOW)







My students are now building their web pages writing 4 short HTML
-- say Hyper Text Markup Language -- programs, which are 

yourname.htm
career.htm
like.htm
hobby.htm

yourname.htm shows your picture, which you get from a digital camera
(see me), and career, hobby, and like are short biographical descriptions.

The models of these are on the web site.

I am interested in your color selection, and content of your page.
Please look under 'Student Home Page' for examples.

Possibly, we can add voice, music, and video.  How cool.  If not in this
class, but the Javascript/HTML (757) class that I teach.

You will be basically using the templates provided, and making changes
on them, then testing them by running them with Netscape or Explorer
browsers.  I like to have one window open in EDIT (a simple word processor
editor), and a 2nd window open in Netscape or Internet Explorer, and make
the changes in EDIT, save them as consecutively different files (more later)
and open and view them in the Browser.  

You can work fast, and effectively this way.  Other students, like
Vanessa, use FrontPage, and Curly writes her pages in WORD, then saves
them as HTML, and runs them.   

No one way is correct -- you must find your own style.

Goals of this assignment are:

For you to create a web presence.

Hopefully, we can transfer your html up the web, and link
you into the CyberClassRoom as other students have done.

Understand the basics of HTML -- the codes, the symbols, the
way things begin  (like <HTML>)   and end  (like </HTML>).

Also, I am not able to say it well, but there is a lot of
'visual art' that goes into a homepage.  If you are like me,
you can figure it out logically,  while some students, like Rhandi,
have a flair for color.   Go!  Show me what you know!


This is 400 points to get it working on your disk, and printed
out in your book, plus 100 to get an home page address, say, from
tripod.com  or  homestead.com, and transfer your homepage to that
site, then give it to me so that it can be linked to the Cyber
ClassRoom.

The continuation of this is Web Design.

=======================================================

I am going to 'paste' the code for Terisita Lim Chua's page below:
Use this as a model for your Homepage:

THIS CODE BELOW CREATED THIS MAINPAGE (yourname.htm)



  
  






<pre>

<!-- THIS IS THE HTML THAT CREATED THIS PAGE:  -->

<!-- CIS 701         PROF AUCIELLO
     BUILDING HOME PAGES:
      REPLACE  TERESITA  WITH  YOUR  NAME.
      (BE CAREFUL NOT TO ERASE ANY OF THE HTML CODES OR SYMBOLS.
      INSERT NAME OF YOUR PICTURE  (XXX.GIF)  OR  XXX.JPG
      WHERE img SRC='tlpix.gig'   Use your picture in gif or jpg
      format.  You will need some help here.

      SAVE AS  C:\MAIN.HTM    ALSO   A:\MAIN.HTM
      RUN IT WITH NETSCAPE.

      YOUR ASSIGNMENT:  INSERT YOUR NAME, CHANGE COLORS AS YOU LIKE.
                        USE COLOR NAMES (WHITE, RED, GREEN, etc)
                        THERE ARE A LIST OF COLOR NAMES UNDER
                        JAVA/JAVASCRIPT PROJECTS.

                        FOR CAREER, HOBBY, LIKE,   WRITE YOUR
                        OWN STUFF.                       

-->

<html>
<head>
   <title> TERESITA LIM CHUA </title>
</head>

<BODY  bgcolor = pink ><CENTER>
<center><table BORDER CELLPADDING=10 WIDTH="640" BORDERCOLOR=WHITE >

<tr>
  <td VALIGN=TOP WIDTH="38%"><img SRC="tlpix.gif" height=114 width=148>
  <br><br>
  <center>
  <p><b><font color=cadet blue> <font size=+3> TERESITA LIM CHUA 
        </font></font></B>

  <p><b><font color=cadet blue> <font size=+1>HOME PAGE
        </font></font></B></center>

  <p><br>
  <br><br><br><br><br>

  <p><font color=maroon></font>
  </td>

  <td VALIGN=TOP WIDTH="63%">
  <center><h1>
  <u><font color=yellow>INFORMATION</font></u>
  </h1></center>

  <li><u><font size=+2><a href="CAREER.HTM"> <font color=black>   Career Info</a></u></li>
  <li><u><font size=+2><a href="HOBBY.HTM" > <font color = red>   Hobby     </a></u></li>
  <li><u><font size=+2><a href="LIKE.HTM"  > <font color = green> Likes</a></u></li>
  </ul>
  </td>
</tr>
</table></center>

<br>

<!-- ASK ABOUT THE HTML CODES.  GET A BOOK ON HTML.
     SEARCH THE WEB FOR INFORMATION ABOUT HTML.
     HTML = HYPER TEXT MARKUP LANGUAGE = LANGUAGE TO WRITE HOME PAGES.
-->


</BODY>
</HTML>
<!-- this is the end of YOURNAME.HTM   -->


<!-- beginning of       CAREER.HTM     -->
<HTML>
<HEAD>
<TITLE>My Career Goal</TITLE>
</HEAD>

<BODY BGCOLOR=red TEXT=black ALINK=BLUE>

<FONT SIZE=5 COLOR=black><P ALIGN="CENTER">My Career Goal... </P>
</FONT>

<FONT COLOR=black>
My career goal is to be on top of the corporate ladder.  Currently,
I'm taking courses at Los Angeles Trade Technical College.  I plan to finish
my Computer Information Systems classes in May 2000.  I will attend
California State University of Los Angeles and continue my education in
Computer Science.
</BODY>    
</HTML>
<!--  END OF CAREER.HTM          -->


<!--  START OF HOBBY.HTM        -->
<HTML>
<HEAD>
<TITLE>My Hobbies</TITLE>
</HEAD>

<BODY BGCOLOR=blue><CENTER>
</CENTER>

<FONT SIZE=5 COLOR=yellow><P ALIGN="CENTER">My Hobbies ... </P>
</FONT>

<FONT COLOR=yellow>
I spend time working on crafts.  I read articles on new techniques and new materials available
for creating artsy novelty items.
</BODY>    
</HTML>
<!--  END OF HOBBY.HTM          -->

<!-- START OF LIKE.HTM          -->
<HTML>
<HEAD>
<TITLE>Fun things I like to do</TITLE>
</HEAD>

<BODY BGCOLOR=orange >
<CENTER>
<FONT COLOR=blue><H1 ALIGN="CENTER">Fun things I like to do</H1>
</FONT><P><HR SIZE=4></P>
<FONT SIZE=5 COLOR=blue><P ALIGN="CENTER">Fun things... </P>
</FONT>

<FONT COLOR=white>
I enjoy attending arts and craft exhibits.  I like taking nature walks.
</font>

</BODY>
</HTML>

<!--   END OF LIKE.HTM        -->

You have to create (4) different html files:  yourname.htm
                                              career.htm
                                              hobby.htm
                                              like.htm

Each one follows the models above.  Change the colors, change
the text.  But don't change the html codes (the  < and > symbols
and the stuff in between.   There is an explanation of HTML codes
under Java/JavaScript  in this classroom.








 
 
 


NAME:     701 - RESUME (EP) 



SKILLS TO BE ATTAINED

 
 
 

CHECK OFF


 




Presentation Quality Work preparing for the Job Market.










How To:


This is an attractive format to follow for your resume.
Try to download it as a DOC file (WORD DOCUMENT), so that
you can just add your own stuff, fairly easily.





 
 
 


NAME:     EXCEL SPREADSHEETS



SKILLS TO BE ATTAINED

 
 
 

CHECK OFF


 




Identifying EXCEL Icons, Features, etc.










How To:

Load EXCEL, and you will see the DESKTOP as shown in the book.
Make copies of this page, and starting with the row of icons,
describe each one (write in the blank space below the icons).

Use as many pages as you need.
By placing the mouse pointer on each icon, you will get a clue
on what they represent!

Repeat this for the toolbar line starting with "File"

You may need help here.







 
 
 


NAME:     EXCEL (EXPENSE BY CATEGORY) >



SKILLS TO BE ATTAINED

 
 
 

CHECK OFF


 




Overall Planning, Design, Strategy.





Creating Titles




Creating Column and Row Headings




Entering Numeric Data.




Developing Row Totals (6 month)




Graphing Categories (Horizontal = X) vs  Total Amount
(Vertical = Y).




Enhancing the Graph -- Titles, Keys, Grid)











How To:
Load EXCEL.  That is, find the EXCEL icon, click it to start.
You will see Toolbars with COLUMNS (A,B,C,D,etc) and Rows (1,2,3,4..) on
the screen. 

Note at this point, you have a large table (called 'spreadsheet') in front
 of you.  The boxes are called 'cells'.   You can move from cell to cell
with the mouse which becomes the 'cell pointer' or with the cursor-control
(arrow keys) on the keypad, (press 'Num Lock' off).

Try moving the cell pointer from A1 to D6.  I just realized that I use
the arrow keys to move the cell pointer.   Try it.

Go to A1.  TYPE IN -- EXPENSE BY CATEGORY
           Then highlight "EXPENSE BY CATEGORY" by positioning
           mouse at the E and holding the button down while
           you drag it across to the Y in CATEGORY.  Keep experimenting
           until you get 'highlighting' down.  When you have it
           highlighted, click the arrow next to the Font Size Box, 
           select 16 (or any large size you like).  This makes 
           a large Title.           

Go to A2.  TYPE IN -- YOUR NAME  (use your own name)
           Repeat for YOUR NAME.  You may want it to be smaller,
           say 14 font size.

Go to A4.  Type CATEG.  Press Right Arrow to B4.  Type JAN
           Continue with MAR, etc all the way to TOTAL.
           (This is called enter 'cell pointer control' and
            entering Text Information.)
           Continue until you get this done.  Understand that
           there each cell contains only 1 word.  Take your
           time, and get it down.   I just typed in CATEG, then
           hit the 'right arrow' key (Num Lock is off, right?),
           and entered all the Months.

At this point, save your work. I want to teach you to save frequently
and back up your work, so you can always 'back track' to an earlier
version when you make an error.  So click File - Save As - In the File
name box, type  701-excel-01a  [the name of the assignment is
 701-excel-01  and this is version 'a'] and click the save button.

This is very cool, because every 5 minutes or so, you will save
your work as  701-excel-01b,  701-excel-01c,  etc ... and when you
'goof up' as we all do, you can just revert to an earlier version!

And if you make a typing mistake, just hit the 'backspace key' above
Enter and correct it.

You can also click on the word mispelled, then click on the word as
it appears in the 3rd toolbar, and move the cursor to the middle of the
word and fix it then and there!  Hit the  to state that you
are done editing.

Next, type salary, rent, trans, supp, util, labor, misc down the
first column, following the pattern.

Now comes entering numbers.  I would use the numbers on the top
of the keyboard, because I use the keypad for cursor control.

Enter any 2 or 3 or 4 digit numbers for SAL, moving across until
you reach June.  I entered numbers then hit the right arrow key.

Stop at Total.  This has to be a formula, it is the sum of all the
SALARIES from JAN to JUNE. 

Of course, you have noted that the Months line up to the left,
and the numbers to the right.  Say 'left-justification for text, and
right-justification for numeric data'.   It will always be that way.
Numbers and Text are  different.  You can calculate with numbers, not
so with text, of course.  Numbers work from right to left, and the
position of a digit is important (say 'positional notattion').

Anyway, we need to calculate the sum of all salaries for that
6 month period.  So in the cell under TOTAL, we type  =SUM(A6:F6)

Let's talk about this.  = starts a function named SUM.  =SUM is
a powerful built-in function that will return the sum of the
range within the parantheses.  The range is from A6:F6, the addresses
of the first 6 months.  So this is very cool.  You are instructing
EXCEL to take the sum of the numbers in cells A6 thru F6.  Always
start left to right.

The math functions of EXCEL are marvelous, and if you want to go off
to look at them, and can find for example the Mortgage Payment function,
give yourself 40 points on the Extra Credit page.  (Experiment using
the HELP icon, click - index - math functions -- try to 'get into
the power of the Help key and the vast array of Math functions.)

At point, you have the SAL row done. Repeat for the rest of the rows.
This is a bit boring, so vary the numbers a bit.  Don't enter
anything under TOTAL, of course.

Now, we are going to copy (say 'replicate') the formula under TOTAL,
to the rows under it.  Let's go.  Point to the formula.  Note the
drag point in the lower right hand corner.  Point to the drag point,
note that it turns into a cross.  Good.  Now press the button and  
drag it down 6 rows.   Dragging means holding the button down while
you move the mouse, same way that you highlighted text.

Let go of the mouse, of course when you are down 6 rows, and you have
replicated the formula. 

What you have done, is repeated the formula for the bottom rows, using
the parameters of the 1st formula, so notice that the address coordinates
changed for the =sum function in each row.  Gadzooks, check this out,
and begin thinking about it.  You may want to begin to talk to yourself
about  relative and absolute addressing, for extra credit.

Now you are done with the Spreadsheet, and you are ready to graph it,
to build a graph from it.

About this time, you should save again, right.  Save as  701-excel-01b 
(you knew that, right?)

Now we have to think ... Hmm ... I will put Categories on the bottom
(say 'X axis), and  plot Totals vertically (Y axis).  Your basic
X and Y graph.  

Repeat after me ... we are going to plot Categories vs. Totals.

And the whole trick is to highlight the 2 colomns that we are
goint to plot.   We have to highlight both the CATEG and the TOTAL
column, so we have to use the Ctrl key as we drag and highlight
the CATEG column, then  highlight the Total column.  You know that 
you are done when both columns are hightlighted!  By keeping the
Ctrl key down, you are able to highlight 2 columns.

Trying again:  Point to the midde of the cell containing Salary -  
Press Ctrl key - drag mouse down thru MISC (you have (1) column
highlighted).  Keep the Ctrl key down, and  point to H5, the row 
total for SALARY.  Find H5 right now.  Point to it. Click on it.  
Drag down to H11. At this point, you should have two columns highlighted.

Saying it again:  Hold Ctrl key down.  Highlight 1st column.  Release
Mouse Button, point to Total Column, and Highlight it!

This is can be tricky, keep 'hacking' away until you get it. 
Help is available if you get stuck.

Then find Chart Wizard icon on 2nd toolbar.  Find it by passing mouse
over each icon until you find it!

Click it --  (and you are passing 2 columns to be plotted into the
Chart Wizard).  Good move.  

You are at Step 1 of 4 - Chart Type.
Select Column for Chart Type.  At this point, you are encouraged -- it
is very cool -- for you to experiment with various types -- be a 'hacker'.
Click Next.

You are at Step 2 of 4 - Chart Source Data.
You see the graph and the data range. Click [next] to pass by. 
(You can study this page later).

(Note at this point, the quality of work that Microsoft has put
into this Chart Wizard.)

Next, Step 3 of 4 - Chart Options.
For Chart Title, enter EXPENSE BY CATEGORY
For Category (x) axis, enter Expense by Type
For Value    (y) axix, enter Expense Amount


On Step 4 of 4 - Chart Location.
Click  Finish  (accept defaults).

Now you have a  chart object in the middle of
your sheet (spreadsheet).

Drag it down, under the spreadsheet, and place
it artistically, aesthetically, balance it on the
page.  Use Print Preview to see how it looks.
Don't quit until it look at least as good as
the examples in the book.

Saying it again, click on the chart, drag it  to where
you want it, click outside to chart to release the drag
points,  do print preview, keep moving it until you 
get it.  (seek help if necessary).

Some advanced stuff.  Please note 'link to embedded object' stuff:
when you change numbers on the sheet, it immediately plots those
changes on the chart.   How cool!

Also, you may change any of the parts inside the chart by clicking
on them.  For example, I got rid of [Series 1] by clicking with
left button, then right button - clear.   Very nice.  You may
re-proportion the elements of the chart by selecting them by clicking
on them, and stretching them out.

When you have this chart done, go ahead and produce different versions
of it -- like Pie or Expanded Pie Chart -- for 100 points each to a maximum
of 600 points for Excel Charts.

You also need to be able to Sort Data.  Just select the range to be
sorted, find SORT under DATA, and experiment with it.  (I owe you
more information here.)   Just remember that when you sort on a field, say
names in a phone book, you must also include in the range to be sorted,
the numbers that go with those names!   Think of the distrastrous consequences
of sorting the name, and leaving the in the the original order!  WOW!

There is lots more that can be done with EXCEL. Really, it is the
Numbers-Thinking-Person's tool.  You can fall in love with it, just
as you can with WORD.  What you can do with word processing in WORD, you
can also do with numbers in EXCEL.   Entire programs (mortgage amortization)
can be done in minutes with one line of code, replacing entire programs
in COBOL or Java (Java allows you to post on the web).   Soon I think
Excel will also convert to HTML.  Wait a minute!  I just checked, and
in my EXCEL 2000, I can save an EXCEL program to the Web!   Gadzooks!
I am happy to correct myself!

Get involved with EXCEL, it is great for mathematical calulations.  You
can even program with it, that is, create Macros which are program
statements in Visual Basic!  It should be part of your Information 
Technology Toolkit.

Learn to use the help key.  Go ahead and look up exponentiaton, and
log, and Future Value calculations for extra points!

I hope that you 'get' that I just introducing you to one of the 
Programming Loves of your Life, and by using it in a lifelong
relationship, you will be a Power Information User!

In any case, create up to 6 different sheets -- you may run different
charts based on the same data, or try different data -- Note the 
analysis of Pizza Cost per square inch example.

I am going to do that one again right now.

						
A	B	C	  D	 E	 F	  G	
					          Sq in per $	 1	
DIAM	PRICE	RADIUS    R^2	 PI	 AREA	  AREA/PRICE	 2	
								 3
12	6.99	6	  +c4^2  3.142	 =+E4*D4  =+F4/+B4	 4	
12	6.99	6	  36	 3.142	  13.11   16.18197425	 5	
16	7.99	8	  64	 3.142	 201.088  25.16745932	 6	
								
								


The best buy is the 16" for $7.99							
								
								
PLEASE NOTICE THAT R^2 (r squared) is coded as +C4 (which
is the cell address for the 3rd col in row 4, which is a 6)

So +c4^2 means  the contents of C4 is squared.   The plus
sign is used when you refer to a cell's address.

Likewise, to mulitply PI times r squared, use =+E4*D4,
which means the contents of E4 multiplied by D4.

Similarly, to divide area by price, use  +F4/B4


Go ahead and get a pizza menu to get some sizes and prices,
or make up some, and run this assignment for 100 points!








 
 
 


NAME:     INTERNATIONAL CHARACTERS



SKILLS TO BE ATTAINED

 
 
 

CHECK OFF


 




Respecting International Alphabets










How To:

Load WORD.  Type ROBERT MU    then stop.

then click insert - symbol - select the � char - click insert.

I will leave it up to the student to figure out how to call
WORDART, and do Roberts' name in WORDART.

I think this is a chance for you to show me that my clues
on using Help, and some thinking / resarch processes are working.

Show me the answer!





 
 
 


NAME:     PROGRAMMING IN WORD.



SKILLS TO BE ATTAINED

 
 
 

CHECK OFF


 




ADVANCED SKILLS










How To:

 100 points for reading this, making notes, highlighting what
you understand and is important.

This is an advanced assignment meant to give you a look at the
next level.   It is an example of research that I did on various
ways to make international characters, and has the ASCII table,
and some other generally impractical (on this level) features.

But when we start Visual Basic, then it will be very practical.
Go!

NAME: HOMEPAGE TEMPLATE
SKILLS TO BE ATTAINED	CHECK OFF
		HTML
		FONT COLOR, BACKGROUND COLOR
		PAGE CONTENT (SAY SOMETHING)
		PAGE APPEARANCE (GOOD SHOW)

NAME: EXCEL (EXPENSE BY CATEGORY) >
SKILLS TO BE ATTAINED	CHECK OFF
		Overall Planning, Design, Strategy.
		Creating Titles
		Creating Column and Row Headings
		Entering Numeric Data.
		Developing Row Totals (6 month)
	Graphing Categories (Horizontal = X) vs Total Amount (Vertical = Y).
	Enhancing the Graph -- Titles, Keys, Grid)

NAME: 701 - RESUME (EP)
SKILLS TO BE ATTAINED	CHECK OFF
		Presentation Quality Work preparing for the Job Market.

NAME: EXCEL SPREADSHEETS
SKILLS TO BE ATTAINED	CHECK OFF
		Identifying EXCEL Icons, Features, etc.

NAME: INTERNATIONAL CHARACTERS
SKILLS TO BE ATTAINED	CHECK OFF
		Respecting International Alphabets

NAME: PROGRAMMING IN WORD.
SKILLS TO BE ATTAINED	CHECK OFF
		ADVANCED SKILLS