The required Excel work sheets are included as specified in the instructions.
accounting
Description
Grading Rubric
Global Bike Excel Accounting Cycle
Practice Case
1.
Name your excel file: GlobalBike_yourfirstname_yourlastname.xlsx
2.
Upload a copy of the file that you wish to be
graded into your Blackboard journal. Do
NOT upload multiple files. If you upload
a new version, DELETE the prior version.
Expected Items for Grade of B
|
||
Item #
|
description of item
|
points
|
|
1. |
The
required Excel work sheets are included as specified in the instructions. |
5 |
|
2. |
Each
worksheet is formatted as specified |
5 |
|
3. |
The Excel
workbook file is named as described in the instructions. |
5 |
|
4. |
No
non-transaction included in the balance sheet format |
5 |
|
5. |
All
transactions entered into the general journal format |
15 |
|
6. |
No more
than 4 of the journal entries incorrect in debit / credit |
5 |
|
7. |
No more
than 4 of the journal entries incorrect in amount |
5 |
|
8. |
All
journal entries accurately entered into the appropriate ledgers |
5 |
|
9. |
Correct
account balances are taken to unadjusted trial balance in the end-of-period
(EOP) worksheet |
10 |
|
10. |
Adjusting
entries are correctly entered into adjusting entries columns in EOP |
5 |
|
11. |
The
adjusted trial balance is accurately calculated |
10 |
|
12. |
The
correct accounts and account balances entered into income statement columns
of EOP |
5 |
|
13. |
The
correct accounts and account balances entered into the balance sheet columns
of the EOP |
5 |
|
14. |
Net
income is correctly calculated and entered into retained earnings |
5 |
|
15. |
Income
statement is correctly formatted in the multi-step form |
5 |
|
16. |
Balance
sheet shown in correct format with items in order of liquidity |
5 |
|
|
Total
points possible |
100 |
|
|
Minimum
points needed for grade of B |
85 |
Additional Items – at least fifteen (15) points from the
following for Grade of A
|
||
Item #
|
description of item
|
points
|
1.
|
in-cell formula correctly
used to extract and display account title based on account number
|
10
|
2.
|
in-cell formula correctly
used to display cell as blank unless an appropriate entry is needed (if
statement)
|
10
|
3.
|
cash flow statement using
direct method is completed correctly
|
10
|
4.
|
worksheets are properly linked to provide for entering data only
once within a workbook (multiple methods possible)
|
10
|
5.
|
accurate documentation of all in-cell formulae included on
documentation worksheet
|
10
|
