Microcomputer Applications for Accountants

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 1 of 19
(Prerequisite: ACC 100)
COURSE DESCRIPTION
This course covers the use of Peachtree Complete Accounting for Windows, Microsoft Excel, and the
interface between the two software packages, as well as the functions and applications available under
Peachtree and Excel.
INSTRUCTIONAL MATERIALS
Required Resources
O’Leary, T. J., & O’Leary, L. (2011). Microcomputer applications for accounting: Excel 2010 custom
edition
(1st ed.). Boston, MA: McGraw-Hill.
Estes, J., & Savich, R. S. (2011). A Comparison of Financial Analysis Software for Use in Financial
Planning for Small Businesses.
Journal of Financial Service Professionals, 65(2), 48-55.
Excel (Version 2010) {Computer software}.Redmond, Washington: Microsoft.
Excel data files to complete Excel homework – Student will need to download the Excel student data files
as indicated by the professor from the textbook Website.
Moorthy, M. K, Ong O. V., Samsuri, C. A. S. B., Gopalan, M., & King-Tak, Y. (2012) Application of
Information Technology in Management Accounting Decision Making.
International Journal of
Academic Research in Business & Social Sciences, 2
(3), 1-16.
Peachtree Complete Accounting 2012 – included with the Peachtree textbook.
Yacht, C. (2013).
Computer accounting with peachtree by sage complete accounting 2012 (16th ed.).
Boston, MA: McGraw-Hill
Supplemental Resources
Convery, S. P., & Swaney, A. M. (2012). a y e e With Excel: The Case of Superior
Log Cabins, Inc.
Issues in Accounting Education, 27(1), 141-156.
Jelen, B. (2012). VLOOKUP Variations.
Strategic Finance, 93(11), 60-61.
Lenning, J. (2011). Pivotal Advance Boosts Excel’s Power.
Journal of Accountancy, 212(3), 40-44.
Mason Jr., J. O. (2011). A Couple of Capital Budgeting Techniques using Microsoft Excel.
Advances in
Management 4
(4), 23-27.
COURSE LEARNING OUTCOMES
1. Create and update spreadsheets with Microsoft Excel.
2. Discuss how automated accounting software can help management make better informed
business decisions.
3. Use advanced features of Microsoft Excel to solve business problems.
4. Organize information between Word and Excel to communicate to internal and external users.
5. Create and maintain accounting records with Peachtree.

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 2 of 19
6. Generate financial reports for most small- to medium-sized businesses with Peachtree.
7. Organize information between Peachtree and Excel to communicate to internal and external
users.
8. Convert a manual-based accounting system to Peachtree.
9. Complete quarter-end / end-of-year accounting activities in Peachtree.
10. Use technology and information resources to research issues in microcomputer applications for
accountants.
11. Write clearly and concisely about microcomputer applications for accountants using proper writing
mechanics.
WEEKLY COURSE SCHEDULE
The standard requirement for a 4.5 credit hour course is for students to spend 13.5 hours in weekly work.
This includes preparation, activities, and evaluation regardless of delivery mode.

Week Preparation, Activities, and Evaluation Points
1 Preparation
Read ( ) from O’Leary
o Chapter 1: Introduction to Microsoft Office 2010
o Lab 1: Creating and editing a Worksheet
Lab from O’Leary
o Lab 1: Lab Exercises / Step-by-By #1 through #3
Additional Readings
o Estes, J., & Savich, R. S. (2011). A Comparison of Financial
Analysis Software for Use in Financial Planning for Small
Businesses.
Journal of Financial Service
Professionals, 65
(2), 48-55.
MS Excel Tutorial
o Review the tutorials from Microsoft on Getting Started with
Excel 2010, located at
http://office.microsoft.com/en-us/excel
help/getting-started-with-excel-2010-HA010370218.aspx
.
Additional Requirements
o Download Excel student data files, located at
http://highered.mcgraw
hill.com/sites/0073519308/student_view0/excel/student
_data_files.html
. These files are needed in order to complete
your homework and optional exercises.
Activities
Discussions
Evaluation
Homework from O’Leary
o Lab 1: Lab Exercises / Step-by-Step #4 – Comparative
Median Income
o Lab 1: Lab Exercises / Step-by-Step #5 – Pecan Grove
o Lab 1: Lab Exercises / On Your Own #2 – Personal Budget
o Lab 1: Lab Exercises / On Your Own #5 – Home Electronics
20
10
10
10
10

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 3 of 19

