GST 2710, Computers and Society
Fall 2002, Wayne State University, Department of Interdisciplinary Studies
David Bowen, Instructor, Section 984
Agenda 7 for 10/21/02

Update to show material covered in class but not in Agenda (added material in red).
  1. Pg 25 in Computer Hardware
  2. I have some extra of these handouts, otherwise print out from course web site (http://www.cll.wayne.edu/isp/drbowen/casF02)
  3. Connectors handout
  4. Two assignments (Deborah Brown letter) with no names.
 Regular agenda as handed out in class:
  1. Announcements:
    1. Midterm is next week, Monday October 28
    2. Homework in folder, check name off (just a line inside the box on the left-hand side, please)
    3. Course web site, from Pipeline or direct from http://www.cll.wayne.edu/isp/drbowen/casf02
    4. GST 2710 web site http://www.cllw.ayne.edu/isp/gst2710, now updated to show how to forward your WSU Email after you have activated your AccessID and Password. (But do not forward it until we are through with it here.)
  2. Review of homework assignments: 
    1. Assignment 1 (due due 9/16)) - Problems on Assignment 1 sheet plus problems in both texts. Confusing; sheet says problems 2 through 20 although sheet has 27 problems. Graded as 2 - 20 only.
    2. Assignment 2 (due 9/23) - Problems on Assignment 2 sheet plus folders and files on diskette
    3. Assignment 3 (due 9/30) - Problems on Binary Numbers handout (Pg 25, 31 and 1-2 on Pg 36, even though Agenda 3 says problems 1 - 5) and letters for Deborah Brown, Madison Convention and Visitor's Bureau, Climbing High, Judy Davidoff and Word elegant Letter template
    4. Assignment 4 (due 10/7) - Problems on Assignment 4 sheet plus letters on Tax Deferred Annuity from WD2, and from WD3 case studies, Ocean Breeze Bookstore, Ultimate Travel, The Master's Touch and Pottery Row. No problems on "Represent Data Part II" handout but there are objectives covering this information, and also practice on Assignment 5.
    5. Assignment 5 (due 10/14) - Making "ascii.txt" text file in Word and attaching it to an email to Instructor, five other email assignments, problems on Assignment 5 sheet, document of EverRipe Tomatoes from WD 3 and from WD2 case studies, documents on Store-It-All, UpTime, Ridge Top and Restaurant Review. 
    6. Assignment 6 (due 10/21)

      1. Read EX 1.01 - 1.32, turn in Inwood spreadsheet, can be downloaded from http://www.cll.wayne.edu/isp/gst2710

      2. Do Assignment 6 sheet, including Excel assignments Enrollments, Budgeting, Medical Center and Cash Counting (can be downloaded from the course web site)

  3. Excel - commonly used in budgeting and accounting, but is also used for many other purposes. Generally, Excel can handle any tabular array of information in rows and columns.
    1. A layout of cells in rows and columns.
    2. The user (you) puts things in cells - the user decides what goes in which cell, just as with a Word Processor. To put something in a cell,
      1. click on the cell, or navigate to it using the arrow keys. The selected cell is shown in the upper-left corner.
      2. Type
    3. What can go in a cell?
      1. Numbers - many formats (Format > Cells > Number
        1. Plain numbers
        2. Dollars and cents
        3. Percentages
        4. Dates
        5. etc.
      2. Text - often to describe the numbers
      3. Formula - to make calculations on the numbers
        1. In Excel, a formula always starts with "="
        2. Example:
      4. Two big Excel problems that people have on exams
        1. Entering a formula without the "=" sign. To see the difference that "=" makes, enter the screen above, then re-enter C1 without the "="
        2. Also important - while you are entering information in a cell (that is, with the insertion point inside a cell or in the formula bar), you cannot do most things in Excel - most menu choices will be greyed out or otherwise unavailable. You must push the <Enter> key to make the change to the cell before the menu items are re-enabled.
      5. Can format text and numbers, but only for the whole cell
      6. Can edit what is in a cell if it is partly or mostly right
      7. Using Cut/Copy and Paste to copy or move a single cell or a range of cells. References in a formula will be changed to follow the cells that are moved.
    4. Can insert and delete rows and columns, fill in cells from a pattern
    5. Charting and graphics
  4. Review for Midterm
    1. Still some mixups between files and folders
    2. Problems on decimal to binary conversion - write neatly or you won't be able to follow your own work!!!
    3. Font classifications Serif Vs San Serif - which is which?
      1. Here is some text. Is it in a serif font, or a non-serif font?
      2. Here is some text. Is it in a serif font, or a non-serif font?
      3. Here is some text. Is it in a monospacing font, or a (?) font?
      4. Here is some text. Is it in a monospacing font, or a (?) font?
      5. Name a serif font. Name a san-serif font. Name a monospacing font. Name a proportional font.
    4. Word
      1. Alignment (Format > Paragraph). The four types of alignment are: left aligned, right aligned, centered and justified
      2. Lists - bulleted Vs numbered
  5. Computer architecture - handout
  6. Lab - Excel Tutorial 2 in Microsoft Office 2000 Professional, Pages EX 2.01 through 2.36. Complete the MSI Sales Report.xls worksheet, print it out and turn it in.
    1. (From Assignment 5) WSU email
      1. Send a message to me
      2. Read a message from me, print it out (click once in the message window, away from a link, to select the message window, then use your browser's Print button or icon)
      3. Reply to a message
      4. Delete a message (click in the box at the left of the message to select it (them), click "Mark | Deleted" (red "Not here" icon appears), click "Purge deleted items" on left-hand menu)
      5. Send an attachment. In Figure 5, Browse button to navigate your files to select file, then, with path showing in text line, "Add Attachment" to add it to the message, then send as usual. Repeat if you have more than one file to attach.
      6. Get an attachment from an email. See paper clip icon in Figure 2. Click on link at bottom of message in Figure 6 to download attached file, and save it to your floppy diskette. Print out a copy of the extracted and saved file and turn it in.
  7. Assignment 7 due 11/4 (the week after the midterm), but there will be more reading assigned.

    1. Read Excel Tutorial 2 (EX 1.01 - 1.32, turn in MSI Sales Report spreadsheet.

    2. Do Assignment 7 sheet, including Excel assignments MJ Income, Airline, Fresh Air Sales Incentives, and Portfolio worksheets. Fresh.xls, the starting point for Fresh Air Sales Incentives, can be downloaded from the course web site.

  8. Computers off