Introduction to Management Information Systems

Instructor: David Murray Teaching Assistants: Jacobs 206J

Email: djmurray@buffalo.edu Galyah Ghajar: galyahgh@buffalo.edu

Office: Jacobs 284 Phone: 645-3249 Sarah Jiva: smjiva@buffalo.edu

Office hours: Thursday 2:00 - 3:30 (or by appointment)

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

· 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:

· A Windows or Mac computer with a working webcam and microphone

· Information Systems for Business and Beyond, Bourgeois, Open Textbooks, 2019.

· Microsoft Access 365 Tutorial and Lab Manual, Murray, Creative Commons Licensed OER, 2024.

Labs:

The lab provides you with an opportunity to practice material covered in lecture and to work on homework assignments and the team project. Lab attendance is mandatory, and each absence will result in a 4-point penalty assessed on your Professionalism grade. Students arriving more than five minutes late to lab will be marked absent. Students arriving unprepared may result in a 3-point penalty at the discretion of the TA. Students are expected to actively use the lab time for the MGS351 coursework. Students who fail to properly utilize lab time may be penalized at the discretion of the TA. 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 six 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. 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 two weeks of the assignment due date.

Final Team Project:

You will work in teams of no more than six to develop a database system using Microsoft Access and the Salesforce platform. Your teams will be assigned in labs so that you will have a dedicated time during which your team can meet. Additionally, teams are expected to connect and meet at least once a week outside of class. 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:

Midterm exams will be held in Knox 20 from 5:30-7:00 PM on 9/19 and 11/14. There are no make-up exams except under exceptional circumstances. Please reschedule your work, social and family commitments accordingly.

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 University at Buffalo. The University at Buffalo Academic Integrity Policy is posted on the course website and should be reviewed carefully.

Grading:

Assignment	Points
Exam I	50
Exam II	50
Team Project Proposal & Design	5
Final Team Project Access Prototype	30
Final Team Project Salesforce	40
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
Homework 6: Salesforce Trailhead Modules	20
Lab Assessments, Exercises and Professionalism	25

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 202.5 points and above, D is 195 points and above and a grade of F is earned if you receive less than 195 points. Any 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. **November 12^th is the last day to resign the course.

Tentative Course Schedule:

Week	Text	Ch	Topics	Assignments (Dates Due)
8/26			Course Introduction	Read Syllabus
8/28	Bourgeois	1	Introduction to Information Systems
9/2	Access	1	Overview of Microsoft Access Databases
9/4	Access	2	Design and Create Tables to Store Data
9/9	Bourgeois	2	Computer Hardware
9/11	Access	3	Simplify Data Entry with Forms	HW 1 due 9/12 at 11:59 PM
9/16	Bourgeois	3	Computer Software
9/18	No Lecture. Exam on Friday
9/19	Exam I (Bourgeois Ch. 1, 2, 3 and Access Ch. 1, 2, 3) on Friday, 9/19 at 5:30 PM
9/23	Access	4	Obtain Valuable Information Using Queries
9/25	Bourgeois	4	Final Project Overview - Relational Database Design	HW 2 due 9/26 at 11:59 PM
9/30	Bourgeois	4	Project ERD Review and Work Session
10/2	Access	5	Create Professional Quality Output with Reports
10/7	Bourgeois	5	Networking and Communication	Proposal due in lab this week
10/9	Access	6	Design & Implement Powerful Relational Databases	HW 3 due 10/10 at 11:59 PM
10/14	No Class. Fall Break
10/16	Bourgeois	10	Information Systems Development
10/21	Access	7	Build User-Friendly Information Systems
10/23	Bourgeois	6	Information Systems Security	HW 4 due 10/24 at 11:59 PM
10/28			Access Prototype Work Session
10/30			Access Prototype Work Session	HW 5 due 10/31 at 11:59 PM
11/4	Salesforce	1	Overview of Salesforce
11/6	Salesforce	2	Design and Create Objects to Store Data	Prototype due 11/7 at 11:59 PM
11/11	Salesforce	3	Simplify Data Entry with Page Layouts
11/13	No Lecture. Exam on Friday
11/14	Exam II (Bourgeois Ch. 4, 5, 6, 10, Access Ch. 4 and Salesforce Ch 1) on Friday, 11/14 at 5:30 PM
11/18	Salesforce	4	Obtain Valuable Information Using Queries
11/20	Salesforce	5	Create Professional Quality Output with Reports	HW 6 due 11/21 at 11:59 PM
11/25			Salesforce Project Work Session
11/27	No Class. Thanksgiving Break
12/2			Team Project Assistance
12/4			Team Project Assistance	Project due 12/5 at 11:59 PM

Week

Text

Ch

Topics

Assignments (Dates Due)