Course Descriptions

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

Business Information Technology

 
BIT 512 Decision Support with Spreadsheets
  1.5 hours Elective Terms Offered: F09(A)
  Course Prerequisites: No credit in TO 311, 511 
   
 

This course covers what-if analysis; charting; functions (e.g., financial; time and date; lookup; and others); one-variable and two-variable data tables; working with internal and external databases; sorting, querying and extracting; pivot tables; using information across multiple worksheets and workbooks; spreadsheet-based access to information on the World Wide Web; scenarios and scenario management; introductory optimization using Solver; and introductory material on the creation of macros in Visual Basic. Students can complete all assignments in this course on their own computer. (Microsoft certifies the BIT 512 textbook "Expert Level". This means that mastering the material in the book makes it possible to pass the MOUS - Microsoft Office User Specialist - Excel exam at the level of Expert.)


http://webuser.bus.umich.edu/schriber/512-513FAQ.html