Skip to main content
sign in
Username
Password
forgot?
Sign up
Share
help_outline
help
Pricing
Request Info
Please enable JavaScript on your web browser
menu
iRubric: MS Excel Level 1 rubric
find rubric
Your browser does not support iframes.
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:
N38B2A
By
eroberson
Ready to use
Public Rubric
Subject:
Computers
Type:
Project
Grade Levels:
6-8
Your browser does not support iframes.
Desktop Mode
Mobile Mode
MS EXCEL PROJECT 1
Not Quite Yet
0 pts
Basic
2 pts
Competent
3 pts
Exemplary
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.
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:
Computers
Types:
Project
Discuss this rubric
You may also be interested in:
More rubrics by this author
More Computers rubrics
More Project rubrics
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 iRubric
tm
.
Copyright © 2024
Reazon Systems, Inc.
All rights reserved.
n232
Your browser does not support iframes.
Your browser does not support iframes.
Your browser does not support iframes.