2 Preparation
Read ( ) from O’Leary
o Lab 2: Enhancing the Worksheet with Graphs and Charts
o Lab 3: Managing and Analyzing a Workbook
Lab from O’Leary
o Lab 2: Lab Exercises / Step-by-By #1 through #4
o Lab 3: Lab Exercises / Step-by-By #1 through #4
Additional Readings
o Moorthy, M. K., Ong O. V., Samsuri, C. A. S. B., Gopalan, M.,
& King-Tak, Y. (2012) Application of Information Technology
in Management Accounting Decision Making.
International
Journal of Academic Research in Business & Social
Sciences, 2
(3), 1-16.
MS Excel Tutorial
o Review the tutorials from Microsoft on Using Tiny Charts with
Excel 2010, located at
http://office.microsoft.com/en-us/excel
help/sparklines-use-tiny-charts-to-show-data-trends
RZ102184477.aspx
.
Activities
Discussions
Evaluation
Homework from O’Leary
o Lab 2: Lab Exercises / Step-by-Step #5 – Internet Experience
o Lab 2: Lab Exercises / On Your Own #5 – Insurance
Comparison
o Lab 3: Lab Exercises / Step-by-Step #5 – Year-to-Date Sales
o Lab 3: Lab Exercises / On Your Own #5 – Start Your Own
Business
Q 1: O’Leary, Lab 1 thro h 3
20
10
10
10
10
120
3 Preparation
Read ( ) from O’Leary
o Working Together I: Linking and Embedding between Word
2010 and Excel 2010
o Lab 4: Using Solver, Creating Templates, and Evaluating
Scenarios
Comp ete the fo ow recomme ded exerc e from O’Leary
o Lab 4: Lab Exercises / Step-by-By #1 through #3
MS Excel Tutorial
o Review the tutorial from Microsoft on conditional formatting,
located at
http://office.microsoft.com/en-us/excel
help/understand-data-at-a-glance-with-conditional-formatting
RZ102060984.aspx
.
Activities
Discussions
20

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 4 of 19

Evaluation
Homework from O’Leary
o Lab WT1: Lab Exercises / Step-by-Step #2 – Student
Retention
o Lab 4: Lab Exercises / Step-by-Step #4 – Cards & Gifts
o Lab 4: Lab Exercises / Step-by-Step #5 – Animal Rescue
o Lab 4: Lab Exercises / On Your Own #3 – Small Business
Expansions
10
10
10
10
4 Preparation
Read ( ) from O’Leary
o Lab 5: Using Data Tables, Using Lookup & IF Functions, and
Designing Forms
o Lab 6: Creating and Working with Tables
Complete the fo ow recomme ded exerc e from O’Leary
o Lab 5: Lab Exercises / Step-by-By #1 through #4
o Lab 6: Lab Exercises / Step-by-By #1 through #4
MS Excel Tutorial
o Review the tutorial from Microsoft on the IF function, located
at
http://office.microsoft.com/en-us/excel-help/the-if-function
what-it-is-and-how-to-use-it-RZ102425926.aspx
.
o Review the tutorial from Microsoft on the Excel tables,
located at
http://office.microsoft.com/en-us/excel-help/use
excel-tables-to-manage-information-RZ102252956.aspx
.
Activities
Discussions
Evaluation
Homework from O’Leary
o Lab 5: Lab Exercises / Step-by-Step #4 – Hayes Furniture
Sales
o Lab 5: Lab Exercises / On Your Own #5 – 3D TV
o Lab 6: Lab Exercises / Step-by-Step #4 – Animal Rescue
o Lab 6: Lab Exercises / On Your Own #5 – Changing Hands
Inventory
Quiz 2: O’Leary, Working Together 1 and labs 4 through 6
Assignment 1: Excel Project
20
10
10
10
10
120
150
5 Preparation
Reading(s) from Yacht
o Appendix B: Accounting Information Systems
o Chapter 1: Introduction to Bellwether Garden Supply
Complete the following recommended exercises from Yacht
o Chapter 1: End of Chapter True/Make True Questions
Test Your Knowledge
o Review the Multiple Choice and True/False questions for
Chapter 1, located at
http://highered.mcgraw

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 5 of 19

