Bauer College of Business
MBA & MS
Extended Orientation
Join us for extended orientation. These sessions are designed to help introduce and refresh skills in Excel and Statistics. These sessions are strongly encouraged, as they will help to build a foundation to be successful in these classes. Please see the details below and register for the class that best fits your needs. Lunch will be provided each day.
|
PLEASE BRING YOUR LAPTOPS. We will not have any on hand.
|
STATISTICS WORKSHOP
Saturday, January 20 from 8:00 am-5:00 pm
Topics that will be discussed
- Why study statistics in a Business School?
-
Data
- Classification
- Measures of central tendency & dispersion
- Concepts of Probability
-
Distributions of a single variable
- Normal
- Binomial
- Poisson
- Exponential
-
Gaining insights from data
- Relationships between two variables
- Pivot tables and categorical variables
- Plots for numerical variables
EXCEL WORKSHOP
Saturday, January 27 from 8:00 am-5:00 pm
Topics that will be discussed
-
Worksheet Basics
- Relative vs. Absolute Addressing
- Statistical Functions
- Financial Functions
- Basic Charts
-
Logical & Reference
- IF/AND/OR statements
- COUNTIF(S), SUMIF, AVERAGEIF
- VLOOKUP, INDEX, MATCH
-
Data Analysis
- Clean up
- Form Controls
- Data Tables
- Pivot Tables
- Filters
- Data Validation & Protection
LOCATION
All sessions will be held in UCBB 310.
Please follow your student-parking pass. Validations will not be provided.
.
If you have any questions regarding extended orientation, please contact Sharoma Scurry-Graves at ssscurry@bauer.uh.edu or 713-743-4699.
|