|Instructor:||"Your Name"||Phone Number|
|Course Time:||Room #|
|Office Hours:||F||and by appointment|
[Text] [Catalog Description][Course Overview] [CourseObjectives] [Grading Process]
[Exams] [Assignments/Exercises][Attendance and Class Participation]
Text and Readings:
Our primary text is:
Power, D. J. Decision Support Systems: Concepts and Resources for Managers.
An MS Excel text like: Parsons, J., D. Oja, R. Ageloff and P. Carey, New Perspectives on Microsoft Excel 2000 - Comprehensive Enhanced, Course Technology, ISBN: 0-619-04427-6, 2001.
You will probably want to subscribe to DSSResources.COM. The subscription cost is $10 for 1 month or $20 for 4 months. The subscriber zone has support materials that you may find useful.
A study of decision support systems and applications. Topics include: decision support framework, decision processes, design and development, architecture and networking, web-based DSS, evaluating DSS projects
This is a specialized course in information systems and information technology (IS/IT) for undergraduate MIS majors. The course is targeted to senior MIS students who want more expertise in developing, managing and using Decision Support Systems. This course will examine the design, development and implementation of information technology based systems that support managerial and professional work, including Communications-Driven and Group Decision Support Systems (GDSS), Data-Driven DSS, Model-Driven DSS, Document-Driven DSS, and Knowledge-Driven DSS.
In general, Decision Support Systems are used by people who are skilled in their jobs and who need to be supported rather than replaced by a computer system. The broadest definition states that Decision Support Systems are interactive computer based systems and subsystems that help decision makers utilize data, models and/or communications to solve problems and make decisions. Data-Driven DSS emphasize using data and include Executive Information Systems (EIS); Model-Driven DSS emphasize using models to support decision making. A Communications-Driven or Group decision support system (GDSS) is an interactive computer-based system intended to facilitate the solution of problems by decision makers working together as a group and includes groupware. Knowledge-Driven DSS attempt to capture the knowledge of a human expert in a computer system. This computer system can then be used by less expert users. Document-Driven DSS access and display text and multimedia information to support decision making.
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.
The primary focus of this course is developing intellectual capabilities related to design and development of decision support systems and Web-based information systems. We will also explore the role of DSS in supporting organization goals and the impact of information systems on organizations.
As a result of our work together in this course, you should:
Most of our class sessions are oriented to lectures and company examples, discussion of reading material, and hands-on computer lab sessions. The material will introduce you to the most significant problems faced in using and managing information and decision support systems and information technology.
Your final grade is a function of the following:
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.
I am planning to give 3 Unit exams in the class over lectures and reading assignments. The Unit exams will be a mix of questions, possibilities include short answer, short essay, mini-case analysis, and multiple choice questions. The Excel quizes may include multiple choice questions and hands-on skill questions. The actual format of the exam will be discussed in class prior to each exam. You will receive a study guide for the Unit exams.
You will be expected to complete a number of in-class and out-of-class assignments (100 points) and a Spreadsheet DSS Project (50 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 accomodate 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 are expected to participate in all class sessions. Active, consistent participation in class is an essential part of the learning experience. We will be discussing cases and readings both face-to-face and in an MIS Forum. You need to read the materials and prepare for the discussions.
Meaningful participation in the face-to-face and any on-line class discussions is valued and needed. Meaningful participation means making a contribution to our discussion, not merely talking or submitting messages, and it does not mean simply agreeing with what others have said.
I reserve the right to lower your grade for limited participation in course activities.
The MIS Forum/WebCT discussion will be evaluated based on the quality and NOT the quantity of your comments, the leadership you show in the discussions, your mastery of the technology, and whether your participation is active, consistent, regular and meaningful. I subtract points for repeated problems with spelling, grammar, and usage.
Course materials, syllabus and assignments may be updated, revised or altered during the course. Changes will be announced in class or by email with at least 2 weeks notice.
(subject to change with notice)
|Ch. 1 Supporting Business Decision-Making|
Tutorial 1: Using Worksheets to Make Business Decisions
|Ch. 2 Gaining Competitive Advantage with DSS|
Tutorial 2: Creating a Worksheet
|Ch. 3 Analyzing Business Decision Processes|
Tutorial 3: Developing a Professional-Looking Worksheet
|Ch. 3 Analyzing Business Decision Processes|
Tutorial 4: Creating Charts
|Excel Quiz #1|
|Ch. 4 Designing and Developing DSS||Start WebCT discussion|
|Oct. 1||Review Power DSS Chs. 1-4||Unit Exam #1|
|Ch. 5 Designing and Evaluating DSS User Interfaces|
Tutorial 7: Developing an Excel Application
|Ch. 6 Evaluating DSS Architecture, Networking and Security Issues|
Tutorial 11: Importing Data into Excel
|Ch. 7 Implementing Communications-Driven and Group DSS|
Tutorial: Using Microsoft Netmeeting for Decision Support
|Ch. 8 Building Data and Document-Driven DSS|
Tutorial 5: Working with Excel Lists
Appendix 2: Using Data Maps
Excel Quiz #2
|Nov. 2||Review Power DSS Chs. 5-8||Unit Exam #2|
|Ch. 9 Building Knowledge-Driven DSS and Mining Data|
Tutorial 9: Data Tables and Scenario Management
|Ch. 10 Building Model-Driven DSS|
Tutorial 10: Using Solver for Complex Problems
|Ch. 10 Building Model-Driven DSS, continued|
Tutorial 12: Enhancing Excel with Visual Basic
|Ch. 11 Building Web-Based and Inter-Organizational DSS|
Tutorial 6: Integrating Excel with WWW
Appendix 4: Saving Pivot Tables in HTML format
|Ch. 12 Evaluating DSS Projects||Excel Quiz #3|
|Dec. 17||Monday, 8-10 am||Unit Exam #3|