Skip to main content

iRubric: BUSN 7303 rubric

find rubric

(draft) edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
BUSN 7303 
Excel
Excel Spreadsheet: Open and save a workbook, enter labels and values, edit cell entries, enter formulas, create complex formulas, use Excel functions, format values, use fonts and font sizes, adjust column widths, generate totals with AutoSum, display and print formula contents, preview and modify a worksheet.
Rubric Code: ZX4542X
By mbaldo11
Draft
Public Rubric
Subject: Computers  
Type: Project  
Grade Levels: 9-12

Powered by iRubric Technology-Excel
Creating, formating and printing spreadsheet.
  Mastery

4 pts

Accomplished

3 pts

Adequate

2 pts

Developing

1 pts

Inadequate

0 pts

Correct data entered

Data and headings are accurate and located in the appropriate cells.
Mastery

All of data (labels and values) was entered correctly.
Accomplished

Most of the data (labels and values) was entered correctly.
Adequate

Some of the data(labels and values) was entered correctly in the appropriate cells.
Developing

Some data was entered but is not located in the appropriate cells
Inadequate

No data was entered
Formulas are correct & visible.

AutoSum, appropriate use of parenthesis, and Min and Max functions are correct.
Mastery

All of the formulas used are applied correctly.
Accomplished

Some of the formulas are applied correctly.
Adequate

Most of formulas used are applied incorrectly.
Developing
Inadequate
Column headings and labels.

The column headings are formatted in bold, as well as the word Total in cell A8.
Mastery

All of the data is formatted correctly, including applying bold to all of the column headings and to Total in cell A8.
Accomplished

Some of data is in appropriate size and font, and some of the column headings, and cell A8 are formatted in bold.
Adequate

Most of data is not in appropriate size and font, and the column headings and cell A8 are not formatted in bold.
Developing
Inadequate
Title is merged & centered

Mastery

Title is merged and centered, underlined, bold, in 12 point font.
Accomplished

Title is not merged and centered, or underlined, or bold and 12 point font were not applied. but one of the two is present.
Adequate

Title is not merged and centered, and appropriate formatting is not present.
Developing
Inadequate
Spread sheet Formatting & Printing

Correct print area & print features showing. Reveal formulas function used and column widths allow for complete viewing of the contents.
Mastery

Correct print area, Gridlines, and Row and Column Headings features. Reveal formulas function used and column widths adjusted so that entire formulas are visible. Paper set to print in Landscape, not Portrait.
Accomplished

Partially correct print area, Gridlines, or Row and Column Headings used. Reveal formulas feature partially used. Some column widths not adjusted to reveal all formulas. Paper may not be set to Landscape.
Adequate

Incorrect print area, no Gridlines, or Row and Column Headings selected. Reveal formulas function not present. Majority of column widths not adjusted to print entire formulas. Paper not set to Landscape.
Developing
Inadequate
Use of Internet as a Resorce

Mastery

Is able to connect to the irubric web site via the internet, log on to the site and access the student assignment and the attachments with no or minor assistance.
Accomplished

Has some difficulty in connecting to the irubric web site via the internet, needs moderate assistance in logging on to the site, or in accessing the assignments or attachments.
Adequate

Is unable to connect to the web site or the internet, needs major assistance in logging on to the site, or in accessing assignments or attachments.
Developing
Inadequate



Keywords:
  • cell, row, column, merge and center, format

Subjects:


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
This rubric is still in draft mode and cannot be scored. Please change the rubric status to ready to use.
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.

n202