Skip to main content

iRubric: MS Excel Level 1 rubric

find rubric

(draft) edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
MS Excel Level 1 
MS Excel Level 1
Students are asked to recreate an Excel spreadsheet. Project tests students ability to create a spreadsheet, correctly use relative and absolute references, TODAY function, AVERAGE function, SUM, COUNT, and their ability to use colour, borders and shading to make it attractive and easy to read.
Rubric Code: A2A7WC
By pmoeller
Draft
Public Rubric
Subject: Computers  
Type: Project  
Grade Levels: (none)

Powered by iRubric MS EXCEL PROJECT 1
  Not Quite Yet

D
0-59

0 pts

Basic

C
60-75

2 pts

Competent

B
76-90

3 pts

Exemplary

A
91-100

4 pts

ACCURACY

Evaluating the accuracy of labels and data entered.
Not Quite Yet

Integrity of the data is lost. There are at least 5 errors.
Basic

Some data and labels have been entered correctly. There are between 3 and 4 errors.
Competent

Most data and labels have been entered correctly. There are no more than 2 errors.
Exemplary

All data and labels have been entered correctly. The spreadsheet has perfect integrity. There are 0 errors.
SUM FUNCTION

Not Quite Yet

Integrity of the spreadsheet is significantly compromised. There are at least 5 errors using the SUM function.
Basic

The SUM fucntion has not been used in all apprpriate instances. There are between 3 and 4 errors.
Competent

The SUM function has not been used in all appropriate instances. There are no more than 2 errors.
Exemplary

The SUM function has been used correctly in all appropriate instances. There are no errors with regards to this function.
AVERAGE FUNCTION

Not Quite Yet

The AVERAGE function was not used correctly.
Basic

Where asked the AVERAGE function was used correctly. It was not properly labeled or formated.
Competent

Where asked the AVERAGE function was used correctly. It was labeld and formatted; however, it was not attractive and did not make the information easy to locate and/or read.
Exemplary

Where asked the AVERAGE function was used correctly. It was labeld and formatted appropriately making it attractive, easy to locate and read.
COUNT FUNCTION

Not Quite Yet

The COUNT function was not used correctly.
Basic

Where asked the COUNT function was used correctly. It was not properly labeled or formated.
Competent

Where asked the COUNT function was used correctly. It was labeld and formatted; however, it was not attractive and did not make the information easy to locate and/or read.
Exemplary

Where asked the COUNT function was used correctly. It was labeld and formatted appropriately making it attractive, easy to locate and read.
HEADER / TODAY FUNCTION

Not Quite Yet

There was no header or the header did not contain all the correct information as per the instructions.
Basic

The header contained all the correct information as per the instructions; however, the TODAY function was not used.
Competent

The TODAY function was used; however, the header did not contain all the correct information as per the instructions.
Exemplary

The TODAY function was used in the header AND the header contained all the correct information as per the instructions.
RELATIVE REFERENCES

Not Quite Yet

Relative references are not used as per the instructions.
Basic

As per the instructions relative references were used; however, not in all appropriate formulas. Formatting, colour and borders are used consistently to make the information easy to locate and read.
Competent

As per the instructions relative references were used in all appropriate formulas. Formatting, colour and borders are used; however, the use of them does not make the information easy to locate and/or read.
Exemplary

As per the instructions relative references were used in all appropriate formulas. Formatting, colour and borders are used consistently to make the information easy to locate and read.
ABSOLUTE REFERENCES

Not Quite Yet

Absolute references are not used as per the instructions.
Basic

As per the instructions absolute references were used; however, not in all appropriate formulas. Formatting, colour and borders are used consistently to make the information easy to locate and read.
Competent

As per the instructions absolute references were used in all appropriate formulas. Formatting, colour and borders are used; however, the use of them does not make the information easy to locate and/or read.
Exemplary

As per the instructions absolute references were used in all appropriate formulas. Formatting, colour and borders are used consistently to make the information easy to locate and read.
APPEARANCE

Not Quite Yet

Colour, format and shading have not been used.
Basic

Colour, format and shading techniques have been used; hoever, they make the viewing of the spreadsheet challenging and therefore distract from the data.
Competent

Colour, format and shading techniques have been used; however, they do not optimize the viewing of the spreadsheet.
Exemplary

The use of colour, format and shading enhance the spreadsheet making it easy to read and attractive to the eye.



Keywords:
  • excel, formula, function, format

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
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.

n178