Fall 1998 Computers and Society
Tuesdays 6 - 9:40 PM in 113 Rackham: GST 2710, Section 990 and AGS 3360, Section 983
Mondays 5:30 - 9:10 PM at NWAC: GST 2710, Section 984
Course web site: http://www.cll.wayne.edu/isp/drbowen/casf98/
Last updated: 11/17/98
Link back to course Welcome...

Eleventh class: Agenda
Rackham: Tuesday November 17 / NWAC: Monday November 23

  1. Announcements:
    1. Tuesday, November 24. No class for Rackham Section. However, I will be there for office hours and lab use from 4 - 6 PM. ALSO, makeup for midterm starting at 6 PM.
    2. Quiz 6: Monday November 30 (NWAC) / Tuesday December 1 (Rackham). You will be using the computers for this. Can you open a file from a floppy disk? Can you save a file to a floppy disk? Do you know how to insert a Header with your name on it in Word and Excel? Can you change fonts in Word? Can you left align, right align, justify and center a paragraph in word? Can you enter a formula in Excel?
    3. Sign in on the course web site (every class).
    4. The people listed below do not have on-line grade reports enabled. This is not a requirement for the course, but it does give you a good record of how you are doing. If you are on the list below, and want on-line grade reports, leave a note for me, including the password that you want to use to access grade reports.
      1. Rackham (Tuesdays)
        1. James Hobbs
        2. Frazier Kimpson
        3. Pamela Shaw
      2. NWAC (Mondays)
        1. Veronica Hill
        2. Gladys Karlin
        3. Melissa Mobley
    5. The people listed below still need to log on to the computer conference for this class. For instructions, see Agenda 5, VII.A.
      1. Rackham (Tuesdays)
        1. Melanie Brown
        2. Nantambu Kohlbatz
        3. Pamela Shaw
      2. NWAC (Mondays)
        1. Joyceline Blackmon
        2. Jason DeMeyer
        3. Precious Sampson
        4. Jevon Woods
  2. Handouts, pass backs
  3. Paper and Pencil Computer. See handouts.
  4. Using Telnet and WSU email. See handouts.
  5. Topics for Quiz 6
    1. Internet basics and applications (Telnet, World Wide Web, email and FTP)
    2. Logic Gates
    3. Recent developments in computer communications -- the "last mile problem" from the textbook and from class discussion
    4. Basic functions of Word Processors, Spreadsheets and Database programs. word processors and spreadsheets from Midterm Topics. Databases:
      1. File open. How does data get saved?
      2. Basic database structures. Tables, records and fields.
      3. Adding records.
      4. Forms Vs datasheets.
    5. Paper and Pencil Computer. The Master Diagram, Architecture, Instruction Register, Instruction Set and Memory Contents diagrams will be given. The question will be to trace out a small program.
  6. Lab 10.
    1. Basic computer skills. For Quiz 6, you should be able to carry out the following tasks without the step-by-step instructions such as you get in Microsoft Office Professional 97 Step by Step, or in many of the Agendas and Labs here.
      1. Start a program. Example: Start Microsoft Word. (NOTE: Microsoft is the manufacturer, Word is the product. "Microsoft Word" and "Word" mean the same thing.) Examples of programs that this can apply to:
      2. Microsoft Word
      3. Microsoft Excel
      4. Netscape (NOTE: Netscape is the manufacturer. The products are Navigator and Communicator, but normally these are just called "Netscape". Netscape is a Web Browser -- a program that used to view web content. A competing Web Browser is Microsoft Internet Explorer. It works pretty much the same way that Netscape does. On the other hand, Internet Explorer is different from Windows Explorer.)
      5. Windows (NWAC: NT) Explorer
      6. With a program started, open a document on any drive, or open a web site
        1. In Word and Excel, open a file, given the path, including the floppy drive
        2. In Netscape, open a web site, given the URL.
          1. URL = "Uniform Resource Locator", such as http://www.cll.wayne.edu/isp/drbowen/casf98
      7. In Netscape, follow a link by clicking on it. Links are colored blue or purple (if they have been followed already), and underlined. the active part of the link is the words themselves.
      8. Print an open file in word or Excel or web page in Netscape.
      9. In Word, Excel or Netscape, Save or Save As, including saving a file to the floppy drive using a different name (retain the default Word/Excel/Netscape extension). Use Save As the first time you save a new file, or if you want to change the path of an existing file. If you open an existing file and Save, you will replace the original version with the current version. Otherwise, Save saves to the path you set in the last Save As.
      10. In Word, enter new text, move or copy text using the Windows clipboard and format text, including changing the font, changing the horizontal alignment (Left, Right, etc.), making bulleted lists, and changing the indents and line spacing. Create bulleted or numbered lists.
      11. In Excel, enter and align text, enter and format numbers (currency, percent) and formulas using sum, multiplication, division, addition and subtraction.
      12. The main Word menus are
        1. File. Used for getting the file into Word and outputting it from Word. Includes opening, saving and printing.
        2. Edit. Used for changing the content of text; moving it around, deleting it, copying it.
        3. Format. Used for changing the appearance of text. Font format affects individual letters, paragraph formatting affects entire paragraphs but not individual letters, etc.
        4. Insert. Inserts things besides text into a document, such as pictures and charts.
    2. Specific practice
      1. Start Microsoft Word and open a:\globwarm.doc. Be sure to save your work regularly. There is no mercy if your computer crashes during the test, and you lose your work because you have not saved. That is not bad luck, that is stupidity, and I don't cut any slack for stupidity.
        1. Correct the typos using spellcheck
        2. Move what is now the third paragraph so that it is the second paragraph.
        3. Create two lines of space at the top of the document. type in the title "Global Warming". Make the title 16 Point Arial New Bold and center it.
        4. for the body of the document (that is, excluding the title) make the first line of each paragraph indented by one-half inch, using paragraph formatting.
        5. Save the edited document as c:\My Documents\practice1.doc
        6. Save again, as a:\glob2.doc
      2. Start Microsoft Excel and open a:\example.xls. What was that about saving?
        1. In Cell A1, enter "Practice Spreadsheet". Make it Times New Roman, size 16, Bold.
        2. In Cell A3, enter "Expenses"
        3. In Cell A12, enter "Income"
        4. In Cell C5, enter "847"
        5. In Cell A19, enter "Savings"
        6. Make Column B wide enough to show all of the text in Cell B13.
        7. In Cell B16, capitalize the initial d in deductions.
        8. Format Column C as currency.
        9. In Cell D10, enter a formula using the SUM function to calculate the total expenses as the sum of the individual expenses in Column C. Make sure that the results are formatted as currency.
        10. In Cell C15, enter a formula to calculate Total Wages as Hours Worked times Hourly Rate.
        11. In Cell C16, enter a formula to calculate Taxes and Deductions as 35% of Total Wages (.35 times Total Wages)
        12. In Cell D17, enter a formula to calculate Net Wages as Total Wages minus Taxes and Deductions
        13. In Cell D19, enter a formula to calculate Savings as Net Wages minus Total expenses.
        14. Save the spreadsheet as a:\yourname.xls, where yourname is your name
  7. Email assignment.
    1. When the diskette "email addresses" comes by, start Microsoft Word, open the file a:\emailf98.doc, and follow the directions in the file to add your email address to the list. Save the file back to the diskette (Save, not Save As).
    2. Send an email message to the Instructor, aa2012@wayne.edu
    3. Send an email address to another student in the class, with a cc to the Instructor.
    4. Forward an email message to the Instructor.

Assignment 11

  1. Pp 10-13 and 10-14, the 10 Multiple Choice questions.
  2. Pg 10-15, Review questions 1 and 2.
  3. Pg 10-16, Critical Thinking question 3.
  4. Pg 10-28, the 10 Multiple Choice questions.
  5. Pg 10-43 and 10-44, the 10 Multiple Choice questions.