Evaluation

Here is the first rubric for the first spreadsheet:

CATEGORY

4

All requirements are met and exceeded, including:

3

All requirements are met, including:

 

2

One requirement was not met completely.

1

Two or more requirements were not met completely, including:

 

SETUP

Organized specifically according to directions. Columns were resized to fit names.

Organized specifically according to directions. Monetary formatting was used appropriately.

Names or formulas not in the right cells. Skipping cells.

Names not in the right cells.

Skipping cells.

 

CONTENT

Players in alphabetical order.

Correct number of players used.

Content in correct cells. Formulas were correct.

Using less than the required number of players. Formulas were incorrect. Final total was incorrect.

Using less than the required number of players. Formulas were incorrect. Final total was incorrect.

 

SUBMISSION

Emailed and attachment functions correctly.

Emailed with attachment, although attachment may not function correctly.

Emailed, no attachment.

Handed in manually or not emailed at all.

 

 

Here is the second rubric for the main and final spreadsheet:

CATEGORY

4

All requirements are met and exceeded, including:

3

All requirements are met, including:

 

2

One or two requirements were not met completely.

1

Two or more requirements were not met completely, including:

 

SETUP

Organized specifically according to directions. Columns were resized to fit largest items.

Organized specifically according to directions. Monetary formatting was used appropriately.

Items or formulas not in the right cells. Skipping cells.

Items or formulas not in the right cells.

Skipping cells.

 

CONTENT

Restaurants in order of visit.

More than one $$$ restaurant used.

More items than just the required used.

Used as much of the budget as you could.

Correct number and type of restaurants used.

Correct type and number of items for each restaurant used.

Content in correct cells. Formulas were correct.

Totals were correct and created by formulas.

Did not go over budgeted amount.

Using less than the required number of restaurants or items. Formulas were incorrect. Final total was incorrect or not created by a formula.

Went over budgeted amount.

Missing prices or formulas.

Using less than the required number of restaurants or items. Formulas were incorrect. Final total was incorrect.

Went over budgeted amount.

Missing prices or formulas.

 

SUBMISSION

Emailed and attachment functions correctly.

Emailed with attachment, although attachment may not function correctly.

Emailed, no attachment.

Handed in manually, or not emailed on time.

 

 

 

 


Excel Webquest © Copyright Mrs. Dianne MS Rowe, 2008, All rights reserved.
Website templates