iRubric: Excel: Family Budget Plan rubric

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

Excel: Family Budget Plan

Students create and manage a budget and design a table to see what percentage of income it is expense each month. Designed to be useful for students entering college and/or a family.

Rubric Code: M23XBX9

By Ivelisse

Ready to use

Public Rubric

Subject: Education

Type: Project

Grade Levels: 9-12

Microsoft Excel
	Excellent 10 pts	Good 8 pts	Fair 6 pts	Poor 4 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.
Table	Excellent The table is present and represents the data appropriately.	Good The table is present and is in good form with data, but lacks a couple key figures.	Fair The table is present, but does not represent the data.	Poor There is no table
Formatting Requirements	Excellent The table has all the headings, column labels, number labels, and is easy to read.	Good The table is missing one of the requirements.	Fair The table is missing 2 of the requirements.	Poor The table is missing all the formatting requirements.
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.