Course Detail

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

CDAE 295 Z3 (CRN: 60384)

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 18 - June 12, 2015; May 26-May 30, 2015 Tuesday-Saturday 9:00-5:00 Pre and Post dates for continued out of class work

Syllabus

View Syllabus

More Information

Section Description

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. 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.

Section Expectation

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 since Dec 2012) 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

Evaluation

Learning Assessment Class participation 30% Assignments 30% Presentations 30% Professionalism 10% General Policies 1. Everyone must attend all classes. 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

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

to

Location

Morrill Hall 005 (View Campus Map)

Times

to on Tuesday, Wednesday, Thursday, Friday and Saturday

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 25% Refund
Last Day to Withdraw

Resources

Other courses you may be interested in…

SectionTitleInstructorsDatesDaysTimesCreditsCRN
CDAE 016 Z1
  • Jane Petrillo
to Tue
Wed
Thu
to 360815
CDAE 095 Z1
  • Chyi-Lyi Liang
to Mon
Tue
Wed
Thu
Fri
to 360860
to N/ASee Notes
CDAE 095 Z2

Only 1 Seat Available, Register Soon!

  • Chyi-Lyi Liang
to Mon
Tue
Wed
Thu
Fri
to 360872
to N/ASee Notes
CDAE 254 Z1
  • Qingbin Wang
to Tue
Wed
Thu
to 360387
CDAE 291 Z1
  • Jane Kolodinsky
to N/ASee Notes 1 - 660507

There are no courses that meet this criteria.