Font Size:
Using Excel as a Structured Learning Environment, Lessons Learned from a Pandemic
Last modified: 2020-10-10
Abstract
Excel is the tool of choice in the business world for data analysis and financial modeling. In higher education Excel can be used to develop a rich, real time learning environment for students. By using conditional formatting, data validation fields, embedded comments, videos, and other Excel features faculty can create rich interactive worksheets that provide students just-in-time learning and real-time feedback. This paper describes the basic techniques for creating dynamic self-correcting worksheets to illustrate a variety of concepts in finance and accounting with applications to other fields. It describes how to use Excel to develop a rich visual hands on learning environment.
Keywords
Education, Excel, Finance, Accounting, On-line Learning,