Skip to main content
sign in
Username
Password
forgot?
Sign up
Share
help_outline
help
Pricing
Request Info
Please enable JavaScript on your web browser
menu
iRubric: Excel Test rubric
find rubric
Your browser does not support iframes.
edit
print
share
Copy to my rubrics
Bookmark
test run
assess...
delete
Do more...
Excel Test
Excel Test
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:
S8XC66
By
klruggieri
Ready to use
Public Rubric
Subject:
Computers
Type:
Assessment
Grade Levels:
6-8
Your browser does not support iframes.
Desktop Mode
Mobile Mode
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:
Computers
Types:
Project
Assignment
Assessment
Discuss this rubric
You may also be interested in:
More rubrics by this author
More Computers rubrics
More Project rubrics
Do more with this rubric:
Preview
Preview this rubric.
Edit
Modify this rubric.
Copy
Make a copy of this rubric and begin editing the copy.
Print
Show a printable version of this rubric.
Categorize
Add this rubric to multiple categories.
Bookmark
Bookmark this rubric for future reference.
Assess
Test run
Test this rubric or perform an ad-hoc assessment.
Grade
Build a gradebook to assess students.
Collaborate
Apply this rubric to any object and invite others to assess.
Share
Publish
Link, embed, and showcase your rubrics on your website.
Email
Email this rubric to a friend.
Discuss
Discuss this rubric with other members.
Do more with rubrics than ever imagined possible.
Only with iRubric
tm
.
Copyright © 2024
Reazon Systems, Inc.
All rights reserved.
n60
Your browser does not support iframes.
Your browser does not support iframes.
Your browser does not support iframes.