DEPARTMENT OF ECONOMICS                                                   

Course:                                 PACE Social Science 305P 

Title:                                     Economic Principles and Applications of Accounting

Instructor:                             Pavlina R. Tcherneva                         

Class Hours:                         Wed: 6 - 6:50pm, RH 314                    

Office Hours:                        Wed: 3 - 5pm and by appointment   

Office:                                   RH 408H                                                               

Telephone:                            816-235-5835                                                        

Email:                                    tchernevap@umkc.edu      

                

Required Materials:             Excel 97 for Windows, by Greg Harvey, 2 IBM formatted 1.44MB floppy disks

 

Online Books:                     www.barnesandnoble.com, www.amazon.com, www.varsitybooks.com, www.abebooks.com

 

Course Description:             This course aims to provide the student with knowledge of spreadsheet use in the context of accounting and economic applications. We will work with Excel, because that is the spreadsheet application of choice for business and government. Much of what you learn about Excel is directly applicable to other spreadsheets, such as Lotus 1-2-3 or Quattro Pro.

 

Course Objective:                Students are expected to walk out of this course with an ability to work comfortably in an Excel 97 environment. In addition, students will learn some of the basic and most important government economic statistics and how to apply them using Excel in introductory sectoral analysis.

 

Assignments:                       Submit your homework on time. Assignments will be given well in advance, so you will have plenty of time to complete them. A late homework will reduce your grade by 10%. In other words, a perfect assignment which is late will receive 90% instead of a 100%. All assignments must be either submitted on a disk or emailed to the instructor.                              

 

Course Outline:                                                                   

22-Aug            Ch 1: Getting Started    

29-Aug            Ch 2, 3 and 8: Tables, Formatting, Formulas and Charts

5-Sep              Lab: Tables, Formatting, Formulas and Charts

12-Sep            Ch 9: Building and Working with a Database

19-Sep            handout: Pivot tables          

26-Sep            Lab: Pivot Tables

3-Oct              quiz + Ch 12: HTML, Hyperlinks (HWK#1 due)

10-Oct             Ch 10: HTML, Hyperlinks and Internet                                       

17-Oct             handout: National Income & Product Accounts (NIPAs)

24-Oct             Lab: More NIPAs (downloads) + Dow Jones Index                                      

31-Oct             guest speaker: GIS mapping                                         

7-Nov              quiz: Data analysis in Excel

14-Nov            Profits  (HWK#2 due)                                                                          

21-Nov            No Class                                                                                                                

28-Nov            handout: Sectoral analysis                                                  

5-Dec               handout: Sectoral analysis                                  

12-Dec             FINAL EXAM: RH 314, 5:45 - 7:45 pm           

 

Grading:                 QUIZ 1                   12.5%                    

                                QUIZ 2                   12.5%                    

                  HOMEWORK 1                    20%                       

                  HOMEWORK 2                    20%                       

                                FINAL                    35%                       

                                                                               

HWK 1: Tables, Charts and Databases                                                      

HWK 2: Data analysis in Excel, use stock market data                 

 

To track the stock market, go to www.bloomberg.com or use any daily paper.

Click on the CHARTS button on the top bar and record the Dow Jones Indus. Avg 'Open' entry.

 

Policy:                 Work on assignments alone!