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/4/03
Link back to course Welcome...

Eighth class: Agenda 8
Wednesday March 5

1. Announcements
   1. Midterm. One hour from 6 to 7 PM. If you finish early, class will pick up at 7 PM.
   2. Handouts: (a) Agenda 8, (b) The Internet and (c) Logic Gates
   3. Reminder: sign in at the beginning of class; sign out at the end.
   4. You can access the course web site either through Blackboard or through the public web (no login), www.cll.wa/yne.eduisp/drbowen/casw03
   5. Online grade reports are available if you have first used the Course Information Form to change the information under "GradeReports" from No to Yes.
   6. If you want to go over your grades with me, without using the Online Grade Reports, see me outside of class.
   7. Passbacks and comments. So far, the assignments are not coming in on time, except for a few people.
2. Topics we will cover in class tonight:
   1. Review of Excel
   2. Internet
      1. IP address, structure of an Internet packet
      2. Domain Name Servers, domain names
      3. Internet applications
         1. Clients and servers
         2. Email; email addresses
         3. World Wide Web ("web"), http, HTML, URLs
   3. Logic Gates
3. Spreadsheets - Review of Excel
   1. A spreadsheet is for ______________
   2. The Excel document is called a _______________, which is made up of one or more _____________
   3. The Excel worksheet is a grid of __________ arranged in ________ and __________
   4. What can be in a cell?
      1. Number - how to enter?
      2. Text (why?) - how to enter?
      3. Formula - how to enter?
   5. How do you format in Excel? What kind of formatting can you do?
   6. How do you edit a cell in Excel?
4. The Internet (handout).
5. Logic Gates (handout).
6. Lab 7. Read the following steps all the way through before starting. Please label your work "Lab 7."
   1. In Microsoft Office 2000 Professional, do Excel Tutorial 2 (Blue corners, pages EX 2.01 through EX 2.36). 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, 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 7)
      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
      3. Enter text as a label, enter values (numbers), enter formulas (sum, percentage, average, min, max), use the AutoSum button
      4. Copy formulas using the Fill Handle and Copy/Paste
      5. Rename worksheet tabs
      6. Use relative and absolute referencing in formulas
      7. Use Spell Check in Excel
      8. Insert rows, change column widths, move cells using Drag 'N Drop
      9. Use AutoFormat
      10. Use Print Preview
      11. Center printout horizontally and/or vertically
      12. Add headers and footers to a worksheet
      13. Set Print Area
      14. Display and print worksheet formulas
      15. Print a worksheet
      16. Close a workbook and exit Excel
   5. To practice these without the detailed directions in the Tutorial, look at the Review Assignment and Case Problems on Pages EX 2.37 through 2.43.
7. Don't forget to Sign Out!
8. 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 9, due in class on March 12. Please write or type "Assignment 9" on the work you turn in for this assignment.

1. For the web server www.cll.wayne.edu, the default web page is "welcome.htm."
   1. Describe the steps that your browser browser goes through, given the following URL: http://www.cll.wayne.edu/isp/courses
   2. For the URL in A, what web page is actually displayed (folders, file name, extension)
2. What is actually wrong, according to the following error messages:
   1. "Server --- has no DNS Entry"
   2. "Server --- is not responding"
   3. "404 - File not found"
3. Turn in the Logic Gates homework problem (only if we get to this in class).
4. In Computers, Technology, and Society, answer the following Review questions on Pp 8-34: 2, 3, 5, 6, 9 and 10.
5. Hand in Lab 7 (see above)
6. In Microsoft Office 2000 Professional, read Excel Tutorial 2 in preparation for Lab 7 next week.