Courses Wayne State University College of Urban, Labor, and Metropolitan Affairs (CULMA) Department of Interdisciplinary Studies (IS) Computers and Society courses, Winter 2003 (Bowen) at blackboard.wayne.edu Wednesdays, 6 - 9:40 PM in Computer Classroom 16 at WACC Computers and Society     GST 2710, Section 986, CRN 25072, 4 credits Computers and Society     AGS 3360, Section 986, CRN 25009, 4 credits Office hours: Wednesdays 5 - 6 PM at WACC	Instructor
	David R. Bowen 2311 A/AB Wayne State University Detroit, MI 48202	Daytime tel: (313) 577-1498 Evening tel: (248) 549-8518 FAX: (313) 577-8585 Home Page:     http://www.cll.wayne.edu/isp/drbowen Email: d.r.bowen@wayne.edu

Last updated: 3/26/03
Link back to course Welcome...

Tenth class: Agenda 10
Wednesday March 26

1. Announcements
   1. Handouts: (a) Agenda 10, (b) File Sizes for Computer Information, (c) Issues in Computers and Society
   2. Reminder: sign in at the beginning of class; sign out at the end.
   3. You can access the course web site either through Blackboard or through the public web (no login), www.cll.wayne.edu/isp/drbowen/casw03
   4. Online grade reports are available if you have first used the Course Information Form to change the information under "GradeReports" from No to Yes. If you want to go over your grades with me, without using the Online Grade Reports, see me outside of class.
   5. Passbacks and comments. So far, the assignments are not coming in on time, except for a few people.
2. Reminders
   1. Quiz 2 one-half hour at the beginning of class next week on April 2. See Agenda 9 Item II.A for details. The last thing we will do tonight is to review the topics list to remove the many items that we have not covered.
   2. Web page is due this week; see Agenda 5 Item VII for how to do this, Agenda 2 Item II.C.1 for suggestions on content. The web page should be finished by the end of the Lab period tonight.
   3. Essay is due April 23; see Agenda 2 Item II.C.2 for details.
3. Topics we will cover in class tonight:
   1. Computers and the war in Iraq
   2. Review of decimal to binary conversion.
   3. Internet
      1. World Wide Web ("web"), http, HTML, URLs
   4. Logic Gates
      1. Negation
      2. Circuits with multiple gates. Lesson: you cannot find the output of a gate unless you know BOTH of its inputs, so don't even try. In practice, this means to work from left (inputs) to right (outputs).
   5. File Sizes for Computer Information
      1. Types of computer information (review)
      2. Number of values in n bits (review)
      3. Sound file storage
      4. Number storage
      5. Computer instruction storage (programs)
