Course Descriptions

Course catalog descriptions for courses offered in the F09(A) term.

Business Information Technology

Department Chairperson: Moore, Scott
Department Website: http://www.bus.umich.edu/Academics/Departments/BIT
 
 
BIT 512 Decision Support with Spreadsheets
  1.5 hours Elective Terms Offered: F09(A)
  Course Prerequisites: No credit in TO 311, 511 
   
  Decision Support with Spreadsheets --- Spreadsheets have advanced to the point of providing powerful, general-purpose functionality and are among the most widely used decision-support tools in business today. This course deals with decision support using spreadsheets, including: what if analysis; financial, statistical and time/date functions; graphical presentation of data; organizing, sorting, querying and extracting information from spreadsheet and external databases and the World Wide Web; cross-tabulation of data; data tables; creation and management of scenarios; use of a solver to find optimal solutions to problems; the design to macros to support spreadsheet applications; and data maps. An expert level of spreadsheet use is achieved. Lecture-demonstrations illustrate relevant features of spreadsheet software. Students do assigned cases on a computer to reinforce and extend conceptual and operational aspects of the material. Windows-based spreadsheet software (such as Excel) is used.
 (more)
 
 
BIT 513 Spreadsheet Modeling and Applications
  1.5 hours Elective Terms Offered: F09(B)
  Course Prerequisites: No credit in CIS 511, TO 511 or TO 564 
  Advisory Prerequisites: BIT 311, BIT 512, or permission of instructor 
   
  Spreadsheet Modeling and Applications --- This course, a continuation of BIT512, emphasizes problem solving using spreadsheet software. Extensive use is made of a spreadsheet solver (such as Solver in Excel) to formulate and solve practical optimization problems from such mathematical programming areas as linear, integer, and nonlinear programming, and multiple-objective decision making. Probabilistic modeling to support risk analysis in the context of spreadsheets is also studied, using native spreadsheet capabilities alone and then supplementing these capabilities with spreadsheet problem analysis, model formulation, implementation, execution and interpretation. Students do assigned computer word to reinforce and extend conceptual and operational aspects of the material.
 (more)
 
 
BIT 551 Information Systems
  3 hours Core Terms Offered: F09
  Course Prerequisites: No credit in STRATEGY/TO 514 
   
  Information Systems --- An introduction to information systems for managers. Topics discussed include the kinds of information systems that support individual, group and corporate goals, with an emphasis not only on the hardware/software but also the managerial concerns with the design and implementation of information technology.
 
 
BIT 623 Information Technology Strategy in Supply Chain and Logistics
  1.5 hours Elective Terms Offered: F09(B)
   
  Information Technology Strategy in Supply Chain and Logistics --- Digital technologies have permeated every aspect of modern business. The capacity to execute any business model rests heavily on the approach taken by firms in organizing their information architecture. This course will explore the role of information architecture on Supply Chain and Logistics functions. We will discuss the dominant technologies traditionally used in planning, forecasting, scheduling and managing supply chains. We will then explore the emerging new technologies such as SOA ( Service Oriented Architecture) that enable firms to innovate in their business models through dynamic engagement with their supply partners in an evolving global supply networks. Class discussions and case studies will include technology and business process choices in new product development, design, MRP, ERP, distribution and logistics.