Yeshiva University
SYLLABUS FOR MANAGEMENT INFORMATION SYSTEMS IDS 1020; Fall 2012 Yeshiva University Sy Syms School of Business Instructor: Shu Han Email: [email protected] Course website: ANGEL
Class Days: Mondays and Wednesdays Office Hours: by appointment
Course Objectives 1. Serve an introduction to how information technology shapes and influences firms and businesses; 2. Familiarize students with the use of Microsoft Excel and Access, to a level of effectiveness that is consistent with a standard business environment; 3. Develop an understanding of hardware, software, telecommunications, Internet technology, network architecture, and infrastructure choices for firms; 4. Analyze selected cases that illustrate the how information technology could be utilized to business decision-making
Textbooks 1. How to Use Microsoft® Excel®: The Careers in Practice Series, v. 1.0 by Joseph M. Manzo, published by Flatworld Knowledge http://catalog.flatworldknowledge.com/bookhub/reader/3371 Free to read online 2. We will use 3 chapters (Access Tutorials 1, 2, 3) from New Perspective book. You can either purchase the whole book or the chapters individually through e-book option. 1. Tutorial 1: Creating a Database 2. Tutorial 2: Building a Database and Defining Table Relationships 3. Tutorial 3: Maintaining and Querying a Database
New Perspectives on Microsoft Office 2007, First Course, Windows XP Edition or Windows Vista Edition, by Ann Shaffer, Patrick Carey, Kathleen T. Finnegan, Joseph J. Adamski, Roy Ageloff, S. Scott Zimmerman, and Beverly B. Zimmerman, ISBN: 1423905776, ISBN: 1423906152 http://oc.course.com/np/Office2007/firstcourseXP.cfm or http://oc.course.com/np/Office2007/FirstCoursevista.cfm
1
Or New Perspectives on Microsoft® Office Access 2007, Brief http://www.cengagebrain.com/shop/en/US/storefront/US?cmd=catProductDetail&ISBN=9780 538474993&cid=GSEM1&gclid=CIuOnMTkh7ICFUJo4Aod1kgA7A o Access Tutorials 1, 2, 3 o E-chapters option is available from Cengage Brain (Cost: $16.47). o How to purchase eChapters: 1. 2. 3. 4.
Go to http://www.cengagebrain.com/shop/index.html Search the book by ISBN number (1423905776 or 1423906152) Choose to buy eChapters Choose all three tutorials 5. Check out
Background Reading: 1. Information Systems: A Manager’s Guide to Harnessing Technology—Version 1.4 by John Gallaugher, published by Flatworld Knowledge http://students.flatworldknowledge.com/course/1105171 Free to read online at 2. New Perspectives on Microsoft Office 2007, First Course, Windows XP Edition or Windows Vista Edition, by Ann Shaffer, Patrick Carey, Kathleen T. Finnegan, Joseph J. Adamski, Roy Ageloff, S. Scott Zimmerman, and Beverly B. Zimmerman, ISBN: 1423905776, ISBN: 1423906152 We will use 3 chapters (Excel Tutorials 1, 3, 4) as additional exercise for Excel http://oc.course.com/np/Office2007/firstcourseXP.cfm or http://oc.course.com/np/Office2007/FirstCoursevista.cfm o Excel Tutorial 1, 3, 4 o E-chapters option is available from Cengage Brain (Cost: $16.47). 3. Management Information Systems for the Information Age, 7/e by Stephen Haag, Maeve Cummings, ISBN: 0073402915 http://highered.mcgraw-hill.com/sites/0073402915/information_center_view0/ o Chapter 1, 2, 5, and Extended Learning Modules A, C, E (details on the second last page) o E-chapters option from McGraw is available in one package (Cost: $16.26) o How to purchase eChapter package:
2
1. Go to http://create.mcgraw-hill.com/shop/ 2. Search for and select book by Title, ISBN, Author, or State/School. ISBN: 9781121027398 Title: Management Information Systems Instructor: Shu Han 3. Add the book to your cart and check out This course is a combination of lecture-discussion classes and lab classes. For conceptual content, classes will follow a format of short lectures and discussions. For computer applications (Excel and Access), classes will follow a format of software demonstration by the instructor and lab work by students.
Grading The calculation of final grades will be as follows: Project (Excel and Decision Support) Assignments Attendance, Professionalism and Participation Midterm Exam Final Exam Total
10% 5% 5% 40% 40% 100%
Project: A real business case will be given, and you will be asked to use various tools in Excel to provide key information for business decision-making. Project details will be provided in the middle of the semester. A team of 2-3 students should be formed. Assignments: Assignments should be submitted through ANGEL submission box. Late assignments will NOT be graded. It is your responsibility to learn how to use the submission box.
Angel Courseware Homepage All communication will be via the YU e-mail system. It is your responsibility to check you YU emails constantly. All students should be automatically signed up for Angel when you register and given a YU email address. Username: that part of your y-mail account name that appears before the @; i.e. shan. Password: normally first letter of last name + last 4 digits of your ID number If you have problems with Angel, you can visit http://www.yu.edu/mis/academic_computing/angelhelp.asp for online help.
3
Class Attendance, Professionalism, and Participation Class attendance – Reasonable attendance is expected and required. Reasonable absence is defined as twice the number of times the class meets per week (i.e. 2x2=4). Any special requests for personal time away from class and/or early travel must be approved by the SSSB Dean’s Office (BH 412). Professionalism means a number of things, such as: 1. speaking in class only after you raise your hand and being asked by the instructor; 2. computers should be turned off except when you are asked to perform lab works on it; 3. Web-surfing is not allowed anytime during class time; 4. Cell phones should be turned off during class; 5. being on time to class Scholastic Dishonesty Any student who commits an act of scholastic dishonesty is subject to discipline. Scholastic dishonesty includes, but is not limited to, cheating, plagiarizing, colluding, submitting for credit any work or materials that are attributable in part or fully to another party, taking an exam for another person, and engaging in or attempting to engage in any act designed to give an unfair advantage to a student. Class participation includes the responsibility to share understanding and judgment with the class in order to advance the group's collective skills and knowledge. Be sure to contribute ONCE per class period via questions or expressed thought. Class participation scores will be based upon the quantity and quality of each student's class discussion. Scores for the Attendance, Professionalism, and Participation component of the course are based solely upon the judgment of the course instructor, and they are non-negotiable.
Tentative Course Topics (Subject to change)
Topic
Number of Classes
4
Introduction to Syllabus Excel Labs Database Basics Access Labs Business Intelligence IT, Strategy and Competitiveness Hardware and Software Enterprise Applications Network Basics and Internet E-Commerce and New Business Model IT Platforms and Infrastructures Project Presentation Midterm Exam Review Final Exam Review Midterm Exam, class time Final Exam Total
1 6 1 5 1 2 1 1 1 1 1 1 1 1 1 (November 12, 2012 class time) 1 (December 24, 2012 class time) 26
Notes 1. No make-up for midterm exam. 2. Late assignment will NOT be graded. 3. FINAL EXAM: Final examinations may be postponed only for health or emergency reasons. In such cases please go to the Office of the Dean to file a “Request for a makeup”. The Committee on Academic Standards will review the request and notify you if a make-up is approved. If a make-up exam is not approved, you will receive an “F” grade. 4. DISABILITIES NOTICE: Students with disabilities who are enrolled in this course and who will be requesting documented disability-related accommodations are encouraged to make an appointment with the Office of Disability Services, (646-685-0112 Wilf) during the first week of class. After approval for accommodations is granted, please submit your accommodations letter to me as soon as possible to ensure the successful implementation of those accommodations.” 5. I reserve the right to alter the sequence of topics, the assignments, the cases, the course coverage, the deadlines and the grading system if I deem it necessary and/or appropriate. Should such changes be made, they will be announced in class as needed, and posted on ANGEL. 6. COMMUNICATIONS: It’s your responsibility to check your YU email on a constant basis!
5
Class Days: Mondays and Wednesdays Office Hours: by appointment
Course Objectives 1. Serve an introduction to how information technology shapes and influences firms and businesses; 2. Familiarize students with the use of Microsoft Excel and Access, to a level of effectiveness that is consistent with a standard business environment; 3. Develop an understanding of hardware, software, telecommunications, Internet technology, network architecture, and infrastructure choices for firms; 4. Analyze selected cases that illustrate the how information technology could be utilized to business decision-making
Textbooks 1. How to Use Microsoft® Excel®: The Careers in Practice Series, v. 1.0 by Joseph M. Manzo, published by Flatworld Knowledge http://catalog.flatworldknowledge.com/bookhub/reader/3371 Free to read online 2. We will use 3 chapters (Access Tutorials 1, 2, 3) from New Perspective book. You can either purchase the whole book or the chapters individually through e-book option. 1. Tutorial 1: Creating a Database 2. Tutorial 2: Building a Database and Defining Table Relationships 3. Tutorial 3: Maintaining and Querying a Database
New Perspectives on Microsoft Office 2007, First Course, Windows XP Edition or Windows Vista Edition, by Ann Shaffer, Patrick Carey, Kathleen T. Finnegan, Joseph J. Adamski, Roy Ageloff, S. Scott Zimmerman, and Beverly B. Zimmerman, ISBN: 1423905776, ISBN: 1423906152 http://oc.course.com/np/Office2007/firstcourseXP.cfm or http://oc.course.com/np/Office2007/FirstCoursevista.cfm
1
Or New Perspectives on Microsoft® Office Access 2007, Brief http://www.cengagebrain.com/shop/en/US/storefront/US?cmd=catProductDetail&ISBN=9780 538474993&cid=GSEM1&gclid=CIuOnMTkh7ICFUJo4Aod1kgA7A o Access Tutorials 1, 2, 3 o E-chapters option is available from Cengage Brain (Cost: $16.47). o How to purchase eChapters: 1. 2. 3. 4.
Go to http://www.cengagebrain.com/shop/index.html Search the book by ISBN number (1423905776 or 1423906152) Choose to buy eChapters Choose all three tutorials 5. Check out
Background Reading: 1. Information Systems: A Manager’s Guide to Harnessing Technology—Version 1.4 by John Gallaugher, published by Flatworld Knowledge http://students.flatworldknowledge.com/course/1105171 Free to read online at 2. New Perspectives on Microsoft Office 2007, First Course, Windows XP Edition or Windows Vista Edition, by Ann Shaffer, Patrick Carey, Kathleen T. Finnegan, Joseph J. Adamski, Roy Ageloff, S. Scott Zimmerman, and Beverly B. Zimmerman, ISBN: 1423905776, ISBN: 1423906152 We will use 3 chapters (Excel Tutorials 1, 3, 4) as additional exercise for Excel http://oc.course.com/np/Office2007/firstcourseXP.cfm or http://oc.course.com/np/Office2007/FirstCoursevista.cfm o Excel Tutorial 1, 3, 4 o E-chapters option is available from Cengage Brain (Cost: $16.47). 3. Management Information Systems for the Information Age, 7/e by Stephen Haag, Maeve Cummings, ISBN: 0073402915 http://highered.mcgraw-hill.com/sites/0073402915/information_center_view0/ o Chapter 1, 2, 5, and Extended Learning Modules A, C, E (details on the second last page) o E-chapters option from McGraw is available in one package (Cost: $16.26) o How to purchase eChapter package:
2
1. Go to http://create.mcgraw-hill.com/shop/ 2. Search for and select book by Title, ISBN, Author, or State/School. ISBN: 9781121027398 Title: Management Information Systems Instructor: Shu Han 3. Add the book to your cart and check out This course is a combination of lecture-discussion classes and lab classes. For conceptual content, classes will follow a format of short lectures and discussions. For computer applications (Excel and Access), classes will follow a format of software demonstration by the instructor and lab work by students.
Grading The calculation of final grades will be as follows: Project (Excel and Decision Support) Assignments Attendance, Professionalism and Participation Midterm Exam Final Exam Total
10% 5% 5% 40% 40% 100%
Project: A real business case will be given, and you will be asked to use various tools in Excel to provide key information for business decision-making. Project details will be provided in the middle of the semester. A team of 2-3 students should be formed. Assignments: Assignments should be submitted through ANGEL submission box. Late assignments will NOT be graded. It is your responsibility to learn how to use the submission box.
Angel Courseware Homepage All communication will be via the YU e-mail system. It is your responsibility to check you YU emails constantly. All students should be automatically signed up for Angel when you register and given a YU email address. Username: that part of your y-mail account name that appears before the @; i.e. shan. Password: normally first letter of last name + last 4 digits of your ID number If you have problems with Angel, you can visit http://www.yu.edu/mis/academic_computing/angelhelp.asp for online help.
3
Class Attendance, Professionalism, and Participation Class attendance – Reasonable attendance is expected and required. Reasonable absence is defined as twice the number of times the class meets per week (i.e. 2x2=4). Any special requests for personal time away from class and/or early travel must be approved by the SSSB Dean’s Office (BH 412). Professionalism means a number of things, such as: 1. speaking in class only after you raise your hand and being asked by the instructor; 2. computers should be turned off except when you are asked to perform lab works on it; 3. Web-surfing is not allowed anytime during class time; 4. Cell phones should be turned off during class; 5. being on time to class Scholastic Dishonesty Any student who commits an act of scholastic dishonesty is subject to discipline. Scholastic dishonesty includes, but is not limited to, cheating, plagiarizing, colluding, submitting for credit any work or materials that are attributable in part or fully to another party, taking an exam for another person, and engaging in or attempting to engage in any act designed to give an unfair advantage to a student. Class participation includes the responsibility to share understanding and judgment with the class in order to advance the group's collective skills and knowledge. Be sure to contribute ONCE per class period via questions or expressed thought. Class participation scores will be based upon the quantity and quality of each student's class discussion. Scores for the Attendance, Professionalism, and Participation component of the course are based solely upon the judgment of the course instructor, and they are non-negotiable.
Tentative Course Topics (Subject to change)
Topic
Number of Classes
4
Introduction to Syllabus Excel Labs Database Basics Access Labs Business Intelligence IT, Strategy and Competitiveness Hardware and Software Enterprise Applications Network Basics and Internet E-Commerce and New Business Model IT Platforms and Infrastructures Project Presentation Midterm Exam Review Final Exam Review Midterm Exam, class time Final Exam Total
1 6 1 5 1 2 1 1 1 1 1 1 1 1 1 (November 12, 2012 class time) 1 (December 24, 2012 class time) 26
Notes 1. No make-up for midterm exam. 2. Late assignment will NOT be graded. 3. FINAL EXAM: Final examinations may be postponed only for health or emergency reasons. In such cases please go to the Office of the Dean to file a “Request for a makeup”. The Committee on Academic Standards will review the request and notify you if a make-up is approved. If a make-up exam is not approved, you will receive an “F” grade. 4. DISABILITIES NOTICE: Students with disabilities who are enrolled in this course and who will be requesting documented disability-related accommodations are encouraged to make an appointment with the Office of Disability Services, (646-685-0112 Wilf) during the first week of class. After approval for accommodations is granted, please submit your accommodations letter to me as soon as possible to ensure the successful implementation of those accommodations.” 5. I reserve the right to alter the sequence of topics, the assignments, the cases, the course coverage, the deadlines and the grading system if I deem it necessary and/or appropriate. Should such changes be made, they will be announced in class as needed, and posted on ANGEL. 6. COMMUNICATIONS: It’s your responsibility to check your YU email on a constant basis!
5
