DateTextChTopicsAssignments (Dates Due)Team Project AssistanceTeam Project AssistanceIntroduction to Management Information SystemsMGS 351 – Spring 2020Instructor: David Murray Teaching Assistants: Jacobs 206JEmail: [email protected] Samuel Cruver: [email protected]: Jacobs 284 Phone: 645-3249 Kirsten McCarthy: [email protected] hours: Thursday 2:00 - 3:15 (or by appointment) Paige Roseman: [email protected] Site: mgs351.comCourse 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 courseworkPrerequisites:MGQ 201 - Introduction to Computers and Statistics. Concurrent registration is not allowed.Optional Course Textbook:- Management Information Systems for the Information Age: 9th Edition Haag, McGraw Hill Inc., 2013.Digital Access Lectures:The lecture is recorded on Thursday at 3:30 PM in Jacobs 106, and will be posted on UBLearns by Friday 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 exercises will also be assigned during lab. Lab attendance is mandatory, and each absence will result in a 3-point penalty assessed on your Professionalism grade. 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 ofthe 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. 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 7 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 willreceive a score of 0. Questions pertaining to your homework grades must be addressed to your TA within 2 weeks of theassignment due date.Final Team Project:You will work in teams of no more than five 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. 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 2/21 and 3/27. Please reschedule your work, social and family commitments accordingly. There are no make-up exams except under exceptional circumstances.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 and School of Management Academic Integrity policies are posted on the course website and should be reviewed carefully.Grading:Assignment PointsExam I 50Exam II 50Team Project Proposal & Design 5Final Team Project Access Prototype 40Final Team Project Salesforce 25Homework 1: Chapters 1 and 2 Guided & Applied Exercises 15Homework 2: Chapter 3 Guided & Applied Exercise 15Homework 3: Chapters 4 and 5 Guided & Applied Exercises 20Homework 4: Chapter 6 Guided & Applied Exercise 15Homework 5: Chapter 7 Guided & Applied Exercise 15Homework 6: Salesforce Trailhead Modules 15Homework 7: Salesforce Trailhead Modules 15Lab Assessments, Exercises and Professionalism 20A 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 courseand circumstances prevent them from completing the semester. **April 17th is the last day to resign the course.Tentative Course Schedule:Date Text Ch Topics Assignments (Dates Due)1/30 Haag 1 The Information Age in Which You Live Read SyllabusMurray 1 Overview of Microsoft Access Databases2/6 Haag XLM A Computer Hardware and SoftwareMurray 2 Design and Create Tables to Store DataMurray 3 Simplify Data Entry with Forms2/13 Haag XLM B The World Wide Web and the Internet HW 1 due 2/14 at 6:00 PMMurray 4 Obtain Valuable Information Using Queries2/20 Murray 5 Create Professional Quality Output with ReportsMurray 6 Design & Implement Powerful Relational Databases2/21 Exam I (Haag Ch. 1, XLM A, XLM B and Murray Ch. 1, 2 and 3) held in Knox 20 at 5:30 PM2/27 Haag XLM C Final Project Overview – Relational Database Design HW 2 due 2/28 at 6:00 PMMurray 7 Build User-Friendly