Public
Activity Feed Discussions Blogs Bookmarks Files

I teach accounting, which consists not only of doing journal entries and preparing financial statements, but also of performing computations. For all of these purposes, doing work in Excel clarifies and facilitates the learning process and prepares the student for the way accounting is done in the real world.

The text books I use typically include about four exercises or problems that are also available in Excel form. In addition to other necessary problems, I usually assign all of these Excel-based tasks.

Furthermore, in addition to using lecture to initially survey and conceptually illuminate a chapter, I allocate time for in-class exerces anf problem solving. My students often tell me that they learn better by doing and practicing in class.

For some accounting topics for which Excel-based alternatives may not be provided that are nevertheless complex and essentially require the use of worksheets to solve problems, I have created Excel-based templates for students to do such homework problems. Good examples are inventory valuation methods, such as the gross profit method and the retail inventory method, as well as general inventory calculations.

Through the use of text-provided templates and some of my own, I endeavor to give my students illuminating and usedful hands-on training and practice to strengthen and reinforce their learning and comprehension of difficult accounting concepts and techniques.

How do other instructors (perhaps apart from teacher of IT) use electronic media to enhance their educational purposes?

Sign In to comment