Skip to main content

iRubric: Excel Rubric

find rubric

edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
Excel Rubric 
Excel Rubric
Rubric for Excel
Rubric Code: Q25X57B
By Frances62914
Ready to use
Public Rubric
Subject: Computers  
Type: Assessment  
Grade Levels: 9-12

Powered by iRubric Excel
Excel Rubric
  Insufficient

1 pts

Partially Proficient

2 pts

Proficient

3 pts

Exceptional

4 pts

Create a Title
4 pts

Merge Cells and Center Across the Spreadsheet
Insufficient

No evidence shown
Partially Proficient

Title is not merged and/or centered
Proficient

Title is not merged and centered correctly on the worksheet
Exceptional

Title is merged and centered across the worksheet
Enter Data Correctly
4 pts

Data is entered correctly - Text; Values; Numeric Labels; Proper Cell
Insufficient

No evidence shown
Partially Proficient

Three or more input errors
Proficient

One to two input errors
Exceptional

No input errors
Organization & Layout
4 pts

Column & Row Headings; are sized correctly; properly formatted
Insufficient

No evidence shown
Partially Proficient

Three or more errors
Proficient

One to two errors
Exceptional

No format errors
Creating Formulas
4 pts

Enter Formulas Using Cell References, Operators & Values;
Using Functions
Order of Evaluation
Insufficient

No evidence shown
Partially Proficient

Formulas have four to five errors.
Proficient

Formulas have two to three errors.
Exceptional

Formulas are correct or have one or less error.
Sorting Data
4 pts

Simple and Custom Sorts - Use the proper sort function; sort the proper data stream; sort using multiple criteria
Insufficient

No evidence shown
Partially Proficient

Spreadsheet Data is sorted with three or more errors.
Proficient

Spreadsheet Data is sorted with one or two errors.
Exceptional

Spreadsheet Data is properly sorted with no errors.
Printing Worksheets
4 pts

Print Area is set correctly; scaling is used when necessary; gridlines are turned on and off as needed; documents are printed with the most efficient use of paper
Insufficient

No evidence shown
Partially Proficient

Most documents are not set up to print correctly
Proficient

Most documents are set up to print correctly but there are several that are not.
Exceptional

All documents are properly set up to print correctly



Keywords:
  • Excel, Functions


Types:

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
Test run

Test run

Test this rubric or perform an ad-hoc assessment.
Grade

Grade

Build a gradebook to assess students.
Collaborate

Collaborate

Apply this rubric to any object and invite others to assess.
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.

n243