Skip to main content

iRubric: Excel rubric

find rubric

(draft) edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
Excel 
Excel
Excel Spreadsheet: Open and save a workbook, enter labels and values, edit cell entries, enter formulas, create complex formulas, use Excel functions, format values, use fonts and font sizes, adjust column widths, generate totals with AutoSum, display and print formula contents, preview and modify a worksheet.
Rubric Code: C6AC5W
By dreimer
Draft
Public Rubric
Subject: Computers  
Type: Project  
Grade Levels: 9-12

Powered by iRubric Technology-Excel
Creating, formating and printing spreadsheet.
  Excellent

4 pts

Very Good

3 pts

Fair

2 pts

Weak

1 pts

Data Entry

Excellent

All of the required data is presented: Calories, Fat, Cholesterol, Sat Fat from all 4 restaurants is correctly entered; Combo meals are created correctly and presented fully
Very Good

Most of the required data is presented: Calories, Fat, Cholesterol, Sat Fat amounts from all 4 restaurants is correctly entered; Combo meals are created correctly and presented fully
Fair

A fair amount of required data is present; missing the following: Calories, Fat Cholesterol, Sat Fat, High Cal Combo, Low Cal Combo,
Weak

Most of the data is not entered correctly; missing the following: Calories, Fat Cholesterol, Sat Fat, High Cal Combo, Low Cal Combo,
Formulas

Excellent

All of the average and sum formulas are correctly written and used appropriately
Very Good

Most of the average and sum formulas are correctly written and correctly applied
Fair

Formulas for average and sum are incorrectly written, or are used incorrectly
Weak

Formulas for average and sum are not included
Table Formatting

Excellent

Data table is interestingly formatted; rows and columns are clearly labeled; creative colour highlights and fill effects are appropriate and appealing; font formatting is well done
Very Good

Table is well formatted; rows and columns are highlighted appropriately; font formatting is evident
Fair

Table formatting is somewhat basic and unoriginal; columns and heading are quite plain; font formatting is weak
Weak

Data table is very basic and plain looking; formatting is not evident; overall look is unappealing
Title

Excellent

Title makes sense, is colourful and dynamic; sized and centred; well formatted and original
Very Good

Title is not merged and centered, or underlined, or bold and 12 point font were not applied. but one of the two is present.
Fair

Title is not merged and centered, and appropriate formatting is not present.
Weak

Title does not make sense; is very plain looking, too small, off centre, and unoriginal
Graphs

Excellent

All four graphs are presented; they are sized correctly and well formatted to be visually appealing and easy to read; all legends and labels are included
Very Good
Fair
Weak
Use of Internet as a Resorce

Excellent

Student is able to log on to Edmodo, access the assignment and attachments with no assistance, find required information on resource pages, and upload finished Excel document
Very Good

Student is mostly able to independently log onto Edmodo, access the assignment and attachment files, find required information on resource web pages, and upload finished excel doc
Fair

Student is struggling somewhat to log onto Edmodo and access assignment attachments; has trouble finding required information on resource web pages, and has problems uploading finished assignment
Weak

Student needs major assistance in logging on to Edmodo, cannot find required information on resource web pages, and cannot upload finished Excel document without help



Keywords:
  • cell, row, column, merge and center, format

Subjects:


Discuss this rubric




Do more with this rubric:
Preview

Preview

Preview this rubric.
Edit

Edit

Modify this rubric.
Copy

Copy

Make a copy of this rubric and begin editing the copy.

Print

Print

Show a printable version of this rubric.
Categorize

Categorize

Add this rubric to multiple categories.
Bookmark

Bookmark

Bookmark this rubric for future reference.
Assess
This rubric is still in draft mode and cannot be scored. Please change the rubric status to ready to use.
Share
Publish

Publish

Link, embed, and showcase your rubrics on your website.
Email

Email

Email this rubric to a friend.
Discuss

Discuss

Discuss this rubric with other members.
 

Do more with rubrics than ever imagined possible.

Only with iRubrictm.

n178