hill.com/sites/0078025354/student_view0/chapter1/.
Activities
Discussions
Evaluation
Homework from Yacht
o Chapter 1: Exercises 1-1 and 1-2
20
20
6 Preparation
Reading(s) from Yacht
o Chapter 2: Vendors
o Chapter 3: Customers
Complete the following recommended exercises from Yacht
o Chapter 2: End of Chapter Multiple Choice Questions
o Chapter 3: End of Chapter Multiple Choice Questions
Activities
Discussions
Evaluation
Homework from Yacht
o Chapter 2: Exercises 2-1 and 2-2
o Chapter 2: Assessment Rubric
o Chapter 3: Exercises 3-1 and 3-2
o Chapter 2: Assessment Rubric
20
20
20
7 Preparation
Reading(s) from Yacht
o Chapter 4: Employees
o Chapter 5: General Ledger, Inventory, and Internal Control
Complete the following recommended exercises from Yacht
o Chapter 4: End of Chapter Multiple Choice Questions
o Chapter 5: End of Chapter Multiple Choice Questions
Activities
Discussions
Evaluation
Homework from Yacht
o Chapter 4: Exercises 4-1 and 4-2
o Chapter 4: Assessment Rubric
o Chapter 5: Exercises 5-1 and 5-2
o Chapter 5: Assessment Rubric
Quiz 3: Yacht, Chapters 1 through 5
20
20
20
120
8 Preparation
Reading(s) from Yacht
o Chapter 6: Job Cost
o Chapter 7: Financial Statements
o Chapter 9: New Company Setup and Beginning Balances

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 6 of 19

Complete the following recommended exercises from Yacht
o Chapter 6: End of Chapter Multiple Choice Questions
o Chapter 7: End of Chapter True/MakeTrue Questions
o Chapter 9: End of Chapter Multiple Choice Questions
Activities
Discussions
Evaluation
Homework from Yacht
o Chapter 6: Exercises 6-1 and 6-2
o Chapter 6: Assessment Rubric
o Chapter 7. Exercises 7-1 and 7-2
o Chapter 9: Exercises 9-1 and 9-2
o Chapter 9: Assessment Rubric
20
20
10
20
9 Preparation
Reading(s) from Yacht
o Chapter 10: Maintaining Accounting Records for Service
Business
o Chapter 11: Completing Quarterly Activities & Closing the
Fiscal Year
o Chapter 12: Vendors & Purchases
Activities
Discussions
Evaluation
Homework from Yacht
o Chapter 10: Exercises 10-1 and 10-2
o Chapter 10: Assessment Rubric
o Chapter 11: Exercises 11-1 and 11-2
o Chapter 11: Assessment Rubric
o Chapter 12: Exercises 12-1 and 12-2
o Chapter 12: Assessment Rubric
Quiz 4: Yacht, Chapters 6, 7 9 and 10
Assignment 2: Accounting Analysis Project
20
20
20
20
120
100
10 Preparation
Reading(s) from Yacht
o Chapter 13: Customers & Sales
o Chapter 14: Inventory & Services
o Chapter 15: Employees, Payroll, and Account Reconciliation
Complete the following recommended exercises from Yacht
o Chapter 13: End of Chapter Multiple Choice Questions
o Chapter 14: End of Chapter Multiple Choice Questions
o Chapter 15: End of Chapter Multiple Choice Questions
Activities
Discussions
20

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 7 of 19

Evaluation
Homework from Yacht
o Chapter 13: Exercises 13-1 and 13-2
o Chapter 13: Assessment Rubric
o Chapter 14: Exercises 14-1 and 14-2
o Chapter 14: Assessment Rubric
o Chapter 15: Exercises 15-1 and 15-2
o Chapter 15: Assessment Rubric
Assignment 3: Peachtree Project
20
20
20
200
11 Preparation
Reading(s): None
Activities
Discussions
Evaluation
Quiz 5: Yacht, chapters 11 through 15
20
120

ACC 306 – Microcomputer Applications for Accountants
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 8 of 19
GRADING SCALE – UNDERGRADUATE

Assignment Total Points % of
Grade
Quizzes (open book with a 2-hour time limit per quiz)
(5 quizzes, 30 questions each, worth 4 points apiece)
600 35%
Homework (43 exercises worth 10 points apiece) 430 25%
Assignment 1: Excel Project 150 9%
Assignment 2: Accounting Analysis Project 100 6%
Assignment 3: Peachtree Project 200 12%
Participation (22 discussions worth 10 points apiece) 220 13%
Total 1,700 100%

 

Points Percentage Grade
1,530 – 1,700 90% – 100% A
1,360 – 1,529 80% – 89% B
1,190 – 1,359 70% – 79% C
1,020 – 1,189 60% – 69% D
Below 1,020 Below 60% F

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 9 of 19
Assignment 1: Excel Project
Due Week 4 and worth 150 points
Th a me t ba ed po O’Leary Lab 4: Stock Portfo o a y a d co t of two (2) part – an
Excel-based assignment and a paper.
You have been assigned to evaluate the stock market performance of firms who manufacture accounting
software products. Your evaluation will be based upon large- and-medium market firms. The firms are as
follows:

