Computational Busn Model

1 Credit · Level: Undergraduate

The course has the following objectives: 1) Define Business Information Systems. 2) Introduce basic concepts related to Data and Model integration for decision making. 3) Cover the following introductory statistical concepts: a. Measures of Central Tendency (Mean, Median, Mode). b. Measures of Dispersion (Range, Variance, Standard Deviation). c. Measures of Shape (Symmetry, Skewness). d. Presenting Quantitative Data using Frequency Distribution Tables and Histograms. e. Summarizing Qualitative Data. f. Generating a Trend Line using the Method of Least Squares with Solver. 4) Provide a comprehensive Excel foundation for use in future MSB courses, such as: a. Creating, Formatting, Auditing and Managing Worksheets and Workbooks. b. Using Built-in Statistical, Financial, Logical & Date Functions. c. Creating and Formatting Charts. d. Manipulating Data, and using Data Tables & PivotTables/Pivot Charts. e. Tools for managing a complex worksheet, such as Grouping, and Documenting. f. Making Decisions with Goal Seek, Scenario Manager & Solver.