accounting information system

User Generated

obmnvqn

Business Finance

Description

hello i have accounting info system assignment please follow the steps to complete the requirement and also follow the policies

i posted to word files one of them for the assignment and other one for policies for the assignment

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 ASSIGNMENT PREP/SUB REQUIREMENTS ACC 351: Accounting Information Systems Instructor: Dr. M. Walters This document provides instructions/requirements for preparing/submitting course assignments. Review this document carefully before attempting course assignments. Failure to prepare assignments in accordance with stipulated requirements will result in point penalties. ACCESSING COURSE ASSIGNMENTS All required assignments will be posted to Blackboard under the “Assignments” button. To access a particular assignment, 1. Access. Access Blackboard (http://ut.blackboard.com) and log in (using your user ID and password), click on the course link, then click the “Assignments” button. 2. Open. Click the link for the appropriate assignment folder (if necessary), then click the file link for the assignment you wish to view. The file link will allow you to open/download the assignment file. Note: PDF files will open automatically. MS Word files will download then ask you if you would like to “open” the file. I recommend you open then save the assignment file to your computer so that you may refer to it while working on the assignment. PREPARING COURSE ASSIGNMENTS All required assignments must be prepared according to the following requirements. 1. Assignment Responses. Read assignment requirements carefully to ensure responses are complete, relevant, and demonstrate logical application of course concepts. Assignment submissions must include ONLY appropriately labeled responses to stated requirements. Do NOT submit the original assignment instructions/requirements with your responses. 2. Assignment Formatting. Assignment submissions must follow stipulated formatting, writing, and referencing requirements. a. File Format. Assignment files must be prepared as a single MS Word file (unless otherwise instructed). Alternative document formats and/or multiple file submissions will NOT be accepted (unless otherwise instructed). b. File Name. Assignment files must possess an abbreviated file name that includes both an abbreviated assignment designation and your/your team leader’s last name (e.g., “PA 1Walters”). c. Cover Page. All assignment submissions must include a cover page that includes the course designation (i.e., “ACC 351: Accounting Information Systems”), the assignment designation (e.g., “PA 1”), your/each team member’s name (team leader’s name listed first on team assignments), the current term (fall/spring year), and the times/days the class section meets. d. Formatting. Assignment submissions must be properly formatted with one-inch margins,1 left justification,2 Times New Roman 12-point font,3 single-spacing,4 section headings (as appropriate), and proper pagination (with page numbers placed in the lower right-hand corner of each page).5 MS Word formatting defaults are NOT necessarily consistent with these requirements; you will need to change default formatting (see footnotes). The MS Word default margins may be changed via the “Layout” tab under “Margins”. Left justification is the MS Word default; justification may be changed via the “Home” tab under “Paragraph”. 3 The MS Word default font may be changed via the “Home” tab under “Font”. 4 The MS Word default line spacing may be changed via the “Home” tab under “Paragraph”; be sure to select 0 pt before/after (not Auto or 6, 8, or 10 pt before/after) and “single spacing” (not 1.5, double or multiple spacing) 5 Page numbers may be added and placed via the “Insert” tab under “Header & Footer”. 1 2 Walters Assign Prep/Sub Req 1 e. Organization. Assignment responses must be organized, numbered, and labeled consistent with assignment requirements. If table templates are provided, table templates must be used to organize responses to requirements. f. Length. Assignment submissions must not exceed stipulated page lengths (including written responses, supporting content, and references but excluding the cover page). g. Writing Mechanics. Assignment responses requiring a text response (as opposed to a diagram, spreadsheet, or table response) must be well written in prose form,6 communicate points clearly, flow logically, use appropriate language/word choice, and follow proper English spelling, grammar, and punctuation. Proofread and revise all work carefully before submitting. h. Supporting Content. Assignment submissions may contain supporting diagrams, tables, or other illustrations. Supporting content must be clear, relevant, professional, and visually appealing. All supporting content must be integrated into MS Word to allow assignment submission as a single MS Word file (unless otherwise instructed). Diagrams must be constructed using MS Visio and copied into a MS Word file. i. Citation/Referencing. Assignment submissions must include proper in-text citations and endof-text references. You must cite/reference ALL print and non-print sources that you rely on in constructing responses to assignment requirements; this includes (but is not necessarily limited to) class materials (e.g., lectures, notes, texts) and outside sources (e.g., online resources) used to complete course assignments. Failure to provide proper citation/reference information constitutes plagiarism even if you paraphrase. See the “Citation/Referencing Requirements” document (posted on Blackboard) for guidance. 3. Assignment Questions. If you have questions on an assignment, you may email me or see me during scheduled office hours. Please be prepared to ask specific questions. Note that, if the assignment on which you seek help is a graded assignment (as opposed to a participation or practice exercise), I will respond to specific concept or requirement clarification queries only. I will NOT help you complete the assignment requirements nor will I "pre-grade" the assignment prior to formal submission for credit. Please do NOT forward assignments to me and request comments/corrections prior to the submission deadline. SUBMITTING COURSE ASSIGNMENTS Assignment files must be submitted according to the following requirements. 1. Submission Deadlines. Assignment files must be submitted to Blackboard BEFORE 10:00 AM on the assignment due date indicated on the syllabus assignment schedule (or otherwise announced in class). Late assignments will NOT be accepted resulting in zero credit. 2. Submission File Format. Assignment files must be submitted as a single MS Word file (unless otherwise instructed). Alternative document formats and/or multiple file submissions will NOT be accepted (unless otherwise instructed). 3. Team Submissions. Teams must submit a single assignment file for team-based assignments. The team leader (or duly designated member of the team) must submit team-based assignment files. Assignments submitted as multiple files by different team members will NOT be accepted. 6 Prose form refers to ordinary written language consisting of complete sentences, proper grammar, paragraph structure, appropriate punctuation, and logical flow of ideas as commonly used in essays, letters, memos, stories, and novels. Prose is distinguished from poetry or verse (which is characterized by rhyme, meter, and verse structure) and bulleted/numbered/outlined lists (which are characterized by a series of disconnected ideas often presented as sparsely worded descriptions or incomplete sentences). Note Re Bullet Points: Bulleted/numbered points may be used to emphasize key details/points, but should not be used excessively. Walters Assign Prep/Sub Req 2 4. Submit. Assignment files must be submitted to Blackboard via the correct assignment link. Emailed or hardcopy assignments will NOT be accepted. To submit an assignment to Blackboard: a. Access. Access Blackboard (http://ut.blackboard.com) and log in (using your user ID and password), click on the course link, then click the “Assignments” button. b. Open. Click the link for the appropriate assignment folder (if necessary), then click the assignment link (NOT the file link) for the assignment you wish to submit. c. Attach. Scroll down to the area labeled “Attach Files” and click “Browse My Computer”. This will bring up the file manager showing the list of files on your computer. Find the finalized assignment document, select, and then click “open” (or “choose”). IF you have been instructed to submit more than one file, you must attach additional file(s) BEFORE you click “submit” (as Blackboard will not allow you to submit additional files once you have clicked “submit”). d. Verify. Carefully verify that you are submitting the correct version of the assignment BEFORE you attempt to submit.7 Check to ensure the correct file name(s) appear in the “Attached Files” box. e. Submit. Once you have verified attached file(s), click “Submit”. You must click “Submit” NOT “Save Draft” to submit your assignment. f. Confirm. If the assignment was successfully submitted, you will receive a confirmation message. Assignments will show up as “!” in the Blackboard grade book until a score has been posted. 7Important Note: I will grade only what you submit to Blackboard via the appropriate assignment link. I will NOT search for assignments on the team file exchange. I will NOT “clear” assignments so you can resubmit even if you inadvertently submit the wrong file or neglect to attach the file. I will NOT accept resubmissions of assignments (or parts of assignments) if you inadvertently submit incorrect, incomplete, or incompatible files. As such, it is very important that you carefully verify assignment submissions BEFORE you click “submit”. Walters Assign Prep/Sub Req 3
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

SUPPLEMENTAL PREP: SPREADSHEET CONTROL (EXCEL)
ACC 351: Accounting Information Systems
Instructor: Dr. M. Walters

Walters ACC 351 Supp Prep Assignment 1

Briefly respond to the following:
1. Spreadsheet Security. Review MS Excel/spreadsheet protection controls.
a. General Controls.
Password Protection- Putting passwords on spreadsheets ensures that they are protected from
access by unauthorized users. The password should only be shared by authorized users. The passwords
will help to ensure that one does not accidentally delete or change any information since the worksheet
is locked (Blaustein, 2009).
Backup- ensuring that the spreadsheets are backed up will guarantee their availability when
needed. When the spreadsheets are backed up, you can easily retrieve them if there is something you
need to correct or you need to reference or restart previously used information.
b. Microsoft (MS) Excel Atomic Learning Tutorials (Auto Protection Controls).
How to protect the whole spreadsheet. - Protecting the whole spreadsheet is necessary especially
when working with sensitive information. This you can do through setting a default setting on the
spreadsheet to lock the entire spreadsheet (Excel 2016 Training, n.d.).
How to overcome shortcomings of a default...


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags