Skip to main content
iRubric: Excel Test rubric

iRubric: Excel Test rubric

find rubric

edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
Excel Test 
Excel
Excel Spreadsheet: Open and save a workbook, enter labels and values, edit cell entries, create and enter formulas, use Excel functions, format values, use fonts and font sizes, adjust column widths, generate totals with AutoFill.
Rubric Code: E75933
By hscharinger
Ready to use
Public Rubric
Subject: Computers  
Type: Assessment  
Grade Levels: 6-8

Powered by iRubric Technology-Excel
  Above Expectations

4 pts

Meets Expectaions

3 pts

Needs improvement

2 pts

Below Expectations

1 pts

Data Tables

Above Expectations

All 7 necessary data tables have been created. All of data is entered correctly.

The data and information contained in each cell is visible, and has been re-sized appropriately.
Meets Expectaions

Has 6 out-of 7 of the necessary data tables. Most of data is entered correctly.

Most of the data and information contained in each cell is in view, and has been re-sized appropriately.
Needs improvement

Has 5 out-of 7 of the necessary data tables. Some of data is entered correctly.

Some of the data and information contained in each cell is in view, and has been re-sized appropriately.
Below Expectations

Missing 3 or more of the necessary data tables. Most of data is not entered correctly.

Most of the data and information contained in each cell is not in view, and has not been re-sized appropriately.
Formulas

Above Expectations

All of the formulas used are created and applied correctly.

No decimal numbers remain in the cells, and were removed by using the appropriate feature on the ribbon.
Meets Expectaions

Most of the formulas used are created and applied correctly.

Few decimal numbers remain in the cells, and were removed by using the appropriate feature on the ribbon.
Needs improvement

Some of the formulas are created and applied correctly.

Many decimal numbers remain in the cells, and those not remaining were removed by the appropriate feature on the ribbon.
Below Expectations

Most of formulas used are not created and applied correctly.

Most, if not all, numbers remain as decimals in the cells, and were not removed by the appropriate feature on the ribbon.
Labels and Headings

Above Expectations

All of the data tables' columns and rows, have been labeled/headed appropriately.

Formatting is uniform in all data tables.
Meets Expectaions

1-2 errors in the labeling/heading of the columns and rows in the data tables.

Formatting is mostly uniform in all of the data tables
Needs improvement

3-4 errors in the labeling/heading of the columns and rows in the data tables.

Formatting is somewhat uniform in all of the data tables.
Below Expectations

5 or more errors in the labeling/heading of the columns and rows in the data tables.

Formatting is not uniform in most of the data tables.
Titles

Above Expectations

All 7 data tables have an appropriate title.

All data table titles are merged and centered.

Both charts/graphs have an appropriate title.
Meets Expectaions

Six of the data tables have an appropriate title.

Six data table titles are merged and centered.

One out-of-the two charts/graphs contains an appropriate title.
Needs improvement

Five of the data tables have an appropriate title.

Five data table titles are merged and centered.

Both charts/graphs contain inappropriate titles.
Below Expectations

Three or more of the data tables do not have an appropriate title.

Three or more data table titles are not merged and centered.

Both charts/graphs are missing titles.
Charts/Graphs

Above Expectations

Both charts/graphs reflects correct data.

Both charts/graphs chosen were appropriate for data being represented.

Both legends are correct and labeled properly.
Meets Expectaions

One chart/graph reflects correct data.

One of the charts/graphs chosen was appropriate for data being represented.

One of the legends is correct and labeled properly.
Needs improvement

Both charts/graphs reflect incorrect data.

Both charts/graphs chosen were inappropriate for data being represented.

Both legends are incorrect, and are improperly labeled.
Below Expectations

Both charts/graphs missing.


Both charts/graphs are missing legends.
Neatness and Creativity

Creativity in formatting of both the data tables and the charts/graphs.
Above Expectations

Data tables and charts/graphs are exceptionally well designed, neat, and attractive.

Colors that go well together are used to make the data tables charts/graphs more readable.

Labels/headings and titles are easy to distinguish and readable.
Meets Expectaions

Data tables and charts/graphs are neat and relatively attractive.

Colors are used to make the data tables and charts/graphs more readable.

Labels/headings and titles are readable, but could be more distinguishable.
Needs improvement

Data tables and charts/graphs are neat, but appears quite plain.

More colors could have been used to make the data tables and charts/graphs more readable.

Labels/headings and titles are not readable or easily distinguished.
Below Expectations

Data tables and charts/graphs are messy and unorganized. They appear to be "thrown together" in a hurry.

Very little to no color was used to make the data tables and charts/graphs more readable.

Labels/headings and titles were not used.



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
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.


Copyright © 2024 Reazon Systems, Inc.  All rights reserved.
n16