Courses Wayne State University College of Lifelong Learning Interdisciplinary Studies Program Computers and Society courses, Winter 2001     ( http://www.cll.wayne.edu/isp/drbowen/casw01) Mondays, 6 - 9:40 PM in 113 Rackham Computers and Society     GST 2710, Section 988, Call Number 95241, 4 credits Computers and Society     AGS 3360, Section 983, Call Number 98319, 4 credits Office hours: Mondays 4 - 6 PM in 113 Rackham	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/19/01
Link back to course Welcome...

Agenda 9
for class on
Monday March 19

1. Midterm exam
2. Handouts
   1. Agenda
3. Passbacks
   1. Assignments and Labs (as ready).
4. Reminders:
   1. Before you leave tonight, fill in the online Attendance (Signin) form on the course web site.
   2. If you miss a class, before the next class you should go to the course web site (the URL is in the upper left-hand corner of every handout) and review the Agenda for that class, then contact me if you have questions. Assignments and quiz topics are listed on the Agenda.
   3. If you need to make up a Quiz, or ask questions, or whatever, my office hours are time set aside for this. These times are Mondays and Wednesdays, 4 - 6 PM, in 113 Rackham (the classroom).
      
      If these times do not work for you, contact me to make other arrangements.
      
      I will not let you start a Quiz if the full half hour is not available before the start of the Monday night (I teach that one, of course) or Wednesday night (someone else teaches that one) class - both start a 6 PM, so 5:30 PM is as late as you can start a Quiz.
5. More Windows basics - Windows Explorer and the hierarchical file system. Windows Explorer is the Windows tool of choice for managing files
   1. Last week we used Drag 'N Drop to copy files. Today we will use Cut and Paste.
   2. Open Windows (NT) Explorer (Start / Programs) and change its options to show all information
      1. Choose menu item View / Options and then the "View" tab at the top of the Options dialog
      2. Above the list box, make sure that "Show all files" is clicked
      3. Below the list box, make sure that "Display the full MS-DOS path in the title bar" is checked. This refers to the title bar on the right pane of Windows Explorer. If this is unchecked, Explorer shows only the final (lowest) folder name
      4. Make sure that "Hide MS_DOS file extensions for file types that are registered" is unchecked. Otherwise, Explorer does not show the file extension for most file names.
      5. Make sure that "Include description bar for right and left panes" is checked. Otherwise, Explorer does not show you what drives and folders you are looking at.
      6. Click OK. This puts your choices into effect.
   3. Open the test floppy diskette in Windows (NT) Explorer. (Do this by clicking on the drive icon. Click on a file, then right click on it and choose "Copy." Go to another folder on the C: drive and right click on it, choosing "Paste" (was not available until you had something copied to the clipboard.
      1. This will also work with a selection of files.
      2. "Cut" will remove files from the original location, after they are pasted into the new location
      3. "Cut" can also work with Drag 'N Drop by holding down the <Alt> key.
      4. There are keyboard alternatives for Copy/Cut and Paste. <Ctrl>c and <Shift><Insert>do copy, <Ctrl>x and <Ctrl><Delete> do Cut, and <Ctrl>v and <Ctrl><Insert> do paste.

Lab 9.

In New Perspectives On Microsoft Office 2000 Professional, do Excel Tutorial 4 on pages EXCEL 4.1 through EXCEL 4.42. The lab assignment is to download the file Concepts.xls and edit, format, save and print out this file with the name
"Cast Iron Concepts.xls" according the the directions throughout the Tutorial - in other words, start at the beginning of the tutorial and work your way through it. No other part of this tutorial is assigned.

1. Download the file from the course web site using the "Concepts.xls" link under the Agenda 9 link.
2. Do NOT save the file to the location given in the book. Save it to your floppy diskette instead.
   REMINDER: being able to control where you save your files to is part of this course! Make sure you can do this without looking at a book or notes! So is starting Excel.
3. When you are done, make a title sheet, with (a) your name, and (b) what assignment this is (Lab 8), print out a copy of your edited file, staple the pages together, and turn in this copy, by the start of the next class. This, together with your chat / computer conference account, is your lab report. You can print the spreadsheet using either:
   1. The printer icon on the toolbar
   2. The menu item File / Print, then click OK on the "Print" dialog.

Assignment 9. Please write or type "Assignment 9" on the work you turn in for this assignment (due 3/26).

1. In Computers, Technology, and Society, read Chapter 9 and answer the following Review questions on Pp 9-41 and 9-42: 3, 5, 8, 9 and 10.