iRubric: Microsoft Excel Rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Microsoft Excel Rubric Microsoft Excel Rubric Creating a vacation analysis spreadsheet and chart Rubric Code: PX49B43 By tammykrug Ready to use Public Rubric Subject: Computers Type: Project Grade Levels: 9-12

Excel Precision 33 %
	Excellent 3 pts	Good 2.5 pts	Fair 2 pts	Poor 1 pts
Formulas-Precision sum function	Excellent The formulas were used wherever appropriate. There were no numbers typed in to do any calculations.	Good Most of the numbers that needed to be calculated were done by formulas.	Fair Some of the numbers that needed to be calculated were done by formulas.	Poor Only 1 or 2 of the numbers that needed to be calculated were done by formulas.
Using Excel 33 %
	Excellent-Good (N/A)	Good (N/A)	Proficient (N/A)	Needs Work (N/A)
Organization-Excel Theme, Heading Styles, column widths	Excellent-Good The spreadsheet is very organized and very easy to read.	Good The spreadsheet is a little difficult to read. Some of the data and the chart are scattered or cluttered.	Proficient The spreadsheet appears to have some order. It can be read, but is very difficult.	Needs Work The spreadsheet is all over the place. The data is not organized and the graph does not accompany the data.
Required Data-Excel All data entered part 1 with printout; All data updated and reprinted.	Excellent-Good All the information is present and it good form.	Good The spreadsheet is missing 1 or 2 items.	Proficient The spreadsheet is missing 3 or 4 items.	Needs Work The spreadsheet is missing 5 or more items.
Critical Thinking 33 %
	Excellent (N/A)	Good (N/A)	Proficient (N/A)	Needs Improvement (N/A)
Graph-Critical Thinking Selected the correct data for a 3D pie chart	Excellent The graph is present and represents the data appropriately.	Good The graph is present and is in good form with data, but lacks a couple key figures.	Proficient The graph is present, but does not represent the data.	Needs Improvement There is no graph.
Formatting Requirements-Critical Style 8 charting	Excellent The graph has all the headings, column labels, number labels, and is easy to read.	Good The graph is missing one of the requirements	Proficient The graph is missing 2 of the requirements.	Needs Improvement The graph is missing all the formatting requirements.
Extra Formatting-Critical Thninking outside labels. correct labels.	Excellent The graph has extra features that makes the graph more attractive and is still easy to read.	Good The graph has extra features, but it makes the graph more difficult to read.	Proficient The graph has a couple extra features, but it makes the graph difficult to read.	Needs Improvement The graph has no extra formatting features.