10/5/2018 Take Test: Data Analytics – AC470.002.FA18….
https://blackboard.bentley.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_2762_1&course_id=_300_1&content_id=_177713_1&step=null 1/5
Take Test: Data Analytics
AC470.002.FA18.Thibodeau.Financial Statement Auditing Assignments
Take Test: Data Analytics
Test Information
Description
Instructions
Multiple
Attempts
This test allows multiple attempts.
Force
Completion
This test can be saved and resumed later.
One major trend in auditing practice is the use of data analysis tools to take
advantage of the growing amounts of data available to auditors. Indeed, the
auditing environment is rapidly being transformed into an environment
characterized by the availability of “Big Data.” Among other changes, there has
clearly been an increase in the use of “smart” information technology applications
which have helped to fuel the increased use of data and analytical tools by entry
level audit professionals on the audit. As a direct result, entry level audit
professionals are being asked to join public accounting �rms having completed
coursework that has exposed them to the use of big data and analytical tools on
the audit.
Using the data set (available at Course Documents / Data Analytics / Cleaned G/L
Data), and utilizing any data analysis tool (Excel, R, Idea, etc.), �nd the answers to
each of the following 20 questions.
This is an individual assignment, but you may work together.
QUESTION 1
Average value of journal entries where the document type is DZ
(customer payment) for the International Subsidiary (Chart of
Accounts = INT) in the second half of 2015
5 points Save Answer
?
Question Completion Status:My Institution Bentley Help
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
Courses
PUI YU Wang 1
https://blackboard.bentley.edu/webapps/blackboard/execute/courseMain?course_id=_300_1
https://blackboard.bentley.edu/webapps/blackboard/content/listContent.jsp?course_id=_300_1&content_id=_19826_1&mode=reset
https://blackboard.bentley.edu/bbcswebdav/pid-177713-dt-content-rid-496850_1/xid-496850_1
https://blackboard.bentley.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_1_1
https://blackboard.bentley.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_22_1
https://blackboard.bentley.edu/webapps/portal/execute/tabs/tabAction?tab_tab_group_id=_2_1
https://blackboard.bentley.edu/webapps/login/?action=logout
10/5/2018 Take Test: Data Analytics – AC470.002.FA18….
https://blackboard.bentley.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_2762_1&course_id=_300_1&content_id=_177713_1&step=null 2/5
QUESTION 2
Give a count of the transaction activity where the posting key=50
(Credit entry) for the International Subsidiary (Chart of Accounts =
INT) in the second half of 2015
5 points Save Answer
QUESTION 3
What was the sum of the values of the journal entries recorded for
the US Subsidiary (Chart of Accounts = CAUS) in the �rst half of
2015
5 points Save Answer
QUESTION 4
Sum all of the activity where the posting key=40 (Debit entry) for
the Japanese Subsidiary (Chart of Accounts = CAJP) in the �rst half
of 2015
5 points Save Answer
QUESTION 5
Sum all of the activity where the posting key=50 (Credit entry) for
the International Subsidiary (Chart of Accounts = INT) in the
second half of 2015
5 points Save Answer
QUESTION 6
Give a count of the transaction activity where the posting key=70
(Debit asset) for the US Subsidiary (Chart of Accounts = CAUS) in
the �rst half of 2016
5 points Save Answer
QUESTION 7
Sum all of the activity where the posting key=91 for the US
Subsidiary (Chart of Accounts = CAUS) in the �rst half of 2015
5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
10/5/2018 Take Test: Data Analytics – AC470.002.FA18….
https://blackboard.bentley.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_2762_1&course_id=_300_1&content_id=_177713_1&step=null 3/5
QUESTION 8
Average value of journal entries where the document type is DZ
(customer payment) for the US Subsidiary (Chart of Accounts =
CAUS) in the �rst half of 2015
5 points Save Answer
QUESTION 9
Give a count of the transaction activity where the posting key=91
for the US Subsidiary (Chart of Accounts = CAUS) in the �rst half of
2016
5 points Save Answer
QUESTION 10
Total value of journal entries by document type is DR (customer
invoice) for the US Subsidiary (Chart of Accounts = CAUS) in the
second half of 2015
5 points Save Answer
QUESTION 11
Give a count of the transaction activity where the posting key=40
(Debit entry) for the US Subsidiary (Chart of Accounts = CAUS) in
the �rst half of 2016
5 points Save Answer
QUESTION 12
Sum all of the activity where the posting key=93 for the US
Subsidiary (Chart of Accounts = CAUS) in the second half of 2015
5 points Save Answer
QUESTION 13
What was the sum of the values of the journal entries recorded for
the Japanese Subsidiary (Chart of Accounts = CAJP) in the second
half of 2015
5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
10/5/2018 Take Test: Data Analytics – AC470.002.FA18….
https://blackboard.bentley.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_2762_1&course_id=_300_1&content_id=_177713_1&step=null 4/5
QUESTION 14
Average value of journal entries where the document type is DR
(customer invoice) for the International Subsidiary (Chart of
Accounts = INT) in the second half of 2015
5 points Save Answer
QUESTION 15
Sum all of the activity where the posting key=50 (Credit entry) for
the US Subsidiary (Chart of Accounts = CAUS) in the �rst half of
2015
5 points Save Answer
QUESTION 16
Sum all of the activity where the posting key=91 for the
International Subsidiary (Chart of Accounts = INT) in the �rst half
of 2015
5 points Save Answer
QUESTION 17
Give a count of the transaction activity where the posting key=70
(Debit asset) for the Japanese Subsidiary (Chart of Accounts =
CAJP) in the �rst half of 2015
5 points Save Answer
QUESTION 18
What were total number of journal entries recorded for the US
Subsidiary (Chart of Accounts = CAUS) in the �rst half of 2016
5 points Save Answer
QUESTION 19
Sum all of the activity where the posting key=50 (Credit entry) for
the Japanese Subsidiary (Chart of Accounts = CAJP) in the second
half of 2015
5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
10/5/2018 Take Test: Data Analytics – AC470.002.FA18….
https://blackboard.bentley.edu/webapps/assessment/take/launch.jsp?course_assessment_id=_2762_1&course_id=_300_1&content_id=_177713_1&step=null 5/5
half of 2015
QUESTION 20
Sum all of the activity where the posting key=93 for the
International Subsidiary (Chart of Accounts = INT) in the �rst half
of 2015
5 points Save Answer
Question Completion Status:
Click Save and Submit to save and submit. Click Save All Answers to save all answers.