Large Market Stocks Oracle Software (Oracle Corp: NASDAQ)
SAP (SAP AG: NYSE)
Medium Market Stocks Microsoft Great Plains (Microsoft: NASDAQ)
Small Market Stocks QuickBooks (Intuit: NASDAQ)
Peachtree (Sage Grp: LSE)

Part 1: Excel Spreadsheet Assignment

Scenario 1 You have been given $1,000,000 to invest the five (5) stocks. You must invest the
$1,000,000 accordingly
No more than 35% of your investment will be in the Large Market stocks,
with a minimum of 15% investment in any given stock
No more than 30% of your investments will be in the Medium Market stock,
with a minimum of 15% investment in the stock
No more than 35% of your investment will be in the Small Market stocks ,
with a minimum of 15% investment in any given stock
The p rcha e date of the tock w be 6 mo th a o. Track yo r tock ’ da y
performance for the 90 trading days following the purchase date. During this time,
you will note the gains and losses each day. At the end of the 90 days’ tracking
period, calculate your net gain (or loss) for each stock and your total investment at
the end of the 90 days. Develop the appropriate charts that highlight your
performance. You will create a minimum of two charts.
Note: Your purchase must be in whole shares. For example, you cannot purchase
100.5 shares. You must purchase either 100 or 101 shares. For this reason, you
may not total to exactly $1,000,000, but you will come close.
Scenario 2 You are now skeptical of the Medium Market stock. With that, you will now invest
your $1,000,000 accordingly
No more than 50% of your investment will be in the Large Market Stocks,
with a minimum of 20% investment in any given stock
No more than 50% of your investment will be in the Small Market Stocks,
with a minimum of 20% investment in any given stock
The purchase date of the stock will be six (6) mo th a o. Track yo r tock ’ da y
performance for the 90 trading days following the purchase date. During this time,
you will note the gains and losses each day. At the end of the 90 days’ tracking
period, calculate your net gain (or loss) for each stock and your total investment at

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 10 of 19

the end of the 90 days. Develop the appropriate charts that highlight your
performance. You will create a minimum of two (2) charts.
Note: Your purchase must be in whole shares. For example, you cannot purchase
100.5 shares. You must purchase either 100 or 101 shares. For this reason, you
may not total to exactly $1,000,000, but you will come close.
Scenario 3 You are now skeptical of the Large Market stock. With that, you will now invest your
$1,000,000 accordingly
No more than 50% of your investment will be in the Medium Market stock,
with a minimum 20% investment here
No more than 50% of your investment will be in the Small Market Stocks,
with a minimum 20% investment here
The purchase date of the stock will be six (6) mo th a o. Track yo r tock ’ da y
performance for the 90 trading days following the purchase date. During this time,
you will note the gains and losses each day. At the end of the 90 days’ tracking
period, calculate your net gain (or loss) for each stock and your total investment at
the end of the 90 days. Develop the appropriate charts that highlight your
performance. You will create a minimum of two (2) charts.
Note: Your purchase must be in whole shares. For example, you cannot purchase
100.5 shares. You must purchase either 100 or 101 shares. For this reason, you
may not total to exactly $1,000,000, but you will come close.
Scenario 4 You are now a believer of only the Medium Market stock. With that, you will now
invest your $1,000,000 into that stock.
The purchase date of the stock will be six (6) mo th a o. Track yo r tock ’ da y
performance for the 90 trading days following the purchase date. During this time,
you will note the gains and losses each day. At the end of the 90 days’ tracking
period, calculate your net gain (or loss) for the stock and your total investment at the
end of the 90 days. Develop the appropriate charts that highlight your performance.
You will create a minimum of two (2) charts.
Note: Your purchase must be in whole shares. For example, you cannot purchase
100.5 shares. You must purchase either 100 or 101 shares. For this reason, you
may not total to exactly $1,000,000, but you will come close.
Note Do not worry about any commission fees or miscellaneous charges.
Assignment Determine how much money you earned or lost with each stock on a daily basis.
Instructions
on how to
complete
There is no sample Excel workbook to use as part of the project, therefore you will
create your own workbook. In creating your workbook, be sure to include the
following data (however, other data will be stored in your scenario) in a columnar
format.
Stock name
Stock symbol
Number of shares purchased / acquired
Stock price
Date of stock transaction

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 11 of 19

