This course focuses on using advanced EXCEL functions to calculate, manage and analyze any scale of data sets. Topics include fundamental EXCEL training and advanced EXCEL toolkits can be applicable to person/business financial analysis, forecasting, simulations, industry trend analysis, human resource data analysis, nutrient/food consumption analysis, enrollment management, or any large scale data analysis.
Chyi-Lyi Liang ()
Dates: May 19 - June 13, 2014; May 19 - May 23, 2014 Mon - Fri 9:00 AM - 5:00 PM; May 26 - June 13 for continued out of class work
May 19, 2014 ? May 23, 2014, Monday Through Friday 9am to 5pm Data Analysis and Management in EXCEL Applications in Statistical Modeling and Financial Analysis Instructor: Dr. Chyi-lyi (Kathleen) Liang Office: 103 C Morrill Hall Phone: 656 0754 E-mail: CLIANG@UVM.edu Purpose of the Course This course focuses on using advanced EXCEL functions to calculate, manage and analyze any scale of data sets. Topics include fundamental EXCEL training and advanced EXCEL toolkits can be applicable to person/business financial analysis, forecasting, simulations, industry trend analysis, human resource data analysis, nutrient/food consumption analysis, enrollment management, or any large scale data analysis. Many unique datasets will be introduced in this class to facilitate participants? learning. These datasets have been purchased and maintained by UVM library, which covers a wide range of information for business, human resource, and economic analysis. Participants need to have some EXCEL experience in working with basic functions, such as data entry and simple calculations. The contents of the course involve economics theories (Micro and Macro) and Statistics (simple descriptive statistics and regression). These contents will be reviewed and be incorporated into the computer applications. Structure of the Course This is a hands-on and application course. The class meets in the computer lab every day. Participants may bring own computers, and must install EXCEL (for Windows or Mac) software prior to attending this course. Please also make sure that you have Analysis Tool Kit installed on your own computer. Discussions and interactions are the key elements of this course. Each day, participants need to prepare for a progress report. Each participant will conduct a mini independent research project, by choosing your own research topic. The final paper is due on the last day of the class. To make EXCEL more fun to learn, each participant will also learn and complete a personal finance analysis using EXCEL. Tentative Schedule Day 1 Introduction ? getting to know each other Knowledge pre-assessment Learning expectations ? setting goals EXCEL Basic Functions (data entry, graphs, charts) Foundation of forecasting Moving Average Analysis for time series data Seasonality analysis and graphs Foundation of the Statistics Descriptive Statistics Correlation Coefficients Using EXCEL to calculate Day 2 Continue the Foundation of Statistics Theories of Regression Analysis Using EXCEL to calculate Continue on the Regression Analysis Self-designed project (discussion and presentation) Define your topic Data collection and primary analysis Graphs and charts Day 3 Check on the projects Foundation of the Financial Analysis ? definitions and terms Cash Flow, Income Statement (Profit and Loss), Balance Sheet Business Analysis Information ? Business Assistant Database in the Library Day 4 Examples of the Financial Analysis Constructing your own financial analysis (use the records that you have been keeping in your assignment) Continue the financial and budgeting discussions Putting everything together ? forecasting and financial analysis Day 5 Reviews ? putting everything together Final presentations (10 minutes per person) Learning reflections Learning Assessment Class participation 30% Assignments 30% Presentations 30% Professionalism 10% General Policies 1. Everyone must attend all classes between May 19 and May 23. 2. All assignments and presentations must be completed on time. Late assignments and presentations will not be accepted. 3. Emergency contact, Tina Haskins (656 2001) or Elisa Ziglar (656 0041) in Morrill Hall, 2nd floor. 4. Please turn off your cell phone when class is in session. 5. Other policies follow the UVM Code of Conduct.
Course runs from to
Morrill Hall 005 (View Campus Map)
to on Monday, Tuesday, Wednesday, Thursday and Friday
Location In Vt Or Out Of State (View Campus Map)
Courses may be cancelled due to low enrollment. Show your interest by enrolling.
|Last Day to Add|
|Last Day to Drop|
|Last Day to Withdraw with 50% Refund|
|Last Day to Withdraw with 25% Refund|
|Last Day to Withdraw|
|CDAE 095 Z3||Cmty Dev & Apld Econ: Community Engagemnt&Leadrship||to||Mon|
|CDAE 254 Z1||Cmty Dev & Apld Econ: Microeconomics for Appl Econ||to||Tue|
|CDAE 291 Z1||Cmty Dev & Apld Econ: Special Problems||to||N/A||See Notes||1 - 6||60728|
|CDAE 295 Z1||Cmty Dev & Apld Econ: Peace Corps Service Analysis||to||N/A||See Notes||1 - 12||60647|
|CDAE 296 Z1||Cmty Dev & Apld Econ: Field Experience/Practicum||to||N/A||See Notes||1 - 18||60217|
There are no courses that meet this criteria.