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

Seventh class: Agenda
Wednesday February 26

1. Handouts: (a) Agenda 7, (b) Using Excel and (c) The Internet
2. Announcements
   1. Reminder: sign in at the beginning of class; sign out at the end.
   2. The Midterm is next week, Wednesday March 5 (not 6). It will be 60 minutes (not 90) at the start of class, 6:00 - 7:00 PM (if you arrive late you have less time for the Midterm). The list of topics for the Midterm was handed out last week. This week we will have a one-hour review of the midterm topics during the second hour of class. Note that this will not be enough time to review all of the topics (even the full class would not be enough time). Therefore, look the topics over, and come to class prepared to ask about the topics you are least sure of.
      1. The Midterm will have about ten questions. For questions on binary arithmetic, you will have to show work, including carries, to get credit. There will be four questions using computers; one with making folders and subfolders, two with Word (a double question) and one with Excel.
      2. If you have questions for the midterm that do not get answered tonight, you can call me, make an appointment to get together, and/or come to the Office Hours 5 - 6 PM in the classroom on March 5.
      3. Class will resume at 7 PM after the Midterm, and there will be an Excel lab as well.
   3. You can access the course web site either through Blackboard or through the public web (no login), www.cll.wa/yne.eduisp/drbowen/casw03
   4. Reminder: sign in at the beginning of class; sign out at the end.
   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.
3. Topics we will cover in class tonight:
   1. Hardware, Operating System and Applications
   2. Excel:
      1. Starting Excel, workbooks and worksheets; layout of a worksheet
      2. Selecting a cell in Excel, entering text, data or formlas
      3. Copying formulas: Relative Vs Absolute addressing
      4. Formatting
      5. Making a chart
      6. Saving a workbook
   3. 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
4. The hardware, the Operating System and applications. The figure below shows their relationships.
   
5. Spreadsheets
   1. Starting Excel with or without opening a file.
   2. A spreadsheet is for ______________
   3. The Excel document is called a _______________, which is made up of one or more _____________
   4. The Excel worksheet is a grid of __________ arranged in ________ and __________
   5. What can be in a cell?
      1. Number - how to enter?
      2. Text (why?) - how to enter?
      3. Formula - how to enter?
   6. How do you format in Excel? What kind of formatting can you do?
   7. How do you edit a cell in Excel?
   8. Using Excel (handout).
6. The Internet (handout).
7. Q & A for Midterm.
8. Lab 6. Read the following steps all the way through before starting. Please label your work "Lab 6."
   1. In Microsoft Office 2000 Professional, do Excel Tutorial 1 (Blue corners, pages EX 1.03 through EX 1.34). 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 (you cannot add the usual cover sheet in Excel but 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 6)
      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. Identify the parts of the Excel window
      3. Move around in an Excel worksheet using the mouse and the keyboard and Edit > Go To
      4. View multiple worksheets in a workbook
      5. Open an existing workbook
      6. Enter text as a label, enter values (numbers), enter formulas, use the sum function
      7. View an Excel chart
      8. Save a workbook using a new name
      9. Change data and see the results in a worksheet and chart (what-if analysis)
      10. Edit a cell
      11. Use help, including Office Assistant
      12. Clear the contents of a cell
      13. Print a worksheet
      14. 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 1.35 through 1.38.
9. Don't forget to Sign Out!
10. 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 8, due in class on March 6. Please write or type "Assignment 8" on the work you turn in for this assignment.

1. Identify or name the following, and break it down into parts - c:\Doc\ISP\Resume.doc
2. Identify or name the following, and break it down into parts - http://www.cll.wayne.edu/isp/courses.htm
3. In Computers, Technology, and Society, answer the following Review questions on Pp 7-28 and following: 2, 3, 5, 6, 11 and 12.
4. Hand in Lab 6 (see above)
5. In Microsoft Office 2000 Professional, read Excel Tutorial 2 in preparation for Lab 7 next week.