Start your scenario using the opening day price for each stock as your purchase
price and use the closing stock price to calculate how much money you earned or
lost each day.
At the end of your scenario, calculate the following for each stock in question.
The highest stock price for the period
The lowest stock price for the period
The average stock price for the period
The largest amount of profit (loss) earned for the period
The lowest amount of profit (loss) earned for the period
Track the stock for 90 consecutive days that the market is open.
Submit One Excel workbook that contains each of the four (4) scenarios. You will need to
use the appropriate Excel formulas and functions which will show the instructor how
you derived your results.

Part II: Paper
Write a three to four (3-4) page paper that summarizes your findings from the four (4) scenarios as well as
how using Microsoft Excel helped you with this process. Use the following outline:
2. Summarize the various accounting systems that each firm provides. Be sure to address the
following for each firm:
a. The various types of accounting systems it sells (e.g., Oracle sells Oracle Financials as
well as PeopleSoft financials)
b. The industries that it markets itself to (e.g., most firms sell their products to banking firms,
construction firms)
c. Explain how Wall Street views the firm. Is it positive? Negative? Why?
3. Analyze the results from the four (4) scenarios to determine how creditable your sources were
and how your selection of sources may have been improved.
4. Develop one (1) additional scenario that would have exceeded the results from your best
scenario.
5. Determine how your findings could be used to better drive management decisions.
Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all
sides; citations and references must follow APA or school-specific format. Check with your
professor for any additional instructions.
Include a cover page containing the title of the a me t, the t de t’ ame, the profe or’

name, the course title, and the date. The cover page and the reference page are not included in
the required assignment page length.
The specific course learning outcomes associated with this assignment are:

Discuss how automated accounting software can help management make better informed
business decisions.
Organize information between Word and Excel to communicate to internal and external users.

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 12 of 19

Use technology and information resources to research issues in microcomputer applications for
accountants.
Write clearly and concisely about microcomputer applications for accountants using proper writing
mechanics.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and
language and writing skills, using the following rubric.

Points: 150 Assignment 1: Excel Project
Criteria Unacceptable
Below 60% F
Meets
Minimum
Expectations
60-69% D
Fair
70-79% C
Proficient
80-89% B
Exemplary
90-100% A
1. Create one (1) Excel
workbook that contains
each of the four (4)
scenarios and also
shows how you derived
your results.
Weight: 30%
Did not submit or
incompletely
created one (1)
Excel workbook
that contains
each of the four
(4) scenarios and
did not submit or
incompletely
showed how you
derived your
results.
Insufficiently
created one (1)
Excel
workbook that
contains each
of the four (4)
scenarios and
insufficiently
showed how
you derived
your results.
Partially
created one (1)
Excel workbook
that contains
each of the four
(4) scenarios
and partially
showed how
you derived
your results.
Satisfactorily
created one
(1) Excel
workbook that
contains each
of the four (4)
scenarios and
satisfactorily
showed how
you derived
your results.
Thoroughly
created one (1)
Excel
workbook that
contains each
of the four (4)
scenarios and
thoroughly
showed how
you derived
your results.
2. Summarize the
various accounting
systems that each firm
provides.
Weight: 15%
Did not submit or
incompletely
summarized the
various
accounting
systems that
each firm
provides.
Insufficiently
summarized
the various
accounting
systems that
each firm
provides.
Partially
summarized the
various
accounting
systems that
each firm
provides.
Satisfactorily
summarized
the various
accounting
systems that
each firm
provides.
Thoroughly
summarized
the various
accounting
systems that
each firm
provides.
3. Analyze the results
from the four (4)
scenarios to determine
how creditable your
sources were and how
your selection of
sources may have
been improved.
Weight: 15%
Did not submit or
incompletely
analyzed the
results from the
four (4) scenarios
to determine how
creditable your
sources were and
how your
selection of
sources may
have been
improved.
Insufficiently
analyzed the
results from the
four (4)
scenarios to
determine how
creditable your
sources were
and how your
selection of
sources may
have been
improved.
Partially
analyzed the
results from the
four (4)
scenarios to
determine how
creditable your
sources were
and how your
selection of
sources may
have been
improved.
Satisfactorily
analyzed the
results from
the four (4)
scenarios to
determine how
creditable your
sources were
and how your
selection of
sources may
have been
improved.
Thoroughly
analyzed the
results from
the four (4)
scenarios to
determine how
creditable your
sources were
and how your
selection of
sources may
have been
improved.
4. Develop one (1)
additional scenario that
would have exceeded
the results from your
best scenario.
Weight: 15%
Did not submit or
incompletely
developed one
(1) additional
scenario that
would have
exceeded the
results from your
best scenario.
Insufficiently
developed one
(1) additional
scenario that
would have
exceeded the
results from
your best
scenario.
Partially
developed one
(1) additional
scenario that
would have
exceeded the
results from
your best
scenario.
Satisfactorily
developed one
(1) additional
scenario that
would have
exceeded the
results from
your best
scenario.
Thoroughly
developed one
(1) additional
scenario that
would have
exceeded the
results from
your best
scenario.
5. Determine how your Did not submit or Insufficiently Partially Satisfactorily Thoroughly

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 13 of 19

