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:
A79623
By
jennielfox
Ready to use
Public Rubric
Subject:
Computers
Type:
Project
Grade Levels:
(none)
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
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
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.
Score
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.
Score
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.
Score
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.
Score
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.
Score
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.
Score
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.
Score
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.
n178
Your browser does not support iframes.
Your browser does not support iframes.
Your browser does not support iframes.