Excel Assignment Computer Focused Principles

Module 02 Content
It is your second week on a new job as a bookkeeper at Mags and Bags, a small boutique store. While you’re enjoying the challenge, you’ve found a few things that don’t add up after completing some of the transactions in the store’s computerized accounting system. Store owner Margaret Posley has given you a trial balance from the end of last month. She says that her CPA told her to use it to compare to her account balances for accuracy. The bookkeeping and recordkeeping functions have not been Margaret’s favorite task as an owner, as she doesn’t understand the information. It has caused accuracy to suffer.
Instructions:
Begin with the template provided here:

Error Correction Template

Complete a brief analysis of what the current account balances are, and what they are should be according to Margaret’s CPA. Show your calculations in the gray area in column G.After your analysis, address the following questions in the Error Correction Template:
Identify which accounts are in error, and how they are related to each other.
Discuss the likely causes of the errors (omission, duplication, incorrect transaction date, etc.).
Looking forward, what tools will you use and actions will you take to ensure these errors don’t continue to be an issue in the company records?
Draft a brief response to Margaret sharing your findings and plan for how you will correct the errors in the computerized accounting software. Be specific in your findings and recommendations for correction. Include suggestions for how these types of errors can be avoided in the future.
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel workbook. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504
Module 02 Written Assignment – Error Correction
Rubric Details
Maximum Score
50 points
Error Analysis (5 Total Pts)
10% of total grade
Mastery – Advanced or exceeds demonstration of criteria.
All account balances differences calculated accurately.
5
Proficiency – Clear or effective demonstration of criteria.
Minor errors in account balance difference calculations.
4
Competence – Adequate or basic demonstration of criteria.
Significant errors in account balance difference calculations.
3
Emerging – Limited or developing demonstration of criteria.
Not submitted; or so erroneous as to suggest learning of the material has not been achieved.
1
Account Identification (5 Total Pts)
10% of total grade
Mastery – Advanced or exceeds demonstration of criteria.
All accounts in error identified accurately.
5
Proficiency – Clear or effective demonstration of criteria.
Minor errors or omissions in error account identification.
4
Competence – Adequate or basic demonstration of criteria.
Significant errors or omissions in error account identification.
3
Emerging – Limited or developing demonstration of criteria.
Not submitted; or so erroneous as to suggest learning of the material has not been achieved.
1
Causes of Errors (10 Total Pts)
20% of total grade
Mastery – Advanced or exceeds demonstration of criteria.
Thorough and accurate description of the likely causes of the errors presented.
10
Proficiency – Clear or effective demonstration of criteria.
Minor errors or omissions in the description of the likely causes of the errors presented.
8
Competence – Adequate or basic demonstration of criteria.
Significant errors or omissions in the description of the likely causes of the errors presented.
7
Emerging – Limited or developing demonstration of criteria.
Not submitted; or so erroneous as to suggest learning of the material has not been achieved.
1
Preventive Tools and Actions (10 Total Pts)
20% of total grade
Mastery – Advanced or exceeds demonstration of criteria.
Thorough and accurate description of the preventive tools and actions needed to ensure future accuracy presented.
10
Proficiency – Clear or effective demonstration of criteria.
Minor errors or omissions in the description of the preventive tools and actions needed to ensure future accuracy presented.
8
Competence – Adequate or basic demonstration of criteria.
Significant errors or omissions in the description of the preventive tools and actions needed to ensure future accuracy presented.
7
Emerging – Limited or developing demonstration of criteria.
Not submitted; or so erroneous as to suggest learning of the material has not been achieved.
1
Response to Owner (10 Total Pts)
20% of total grade
Mastery – Advanced or exceeds demonstration of criteria.
Exemplary response to owner including error findings, and recommendation for corrective measures.
10
Proficiency – Clear or effective demonstration of criteria.
Accurate response to owner including error findings, and recommendation for corrective measures.
8
Competence – Adequate or basic demonstration of criteria.
Reasonable response to owner including error findings, and recommendation for corrective measures.
7
Emerging – Limited or developing demonstration of criteria.
Not submitted; or so erroneous as to suggest learning of the material has not been achieved.
1
TS-Critical Thinking (10 Total Pts)
20% of total grade
Mastery – Advanced or exceeds demonstration of criteria.
Thorough investigation and explanation of errors present, including suggestions for error correction and prevention.
10
Proficiency – Clear or effective demonstration of criteria.
Satisfactory investigation and explanation of errors present including suggestions for error correction and prevention.
8
Competence – Adequate or basic demonstration of criteria.
Moderate investigation and explanation of errors present including suggestions for error correction and prevention.
7
Emerging – Limited or developing demonstration of criteria.
Not submitted; or minimal investigation and/or explanation of errors present. May or may not include suggestions for error correction and prevention.
1

Last Completed Projects