College Meets Curriculum Criteria

BY RICHARD D. PARKER

The Crisis in Accounting Education” states that technology has made preparing and disseminating financial information so inexpensive that anyone with the right computer software can produce basic data. “Yet, many accounting educators have failed to restructure the accounting curriculum to equip graduates with the tools and expertise they need in today’s business world.”

This is not true at Olivet College because

Students use Excel, Power Point and Word to prepare templates for all accounting problems. They then use these templates during the testing process.

In intermediate accounting students learn how to make depreciation and amortization schedules in which the only input is the cost of the asset, its residual value and its life.

In tax accounting students create many of the tax forms, a tax calculator and a comprehensive questionnaire. The tax questionnaire functions as an input mechanism, and the system they create is set up to function like Turbo Tax.

In accounting information systems the students use the drawing features of Excel to create system flowcharts and all business forms. Students use this same template system in cost accounting and advanced accounting and to some degree in auditing.

The students are allowed to use their own templates to take the mid-term and final exams.

In accounting principles the students use the templates in an interactive tutorial, purchased from the bookstore to help them learn.

Student feedback from this unique system is very positive. I received an e-mail from a graduate who attributed his placement with a good starting salary not to his accounting or insurance education but to his spreadsheet education in Excel.

Richard D. Parker, CPA
Assistant Professor of Business
Olivet College
Eaton Rapids, Michigan

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out