new york institute of technology

school of management / mis

mist 595

introduction to management information systems

MBA  PROGRAM

NO  PREREQUISITES

3  CREDITS

Spring, 2004

DR. STEPHEN W. HARTMAN

OFFICE  HOURS:  

Old Westbury Campus

MONDAYS 4:30-6:00

Third Floor Wisser Library

and by appointment

 OFFICE  TEL. (516) 686-7972 O.W.

(212) 261-1602

 Reference Web Page

 

  Course Web Page

 

Dr. Hartman

 

Course Description

 

The purpose of this course is to explore and learn the basic concepts of computer systems including basic business applications. Microsoft Office XP applications are used as basic business software in the database, spreadsheet and word processing areas respectively. 

Course Objectives

Introduce the basic components of computer systems and personal productivity tools.  Learn the types of computers and basic concepts of information systems.

Learn the differences between information and data.  Discuss the concepts of the CPU, Input, Output systems, operating systems, communication and networks. 

Students should become familiar with using Microsoft Windows and applications.

Provide technical proficiency using Microsoft Office XP.  This includes the basic spreadsheet functions as well as the database functions of creating files, reports, and sorting and related commands. 

Learn how to use the spreadsheet to solve business problems using case studies: cash flow analysis, what-if analysis, data input using macros (interactive mode).

Learn about Object-Linking Embedding (OLE), and how to integrate different document files created in different applications including Word, Excel, Access, and PowerPoint. 

Understand Internet basics including web programming.  Go to this website to learn basic HTML programming:

Webpage Basics

 

Textbooks and Disk Requirements

 

Shelly, Gary B., et. al.,  Microsoft Office XP Introductory Concepts and Techniques (Boston, MA: Course Technology, 2002).  ISBN 0-7895-6289-8.

EXCEL/TI-83 Application Pack, Version 4.0, January 1999

 

             Students should have at least two 3 ½” floppy disk available at all times in class.

 

Publications and Periodicals

 

1. Journal of Information Systems

15. Infosystems

 

2. Lan Times - Monthly Journal

16. Personal Computing

 

3. IEEE Computer Society

17. Lotus

 

4. Network World

18. IBM System Journal

 

5. Datapro Reports

19. Data Management

 

6. Computer World

20. Software Magazine

 

7. I/S Analyzer

21. Byte

 

8. Datamation

22. Business Software Review

 

9. Info World

23. Expert

 

10. Integration

24. High Technology

 

11. PC Week

25. Computer Graphics World

 

12. PC Computing

26. Information Management

 

13. PC Magazine

27. MIS Quarterly

 

14. PC World

28. MIS Week

 

 

Teaching Method

Lectures are combined with extensive hands-on use of computers.  There will be several assignments to acquire basic computer skills.  Additionally, there will be class assignments using Excel in combination with a workbook that will be given out in class.

attendance

If you stay current in your readings, get the notes, and do the assignments, isolated absences should not, in general, have any adverse effects.  However, more than three absences may force your withdrawal. 

 

Please exchange phone numbers with those sitting around you.  Please do not call to notify me of your absence unless you have an unusual problem.  Your absence will be obvious.  If you do miss a class, stay current by calling one of your classmates and get the notes etc.

grade  Weighting

 

Mid Term Exam - 30%

Final Examination - 30%

Class Projects - 30%

Class Participation - 10%

 

grading

 

90-100= A

87-89 = B+

80-86 = B

77-79 = C+

70-76 = C

0-69  =  F

 

 Makeup examinations are not given.   Students who do not pass at least one examination will not pass the course! 

keeping current

Information technology changes dramatically and evolves extremely rapidly.  Each week students are required to bring in an article discussing developments in the overall area of information technology.  The articles can come from any media source including material gathered from the World Wide Web on the Internet.  The student is required to hand in the article AT THE BEGINNING OF THE CLASS with their name on the top.  Some of the students may be required to briefly discuss the article with the class.  These articles are used for attendance!                                                                  

 

Reading Assignments

 