findings could be used
to better drive
management
decisions.
Weight: 15%
incompletely
determined how
your findings
could be used to
better drive
management
decisions.
determined
how your
findings could
be used to
better drive
management
decisions.
determined how
your findings
could be used
to better drive
management
decisions.
determined
how your
findings could
be used to
better drive
management
decisions.
determined
how your
findings could
be used to
better drive
management
decisions.
6. Clarity, writing
mechanics, and
formatting
requirements
Weight: 10%
More than 8
errors present
7-8 errors
present
5-6 errors
present
3-4 errors
present
0-2 errors
present

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 14 of 19
Assignment 2: Accounting Analysis Project
Due Week 9 and worth 100 points
The Accounting Analysis Project is due at the end of Week 8. The project is based upon you completing
the Bellwether Garden Supply (BGS) which is located at the end of Chapter 7. This project will require to
you to analyze the following:



Transactions posted by you and others
Reports that have been or can be produced
The controls that exists within the firm as well as any lacking internal controls

After your analysis, submit two (2) documents. The first one will include the answers to the fifteen (15)
questions regarding the Bellwether Garden Supply scenario. The second document will consist of a three
to five (3-5) page paper in which you:
2. Analyze the financial condition of Bellwhether Garden Supply.
3. Submit a copy of the f rm’ key f a c a tateme t a d reports (balance sheet, income
statement, statement of retained earnings, statement of changes in financial position, and
customer ledger) in one (1) Excel document.
4. Make recommendations for how management should address major business decisions or
directions for the company in the next one to two (1-2) years.
Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all
sides; citations and references must follow APA or school-specific format. Check with your
professor for any additional instructions.
c de a cover pa e co ta the t t e of the a me t, the t de t’ ame, the profe or’

name, the course title, and the date. The cover page and the reference page are not included in
the required assignment page length.
The specific course learning outcomes associated with this assignment are:



Create and maintain accounting records with Peachtree.
Generate financial reports for most small- to medium-sized businesses with Peachtree
Organize information between Peachtree and Excel to communicate to internal and external
users
Use technology and information resources to research issues in microcomputer applications for
accountants.
Write clearly and concisely about microcomputer applications for accountants using proper writing
mechanics.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and
language and writing skills, using the following rubric.

Points: 100 Assignment 2: Accounting Analysis Project
Criteria Unacceptable
Below 60% F
Meets
Minimum
Expectations
60-69% D
Fair
70-79% C
Proficient
80-89% B
Exemplary
90-100% A

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 15 of 19

