RCampus - Learning, ePortfolios, Assessments, Outcomes
Enter your login name here, or click here to go to the login page.
Enter your password:
forgot?   | click here to create a free account.
iRubric: Excel Spreadsheet Rubric

iRubric: Excel Spreadsheet Rubric

preview rubric

 

edit print email Copy to my rubrics Bookmark test run apply to... delete

Excel Spreadsheet Rubric

  Derived from rubric: Excel Spreadsheet Rubric
built by kimekennedy

Rubric Code: Y3B799
Rubric for evaluating student in-class labs for MS Office Excel
ready Ready to use    public Public Rubric

Directly link to this rubric or embed it on your website:
url:
link:
embed:
Keywords: (None)
Categories: Subjects: Computers  
Types: Assignment  
Grade Levels:

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.



Discuss this rubric



Do more with this rubric:

Preview

Preview this rubric.

Edit

Modify this rubric.

Copy

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


Print

Show a printable version of this rubric.

Categorize

Add this rubric to multiple categories.

Bookmark

Bookmark this rubric for future reference.
Assess

Test run

Test this rubric or perform an ad-hoc assessment.

Grade

Build a gradebook to assess students.

Collaborate

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

Publish

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

Email

Email this rubric to a friend.

Discuss

Discuss this rubric with other members.
 

Do more with rubrics than ever imagined possible.

Only with iRubrictm.


Bookmark this page:   RCampus RCampus   twit this twitter   delicious del.icio.us   digg Digg   facebook Facebook  
About Education Sites & Communities My Account Support
About RCampus
Terms of Use
Security & Privacy
Site Map
Case Studies
Classrooms
ePortfolios
Rubrics
Coursework
Grades
Book Exchange
Tutors
Website Gallery
Basic Groups
Study Groups
Club websites
Faculty Groups
My Account Settings
My Messages
My Calendar
My To-do List
My Favorites
My Documents
Free Sign up
Log in
Help & FAQ
Contact Us
Copyright © 2014 Reazon Systems, Inc.  All rights reserved.