iRubric: Excel Spreadsheet Rubric

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

Excel Spreadsheet Rubric

Excel Spreadsheet and Chart Rubric

Rubric Code: PX54X76

By sgaskill

Ready to use

Public Rubric

Subject: Computers

Type: Assessment

Grade Levels: 9-12, Undergraduate

Technology-Excel
	Advanced 4 pts	Proficient 3 pts	Basic 2 pts	Below Basic 1 pts
Neatness and Organization	Advanced The spreadsheet has exceptional formatting and the information is well organized. It's easy to read.	Proficient The spreadsheet has attractive formatting and is somewhat organized. Data can be read and interpreted, but with some difficulty.	Basic The spreadsheet is somewhat organized. Readability needs improvement, as there is great difficult in interpreting information.	Below Basic The spreadsheet formatting and organization can be confusing to observer. Spreadsheet information is not readable.
Formulas	Advanced The spreadsheet formula(s) are well-developed and will correctly determine the needed information.	Proficient The spreadsheet formula(s) will correctly determine the needed information.	Basic The spreadsheet formula(s) cannot be used to correctly determine the needed information.	Below Basic The spreadsheet has no formula(s)
Titles, Labels and Headings	Advanced 1. Contains a creative title that clearly relates to the data displayed. 2. Contains clearly labeled rows and columns.	Proficient 1. Contains a title that somewhat relates to the data displayed. 2. Contains clearly labeled rows and columns, but the row-column organization was not completely thought out.	Basic 1. Title is present at the top of the graph. 2. Does not contain labels for some of the rows or columns, and spreadsheet shows some signs of disorganization.	Below Basic 1. Does not contain a title. 2. Does not contain any labels for columns and rows.
Content	Advanced Spreadsheet meets all requirements necessary to accurately complete the assignment.	Proficient Spreadsheet includes the spreadsheet and chart with minor errors when completing the problem.	Basic Spreadsheet and chart do not accurately demonstrate a solution to the problem assigned.	Below Basic Spreadsheet and chart fail to solve the problem correctly.
Chart	Advanced The chart represents the data well and encompasses all the necessary chart parts (titles, legend)	Proficient The chart represents the data and encompasses all the necessary chart parts (titles, legend)	Basic The chart is not answering clearly the problem presented.	Below Basic The chart fails to solve the problem
Total	Advanced 20	Proficient 15	Basic 10	Below Basic 5