project phase 2 rubric excel 1 – www.savvyessaywriters.net
project phase 2 rubric excel 1 – www.savvyessaywriters.net
Rubric
Phase Two: MS Excel
|
Worksheets |
Content |
Possible |
Earned |
|
1 |
Create an Excel Spreadsheet that will support at least 5 Employees for your corporation. Include at least 8 pieces of information to describe your employees. |
15 |
|
|
2 |
Create an Excel Spreadsheet that will account for all the Merchandise your business sales. Include at least 8 products and at least 6 pieces of information about each one. |
15 |
|
|
3 |
Create an Excel Spreadsheet that will account for all the Customers you may have at your business. Create at least 7 different customers and outline at least 8 items of information for each person. |
15 |
|
|
4 |
Create an Excel Spreadsheet that will account for all the Reoccurring bills at your business. Include at least 8 bills and at least 5 items of information needed for each bill. |
15 |
|
|
5 |
Create an Excel Spreadsheet that will account for all the Transactions you will have. Include at least 10 transactions, and list at least 7 items of information about each transaction. |
15 |
|
|
6 |
Create an Excel Spreadsheet that will display the Weekly/Montly Financial statement information about the business. It will list all sales, debts, profits, taxes, salaries, bills on this one comprehensive sheet.(note: don’t copy/paste from other sheets, you need to generate information with formulas) |
25 |
|
|
6 total Worksheets |
Total |
100 |
|
|
You will use only One Excel book, but 6 different worksheets. Please create worksheet using the following format (not limited to):
If violated you will lose up to 20 points. |
Minus 20 points Max |
||
|
Instructor Notes: |
|||
Savvy Essay Writers
