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

  1. Announcements:
    1. Midterm is this week, first part of class. Quiz 2 coming up on November 25.
    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.)
    5. WSU class schedule for Winter 2003 is now online at http://www.classschedule.wayne.edu . You can also register online at pipeline, or by touch-tone. Printed schedules will be available at Helen Newberry Joy, Undergraduate Library, extension centers at Oakland and Wayne County, and at the University Center at Macomb by the week before registration begins.
    6. My office hours (available for help or work on the computers): 5 - 6 PM Mondays in 113 Rackham. I can come at 4 if you make an arrangement. Other good days for pre-arranged help sessions: Mondays and Thursdays. Telephone: (office) 313-577-1498, (113 Rackham) 313-577-9705, (home) 248-549-8518, (at Ford Tuesdays and Fridays) 313-390-2155.
  2. Review of homework assignments: 
    1. General: The last part of the class is the computer lab session. There is a lot to do during this part, especially if you want to do the computer homework at this time, and reading the lab section before class will help you work faster. The lab work is generally one of the tutorials in Microsoft Office 2000 Professional. The tutorials have you work through a file, which you should print out and hadn in along with the rest of the assignment. At the end of that tutorial, there are other assignments that are part of homework, but that you can also do during the lab section, if you can work quickly. The tutorial will teach you what you need to know in order to work quickly and accurately on the case studies.
      NOTE: Assignments also include other reading and problems on an assignment sheet.
    2. 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.
    3. Assignment 2 (due 9/23) - Problems on Assignment 2 sheet plus folders and files on diskette
    4. 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
    5. 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.
    6. 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. 
    7. 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)

    8. 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.

  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. Content Vs formatting. What appears in the cell is the formatted content. The actual content is displayed in the formula bar when you click on the cell. To see the difference, start Excel, select a cell, type in a dollar figure (e.g. $3.41), tap <Enter> to actually do the entry, then click back on the cell and compare what you see in the cell with what you see on the formula bar.
      3. Text - often to describe the numbers
      4. Formula - to make calculations on the numbers
        1. In Excel, a formula always starts with "="
        2. Example:
      5. 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.
      6. Can format text and numbers, but only for the whole cell
      7. Can edit what is in a cell if it is partly or mostly right - click on the cell to select it and then click on the formula bar to start editing, or click on the cell and tap <F2>. Notice that the arrow keys work differently than they do for originally entering a formula.
      8. 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. Computer architecture - handout
  5. 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.
  6. Assignment 7 due 11/4 (the week after the midterm). See the additional reading in C.

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

    2. Do Assignment 7 sheet, including Excel Case Studies 1 through 4 at the end of Tutorial 2 - 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.

    3. (New) Start reading "The Machine Stops," by E.M. Forster. This will be the basis for the class paper. The paper will be described later, but it will be due in class on Monday December 9. You will need to allow yourself some time to write the paper, so finish the reading by November 25.

  7. Computers off