iRubric: Excel College Budget rubric

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

Excel College Budget

Students create and manage a budget and design a pie chart to see what percentage of income is spent on each expendse category. Designed to be useful for students entering college.

Rubric Code: Q764XX

By cnfrum

Ready to use

Public Rubric

Subject: Social Sciences

Type: Project

Grade Levels: 9-12

Microsoft Excel
	Excellent 4 pts	Good 3 pts	Fair 2 pts	Poor 1 pts
Formulas	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.
Organization/Creativity	Excellent 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.	Fair The spreadsheet appears to have some order. It can be read, but is very difficult.	Poor The spreadsheet is all over the place. The data is not organized and the graph does not accompany the data.
Required Data	Excellent All the information is present and in good form.	Good The spreadsheet is missing 1 or 2 items.	Fair The spreadsheet is missing 3 or 4 items.	Poor The spreadsheet is missing 5 or more items.
Graph	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.	Fair The graph is present, but does not represent the data.	Poor There is no graph.
Formatting Requirements	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.	Fair The graph is missing 2 of the requirements.	Poor The graph is missing all the formatting requirements.
Extra Formatting	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.	Fair The graph has a couple extra features, but it makes the graph difficult to read.	Poor The graph has no extra formatting features.
Justification	Excellent Student provides clear and convincing justification for all budget categories and amounts.	Good Student provides clear and convincing justification for most budget categories and amounts.	Fair Student provides justification for some budget categories and amounts.	Poor Student justification for few or none of the budget categories and amounts.