Solution Manual For
Data and Analytics in Accounting
Author: Ann Dzuranin, Guido Geerts
1st Edition
1-1
,TABLE OF CONTENT
PLAN
Chapter 1: Data and Analytics in the Accounting Profession
Chapter 2: Foundational Data Analysis Skills
Chapter 3: Motivations and Objectives for Data Analysis
Chapter 4: Planning Data and Analysis Strategies
ANALYZE
Chapter 5: Analysis: Data Preparation
Chapter 6: Analysis: Information Modeling
Chapter 7: Analysis: Data Exploration
REPORT
Chapter 8: Interpreting Data Analysis Results
Chapter 9: Communicating Data Analysis Results
Chapter 10: Recent Data and Analyses Developments in Accounting
1-2
,Solution Manual For
Data And Analytics In Accounting An Integrated Approach 1e Ann C.
Dzuranin, Guido Geerts, Margarita Lenk
CHAPTER 1
DATA AND ANALYTICS IN THE ACCOUNTING
PROFESSION
Learning Objectives:
LO 1.1: Summarize How Advances In Data And Technology Are Impacting Accounting Professionals.
LO 1.2: Describe The Stages Of The Data Analysis Process.
LO 1.3: Identify The Skills Necessary To Perform Data Analysis.
LO 1.4: Explain How To Apply A Data Analytics Mindset During The Data Analysis Process.
ANSWERS TO MULTIPLE CHOICE QUESTIONS
LO 1.2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
1. A Leverage Technology To Develop And Enhance Functional Competencies
LO 1.1, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
7. D
2. C LO 1.2, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
LO 1.1, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
8. C
3. C LO 1.2, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
LO 1.2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
9. A
4. B LO 1.3, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
LO 1 2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
10.D
5. B LO 1.3, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
LO 1.2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
11.B
6. C
1-3
, LO 1.3, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
14.A
LO 1.4, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
12.A
LO 1.4, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
15.B
LO 1.4, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
13.D
LO 1.4, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
ANSWERS TO REVIEW QUESTIONS
1. Both The CPA Exam And The CMA Exam Have Added Data Analytic Content To Their Exams. This Is
In Response To What New Professionals Need To Know As They Enter The Accounting Profession. The
CPA Exam Evolution Is A Strong Indication Of How The Accounting Profession Is Changing. The New
CPA Exam Will Have More Technology And Data Analytics Questions In The Core Exam, As Well As The
Discipline Exams.
LO 1.1, BT: K, Difficulty: Easy, TOT: 6 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
2.
Changes Accounting Practice Area
1. Ability To Use Entire Data Sets To Identify ANS: A. Auditing, C. Managerial Accounting
Exceptions, Anomalies, And Outliers
2. Automation Of Manual Processes ANS: A., B., C., D. (All Areas)
3. Automation Of Journal Entries ANS: B. Financial Accounting
4. Risk Identification ANS:. A. Auditing, C. Managerial Accounting
5. Forecasting ANS: B. Financial Accounting, C. Managerial
Accounting
6. Compliance Reporting ANS: D. Tax Accounting
LO 1.1, BT: C, Difficulty: Medium, TOT: 8 Min, AACSB: Analytic, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
3. Data Are Raw Facts And Figures. Technology Helps Covert That Data Into Information. Information Is
The Knowledge Gained From Analyzing The Data.
LO 1.1, BT: C, Difficulty: Medium, TOT: 6 Min, AACSB: Analytic, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
4.
Purpose Method
1. Understanding What Is Happening Currently ANS: A. Descriptive
And What Has Happened In The Past.
1-4
Data and Analytics in Accounting
Author: Ann Dzuranin, Guido Geerts
1st Edition
1-1
,TABLE OF CONTENT
PLAN
Chapter 1: Data and Analytics in the Accounting Profession
Chapter 2: Foundational Data Analysis Skills
Chapter 3: Motivations and Objectives for Data Analysis
Chapter 4: Planning Data and Analysis Strategies
ANALYZE
Chapter 5: Analysis: Data Preparation
Chapter 6: Analysis: Information Modeling
Chapter 7: Analysis: Data Exploration
REPORT
Chapter 8: Interpreting Data Analysis Results
Chapter 9: Communicating Data Analysis Results
Chapter 10: Recent Data and Analyses Developments in Accounting
1-2
,Solution Manual For
Data And Analytics In Accounting An Integrated Approach 1e Ann C.
Dzuranin, Guido Geerts, Margarita Lenk
CHAPTER 1
DATA AND ANALYTICS IN THE ACCOUNTING
PROFESSION
Learning Objectives:
LO 1.1: Summarize How Advances In Data And Technology Are Impacting Accounting Professionals.
LO 1.2: Describe The Stages Of The Data Analysis Process.
LO 1.3: Identify The Skills Necessary To Perform Data Analysis.
LO 1.4: Explain How To Apply A Data Analytics Mindset During The Data Analysis Process.
ANSWERS TO MULTIPLE CHOICE QUESTIONS
LO 1.2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
1. A Leverage Technology To Develop And Enhance Functional Competencies
LO 1.1, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
7. D
2. C LO 1.2, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
LO 1.1, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
8. C
3. C LO 1.2, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
LO 1.2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
9. A
4. B LO 1.3, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
LO 1 2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
10.D
5. B LO 1.3, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
LO 1.2, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
Leverage Technology To Develop And Enhance Functional Competencies
11.B
6. C
1-3
, LO 1.3, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
14.A
LO 1.4, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
12.A
LO 1.4, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
15.B
LO 1.4, BT: C, Difficulty: Medium, TOT: 3 Min, AACSB: Analytic, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
13.D
LO 1.4, BT: K, Difficulty: Easy, TOT: 2 Min, AACSB: Knowledge, AICPA FC:
Leverage Technology To Develop And Enhance Functional Competencies
ANSWERS TO REVIEW QUESTIONS
1. Both The CPA Exam And The CMA Exam Have Added Data Analytic Content To Their Exams. This Is
In Response To What New Professionals Need To Know As They Enter The Accounting Profession. The
CPA Exam Evolution Is A Strong Indication Of How The Accounting Profession Is Changing. The New
CPA Exam Will Have More Technology And Data Analytics Questions In The Core Exam, As Well As The
Discipline Exams.
LO 1.1, BT: K, Difficulty: Easy, TOT: 6 Min, AACSB: Knowledge, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
2.
Changes Accounting Practice Area
1. Ability To Use Entire Data Sets To Identify ANS: A. Auditing, C. Managerial Accounting
Exceptions, Anomalies, And Outliers
2. Automation Of Manual Processes ANS: A., B., C., D. (All Areas)
3. Automation Of Journal Entries ANS: B. Financial Accounting
4. Risk Identification ANS:. A. Auditing, C. Managerial Accounting
5. Forecasting ANS: B. Financial Accounting, C. Managerial
Accounting
6. Compliance Reporting ANS: D. Tax Accounting
LO 1.1, BT: C, Difficulty: Medium, TOT: 8 Min, AACSB: Analytic, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
3. Data Are Raw Facts And Figures. Technology Helps Covert That Data Into Information. Information Is
The Knowledge Gained From Analyzing The Data.
LO 1.1, BT: C, Difficulty: Medium, TOT: 6 Min, AACSB: Analytic, AICPA FC: Leverage Technology To Develop And Enhance Functional Competencies
4.
Purpose Method
1. Understanding What Is Happening Currently ANS: A. Descriptive
And What Has Happened In The Past.
1-4
