iRubric: Excel Project 1 rubric

(draft) edit print share Copy to my rubrics Bookmark test run assess... delete Do more...

Excel Project 1

Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks.

Rubric Code: S3X5CC

By link14

Draft

Public Rubric

Subject: Computers

Type: Homework

Grade Levels: (none)

Excel Project 1
	Exceptional 10 pts	Very Good 7 pts	Good 3 pts	Incomplete 1 pts	Score/Comments (N/A)
Required Data	Exceptional All of the information is present and accurate.	Very Good The spreadsheet is missing 1 or 2 pieces of information.	Good The spreadsheet is missing 3 or 4 pieces of information.	Incomplete The spreadsheet is missing 5 or more pieces of information.	Score/Comments
Data Table	Exceptional The data table includes all of the following: The correct title and column titles The table has the correct title Formulas are entered correctly The table is defined	Very Good The data table includes 3 of the 4: The correct one-input data table. The table has the correct title Formulas are entered correctly The table is defined	Good The data table includes two of the following: The correct one-input data table. The table has the correct title Formulas are entered correctly The table is defined	Incomplete The data table includes 1 or none of the following: The correct one-input data table. The table has the correct title Formulas are entered correctly The table is defined	Score/Comments
Amortization Schedule	Exceptional The amortization schedule includes all of the following: Correct Entered Formulas Correct Copied formulas *Total Formulas	Very Good The amortization schedule includes two of the following: Correct Entered Formulas Correct Copied formulas *Total Formulas	Good The amortization schedule includes one of the following: Correct Entered Formulas Correct Copied formulas *Total Formulas	Incomplete The amortization schedule includes none of the following: Correct Entered Formulas Correct Copied formulas *Total Formulas	Score/Comments
Hyperlink	Exceptional The hyperlink is assigned to an embedded graphic and works properly.	Very Good The hyperlink works properly but is not assigned to an embedded graphic.	Good The hyperlink is assigned to an embedded graphic but doesn not work properly.	Incomplete The hyperlink is not assigned to an embededded graphic and does not work properly.	Score/Comments
Formatting	Exceptional The entire assignment is formatted correctly. Loan Payment Calculator Interest Rate Schedule *Amortization Schedule	Very Good Two of the three parts of the assignment are formatted correctly. Loan Payment Calculator Interest Rate Schedule *Amortization Schedule	Good One of the parts of the assignment are formatted correctly. Loan Payment Calculator Interest Rate Schedule *Amortization Schedule	Incomplete None of the assignment is formatted correctly. Loan Payment Calculator Interest Rate Schedule *Amortization Schedule	Score/Comments

Subjects:

Computers

Types:

Homework

Discuss this rubric