Expert answer:Supplemental Prep Assignment

Solved by verified expert:I attached all the requirements.
sp_5.png

sp_5__ss_ctrl__ex_al_.doc

Unformatted Attachment Preview

SUPPLEMENTAL PREP: SPREADSHEET CONTROL (EXCEL)
ACC 351: Accounting Information Systems
Instructor: Dr. M. Walters
Supplemental Prep Assignment. This assignment requires students to complete training/research for
a selected course topic. Required Submission: Each student will be required to submit a write-up of
work completed. Write-ups must be properly prepared, formatted, and submitted in accordance with
instructions in the “Assignment Policies” documents posted on Blackboard. Write-ups must be
submitted to Blackboard before 10:00 AM on the submission deadline date indicated on the course
syllabus. Late, emailed, or hardcopy write-ups will NOT be accepted.
REQUIREMENTS
Synthesize an understanding of spreadsheet controls. MS Excel is available in selected computer labs
(see Blackboard). The following resources have been posted to Blackboard or are available online.
•
•
•
•
•
Blaustein, R. (2009, January 1). Eliminating Spreadsheet risks. IIA Online. Retrieved from
https://iaonline.theiia.org/eliminating-spreadsheet-risks.
European Spreadsheet Risks Interest Group (EuSpRig) (n.d.). Best Practice. EuSpRig. Retrieved
from http://www.eusprig.org/index.htm.
Excel 2016 Training (n.d.). Atomic Learning. Available from https://www.atomiclearning.com.
Metz, L. R. (2007). Five Common Spreadsheet Risks and Ways to Control Them. IIA Online.
Retrieved from https://iaonline.theiia.org/five-common-spreadsheet-risks-and-ways-to-controlthem.
Panko, R R. (2006). Recommended Practices for Spreadsheet Testing. Proceedings of EuSpRIG
2006 Conference, Cambridge, UK: European Spreadsheet Risks Interest Group (EuSpRIG).
Note: Atomic Learning may be accessed via Blackboard (under the “Student Tools” button) or via the
website (http://www.atomiclearning.com/login/ut/, log on using Spartans Domain user ID and
password). Search for tutorials using the search box (search for “Excel 2016”) or drop-down menus.
Briefly respond to the following:
1. Spreadsheet Security. Review MS Excel/spreadsheet protection controls.
a. General Controls. Identify two general controls that may be used to protect spreadsheets.
Explain how the identified controls ensure spreadsheet security. Hint: Search for “spreadsheet
control best practices” or “spreadsheet security”.
b. Microsoft (MS) Excel Atomic Learning Tutorials (Auto Protection Controls). Complete the
Excel 2016: Protecting your Spreadsheets tutorials: A. Protecting Your Spreadsheet (required)
module tutorials. List the modules completed and provide a brief synopsis what you learned
within each module (Note: You do not have to provide a synopsis of each individual tutorial
video within each module).
c. Why do you think most spreadsheets exclude such controls? Discuss
2. Spreadsheet Integrity. Review MS Excel/spreadsheet integrity controls.
a. Application Controls. Identify two application controls used to ensure spreadsheet integrity.
Explain how the identified controls ensure spreadsheet data integrity. Hint: Search for
“spreadsheet integrity controls”.
b. MS Excel Atomic Learning Tutorials (Auto Validation Controls). Complete the Excel 2016:
Evaluating Data tutorials: B. Data Validation (required) module tutorials. List the modules
Walters ACC 351 Supp Prep Assignment 1
completed and provide a synopsis what you learned within each module (Note: You do not
have to provide a synopsis of each individual tutorial video within each module).
c. Why do you think most spreadsheets exclude such controls? Discuss.
3. Spreadsheet Testing. Review MS Excel/spreadsheet testing procedures.
a. Testing Procedures. Identify and explain two testing procedures that may be used to assess
spreadsheet integrity. Explain how the identified controls ensure spreadsheet data
integrity/security. Hint: Search for “spreadsheet testing” or “spreadsheet testing tools”.
b. MS Excel Atomic Learning Tutorials (Auto Testing Tools). Review automated testing
functions such those integrated into MS Excel by completing Atomic Learning tutorials.
Complete the Excel 2016: Frequently Used Formulas & Functions Training tutorials: D.
Auditing and Error Checking (required) module tutorials. List the modules completed and
provide a brief synopsis what you learned within each module (Note: You do not have to
provide a synopsis of each individual tutorial video within each module).
c. Why do you think most users fail to test their spreadsheets? Discuss.
4. Spreadsheet Compliance. Explain why spreadsheet control represents a significant SarbanesOxley compliance concern for organizations. Hint: Search for “spreadsheets and compliance” or
“spreadsheets and Sarbanes Oxley.”
Walters ACC 351 Supp Prep Assignment 2
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades