Last updated: 11/1/00
Link back to course Welcome

AGS 3340: Topics for Final Exam

The Final Exam for AGS 3340 will be Wednesday, December 20 at normal class time (6 - 10 PM) in the normal location (113 Rackham Building). Also, it will be cumulative.

There are numerous opportunities for practice, and Q&A, as follows:

1. Wednesdays 4 - 6 PM.
2. Fridays 6:30 to ??? If no one comes or calls by 7:30, I will leave, but if someone is here I will stay until 9:40 PM. Lab Telephone: 577-9705.
3. December 22, 4 - 6 PM (the day of the Final).
4. Phone, email, appointments, computer conference -- ask for what you want.

If you are unfamiliar with Excel and/or Access, you should find an opportunity to practice before the Final.

Topics for Final Exam:

1. All topics from Quiz 1 and Quiz 2 are included.
2. Databases
   1. Create databases and tables, enter information into tables, edit tables
   2. Sort records, and create filters, queries and forms
      1. Sort a Table (simple sort using one field only)
      2. Create a select Filter (including or excluding a selection)
      3. Convert a Filter to a Query
      4. Create a Relationship Query with a Join
      5. Create a Form using the Form Wizard
   3. Describe or define tables, relationship, join, fields, records, filters, queries, forms and reports, including what they are useful for
3. Release 2.1, chapters 8 to end
   1. For online privacy,
      1. Give some examples, including some different from those in the book, of cases where a person might want to have different information allowed or revealed in different cases
      2. Does the author feel that different people will want different online privacy levels? What do you think, and why?
      3. What are the roles that the author sees in dealing with privacy concerns for (a) government, (b) individuals, (c) technology and (d) third parties such as banks and other companies?
   2. What is the difference between privacy and anonymity? How are they similar? Does the author feel that different people will want different levels of anonymity? Can anonymity become a problem?
   3. What does the author mean by information security? What level of computer technology is available for security? What types of computer information security will be needed?
   4. What guidelines does the author offer for designing your life online? Give an example of how you might apply each one. Are there any additional guidelines that are important to you now?