Week             Sections                     Key Topic

 

   1                   INTRO                       Project One An Introduction to Windows 2000 Professional and Office XP.

                                                            Creating and Editing a Word Document

                                                            An Introduction to Windows XP and Office XP  

                                                            Microsoft Word Website

 

  2                    WORD                       Project Two Creating a Research Paper                                                          

                                                           Project Three Creating a Resume and Cover Letter

                                                            In Class Exercise 

                                                            Homework Assignment:  Create and resume and cover letter.

                                                            Web Feature Creating Web Pages using Word

 

  3                    EXCEL                      Project One Creating a Worksheet and Embedded Chart        

                                                         Microsoft Excel Website

                                                        WORD PORTFOLIO DUE

                                                           

 4                        EXCEL                      Project Two: Formulas, Functions, Formatting, and Web Queries

                                                           

 5                    EXCEL                       SumProduct.

                                                                                   

6                    EXCEL                       Project Three What-If Analysis, Charting, and Working with Large Worksheets

                                                           

7                     EXCEL                       Web Feature Creating Static and Dynamic Web Pages Using Excel

                                                            Extra Credit  Homework Create a Dynamic Webpage using an assigned problem from  

                                                            the book.

                                                            Countif.

 

8                      EXCEL                     MIDTERM Examination Word and Excel

 

9                               ACCESS                    Review Midterm Results

                                                            Project One Creating a Database Using Design and Datasheet Views

                                                            Microsoft Access Website

                                                                                                                       

10                   ACCESS                    Project One Continued

                                                            Sumif

                                                                                                                      

11                   ACCESS                    Project Two Querying a Database Usng the Select Query Window

                                                           

 

12                   ACCESS                    Project Three  Maintaining a Database Using the Design and Update Features of Access

 

13                   POWER POINT        Project One  Using a Design Template and Text Slide Layout to Create a Presentation
                                                           
ACCESS PROJECTS DUE  

                                                            Microsoft PowerPoint Website

                                                             

13                  POWER POINT         Project Two  Using the Outline Tab and Clip Art to Create a Slide Show

 

14                 OFFICE REVIEW       Review Microsoft Word, Access, and Excel

                                                            POWERPOINT PORTFOLIO DUE

 

15                  FINAL EXAM             Combination of multiple choice questions and problems using the material taught in class.

references

Winston Bumpus.. [et al.].  Common Information Model: Implementing The Object Model For Enterprise Management.  New York, N.Y: Wiley, 2000. Xviii, 316 p.: ill. ; 25 cm. ISBN: 0471353426 (cloth: elk. paper)

 

Claudio U. Ciborra. [et al.].    From Control To Drift: The Dynamics Of Corporate Information Infastructures. New York: Oxford University Press, 2000. ISBN: 0198297343

 

Nuno Guimarães (ed.). Organizational change, evolution, structuring, and awareness: organizational computing systems. Berlin; New York: Springer, 1998.  ISBN: 3540628630 (soft cover).

 

Kenneth E. Kendall, editor.  Emerging Information Technologies: Improving Decisions, Cooperation, And Infrastructure.  Thousand Oaks, Calif.: Sage Publications, 1999. X, 373 p.: ill. ; 24 cm. ISBN: 0761917489 (elk. paper) 0761917497 (pbk.).

 

E. Wainright Martin. [et al.]. Managing Information Technology: What Managers Need To Know / 3rd ed. Englewood Cliffs, NJ: Prentice Hall, c1999.  xx, 716 p.: ill. ; 27 cm.   ISBN: 013860925X (hardcover).

 

[edited by] Barbara C. McNurlin, Ralph H. Sprague, Jr.  Information Systems Management In Practice 4th ed.   Upper Saddle River, N.J.: Prentice Hall, c1998. ISBN: 0138479712.

 

S.G. Tzafestas, ed.  Computer-assisted Management And Control Of Manufacturing Systems   Berlin; New York: Springer, c1997.

 

John Wazalek, editor.   Enterprise Systems Integration.  Boca Raton, Fla.: Auerbach, 1999.

The WIDE project / editors, Paul Grefen, Barbara Pernici, Gabriel Sánchez; assistant editors, Jochem Vonk, Erik Boertjes.  Database Support For Workflow Management.  Boston: Kluwer Academic Publishers, c1999.