Computer Literacy Test #2 Terms

Technological Infrastructure

The progress of hardware technology
Killer Applications
Major Technological Steps in Information Systems History (see handout)
Linux vs. Windows, the Power of Giving
Open vs. Closed Architecture Strategies
Technical Job Market
Growing influence of Information Technology on our economy

The Dot-Com Crash

March 2000
Meaning to our national economics
Depth of the crash
Market Bubbles
New Technology impact
Boom and Bust Cycle
Education as a safety net
Technology speeding up the process
Technology impact on the stock market
Legal changes after 1920s crash and depression
Why people will always mislead investors

Software Concepts

Spreadsheets

Cells
Formulas
Column
Row

Software Licenses

Site License
Shareware
Public Domain
Pirate Software
Freeware
Software Piracy

Operating Systems

Windows
Multi-tasking
Multi-user
Command Line
GUI
Unix
Linux
DOS

File System

File
Folder
Executable File
Data File

WWW World Wide Web

Spyware
Home Page
URL

IM Instant messaging
Web Cam
Web Casting
Chat Rooms
Netiquette

Spamming
Flaming

Webpage traps (Alt-F4)

Pop-ups
Banners
Cookies
Blind Links

Networking

Open Architecture (open systems) vs. Closed Architecture
Network types

Client/Server network model

Internet online services

Electronic Commerce
American Online

Networking Hardware

Modem
Switches/Hubs
Routers
Bandwidth/Baudrate

Telecommunications Media

Twisted Pair
coaxial
Optical Fiber
Microwave
Infrared
Packet Radio

Cellular Phones
Internet Access:

ISP
dial-up modem
cable modem
DSL
Satellite

Types of wireless

Microwave
Infrared
Packet Radio

Network Protocols

Token Ring
Ethernet
TCP/IP

E-Commerce

Electronic Commerce (Usage of the Internet for Business)
B2B
B2C
Interdependence
Globalism
What “Dot-Com” means
Napster

File-Sharing
Peer-to-Peer
Impact on business

Intranets/Extranets
Retailing on the Web: Pros and Cons
Wholesaling on the Web
Resistance to Technology: Getting people to try new things
Which products work well with E-Commerce
Dot-Coms vs. Companies with Websites
Video and Teleconferencing
Electronic Funds Transfer
Shopping Cart
Telecommuting
Peer-to-Peer Technologies

Database Concepts:

DBMS
SQL – Structured Query Language
Data Dictionary
Data vs. Information

Database Objects:

Table/File
Record
Field
Database Primary Key/Unique Key
Query
Form
Report

Error concepts

Human Error

Data Validation

Garbage in/ Garbage Out
Catching the error first

Big Database Vendors, Oracle, MS Access, IBM big computers
Data mining
Database Administrator
Relational/Object-Oriented Database Structures
DBMS uses

Application Development
Database Development
Database Interrogation
Database Maintenance

Information Systems

IS (Information Systems)
IT (Information Technology)
Competitive Advantage (using IT)

Cost Strategies
Differentiation Strategies
Innovation Strategies

Computer-Based Information System
Data or Information Processing
Data Resources
Electronic Commerce (E-Commerce)
End User
Globalization
Hardware Resources
Data vs. Information
Information Products
Information Quality
Information System
Information System Model
Roles of IS in an organization
Computer Systems/Computer Peripherals
User Interface
System Software/Application Software/Procedures
The Ease of Overselling Technology (not in the book)
CAD (computer aided design)
CAM (computer aided manufacturing)
CIM (computer integrated manufacturing)
CASE (computer assisted software engineering)
SQC/SPC (Statistical quality control)/(Statistical Process Control)
Changes in staffing due to IS adoption

Clerical reduced
Technical increased

Reasons for new IS

o to improve product quality

o to reduce personnel

o to improve productivity

Specialized Information Systems

Executive support type of IS

o niche information system

o turnkey system

o closed system