iRubric: Excel Spreadsheet Rubric

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

Excel Spreadsheet Rubric

Rubric for evaluating student in-class labs for MS Office Excel

Rubric Code: B895A2

By donnat481

Ready to use

Public Rubric

Subject: Computers

Type: Assignment

Grade Levels: 9-12

Excel Spreadsheet Rubric
	Beginning (N/A)	Developing (N/A)	Accomplishing (N/A)	Exemplary (N/A)
Excel Starting with MS Office Excel 2010	Beginning Understand and identify spreadsheet software, identify a worksheet and a workbook, explore the Excel 2010 program window.	Developing Understand the details about formulas, identify the Excel arithmetic operators, understand cell references in formulas, and determine the calculations to use.	Accomplishing Enter labels and values, use AutoSum, define a function and its argument, navigate a worksheet, edit cell entries, and identify common Excel pointers.	Exemplary Use the formula prefix to enter and edit a simple formula, understand calculation operators, arithmetic operators, comparison operators, text concatenation operators, reference operators, and named ranges, switch worksheet views, and choose print options.
Exel Work with Formulas and Functions in MS Office Excel 2010	Beginning Create a simple formula, and review the mathematical order of precedence.	Developing Understand functions, insert a function, manually type a function, copy and move cell entries, insert and delete selected cells.	Accomplishing Understand relative and absolute cell references, copy formulas with relative cell reference, and copy formulas with absolute cell references.	Exemplary Use the auto fill options button, use the fill handle for sequential text or values, and create a new workbook using a template.
Excel Formatting a Worksheet in MS Office Excel 2010	Beginning Understand cell-formatting values, including what changes occur and what changes do not occur, change font and font size.	Developing Understand formatting cell attributes and cell alignments, rotate and indent cell entries.	Accomplishing Adjust column width, change row height, understand common column formatting commands, insert and delete rows and columns, hide and unhide rows and columns, add and edit comments.	Exemplary Use the cut, copy and paste options to copy or move data from one cell to another and check spelling.