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: 12/7/98
Link back to course Welcome...

Topics for Final Exam

The Final Exam will be during the regular class time on

These topics will be discussed in class on

These topics are cumulative; all topics for the Midterm and Quiz 6 are included; the topics here are in addition to the Midterm and Quiz 6 topics.

  1. The Internet
    1. General
      1. Brief statement of the structure of the Internet and what it does
      2. Brief description of how Gateways and Routers carry out the basic Internet function of information transport between computers
      3. Describe or give an example of the numerical IP address and how it is used on the Internet
      4. Brief description of client-server functions and interaction
      5. Describe what a domain name is and how clients use a Domain Name Server
    2. Applications. For each of the Internet applications below, brief descriptions of (a) what the application does, (b) how the client and server interact in doing this and (c) what type(s) information are exchanged
      1. World Wide Web
        1. Describe briefly how web searches work (Lab for Class 14)
      2. Email
      3. Telnet
      4. File Transport Protocol (FTP)
  2. Logic Gates (AND, OR, XOR)
    1. Recognize shapes by name
    2. Use name to fill in truth table
  3. Paper and Pencil Computer. (The documentation will be improved.) Given the documentation for the Paper and Pencil Computer (layout diagram, master diagram, Instruction Register division into Op Code and address of RML, instruction set and memory diagram), carry out the next instruction cycle, indicating the contents of the following locations at the end of the cycle:
    1. Accumulator (starting value may be given)
    2. Instruction Register
    3. Program Counter
    4. Keyboard
    5. Monitor
    6. Any memory location that has a new value
  4. Computers and Society. Given a list of three issues in Computers and Society, choose two and in approximately one-half page of writing
    1. Describe what the issue is about
    2. Indicate the range of public opinions on the issue
    3. State your own opinion and your basis for it
  5. Identify (mark and name) the parts of
    1. A path
    2. An Internet URL
    3. An Internet email address
  6. Summarize the content of each section of the Comments on Readings in III on Agenda 10
  7. Computer applications
    1. General functions
      1. Difference between entering or editing and formatting
      2. When do you need to use "Save As" Vs "Save"
      3. What does "Save" do
      4. Difference between Explorer view of folders and files, and File Open view of folders and files
    2. Spreadsheets
      1. Layout of worksheet into rows and columns intersecting in cells
      2. What types of content can be entered into a cell
      3. Describe how to enter a formula into Excel (this can be different in other spreadsheets such as Lotus 1-2-3)
      4. What types of formatting can be done in a spreadsheet? (row height, column width, font face, size, weight etc. and number formatting into currency, percent, date and others)
      5. Describe the "what if" function of spreadsheets
    3. Databases
      1. Describe the layout of a database into tables, fields and records
      2. Describe what a relation between tables is, and what it does
      3. List the types of content in records and fields
      4. List the types of formatting in records and fields
      5. Decribe the uses of Forms, Queries and formulas in a database
      6. Describe how information gets saved in a database
  8. Practical skills (in addition to those for Word and Excel in the Midterm Topics)
    1. Start Microsoft Access and open an existing database
    2. Add records to an existing table using a Form or directly, using the Datasheet view
    3. Add a new table to a database, using either the Datasheet View or the Table Wizard
    4. Change field names in an existing table, using either the Datasheet view (double-click on default field name supplied by Access) or Design View

    NOTE: These can be "chained" together. For example, you could be asked to open an existing database, add a table, change the field names in this table, and enter data in the table.