What's Happening to Profits at Cazenovia Creations?

作者: Margaret Garnsey , Andrea Hotaling

DOI: 10.3194/1935-8156-8.1.24

关键词: Financial analysisBusinessMarketingDatabase transactionDatabase queryNet incomeHappeningFinancial statement analysisLevel dataSet (psychology)

摘要: ABSTRACT In this case, students assume the role of an accounting professional asked by a client to investigate why net income is not as strong expected. The must first analyze set financial statements identify areas possible concern. After determining investigate, use database query tool see if they can determine causes examining transaction level data. Finally, are professionally communicate their findings and recommendations client. case provides with experience in using query-based approaches answering business questions. It appropriate for basic analysis skills knowledge internal controls. A Microsoft Access details final seven months current year well prior provided.

参考文章(10)
Carolyn Strand Norman, Anna M. Rose, Jacob M. Rose, Using Database Technology In The AIS Classroom: Effects On Learning And Student Satisfaction business information systems. ,vol. 10, pp. 1- 10 ,(2011) , 10.19030/RBIS.V10I1.5303
A. Faye Borthick, Paul L. Bowen, Gregory J. Gerard, Modeling a Business Process and Querying the Resulting Database: Analyzing RFID Data to Develop Business Intelligence Journal of Information Systems. ,vol. 22, pp. 331- 350 ,(2008) , 10.2308/JIS.2008.22.2.331
A. Faye Borthick, Donald R. Jones, Ryan Kim, Developing Database Query Proficiency: Assuring Compliance for Responses to Web Site Referrals Journal of Information Systems. ,vol. 15, pp. 35- 56 ,(2001) , 10.2308/JIS.2001.15.1.35
David R. Fordham, New Roles for AIS Courses: A Surprising Finding from a Case Study Journal of Information Systems. ,vol. 19, pp. 113- 129 ,(2005) , 10.2308/JIS.2005.19.1.113
Arline Savage, Carolyn Strand Norman, Kathryn A. S. Lancaster, Using a Movie to Study the COSO Internal Control Framework: An Instructional Case Journal of Information Systems. ,vol. 22, pp. 63- 76 ,(2008) , 10.2308/JIS.2008.22.1.63
Marianne Bradford, Janet A. Samuels, Robert E. Wood, Beta Auto Dealers: Integrating Disparate Data to Solve Management Problems Issues in Accounting Education. ,vol. 23, pp. 309- 326 ,(2008) , 10.2308/IACE.2008.23.2.309
Tina M. Loraas, DeWayne L. Searcy, Using Queries to Automate Journal Entry Tests: Agile Machinery Group, Inc. Issues in Accounting Education. ,vol. 25, pp. 155- 174 ,(2010) , 10.2308/IACE.2010.25.1.155
Duanning Zhou, Arsen Djatej, Yining Chen, David Senteney, Recruiting MIS Minors: The Impact Of In-Depth Database Exposure In The Accounting Information Systems Course international conference on bioinformatics. ,vol. 15, pp. 119- 128 ,(2011) , 10.19030/IJMIS.V15I3.4648
A. Faye Borthick, Donald R. Jones, Analyzing a Potential Warranty Call Center Budget Overrun: Using Database Queries to Solve Business Problems Journal of Information Systems. ,vol. 19, pp. 97- 111 ,(2005) , 10.2308/JIS.2005.19.1.97