Revised 11/08/2006
Facilitator
Dr. Daniel Power
255 Curris Business Building, Department of Management
College of Business Administration University of Northern Iowa
Cedar Falls, IA 50614-0126 U.S.A
phone: (319) 273-2987, fax: (319) 273-2922
e-mail: Daniel.Power@uni.edu
web site: http://DSSResources.COM
Course Schedule
Wednesdays
Power, D. J. Decision Support Systems: Concepts
and Resources for Managers, Quorum Books, 2002.
Course Packet, Microsoft Excel 2002, Copyworks.
You will receive a free subscription to
DSSResources.COM. The subscriber zone has support materials that you should
find useful.
Provides students with
knowledge of the role of information systems within an organization; systems,
information and decision theory; information systems applications including
decision support; and systems evaluation and selection. Prerequisites: consent
of MBA Director.
This is an advanced course in
information systems and information technology (IS/IT) for MBA students. The
course is targeted to students who want more expertise in developing, managing
and using information systems and especially Decision Support Systems, but who
do not want to master and use the specialized systems development and technical
skills associated with an MIS major curriculum. If you want to be a
sophisticated IS/IT user and possibly an innovator AND a business manager or
staff support specialist, then this course should be a "good fit" for
you.
Today, business information systems are a
primary channel for communicating, storing and retrieving product orders,
accounting records, and other business data. In your information systems
foundation course, you learned that information systems support most tasks and
functions of an organization. Also, you learned most managers are involved with
using and managing information. You should have developed some knowledge of how
computers, software, networks and information systems support business decision
making and operations. You probably realize that some of what you learned is
already dated or obsolete. We are studying complex, rapidly changing systems
and technologies. For all of the above reasons, managers need to continually
learn more about IS/IT and they need to develop a positive partnership with
Information Systems professionals. Managers and IS professionals must share responsibility
for the effectiveness of information systems and share responsibility for
dealing with the problems and opportunities presented by rapidly changing
information technologies. Managers must consider both information systems and
information technology issues when they design jobs, supervise subordinates,
work with customers and suppliers, formulate strategy, develop goals and plans
and implement management controls.
Your knowledge of information systems and
information technology must include understanding how IS/IT can help you be a
better manager and how it can help improve the management and operations of the
company where you work.
The primary focus of this course is exploring
the design and development of decision support systems and web-based
information systems. We will also explore the role of information systems in
supporting organization goals and the impact of information systems on
organizations.
My perspective will be both managerial and
technical. My overriding concern is helping you become a person who can use and
manage information systems and technologies to improve you own productivity,
the productivity of subordinates and co-workers and the productivity of the
organization as a whole.
As a result of our work together
in this course, you should:
Most of our class sessions
are oriented to mini-lectures, discussions, student presentations, web-based
materials, cases and company examples. The readings, case studies and
supporting material will introduce you to problems and solutions associated
with management use of information and decision support systems. Discussions will emphasize using and managing
information systems and information technology. Grading will emphasize mastery
of concepts and understanding of the material discussed and presented in class
sessions. Students are responsible for
completing all assigned readings.
Your final grade is a function of four major
components, including:
Quizes/short write-ups/Excel exercises |
100 |
2 Case Analyses and a case presentation |
100 |
Project and Presentation |
100 |
Exam on DSS book |
100 |
Students
receiving at least 92% of the points will receive an A; at least 82%, a B; at
least 72%, a C. Plus and minus grades will be awarded. The curve may be
adjusted downward at the discretion of the instructor.
You will be expected to complete a number of
in-class and out-of-class assignments, quizes and
Excel exercises (100 points). If you have problems that prevent you from
following the class schedule, please let me know in advance and we will discuss
how we might accommodate your situation. In class labs are open book and open
notes. If the lab is submitted at the end of the lab session, then the student
can receive 100% of the points. Lab exercises submitted within 24 hours of the end
of a lab session can receive a maximum of 80% of the total points for the lab.
You
will be expected to complete two case study analyses during the course. All students will submit a 5 page typed
analysis (35 points) of Power & Roth “Ertl's Decision Support
Journey” by
The project (100 points) is an
opportunity for students to study an existing DSS, propose an innovative DSS or
build a small scale DSS using Excel.
Some students will conduct a decision process audit and analysis and
then develop a proposal for building a decision support system. Some students
with strong technical skills can alternatively request permission to use
Microsoft Excel to build and document a small-scale, spreadsheet-based
DSS. Some students may research and
write a case study. Students have a choice in the type of project proposed
between a more managerial and a more technical end user development task. A
maximum two (2) page project proposal must be submitted by
The exam (100 points) covers the
content in Power Decision Support Systems: Concepts and Resources for
Managers. The exam will include 35
multiple choice questions (70 points), 10 short answer questions (20 points),
and an open book/open notes essay question (10 points).
You are expected to participate in all class sessions. Active, consistent participation in class is an essential part of the learning experience. You need to read the materials and prepare for the discussions and lab sessions. I may assign graded review questions for students to complete and submit. Meaningful participation in discussions is valued and needed. Meaningful participation means making a contribution to our discussion, and it does not mean simply agreeing with what others have said. However, as I realize unexpected situations occur at home and at work, we can negotiate the “make up” for one missed class session. I reserve the right to lower your grade for limited participation in course activities.
"The Americans with Disabilities Act of 1990
(ADA) provides protectionfrom illegal discrimination for
qualified individuals with disabilities. Students requesting instructional
accommodations due to disabilities must arrange for such accommodation through
the Office of Disability Services. The ODS is located at: 213 Student
Services Center, and the phone number is:
273-2676."
Course materials, syllabus and assignments may be updated, revised or
altered during the course. When possible changes will be announced in class or
by email with at least 1 week notice. Also, check the course web page. Last
updated November 8, 2006.
Last
revised 11/8//2006
Dates
|
Assigned Content/Readings
|
Labs
|
Wed.,
November 8, 2006 |
Course
Overview Ask
Dan! What do
managers need to know about IS/IT, MIS and DSS? Ask
Dan! What
type of DSS is X? Ch.
2. Gaining Competitive Advantage with DSS; Ask
Dan! What is
a Spreadsheet-based DSS? |
DSSResources.COM DSS
Web Tour |
Sat.,
November 11, 2006 |
Ask
Dan! What is
a cost estimation DSS? What
are the answers to the DSS case study questions at DSSResources.COM? |
Excel
review; TUT 1: Excel as a Decision Support Tool TUT
2: List Management and Pivot Tables |
Wed.,
November 15, 2006 |
Quiz
#1 Ch. 1 and 2 Ch.
3. Analyzing Business Decision Processes Ask
Dan! What is
an example of a decision process? Ask
Dan! What
kind of DSS does Mr. X need? Case:
Power & Roth “Ertl's Decision Support Journey”
(5 page analysis) due 11/22 |
Excel
Flow Charts |
Wed.,
November 29, 2006
|
Quiz
#2 Ch. 3,4 Ch.
5. Designing and Evaluating DSS User Interfaces Ch.
6. Evaluating DSS Architecture, Networking and Security Issues Ch.
7. Implementing Communications-driven and Group DSS |
Project
Proposal due TUT
7: Developing an Excel application; data validation; conditional formulas;
add spinners |
Wed.,
December 6, 2006 |
Quiz
#3 Ch. 5, 6 and 7 Ch.
8. Building Data and Document-driven DSS Ch.
9. Building Knowledge-driven DSS and Mining Data; Ch.
10. Building Model-driven DSS; |
|
Sat.,
December 9, 2006 |
Who are
the major vendors of Excel add-in programs for building model-driven DSS? |
Tutorial
9. Data Tables and Scenario Management; Tutorial 10. Using Solver for Complex
Problems |
Wed.,
December 13, 2006 |
Quiz
#4 Ch. 8, 9, 10 Ch.
11. Building Web-Based and Inter-organizational DSS Ch.
12. Evaluating DSS Projects |
|
Wed.,
January 10, 2007
|
In-class
Exam DSS book (100 points) |
Project
consultations |
Wed.,
January 17, 2007 |
Case
analyses |
|
Wed.,
January 24, 2007 |
Case
analyses |
Project
consultations |
Wed.,
January 31, 2007 |
Project
presentations |
|
Wed.,
February 7, 2007 |
Project
presentations |
Project
Deliverable due |
This
schedule is subject to change and when possible changes will be announced in
advance. |