The second exam is Wednesday, May 14. It will be closed-book, closed-notes. It is worth 75 points, or 15% of your course grade. You will have the entire class period to take the exam. The exam will be a combination of multiple choice, matching and short answer questions.

Note: I hand out two versions of the exam. They differ only in the order of questions. The students in front of you and behind you will have your version; the students on your left and right will have the other version.

Resources

• A complete set of lecture notes is available on the web at
  http://faculty.otterbein.edu/PSanderson/CSC100/schedule.html. We did not cover every single topic, but you should start by reviewing these. My exam topics are drawn mainly from the notes.
• Read the textbook. Read the posted lecture notes for a chapter first, then re-read/review that chapter. There are topics in the book that are not covered in the notes, and there will be few if any questions over those.
• Questions at the end of each chapter: True or False, Multiple Choice, and Review Questions. Work through these questions. You will see some questions like them on the exam.

Things you should know, by category, in the order we covered them:

Databases (chap 7)

• what a database is
• database terminology (record, field, key field, query, etc)
• what SQL is
• what a relational database is
• tables and relations in Microsoft Access

Graphics (chap 6)

• what pixels are, where pixel values are stored and what the values represent
• basics of RGB and CMY color systems
• comparing monitors to printers: resolution and color systems
• difference between raster (bitmap) and vector (object) graphics
• factors that determine storage requirements of digital audio or video (sampling rate, sample size, compression)

Network Communication (chap 8)

• The difference between analog and digital signals.
• Basic differences among network connections: dialup modems, DSL, cable modem, LAN, satellite, Wi-fi.
• Basic facts about Ethernet (the transmission protocol used in most LANs)
• Transmission media and characteristics: copper wire (twisted pair, coax), fiber optic, wireless (microwave, radio wave)

The Internet (chap 9)

• Origins of the Internet.
• What the term "protocol" means
• The difference between client-server and peer-to-peer applications
• two forms of internet addresses: numeric IP address and domain name address
• What the Domain Name System (DNS) is (translates names to numeric addresses) and why it is critically important
• What each component of a URL is.
• What HTML and HTTP are, and how they are different.
• basics of HTML (what HTML means, what tags are, how they are used, what the browser does with them)

Security and Risks (chap 10)

• What spyware, spoofing and phishing are, and how they are used in identity theft
• What viruses, worms, Trojan horses can do, and how you get them and prevent them.
• What denial-of-service attacks are
• What zombies are, and their role in all the above attacks
• What firewalls are and what they do.
• Difference between traditional (secret key) encryption and public key encryption.
• Major authentication methods in use today (passwords, biometrics, etc).

Study hard and good luck!