BIT 311 - Decision Support with Excel
Section: 001
Term: FA 2010
Subject: Business Information Technolog (BIT)
Department: Ross School of Business
Credits:
3 (Non-LSA credit).
Waitlist Capacity:
unlimited
Repeatability:
May not be repeated for credit.
Primary Instructor:

Spreadsheets are among the most widely used decision support tools in business today, and have advanced to the point of providing powerful, general-purpose functionally. The first half of the course introduces decision support modeling using spreadsheets, including: what-if analysis; financial, statistical, and time/date functions; graphical presentation of data; organizing and extracting information from spreadsheet databases; and cross-tabulation of data. The second half of the course includes importing information into spreadsheets from external sources; goal seeking; one and two way data tables; the use of a solver to find optimal solutions to problems; designing macros to develop semi-automated and fully automated spreadsheet applications; and probabilistic modeling to support risk analysis in the context of spreadsheets. Lecture/demonstrations illustrate the features of spreadsheet software. Lab work involves carrying out hands-on tutorials in a supervised setting, then reinforcing and extending conceptual and operational aspects of the material by doing follow-on cases. Windows-based spread-sheeting software (such as Excel for Windows) is typically studies in the course.

BIT 311 - Decision Support with Excel
Schedule Listing
001 (REC)
P
35281
Open
15
18BUSAD BBA - Jr or Sr Only
-
TuTh 10:00AM - 11:30AM
002 (REC)
P
38203
Open
10
16BUSAD BBA - Jr or Sr Only
-
TuTh 11:30AM - 1:00PM
NOTE: Data maintained by department in Wolverine Access. If no textbooks are listed below, check with the department.


ISBN: 1423905857
New perspectives on Microsoft Office Excel 2007 : comprehensive / June Jamrich Parsons ... [et al.]., Publisher: Thomson Course Technology 2008
Required
ISBN: 0470046740
Excel 2007 VBA programming for dummies, Author: by John Walkenbach ; revised by Jan Karel Pieterse., Publisher: Wiley Pub. Rev. [ed.] 2007
Required
Syllabi are available to current LSA students. IMPORTANT: These syllabi are provided to give students a general idea about the courses, as offered by LSA departments and programs in prior academic terms. The syllabi do not necessarily reflect the assignments, sequence of course materials, and/or course expectations that the faculty and departments/programs have for these same courses in the current and/or future terms.

No Syllabi are on file for BIT 311. Click the button below to search for a different syllabus (UM login required)

Search for Syllabus
The CourseProfile (ART) system, supported by the U-M Provost’s 3rd Century Initiative through a grant to the Digital Innovation Greenhouse, provides additional information about: course enrollments; academic terms and instructors; student academic profiles (school/college, majors), and previous, concurrent, and subsequent course enrollments.

CourseProfile (ART)