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

  1. Announcements:
    1. Midterm is 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

  2. (Update fro last week) Computer standards - required whenever computers need to be compatible or different types of equipment need to work together, or when sharing information or communicating over a network

    1. Sources of standards

      1. Industry standards - generally from professional organizations

        1. American National Standards Institute (ANSI). ASCII standard is theirs.
        2. Institute of Electrical and Electronics Engineers (IEEE) - standards for how numbers are stored
        3. Association for Computing Machinery (ACM) - more into publishing information about overlapping standards, such as compressed graphics file formats (gif, jpeg, png etc.) 
        4. International Standards Organization (ISO) Basic networking standards, underlying specific types such as Ethernet (seven-layer ISO model of a network connection)

      2. Marketing standards - imposed by a market leader

        1. Microsoft sets the standards for Windows
      3. Government standards
        1. US government fostered the spread of the Internet by requiring that it be used in communications with the government
    2. Characteristics (not written down last week.
      1. Industry standards represent a broad consensus, so many people adhere to them, and they are stable (that is, they will outlive any one corporation). On the other hand, they can be difficult to change. Marketing standards can be changed quickly, but they are not publicly available, and they will become obsolete if the sponsor goes out of business.
  3. MS Word and Windows generally
    1. Standard menus - File, Edit, View, Format, Help
      1. Format font Vs paragraph
      2. Page setup
    2. File > Save As...
      1. Save as type:

        Figure 7 - the Save As dialog in Microsoft Word ("doc" is the default type)
      2. Difference between File > Save As... and File > Save (or toolbar diskette icon)
      3. File > Save As... compared to Windows Explorer

        Figure 7 - Save As shows less information about the folder hierarchy than Windows Explorer does
  4. 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 fro WD 3 and from WD2 case studies, documents on Store-It-All, UpTime, Ridge Top and Restaurant Review.
    6. Assignment 6 (due 10/21) - see below
  5. Switches and Boolean Logic - handout
    1. Pages : we can do arithmetic with switches
    2. Boolean or binary logic - two values, true or false, one or zero
      1. Logical functions AND, OR, NOT
      2. AND: two inputs, one output, output is true if and only if both inputs are true, false otherwise
      3. OR: two inputs, one output, output is true if either one or both of the inputs is true, false otherwise
      4. NOT: one input, one output, output is the opposite of the input
      5. Truth tables
  6. 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
        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:
        3. Alternate method - "building a formula"
      4. Can format text and numbers, but only for the whole cell
      5. Can edit what is in a cell if it is partly or mostly right
      6. Graphics can go in a cell, or "on top"
    4. Can insert and delete rows and columns, copy from one place to another, fill in cells from a pattern
    5. Charting and graphics
  7. Lab
    1. You can download the Excel files from the GST2710 web site
    2. (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 suaula. 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
  8. 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)

  9. Computers off