iRubric: Create a Personal Budget Spreadsheet rubric

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

Create a Personal Budget Spreadsheet

Excel Spreadsheet: Open and save a workbook, enter labels and values, edit cell entries, create Functions, format values, use fonts and font sizes, adjust column widths, generate totals with AutoFill.

Rubric Code: E94855

By truntagh

Ready to use

Public Rubric

Subject: Computers

Type: Assessment

Grade Levels: Undergraduate

Technology-Excel
	Above Expectations 4 pts	Meets Expectaions 3 pts	Needs improvement 2 pts	Below Expectations 1 pts
Neatness and Organization	Above Expectations The spreadsheet has exceptional formatting and the information is well organized. It's easy to read.	Meets Expectaions The spreadsheet has attractive formatting and is somewhat organized. Data can be read and interpreted, but with some difficulty.	Needs improvement The spreadsheet is somewhat organized. Readability needs improvement, as there is great difficult in interpreting information.	Below Expectations The spreadsheet formatting and organization can be confusing to observer. Spreadsheet information is not readable.
Functions	Above Expectations The spreadsheet function(s) are well-developed and will correctly determine the needed information.	Meets Expectaions The spreadsheet function(s) will correctly determine the needed information.	Needs improvement The spreadsheet function(s) cannot be used to correctly determine the needed information.	Below Expectations The spreadsheet has no function(s)
Titles, Labels and Headings	Above Expectations 1. Contains a creative title that clearly relates to the data displayed. 2. Contains clearly labeled rows and columns.	Meets Expectaions 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.	Needs improvement 1. Title is not 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 Expectations 1. Does not contain a title. 2. Does not contain any labels for columns and rows.
Content	Above Expectations Spreadsheet meets all requirements necessary to determine a personal budget.	Meets Expectaions Spreadsheet includes and makes clear all but 1 or 2 minor details that are necessary to the personal budget.	Needs improvement Spreadsheet includes and makes clear all but 3 or 4 details that are necessary to the personal budget.	Below Expectations Spreadsheet fails to include and make clear more than 4 of the details that are needed in the personal budget.