4. We are asked to consider the effect of our course material on the war in Iraq. I have two effects of Computers and the Internet to mention.
   1. Certainly computer-guided weapons are more lethal than earlier types (more apt to hit and destroy or kill what they are intended to hit). But in also being precise, they are contributing to lower total death rates. Consider the hundreds of thousands of civilians killed by bombing cities, both by Germany and the US, during World War II, and the many civilians killed by "carpet bombing" during the Vietnam war.
   2. The Internet makes crossing national borders with information much easier. One example is the anonymous public web site (a "web log" or "blog") of someone who appears to be an Iraqi living inside Baghdad writing about his day-to-day experiences (http://dear_raed.blogspot.com/).
5. Binary to decimal conversion (from Agenda 4 but clarified). Binary to decimal conversion means that I give you a decimal number, then you tell me the corresponding binary number. Also note that Quiz 2 will not include any type of binary problems, while the Final will.
   1. Write down the powers of 2 in decimal that are not greater than the number to be converted. (Example: in converting 35, list 2⁰ = 1, 2¹ = 2, 2² = 4, 2³ = 8, 2⁴ = 16, 2⁵ = 32, and stop there because 64 is greater than 35.) We will also use a working number, which starts off as the decimal number to be converted to binary.
   2. Start from the largest power of 2 and work your way all of the way down to 1. Starting with the largest power of 2, compare it to the working number. Then do either step 1 or step 2, depending on whether the working the working number is greater than, equal to or less than the power of 2.
      1. If the working number is larger than or equal to the power of 2 then:
         1. Write down the power of 2 in binary. (Keep your columns straight for later addition.)
         2. Subtract the power of 2 in decimal from the working number. If the answer to the subtraction is zero, you are done, so STOP. Otherwise, the answer to the subtraction is is the new working number, cross the power of 2 off the list and go to the next lower power of 2 and step B.
      2. If the working number is less than the power of 2, then simply cross the power of 2 off the list and go to the next lower power of 2 and step B, without subtracting or writing down the power of 2 in binary.
   3. Continue through the powers of 2 until the result of the subtraction is zero. At the end, add up all of the binary numbers that you have written down, from step a above. The result is your answer, the decimal number converted to binary.
   4. Since decimal to binary conversion offers more chances for mistakes, and binary to decimal is so simple, I recommend checking a decimal to binary conversion by converting the result back to binary. If the two binary numbers are the same, you can be confidant of your result.
6. The Internet (handout).
7. Logic Gates (handout).
8. File Sizes for Computer Information (handout)
9. Lab 9. Read the following steps all the way through before starting. Please label your work "Lab 9."
   1. In Microsoft Office 2000 Professional, do Excel Tutorial 4 (Blue corners, pages EX 4.01 through EX 4.38). If you are going to do this outside of this lab, make sure that you know which pages to work on before you leave class tonight. Print out your document as described and a cover sheet made using Word (see below), and save your document to your floppy diskette.
   2. In this tutorial, you start from an existing file, Concepts.xls, and a graphic, Stove.pcx, both of which you can download from the course web site or get from the CD that came with your book.
   3. Create a one-page cover sheet for your lab using Word. On the cover sheet, put:
      1. Your name
      2. This Assignment (Lab 9)
      3. Your location (Wayne County Center)
      4. The full path (drive, any folders, and filename) that you saved your Excel file with.
      5. Print out the cover sheet and staple it in front of your Excel printouts.
   4. As a result of your work in this lab, you should be able to do the following under test conditions:
      1. Start Excel, beginning with the computer off.
      2. Open an existing workbook and save it under another name
      3. View worksheets in a workbook by clicking on their tabs
      4. Use Chart wizard to create a column chart and a pie chart inside a data worksheet or on a separate chart sheet
      5. Move and resize a chart
      6. Change data underlying a chart
      7. Delete a data series from a chart
      8. Add and edit text on a chart, such as titles and data labels
      9. Format the text on a chart
      10. Add fills and borders to a chart
      11. Change the subtype of a chart after your original choice
      12. Rotate a chart
      13. Use a graphic for the bars in a bar chart
      14. Save and print a worksheet and chart
   5. To practice these without the detailed directions in the Tutorial, look at the Review Assignment and Case Problems on Pages EX 4.39 through 4.41.
10. Don't forget to Sign Out!
11. Turning your computer off
    1. Save any files that you have worked on during the class and still have open
    2. Click on "Start" then Shut Down...
    3. Make sure that "Shut down the computer" is selected and click "Yes"
    4. Wait for the dialog "It is now safe to turn off your computer.", then turn off the power using the red switch under the desktop.

Assignment 10, due in class on March 26. Please write or type "Assignment 10" on the work you turn in for this assignment.

1. Finish and turn in the Logic Gates worksheet
2. In Computers, Technology, and Society, read Chapter LIF and answer the following Review questions on Pg LIF-34: 2, 6, 7 (list any disadvantages also), 8, 10 and 13.
3. Read the handout "Issues in Science and Technology" for discussion in class on April 9. The issues in this handout can also be used as a topic for your Essay.
4. In Microsoft Office 2000 Professional, read Integration Tutorial 1 (Int 1.01 through 1.19, this comes just after the Excel tutorials - NOT Int 2) in preparation for Lab 10 next week.