Christine Cheng, Shelley Rhoades-Catanach, Luke Watson
{"title":"Data Analytics for Undergraduate Tax Students: An Alteryx Case Study for MACRS Depreciation","authors":"Christine Cheng, Shelley Rhoades-Catanach, Luke Watson","doi":"10.2308/issues-2022-005","DOIUrl":null,"url":null,"abstract":"\n The increasing use of data analytics in the accounting profession necessitates development of instructional cases that teach students how to use data analytics tools to solve common accounting problems. While there has been an emphasis on data analytics cases for graduate education, we recognized a need for such cases at the undergraduate level to prepare students for internships, careers, and graduate education. This case meets this important need by introducing Alteryx in a typical tax setting—the calculation of Modified Accelerated Cost Recovery System (MACRS) depreciation. The learning objectives are to: (1) extend knowledge of data analytics; (2) develop skills using Alteryx to extract, transform, and load data; (3) demonstrate understanding of tax rules for computing depreciation; and (4) develop effective written communication skills.","PeriodicalId":1,"journal":{"name":"Accounts of Chemical Research","volume":null,"pages":null},"PeriodicalIF":16.4000,"publicationDate":"2023-07-25","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Accounts of Chemical Research","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.2308/issues-2022-005","RegionNum":1,"RegionCategory":"化学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q1","JCRName":"CHEMISTRY, MULTIDISCIPLINARY","Score":null,"Total":0}
引用次数: 0
Abstract
The increasing use of data analytics in the accounting profession necessitates development of instructional cases that teach students how to use data analytics tools to solve common accounting problems. While there has been an emphasis on data analytics cases for graduate education, we recognized a need for such cases at the undergraduate level to prepare students for internships, careers, and graduate education. This case meets this important need by introducing Alteryx in a typical tax setting—the calculation of Modified Accelerated Cost Recovery System (MACRS) depreciation. The learning objectives are to: (1) extend knowledge of data analytics; (2) develop skills using Alteryx to extract, transform, and load data; (3) demonstrate understanding of tax rules for computing depreciation; and (4) develop effective written communication skills.
期刊介绍:
Accounts of Chemical Research presents short, concise and critical articles offering easy-to-read overviews of basic research and applications in all areas of chemistry and biochemistry. These short reviews focus on research from the author’s own laboratory and are designed to teach the reader about a research project. In addition, Accounts of Chemical Research publishes commentaries that give an informed opinion on a current research problem. Special Issues online are devoted to a single topic of unusual activity and significance.
Accounts of Chemical Research replaces the traditional article abstract with an article "Conspectus." These entries synopsize the research affording the reader a closer look at the content and significance of an article. Through this provision of a more detailed description of the article contents, the Conspectus enhances the article's discoverability by search engines and the exposure for the research.