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

  1. Announcements:
    1. 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.
    7. See change for Assignment 7, II.H.2.
  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.

  3. Midterm being passed back. Grading is on the basis of 5 points per problem, maximum possible number of points is 310, grade = total points / 310. Both total points and grade on the basis of 100 are xhown.

    1. Still people that need to take the Midterm, so no detailed discussion or review today.

    2. For Office in general, there are "strong" and "weak" methods of doing various tasks. For example, centering text. No one did this. so it makes a good example. Here are several methods that people do use:

      1. Weak. Use spacebar to center text. Problems with this: Depends upon font being used; change the font and the text is no longer centered. Does not work if the line splits or if you change the margins. Has to be redone frequently. Also, never gets exactly centered, some people will notice and criticize you.

      2. Medium. Use a center tab to center text. This is much better, but will not work if you change from portrait to landscape.

      3. 3. Strong method. Use "Center" paragraph formatting.

      You are expected to know and use the strong methods. These are what you learn during the lab sessions, from the reading and practice for the Tutorials, (the parts before the case studies).

    3. You should also be able to start work from an existing file, and from scratch, for Word, Excel, and Access (coming up).

  4. Content of the tutorials for Word and Excel in Microsoft Office 2000 Professional (handout)
  5. Computer architecture - handout
  6. Lab - Excel Tutorial 3 in Microsoft Office 2000 Professional, Pages EX 3.01 through 3.35. Pronto Salsa Company.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 9 due 11/11.

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

    2. Do Assignment 9 sheet, 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.

  8. Computers off