R. Craig Collins > BCIS 1305/ITSC 1309 > DC Review 2

Table of Contents
1. Introduction to Computers
2. The Internet and World Wide Web
3. Application Software
4. The Components of the System Unit
5. Input and Output
6. Storage
7. Operating Systems and Utility Programs
8. Communications and Networks
9. Database Management
10. Computer Security, Ethics, and Privacy
11. Information System Development and Programming Languages
12. Enterprise Computing

Test 1: 1, 2, 7, 3, 4, 5 Word

Test 2: 6, 8, 9 Excel

Discovering Computers 6: Storage
Describe the characteristics of magnetic disks
Floppy vs zip vs hard disk, vs optical disks
CD* vs DVD *
    • capacity
    • ROM vs. R vs. RW
Tape (sequential vs random access)
Miniature mobile storage

Discovering Computers 8: Communications
Sender receiver medium (channel)
Types of networks
   •Peer to peer
   •Client server
    • LAN
    • WAN
Architecture/topology
   •Bus
   •Ring
   •Star (Ethernet)
Phones
   •Dial up (analog)
   •ISDN (digital)
   •DSL
BroadBand
   •DSL
   •T1
   •T3
Wireless
   • 803.11b-g
   •Satellite, radio, microwave
Devices
   •Hub
   •Nic
   •Modem

Discovering Computers 9: Databases
Valuable information
   • timely
   • accurate
   • available
   • useful
Hierarchy
   • Characters
   • Field
   • Record
   • File
   • Database
   • Relational database
File processing vs database approach
   • Validatation/data integrity (input masks)
   • Reduce redundancy
DB vs DBMS
Database designer vs administrator vs user