Project Phase 2 Rubric: 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):

• Apply a theme
• Worksheet tab named properly
• Worksheet should have title, column header
• Use different font size, font color to format your sheet
• Use currency style to format your dollar amount
• Must use formulas when applicable

If violated you will lose up to 20 points.

Minus 20 points Max

Instructor Notes: