NABET, NABET 2020 CONFERENCE

Font Size: 
Using Excel as a Structured Learning Environment, Lessons Learned from a Pandemic
Eric L Blazer

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,