Course Detail

Cmty Dev & Apld Econ: Data Mgmt & Analysis in Excel

CDAE 295 Z3 (CRN: 60505)

3 Credit Hours

The period for adding the course CDAE 295 Z3 has ended.

You may review the related courses listed at the bottom of the page.

About CDAE 295 Z3

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.

Instructor

Chyi-Lyi Liang ()

Notes

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

Video

View Video

More Information

Section Description

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.

Meetings

Course runs from to

to

Location

Morrill Hall 005 (View Campus Map)

Times

to on Monday, Tuesday, Wednesday, Thursday and Friday

to

Location

Location In Vt Or Out Of State (View Campus Map)

Important Dates

Deadlines
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

Resources

Other courses you may be interested in…

SectionTitleInstructorsDatesDaysTimesCreditsCRN
CDAE 095 Z3
  • Chyi-Lyi Liang
to Mon
Tue
Wed
Thu
to 360503
to N/ASee Notes
CDAE 254 Z1

This section is full: view available options

  • Qingbin Wang
to Tue
Wed
Thu
to 360515
CDAE 291 Z1
  • Jane Kolodinsky
to N/ASee Notes 1 - 660728
CDAE 295 Z1
  • Edward McMahon
to N/ASee Notes 1 - 1260647
CDAE 296 Z1
  • Charles Ferreira
to N/ASee Notes 1 - 1860217

There are no courses that meet this criteria.