Skip to main content
iRubric: MS Excel Level 1 rubric

iRubric: MS Excel Level 1 rubric

find rubric

edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
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: LXXB6B2
Ready to use
Public Rubric
Subject: Computers  
Type: Project  
Grade Levels: 6-8

Powered by iRubric MS EXCEL PROJECT 1
  Not Quite Yet

0 pts

Basic

2 pts

Competent

3 pts

Exemplary

4 pts

Score

(N/A)

ACCURACY

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.
Score
CREATE BAR CHART

Not Quite Yet

The BAR CHART function was not created or labeled correctly.
Basic

It was labeled but did not contain the right cell information.
Competent

BAR CHART was labeled and formatted; however, it did not make the information easy to locate and/or read.
Exemplary

BAR CHART was labeled and formatted appropriately making it attractive, easy to locate and read.
Score
CREATE PIE CHART IN 3-D

Not Quite Yet

The PIE CHART function was not created or labeled correctly.
Basic

It was labeled but did not contain the right cell information.
Competent

PIE CHART was labeled and formatted; however, it did not make the information easy to locate and/or read.
Exemplary

PIE CHART was labeled and formatted appropriately making it attractive, easy to locate and read.
Score
APPEARANCE

Not Quite Yet

Colour, format and shading have not been used.
Basic

Color, format and shading techniques have been used; however, 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.
Score
PRINTING ORIENTATION

Not Quite Yet

All spreadsheets and charts are printed incorrectly.
Basic

Two or more activities are printed incorrectly.
Competent

All but 1 are printed in the correctly.
Exemplary

All spreadsheets and charts are printed showing formulas and in the correct orientation.
Score



Keywords:
  • excel, formula, function, format

Subjects:

Types:





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.



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