• Number and Title of Course
• Catalog Description of Course
• Instructor
• Required Textbook
• Educational Outcomes
• Major Topics
• Instructional Methods and Techniques
• Assignments for Course
• Evaluation
• COURSE OUTLINE

Number and Title of Course: MIS423/523 - Microcomputer Applications in Business

Instructor(s): Dr. Wayne Summers Office: SC208A Office phone: (505) 454-3230
Department phone: (505) 454-3295
Office Hours: 9-9:50 A.M. MW; 3:00-3:50 P.M. TR; via e-mail, net-meetings and by appointment
e-mail address: summers_wayne@ColumbusState.edu
homepage:http://csc.ColumbusState.edu/summers

Catalog Description of Course: A capstone course to include various software packages available for information system development (3 credits).
Course Prerequisite: MIS 233 or basic knowledge and/or experience with spreedsheets and database management systems with permission of instructor.

Required Textbook(s):

1. Personal Productivity with Information Technology; Davis & Naumann; McGraw-Hill; ISBN 0-07-015916-5
2. Application Cases in MIS 2nd Ed.;James Morgan; IRWIN; ISBN 0-256-22056-5

• Microsoft Access or dBase IV or Paradox references.
• Software and manuals found in the lab and from the book.
• Microssoft Excel, Lotus 1-2-3, or Quatro Pro references.
• Microsoft Access 97 or 95, dBase IV or Paradox software.
• Microssoft Excel, Lotus 1-2-3, or Quatro Pro software.

1. To learn how to use computers more effectively in business.
2. To learn how to use technology to enhance productivity.
3. To develop skill in the application of features and functions of spreadsheet analytical tools in deriving solutions to a variety of typical business problems and situations.
4. Review the basic features and functions of spreadsheet applications.
5. Develop skill in the use of the more advanced features of spreadsheets.
6. To develop skill in the application of features and functions of database analytical tools in deriving solutions to a variety of typical business problems and situations.
7. Review the basic features and functions of database applications.
8. Develop skill in the use of the more advanced features of database management systems.
9. Develop skill in the analysis of business situations (exercises or cases), and deriving the appropriate solution by evaluating "what-if" alternatives.
10. Develop skill in group dynamic problem resolution by working in teams in the analysis of business situations, and the application of spreadsheet and database solutions to those situations.
11. Students will be familiar with a variety of computer network security issues.

1. Productivity in Knowledge Work
2. Data and Software Management for Knowledge Work Productivity
3. Designing and Implementing Productivity Enhancements
4. Developing Spreadsheet Applications
5. Implementing Spreadsheet Applications
6. Developing Database Applications
7. Implementing Database Applications

1. The class will meet for two one hour and twenty-five minute lecture/discussion periods each week.
2. The lectures should be conducted using state-of-the-art multimedia techniques including a computer projection system.
3. There should be facilities for demonstrating software and access to computer networks in the classroom.

• Readings from the textbook(s)
• Outside reading from popular computing and MIS periodicals like PC-Week, InfoWeek, etc.
• Readings from documents found on the Internet
• Frequent case assignments

1. One midterm and final exam over the lectures and readings consisting of both non-essay and essay questions.
2. Homework and/or frequent quizzes on material discussed in class.
3. The students would be expected to discuss their readings weekly in the Collabra Discussion Group MIS423/523 found on cs.nmhu.edu.
4. Lab Projects on spreadsheet and database cases. (Graduate Students will be expected to do Graduate Level work on these projects)
5. Additional Case Studies including an oral presentation. (for Graduate Students)

Course Evaluation (tentative):

• Weekly Homework (10 pts each) = 100-150 pts.
• Weekly Quizzes (10 pts each) = 100-150 pts.
• Six Lab Project (Cases) = 300 pts.
• Class Participation and Attendance (including the Collabra Discussion Group) = 50-100 pts.
• One midterm test = 100 pts.
• 1 Comprehensive FINAL EXAM = 200 pts.
• (Graduate students will be expected to do two additional case studies including an oral presentation) = 100 pts.

Honor Policy: Cheating will not be tolerated. Any student caught cheating will be given a zero on the assignment or exam. Repeat offenders will be given an F for the course and may suffer expulsion from the university. All work must be your own. You may discuss the material in the course and help one another, however, I expect any work you hand in for a grade to be your own. Plagiarism will result in, at best, an "F" for the assignment. A simple way to avoid inadvertent plagiarism is to talk about the assignments, but don't read each other's work or write solutions together. Keep scratch paper and old versions of assignments until after the assignment has been graded and returned to you. If you have any questions about this, please see me immediately.