Skip to main content
iRubric: Excel Spreadsheet Rubric

iRubric: Excel Spreadsheet Rubric

find rubric

edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
Excel Spreadsheet Rubric 
Excel Spreadsheet Rubric
Rubric for evaluating student in-class labs for MS Office Excel
Rubric Code: Y3B799
By kimekennedy
Ready to use
Public Rubric
Subject: Computers  
Type: Assignment  
Grade Levels: (none)

Powered by iRubric Excel Spreadsheet Rubric
Rubric for evaluating In-Class Lab Assignments Exel Units A - D
  Beginning (1)

1 pts

Developing (2)

2 pts

Accomplishing (3)

3 pts

Exemplary (4)

4 pts

Excel Unit A
100 %

Starting with MS Office Excel 2007
Beginning (1)

Understand and identify spreadsheet software, identify a worksheet and a workbook, explore the Excel 2007 program window.
Developing (2)

Understand the details about formulas, identify the Excel arithmetic operators, understand cell references in formulas, and determine the calculations to use.
Accomplishing (3)

Enter labels and values, use AutoSum, define a function and its argument, navigate a worksheet, edit cell entries, and identify common Excel pointers.
Exemplary (4)

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 Unit B
100 %

Work with Formulas and Functions in MS Office Excel 2007
Beginning (1)

Create a complex formula, and review the mathematical order of precedence.
Developing (2)

Understand functions, insert a function, manually type a function, copy and move cell entries, insert and delete selected cells.
Accomplishing (3)

Understand relative and absolute cell references, copy formulas with relative cell reference, and copy formulas with absolute cell references.
Exemplary (4)

Understand a mixed reference cell, use auto fill options button, use the fill handle for sequential text or values, round a value with a function, and create a new workbook using a template.
Excel Unit C
100 %

Formatting a Worksheet in MS Office Excel 2007
Beginning (1)

Understand cell-formatting values, including what changes occur and what changes do not occur, change font and font size.
Developing (2)

Understand formatting as a table using the Table Styles gallery, change cell attributes and cell alignments, rotate and indent cell entries.
Accomplishing (3)

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 (4)

Apply colors, patterns, and borders, apply themes and cell styles, apply conditional formatting rule(s), name and move a worksheet, copy a worksheet, check spelling, and email a workbook.
Excel Unit D
100 %

Work with Charts in MS Office Excel 2007
Beginning (1)

Follow guidelines to plan a chart, understand and identify the elements of a chart, and identify common chart types.
Developing (2)

Create a chart, use the contextual tab Chart Tools, move and resize a chart, and move an embedded chart to a worksheet.
Accomplishing (3)

Change the chart design, work with a 3-D chart, change the chart layout, add data labels to a chart, identify gridlines, format a chart, and change alignment in axis text and titles.
Exemplary (4)

Enter text annotations on a chart, enter a drawing on a chart, add SmartArt graphics, create an exploding pie chart, use the Page Setup dialog box, Print Preview, and Print the worksheet and, then, only the chart.




Subjects:

Types:

Discuss this rubric




Do more with this rubric:
Preview

Preview

Preview this rubric.
Edit

Edit

Modify this rubric.
Copy

Copy

Make a copy of this rubric and begin editing the copy.

Print

Print

Show a printable version of this rubric.
Categorize

Categorize

Add this rubric to multiple categories.
Bookmark

Bookmark

Bookmark this rubric for future reference.
Assess
Test run

Test run

Test this rubric or perform an ad-hoc assessment.
Grade

Grade

Build a gradebook to assess students.
Collaborate

Collaborate

Apply this rubric to any object and invite others to assess.
Share
Publish

Publish

Link, embed, and showcase your rubrics on your website.
Email

Email

Email this rubric to a friend.
Discuss

Discuss

Discuss this rubric with other members.
 

Do more with rubrics than ever imagined possible.

Only with iRubrictm.


Copyright © 2024 Reazon Systems, Inc.  All rights reserved.
n16