Introduction to Management Information Systems

 

MGS 351 – Fall 2017


 

Instructor: David Murray                                                           Teaching Assistants: Jacobs 206J

Email: djmurray@buffalo.edu    Skype: djmurrayub                    Alex Bitar: alexmgs351@gmail.com

Office: Jacobs 284        Phone: 645-3249                                   Dan Franasiak: djfranas@buffalo.edu

Office hours: Thursday 1:30 - 3:15 (or by appointment)               Marvin Phattanachitchon: marvinph@buffalo.edu

Web Site: mgs351.com                                                             Sally-Edith Yong: sokyingy@buffalo.edu (SIM)

 

Course Objectives:

This course provides students with an introduction to Information Systems (IS) and Information Technology (IT) and their use in an increasingly competitive business world.  As future managers, you need to be equipped to make decisions concerning the planning, development and implementation of information technology resources to increase organizational effectiveness and create a strategic advantage.  The course accomplishes this by:

·         Introducing basic concepts of IS and IT and exploring how technology can be used to create business value.

·         Examining the potential benefits and limitations of IT and providing an overview of the components of computers.

·         Increasing awareness of managerial issues raised by the use of IT

·         Providing “hands on” exercises to practice course material

·         Providing a foundation needed for subsequent MIS coursework

 

Prerequisites:

MGQ 201 - Introduction to Computers and Statistics.  Concurrent registration is not allowed.

 

Course Materials: Items marked with asterisks (**) are recommended but not required.

·         E-Assign.com Digital Course Materials - Register an account with your UB email and obtain the digital materials using the correct course code listed below.  Select your recitation section when prompted.

·         UB Students: Use course code 20179351

·         UB Singapore Institute of Management Students: Use course code 99179351

·         **Management Information Systems for the Information Age: 9th Edition  Haag, McGraw Hill Inc., 2013.

 

Digital Access:

The lecture is recorded on Tuesday at 3:30 PM in Jacobs 106, and will be posted on UBLearns by Wednesday at 10:00 AM.  Space permitting, any student is welcome to attend the “live” section of the class.  It is important to keep up with the lectures online just as you would a “live” class.  Please do not ask me or your TA questions about the class, homework or project if you haven’t watched the lecture that week yet!  It’s your responsibility to first watch the lectures.

 

Labs:

The lab provides you with an opportunity to practice material covered in lecture and to work on homework assignments and the team project.  Periodic pop quizzes and Lab Manual exercises will also be assigned during lab.  Lab attendance is mandatory and each absence will result in a 3 point penalty.  Students arriving more than 5 minutes late to lab will be marked absent.  Students arriving unprepared may result in a 2 point penalty at the discretion of the TA.  One absence or late arrival is permitted without penalty.  Please don’t ask me to change any of your lab grades as I will not change a lab grade that a TA has submitted to me.

 

Homework Assignments:

There are 5 homework assignments designed to help reinforce the material that has been covered in the lecture and labs.  Completion of these assignments is crucial to your success in this course. Completed assignments should be submitted to E-Assign.com prior to the due date and time.  Late assignments are not accepted and will receive a score of 0.  Questions pertaining to your homework grades must be addressed to your TA within 2 weeks of the assignment due date.

 

Final Team Project:

You will work in teams of no more than 5 to develop a database system using Microsoft Access.  Your teams will be assigned in labs so that you will have a dedicated time during which your team can meet.  Projects will be evaluated based on the system’s required functionality and enhancements, adequacy of system testing, attention to aesthetics and group member peer evaluations.  Further details will be given in lecture and lab.

 

Exams:

There will be two midterm exams plus a non-cumulative final exam administered during finals week.  There are no make up exams except under exceptional circumstances.  Exams will be held in Knox 20 and Knox 104 from 5:30-7:00 PM on 9/22 and 10/27.  Please reschedule your work, social and family commitments accordingly.  SIM students should consult with the Singapore Institute of Management for information about the exact dates and times of their exams

 

Course Conduct:

You are required to observe the rules of academic integrity and classroom conduct established by the University at Buffalo.  Cheating will not be tolerated.  Students found cheating will receive a grade of F for the course and may be subject to further disciplinary action by the School of Management and/or the University at Buffalo.  The University at Buffalo and School of Management Academic Integrity policies are posted on the course website and should be reviewed carefully.

 

Grading:

Assignment

Points

Exam I

50

Exam II

50

Final Exam

50

Team Database Project Proposal & Design

5

Final Team Database Project Submission

45

Homework 1: Chapters 1 and 2 Guided & Applied Exercises

15

Homework 2: Chapter 3 Guided & Applied Exercise

15

Homework 3: Chapters 4 and 5 Guided & Applied Exercises

20

Homework 4: Chapter 6 Guided & Applied Exercise

15

Homework 5: Chapter 7 Guided & Applied Exercise

15

Lab Assessments, Exercises and Attendance

20

 

A course grade of A is 282 points and above, A- is 270 points and above, B+ is 262.5 points and above, B is 255 points and above, B- is 240 points and above, C+ is 232.5 points and above, C is 225 points and above, C- is 210 points and above, D is 195 points and above and a grade of F is earned if you receive less than 195 points.  Depending on the overall class performance, I reserve the right to adjust the scale.  My decision to adjust the scale will only be made at the end of the semester once all of the course grades are in.

 

According to University Regulations, a grade of Incomplete can only be given if the student is currently passing the course and circumstances prevent them from completing the semester.  Incomplete grades will not be given once the student has taken the final exam.  **November 10th is the last day to resign the course.

 

Tentative Course Schedule:

Date

Text

Ch

Topics

Assignments (Dates Due)

8/29

 

 

Course Introduction

Download & Read Syllabus

 

Haag

1

The Information Age in Which You Live

 

 

Murray

1

Overview of Microsoft Access Databases

 

9/5

Haag

XLM A

Computer Hardware and Software

 

 

Murray

2

Design and Create Tables to Store Data

 

9/12

Haag

XLM B

The World Wide Web and the Internet

HW 1 due in lab this week

 

Murray

3

Simplify Data Entry with Forms

 

9/22

Exam I (Haag Ch. 1, XLM A, XLM B and Murray Ch. 1, 2 and 3) held in Knox 20 and Knox 104 at 5:30 PM

9/26

Haag

3

Databases and Data Warehouses

HW 2 due in lab this week

 

Haag

XLM C

Final Project Overview – Relational Database Design

 

10/3

Murray

4

Obtain Valuable Information Using Queries

 

10/10

Haag

4

Analytics, Decision Support and Artificial Intelligence

 

 

Murray

5

Create Professional Quality Output with Reports

 

10/17

Haag

5

Electronic Commerce

HW 3 due in lab this week

 

Murray

6

Design and Implement Powerful Relational Databases

 

 

Project Proposal & Design Due in Lab week of 10/17-10/22

10/27

Exam II (Haag Ch. 3, 4, 5, XLM C and Murray Ch. 4 and 5) held in Knox 20 and Knox 104 at 5:30 PM

10/31

 

 

Team Project Design Review and Assistance

 

11/7

Haag

6

Systems Development

HW 4 due in lab this week

 

Murray

7

Build User-Friendly Database Systems

 

11/14

Haag

XLM E

Network Basics

 

11/21

Haag

XLM F

Building a Web Page with HTML

 

11/28

Haag

8

Protecting People and Information

HW 5 due in lab this week

 

Haag

XLM H

Computer Crime and Digital Forensics

 

12/5

 

 

Team Project Assistance

Project due in lab this week

TBA

Final Exam (Haag Ch. 6, 8, XLM E, XLM F, XLM H and Murray Ch. 6 and 7)