|
|
Podcast |
Tutorials |
SecondLife |
Other |
Learning Outcomes |
|
|
|
|
|
|
|
Dave McD
Introduction |
|
|
|
Management Information Systems for the Information Age |
|
|
|
|
|
Chapter 1 - The Information Age in Which You Live |
|
|
|
|
|
a. Describe the Information age and the role of knowledge workers within
it. |
|
Dave McD
Info Age |
|
|
|
b. Define management information systems (MIS). |
|
|
|
|
|
c. Describe key factors shaping today’s economic environment. |
|
|
|
|
|
d. Validate information as a key resource and describe both personal and
organizational dimensions of information |
|
Dave McD |
|
|
|
e. Define how people are the most important organizational resource,
their information and technology literacy challenges, and their
responsibilities. |
|
|
|
|
|
f. Describe the important characteristics of information technology (IT)
as a key organizational resource. |
|
|
|
|
|
g. List and describe the six roles and goals of information technology
on any organization |
|
|
|
|
|
|
|
|
|
|
|
Chapter 2 - Strategic and Competitive Opportunities |
|
Dave McD
Competitiveness |
|
|
|
a. Illustrate how the creative use of information technology can give an
organization a competitive advantage. |
|
Dave McD |
|
|
|
b. Describe how to develop business strategies for the Internet Age and
use tools to help. |
|
|
|
|
|
c. Describe how e-commerce technologies up the stakes and give
organizations even more opportunities. |
|
Dave McD |
|
|
|
d. Summarize how one specific industry has consistently used information
technology for competitive advantage. |
|
|
|
|
|
e. Summarize how to use information technology for competitive advantage
in an organization. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 3 - Databases and Data Warehouses |
|
Dave McD
Veda S |
|
|
BI |
a. Describe business intelligence and its role in an organization. |
|
|
|
|
|
b. Differentiate between databases and data warehouses with respect to
their focus on online transaction processing and online analytical
processing. |
|
|
|
|
|
c. List and describe the key characteristics of a relational database. |
|
|
|
|
|
d. Define the five software components of a database management system. |
|
|
|
|
NYPD & IS |
e. List and describe the key characteristics of a data warehouse. |
|
|
|
|
|
f. Define the four major types of data mining tools in a data warehouse
environment. |
|
|
|
|
|
g. List key considerations in managing the information resources in an
organization. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 4 - Decision Support and Artificial Intelligence |
|
|
|
|
|
a. Define decision support system, list its components, and identify the
type of applications it’s suited to. |
|
|
|
|
|
b. Define collaboration systems along with their features and uses. |
|
|
|
|
|
c. Define geographical information systems and state how they differ
from other decision support tools. |
|
|
|
|
|
d. Define artificial intelligence and list the different types that are
used in business. |
|
|
|
|
|
e. Define expert systems and describe the types of problems to which
they are applicable. |
|
|
|
|
|
f. Define neural networks, their uses, and a major strength and weakness
of these AI systems. |
|
|
|
|
|
g. Define genetic algorithms and list the concepts on which they are
based, and the types of problems they solve. |
|
|
|
|
|
h. Define intelligent agents, list the four types, and identify the
types of problems they solve. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 5 - Electronic Commerce |
|
|
|
|
|
a. Describe the four main perspectives of e-commerce, its current
status, and the global growth expected in the next few years. |
|
|
|
|
|
b. Identify the advantages of business to consumer (B2C) commerce. |
|
|
|
|
|
c. Describe the techniques that lead to success in B2C e-commerce
ventures. |
|
|
|
|
|
d. Describe the variety of ways that business to business (B2B)
e-commerce technologies are being used, and describe next generation
models, which may widen the adoption of global B2B e-commerce. |
|
|
|
|
|
e. Identify the unique aspects of e-government applications. |
|
|
|
|
|
f. Describe the status and options for e-commerce payment systems. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 6 - System Development |
|
CW SDLC |
|
|
CW Quick Study |
a. List the seven steps in the system development life cycle and an
associated activity for each step. |
|
|
|
|
|
b. List four reasons why your participation during the systems
development life cycle is critical. SDLC
Humor? |
|
|
|
|
|
c. Describe three of the five reasons why projects fail. |
|
|
|
|
|
d. List two of the three advantages of selfsourcing. |
|
|
|
|
|
e. Describe prototyping and profile an example of a prototype. |
|
|
|
|
|
f. Describe two of the five advantages of prototyping. |
|
|
|
|
|
Let's be
agile also... :-) |
| |
|
|
|
|
|
|
|
|
|
Chapter 7 - IT Infrastructures |
|
|
|
|
|
a. Explain the relationship between organization’s roles and goals and
the IT infrastructure. |
|
|
|
|
|
b. List and describe four of the seven factors that help increase
employee productivity. |
|
|
|
|
|
c. Explain system integration and how it enhances decision-making. |
|
|
|
|
|
d. List and describe two different types of workflow systems. |
|
|
|
|
|
e. List and describe two IT infrastructure components that create
business partnerships and alliances. |
|
|
|
|
|
f. List and describe two of the four IT infrastructure components that
enable global reach. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 8 - Protecting People and Information |
|
|
|
|
|
a. Define ethics and describe the two factors that affect how you make a
decision concerning an ethical issue. |
|
|
|
|
|
b. Define and describe intellectual property, copyright, Fair Use
Doctrine, and pirated and counterfeit software. |
|
|
|
|
|
c. Define privacy and describe the ways in which it can be threatened. |
|
|
|
|
|
d. Describe the two ways that information is valuable to business. |
|
|
|
|
|
e. Describe the ways in which information on our computer or network is
vulnerable. |
|
|
|
|
|
f. Define risk management and risk assessment and describe the seven
security measures that companies can take to protect their information. |
|
TonyVance
Computer Forensics |
|
|
|
|
|
Dave McD
Emerging Technologies |
|
Dave McD |
|
Chapter 9 - Emerging Trends and Technologies |
|
|
|
|
|
a. Describe why information filtering is becoming important and list and
define the two trends that will support information filtering. |
|
Dave McD |
|
|
|
b. Describe the movement toward intellectual computing including
automatic speech understanding and the role of people in
decision-making. |
|
Dave McD |
|
|
|
c. Define biometrics, automatic speech recognition, virtual reality, and
CAVs as they relate to changes in physiological interaction. |
|
Dave McD |
|
|
|
d. Describe the various technology innovations and trends that will
increase portability and mobility. |
|
Dave McD |
|
|
|
e. Discuss the challenges of and technological innovations for the
coming digital frontier. |
|
|
|
|
|
f. Describe the broadening of e-government and the coming C2C explosion
as they relate to the re-birth of e-commerce. |
|
Upkar V
Mobile |
|
|
|
Upkar
V
speaks on mobile & wireless computing (larger) |
|
|
|
|
Top 10 |
Gartner's Top 10 Technologies for 2008 |
|
|
|
|
Emerging 10 |
MIT Technology Review's Top 10 Emerging Technologies for 2008 |
|
|
|
|
SIGGraph |
SIGGraph 2007 Emerging Technologies |
|
|
|
|
|
XML A - Computer Hardware and Software |
|
Dave McD
HWSW Intro |
|
|
|
a. Define Information Technology (IT) and its two basic categories:
Hardware and Software. |
|
|
|
|
|
b. Describe categories of computers by size. |
|
Dave McD |
|
|
|
c. Compare the roles of personal productivity, vertical market and
horizontal market software. |
|
Dave McD |
|
|
|
d. Describe the roles of operating systems and utility software as
components of system software. |
|
Dave McD |
|
|
|
e. Define the purpose of the six major categories of hardware. |
|
|
|
|
|
|
|
|
|
|
|
XML B - The WWW and the Internet |
|
|
|
|
|
a. Define the relationship among web site, web site address, domain
name, web page and uniform resource locator (URL). |
|
|
|
|
|
b. Explain how to interpret the parts of the address on the web. |
|
|
|
|
|
c. Identify the major components and features of web browser software. |
|
|
|
|
|
d. Describe the differences between directory and true search engines. |
|
|
|
|
|
e. Describe the various technologies that make up the Internet. |
|
|
|
|
|
f. Identify key considerations in choosing an Internet service provider
(ISP). |
|
|
|
|
|
g. Describe the communications software and telecommunications software
you need to connect to the Internet. |
|
|
|
|
|
|
|
|
eTraining;
Access 2007 in Pictures;
Microsoft |
|
|
Downloading Access Instructions
Using MSDNAA
Access Tutorials:
eTraining;
Access 2007 in Pictures;
Microsoft |
|
|
|
|
|
Database Concepts |
|
Dave McD |
|
|
|
Chapter 1 - Getting Started |
|
|
|
|
|
a. Survey the why, what and how of database processing. |
|
Dave McD |
|
|
|
b. Understand the reasons for using a database (why). |
|
Dave McD |
|
|
|
c. Learn the functions and components of database systems (what). |
|
Dave McD |
|
|
|
d. Know the three major steps in creating a database (how). |
|
|
|
|
|
|
|
Dave McD
Relational Model |
|
|
|
Chapter 2 - The Relational Model |
|
Dave McD |
|
|
|
a. Learn the conceptual foundation of the relational model. |
|
Dave McD |
|
|
|
b. Understand how relations differ from nonrelational tables. |
|
Dave McD |
|
|
|
c. Learn basic relational terminology. |
|
Dave McD |
|
|
|
d. Learn the meaning and importance of keys, foreign keys and related
terminology. |
|
Dave McD |
|
|
|
e. Understand how foreign keys represent relationships. |
|
|
|
|
|
f. Learn the purpose and use of surrogate keys. |
|
Dave McD |
|
|
|
g. Learn the meaning of functioning dependencies. |
|
|
|
|
|
h. Understand the two basic relational design principles. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 3 - Structured Query Language |
|
Dave McD |
|
|
|
a. Learn basic SQL statements for crating database constructs. |
|
Dave McD
SELECT Statement |
|
|
|
b. Learn basic SQL SELECT statements and options for processing a single
table. |
|
|
|
|
|
c. Learn basic SQL SELECT statements for processing multiple tables with
subqueries. |
|
|
|
|
|
d. Learn basic SQL SELECT statements for processing multiple tables with
joins. |
|
|
|
|
|
e. Learn SQL Statements to add, modify and delete data. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 4 - Data Modeling and the Entity-Relationship Model |
|
Dave McD |
|
|
|
a. Learn the basic stage of a database development project. |
Dave McD
Logical Model
Sparc Architecture |
|
|
|
b. Understand the purpose and role of a data model. |
|
Dave McD
Semantic Models |
|
|
|
c. Know the principal components if the E-R data model. |
|
|
|
|
|
d. Understand how to interpret both traditional and UML-style E-R
diagrams. |
|
Dave McD |
|
|
|
e. Learn to construct traditional E-R diagrams. |
|
Dave McD |
|
|
|
f. Learn how to represent 1:1, 1:N, N: M, and binary relationships with
the E-R model. |
|
Dave McD |
|
|
|
g. Know how to represent recursive relationships with the E-R model. |
|
Dave McD |
|
|
|
h. Understand the two types of weak entities and know how to use them. |
|
Dave McD |
|
|
|
i. Learn how to create an E-R diagram from source documents. |
|
|
|
|
|
|
|
|
|
|
|
Chapter 5 - Database Design |
|
Dave McD |
|
|
|
a. Learn how to transform E-R data models into relational designs. |
|
Dave McD
Normalization |
|
|
|
b. Understand the nature and the background of normalization theory. |
|
Dave McD |
|
|
|
c. Know how to use normalization criteria to evaluate relational
designs. |
|
|
|
|
|
d. Understand the need for denormalization. |
|
Dave McD |
|
|
|
e. Learn how to represent 1:1, 1:N, and N:M binary relationships. |
|
Dave McD |
|
|
|
f. Learn how to represent 1:1, 1:N, and N:M recursive relationships. |
|
Dave McD |
|
|
|
g. Learn SQL statements for creating joins over binary and recursive
relationships. |
| |
|
|
|
|
CIS Department
J. Mack Robinson College of
Business
Georgia State University
35 Broad Street, NW
P.O. Box 4015
Atlanta, GA 30302-4015
Phone: 404.413.7360
Faculty Contact for CIS 2010:
Jeff Hubona, Ph.D.,,
Associate Professor and CIS 2010 coordinator,
hubona@gsu.edu
Carl Stucke, Ph.D.,,
Associate Chair,
cstucke@gsu.edu
