iRubric: Excel Rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...

Excel Rubric

Rubric for Common Excel Functions

Rubric Code: UAB499

By ttgrateful

Ready to use

Public Rubric

Subject: Business

Type: Assessment

Grade Levels: 9-12

Excel Excel Function 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 There are 3 or more errors where Numeric Labels are entered as Values	Proficient There are 1-2 errors where Numeric Labels are entered as Values	Exceptional There is a proper distinction between Values and Numeric Labels
Organization & Layout 4 pts Column & Row Headings; are sized correctly; properly formatted	Insufficient No evidence shown	Partially Proficient There are 3 or more errors where Column and Row Headings are not properly sized and properly formatted in the worksheet	Proficient There are 1-2 errors where Column and Row Headings are not properly sized and properly formatted in the worksheet	Exceptional Columns and Row Headings are properly sized and properly formatted in the worksheet
Creating Formulas 4 pts Enter Formulas Using Cell References, Operators & Values; Using Functions (Sum,Min, Max); Order of Evaluation	Insufficient No evidence shown	Partially Proficient All Formulas in the worksheet are properly calculated using the proper formula with 4-5 errors.	Proficient All Formulas in the worksheet are properly calculated using the proper formula with 2-3 errors.	Exceptional All Formulas in the worksheet are properly calculated using the proper formula with 1 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 All Spreadsheet Data is properly sorted using Simple or Custom sorting parameters with 3 or more errors.	Proficient All Spreadsheet Data is properly sorted using Simple or Custom sorting parameters with 1-2 errors.	Exceptional All Spreadsheet Data is properly sorted using Simple or Custom sorting parameters with no errors.
Create Charts 4 pts Create Line, Column, Bar and Pie Charts; Create correct type of chart; Use proper content to build the chart; Title the Chart; Label the X & Y Axes; Provide a Legend	Insufficient No evidence shown	Partially Proficient Charts created are missing 3 or more pieces of appropriate information necessary to fully understand the chart.	Proficient Charts created are missing 1-2 pieces of appropriate information necessary to fully understand the chart.	Exceptional All charts are created properly with a legend, axis titles, a chart title, and all other appropriate information.
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 their content in the most efficient manner possible.	Proficient Most documents are set up to print their content in the most efficient manner possible but there are several that are not.	Exceptional All documents are properly set up to print their content in the most efficient manner possible.

Keywords:

Excel, Functions

Subjects:

Business

Types:

Assessment

Discuss this rubric