Data Modeling

April 3 - May 1, 2018
Five consecutive Tuesday evenings
5:30-9 p.m.
208 Jacobs Management Center (computer lab)
North Campus
$1,095, includes all costs

Take a deep dive into Microsoft Excel and learn how this tremendously powerful tool can help you manipulate complex data to provide information and make decisions. This hands-on course enhances your Excel skills.

All managerial activities revolve around decision-making. One of the hallmarks of successful management in a complex and rapidly changing environment is the ability of people to recognize decision situations, understand their essential features, and obtain insight that makes clear what the appropriate actions are. 

Fundamental to decision making is a model that represents the situations. The spreadsheet-modeling environment is a most widely accepted modeling tool for managerial decision making. This training studies two fundamental issues of decision making, namely, the modeling of the situations or problems and the solution of those problems. The purpose of this training is to provide the participants with a working knowledge of a method to address decision situations in a rational, well-organized manner.  

Course Objectives

With a little knowledge and a willingness to practice and make mistakes, you'll be amazed at how quickly your effectiveness in using spreadsheets will improve.

Topics

  • Auditing
  • Toolbars
  • "Go To" feature
  • Charts
  • Basic customization (lists, defaults, windows)
  • Data analysis
  • Pivot tables
  • Statistical analysis toolpack
  • Formatting
  • Beginning to advanced formulas
  • Beginning, intermediate and advanced functions (arrays, information and text)
  • Nesting
  • Idiot proofing
  • Validation
  • What if analysis
  • Data tables
  • Scenarios
  • Goal seek and solver

About the Instructor

Dianna Cichocki

Clinical Assistant Professor
Management Science and Systems Department

Education

MS, Oswego State University
BA, St. John Fisher College

Dianna Cichocki teaches "Statistical Decisions in Management" and "Statistical Foundations in Analytics." She has given several presentations at both the state and national levels concerning incorporating technology into statistics, educational practices and assurance of learning. Cichocki has been honored with academic excellence awards for her instruction.

Teaching

    MGQ301 – Statistical Decisions in Management
    MGQ 606 - Statistical Foundations in Analytics

Professional Affiliations

    American Mathematics Association of Two-Year Colleges (AMATYC)
    New York State Association of Two-Year Colleges (NYSMATYC)

Awards and Recognition

    National Institute for Staff and Organizational Development (2010)
    Outstanding Classroom or Alternative Instruction (2010)

Payment Options

The program costs $1,095 and includes all materials used.

Payment can be made as follows:

Credit card (Visa, MasterCard, American Express or Discover)
or
Check made payable to UB Foundation Activities Inc. and mailed to:
Center for Executive Development
108 Jacobs Management Center
Buffalo, NY 14260