1. Complete one
(1) Excel
workbook that
contains each
answer to the
fifteen (15)
questions
regarding the
Bellwether
Garden Supply
scenario.
Weight: 15%
Did not submit or
incompletely
completed one
(1) Excel
workbook that
contains each
answer to the
fifteen (15)
questions
regarding the
Bellwether
Garden Supply
scenario.
Insufficiently
completed one
(1) Excel
workbook that
contains each
answer to the
fifteen (15)
questions
regarding the
Bellwether
Garden Supply
scenario.
Partially
completed one
(1) Excel
workbook that
contains each
answer to the
fifteen (15)
questions
regarding the
Bellwether
Garden Supply
scenario.
Satisfactorily
completed one
(1) Excel
workbook that
contains each
answer to the
fifteen (15)
questions
regarding the
Bellwether
Garden Supply
scenario.
Thoroughly
completed one
(1) Excel
workbook that
contains each
answer to the
fifteen (15)
questions
regarding the
Bellwether
Garden Supply
scenario.
2. Analyze the
financial
condition of
Bellwhether
Garden Supply.
Weight: 30%
Did not submit or
incompletely
analyzed the
financial
condition of
Bellwhether
Garden Supply.
Insufficiently
analyzed the
financial
condition of
Bellwhether
Garden Supply.
Partially
analyzed the
financial
condition of
Bellwhether
Garden Supply.
Satisfactorily
analyzed the
financial
condition of
Bellwhether
Garden Supply.
Thoroughly
analyzed the
financial
condition of
Bellwhether
Garden Supply.
3. Submit a copy
of the f rm’ key
financial
statements and
reports (balance
sheet, income
statement,
statement of
retained
earnings,
statement of
changes in
financial
position, and
customer ledger)
in one (1) Excel
document.
Weight: 15%
Did not submit or
incompletely
submitted a copy
of the firm’ key
financial
statements and
reports (balance
sheet, income
statement,
statement of
retained
earnings,
statement of
changes in
financial
position, and
customer ledger)
in one (1) Excel
document.
Insufficiently
submitted a copy
of the firm’ key
financial
statements and
reports (balance
sheet, income
statement,
statement of
retained
earnings,
statement of
changes in
financial
position, and
customer ledger)
in one (1) Excel
document.
Partially
submitted a copy
of the firm’ key
financial
statements and
reports (balance
sheet, income
statement,
statement of
retained
earnings,
statement of
changes in
financial
position, and
customer ledger)
in one (1) Excel
document.
Satisfactorily
submitted a copy
of the firm’ key
financial
statements and
reports (balance
sheet, income
statement,
statement of
retained
earnings,
statement of
changes in
financial
position, and
customer ledger)
in one (1) Excel
document.
Thoroughly
submitted a copy
of the firm’ key
financial
statements and
reports (balance
sheet, income
statement,
statement of
retained
earnings,
statement of
changes in
financial
position, and
customer ledger)
in one (1) Excel
document.
4. Make two (2)
recommendation
s for how
management
should address
major business
decisions or
directions for the
company in the
next one to two
(1-2) years.
Weight: 30%
Did not submit or
incompletely
made two (2)
recommendation
s for how
management
should address
major business
decisions or
directions for the
company in the
next one to two
(1-2) years.
Insufficiently
made two (2)
recommendation
s for how
management
should address
major business
decisions or
directions for the
company in the
next one to two
(1-2) years.
Partially made
two (2)
recommendation
s for how
management
should address
major business
decisions or
directions for the
company in the
next one to two
(1-2) years.
Satisfactorily
made two (2)
recommendation
s for how
management
should address
major business
decisions or
directions for the
company in the
next one to two
(1-2) years.
Thoroughly
made two (2)
recommendation
s for how
management
should address
major business
decisions or
directions for the
company in the
next one to two
(1-2) years.
5. Clarity, writing
mechanics, and
formatting
requirements
Weight: 10%
More than 8
errors present
7-8 errors
present
5-6 errors
present
3-4 errors
present
0-2 errors
present

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 16 of 19
Assignment 3: Peachtree Project
Due Week 10 and worth 200 points
The Peachtree Project is due at the end of Week 10. The Peachtree Project is based upon you
completing the Project 2 – Sports Emporium (located at the end of Chapter 15) and Project 4a – StudentDesigned (located at the end of Chapter 18) assignments. This project will require to you to:
1. Convert a manual accounting system to Peachtree
2. Record a series of accounting transactions
3. Generate a series of reports
4. Complete period-end accounting activities (adjusting entries)
5. Analyze the firm via a series of questions (see the Check Your Progress: Project 2 section of the
project)
You will turn in five (5) documents per this project:
For Project 2

Document 1: An Excel workbook that contains all of the required reports (8) generated per this
assignment (see the Checklist of Printouts: Project 2 section of the project).
Document 2: A Word document that explains how accountants use Excel to help perform the job
task and to provide information to management used in the decision-making process.
Document 3: The answers to Check Your Progress questions posed by the project). You will
create an Excel document that includes each question and the answer to each question.
Evaluate your progress and proficiency level related to Excel.
For Project 4a
Document 4: An Excel workbook that lists all of the transactions that you recorded in Peachtree
for the following month, presented in a professional and readable format.
Document 5: A Word document explaining how you would help management understand the
meaning of the transactions prepared.
Document 6: An Excel workbook that contains a listing of all of the required reports (8) generated
per this assignment (see the Checklist of Printouts: Project 2 section of the project).
Document 7: Using the questions from the Check Your Progress section of Project 2, answer

each question based upon the results of your new transactions. You will create an Excel
document that includes each question and the answer to each question.
The specific course learning outcomes associated with this assignment are:



