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

  1. Announcements:
    1. Quiz 2 coming up next week 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.
    7. See boldface changes for Assignments 7 and 9 (we went over these in class last week).
    8. What about getting started on those assignments?
      1. I will not be able to accept all of your assignments at the end of the semester.
        MAXIMUM: two assignments accepted on the day of the Final, December 16
        MAXIMUM: two assignments accepted on the class before the Final, December 9
      2. I will not be able to grade assignments over these maximums in time for them to count in regular grades. This may result in a low grade or a failing grade. You may want to speak to me about an incomplete (I) before then.
    9. Online grade reports. On the course web site, you can look at my record of your grades. You will need to give me a password to access your grades.
  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 hand 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)

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

      2. (changed) Do Assignment 7 sheet, including Excel Case Studies 1 and 3 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. Only do the odd-numbered problems on the Assignment 7 sheet.

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

    9. Assignment 9 due 11/11.

      1. Read Excel Tutorial 3 (EX 3.01 - 3.37), turn in Pronto Salsa Company.xls spreadsheet.

      2. Do Assignment 9 sheet odd-numbered problems only, including Excel Case Studies 1 and 4 at the end of Tutorial 3 - Jensen Sports Wear and Ortiz Marine Services worksheets. Running.xls, the starting point for Jensen Sports Wear, can be downloaded from the course web site at http://www.cll.wayne.edu/isp/gst2710.

    10. Assignment 10 due 11/18

      1. New Perspectives Computers, Technology and Society Chapters 4 (Pages 4-14 to 4-33) and Chapter 9 (9-29 to 9-36)
      2. Assignment 10.
      3. Essay assignment: The general essay topic is social dependence on technology. Your essay should be three pages long, based on the assigned reading, The Machine Stops, by E.M. Forster. The essay should be in 12 point Times Roman type, with 1" margins on all four sides, with "Double" line spacing. Your essay should have a footer including your name and the page number. No cover sheet is necessary; the essay title should be at the top of the first page, bold and centered. Make sure to use spell check and grammar check. The Word grammar checker complains about all use of the passive voice, although normal writing contains up to about one-third passive voice. The essay is due in class on the last regular class, December 9.
  3. Review of old material - still some problems with it
    1. Two parts of computers
    2. Two types of memory
    3. Four (now five) types of hardware
  4. Data communications (handout)
    1. kb = kilobits or kilobaud, kB = kilo bytes
  5. Review for Quiz 2 (handout)
  6. Homework: Assignment 11
  7. Lab - Web searching (handout)
    1. Do searches according to directions, for the same topic on all of the search engines listed (Google, Alta Vista, Dobpile). Examples of topics:
      1. George Washington Carver
      2. Battle of Gettysburgh
      3. other...
    2. Print first page of search results, and first article (five pages max), turn them in as th elab assignment
  8. Computers off