Create and maintain accounting records with Peachtree.
Generate financial reports for most small- to medium-sized businesses with Peachtree.
Organize information between Peachtree and Excel to communicate to internal and external
users.
Convert a manual-based accounting system to Peachtree.
Use technology and information resources to research issues in microcomputer applications for
accountants.
Write clearly and concisely about microcomputer applications for accountants using proper writing
mechanics.

Grading for this assignment will be based on your ability to complete the learning outcomes as required
per this project, using the following rubric.

ACC 306 – Assignments and Rubrics
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 17 of 19

Assignment 3: Peachtree Project
Document Points per Report or
Question
Number of Reports or
Questions
Total Points Possible
Document 1 – Required
Reports
6 8 48
Document 2 – Decision
Making Process
n/a n/a 25
Document 3 – Check
Your Progress
1 12 12
Document 4 – Next
Mo th’ Tra act o
n/a n/a 30
Document 5 –
Transactions Meanings
n/a n/a 25
Document 6 – Required
Reports
6 8 48
Document 7 – Check
Your Progress
1 12 12

ACC 306 – Student Notes
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 18 of 19
Weekly Course Schedule
The purpose of the course schedule is to give you, at a glance, the required preparation, activities, and
evaluation components of your course. For more information about your course, whether on-ground or
online, access your online course shell.
The expectations for a 4.5 credit hour course are for students to spend 13.5 hours in weekly work. This
time estimate includes preparation, activities, and evaluation regardless of the delivery mode.
Instructional Materials
In order to be fully prepared, obtain a copy of the required textbooks and other instructional materials
prior to the first day of class. When available, Strayer University provides a link to the first three (3)
chapters of your textbook(s) in eBook format. Check your online course shell for availability.
Review the online course shell or check with your professor to determine whether Internet-based
assignments and activities are used in this course.
Strayer students are encouraged to purchase their course materials through our designated bookstore
MBS Direct.
http://bookstore.mbsdirect.net/strayer.htm If a lab is required for the course, MBS Direct is
the only vendor that sells the correct registration code so that Strayer students may access labs
successfully.
Discussions
Students taking this course online are required to post their discussions to a weekly thread in the online
course shell. To earn full credit in an online threaded discussion, students must have a total of 3 posts per
discussion thread. Additionally, the posts must be made on two different days during the week. Please
note: Material in the online class will be made available on the previous Thursday. As it is always possible
that students could lose their work due to unforeseen circumstances, it is a best practice to routinely save
a working draft in a separate file before posting in the course discussion area.
Professors hold discussions during class time for on-ground students. Check with your professor if any
additional discussion participation is required in the online course shell outside of class hours.
Tests
Tests (quizzes, midterm and final exams, essay exams, lab tests, etc.) are available for student access
and completion through the online course shell. Check the online course shell to determine how you are
expected to take the tests.


Online students are to complete the test by Sunday midnight the week the test is due.
On-ground students are to complete the tests after the material is covered and before the next
class session.

Assignments
A standardized performance grading rubric is a tool your professor will use to evaluate your written
assignments. Review the rubric before submitting assignments that have grading rubrics associated with
them to ensure you have met the performance criteria stated on the rubric.
Grades are based on individual effort. There is no group grading; however, working in groups in the
online or on-ground classroom is acceptable.
Assignments for online students are always submitted through the online course shell. On-ground
professors will inform students on how to submit assignments, whether in paper format or through the
online course shell.

ACC 306 – Student Notes
© 2012 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information
and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of
Strayer University.
ACC 306 Student Version 1128 (1087 10-05-2012) Final – Revised Page 19 of 19
Resources
The Resource Center navigation button in the online course shell contains helpful links. Strayer University
Library Resources are available here as well as other important information. You should review this area
to find resources and answers to common questions.
Technical support is available for the following:
For technical questions, please contact Strayer Online Technical Support by logging in to your
iCampus account at
https://icampus.strayer.edu/login a d bm tt a ca e der “St de t
Ce ter,” the “S bm t He p T cket.” f yo are ab e to o to yo r Campus account, please
contact Technical Support via phone at (877) 642-2999.
For concerns with your class, please access the Solution Center by logging in to your iCampus
account at
https://icampus.strayer.edu/login a d bm tt a ca e der “St de t Ce ter,” the
“S bm t He p T cket.” If you are unable to log in to your iCampus account, please contact the IT
Help Desk at (866) 610-8123 or at
mailto:[email protected].
TurnItIn.com is an optional online tool to assess the originality of student written work. Check with your
professor for access and use instructions.
The
Strayer Policies link on the navigation bar in the online course shell contains academic policies. It is
important that students be aware of these policies.