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: Data Analysis/PivotTables rubric
find rubric
Your browser does not support iframes.
edit
print
share
Copy to my rubrics
Bookmark
test run
assess...
delete
Do more...
Data Analysis/PivotTables
Advanced MS Excel FUNctions
Rubric Code:
Z2WX24
By
kwhelpley
Ready to use
Public Rubric
Subject:
Computers
Type:
Assignment
Grade Levels:
9-12
Your browser does not support iframes.
Desktop Mode
Mobile Mode
DATA ANALYSIS/PIVOT TABLES
Poor
1 pts
Fair
2 pts
Good
3 pts
WEBSITE LINK
Poor
No heading
Link does not work
Fair
Correct heading entered in cell A7
Linked correctly to website
Incorrect area selected on website
Good
Correct heading entered in cell A7
Linked correctly to website
Correct area selected on website
FREIGHT WORKSHEET
Poor
Formulas missing
Attempted macro but did not work
Not sorted in Ascending order
Fair
Correct formulas entered in cells
Macro created but not in correct format for slogan
Not sorted in Ascending order
Good
Correct formulas entered in correct cells
Sorted correctly in Ascending order
Macro created in correct format for slogan
Correct cell linked to correct cell in Inventory Sheet
Link works properly
INVENTORY WORKSHEET
Poor
Formula missing
Scenario Manager attempted but not successful
Fair
Correct formula entered in correct cell to calculate profit margin and retail price
Scenario Manager created but with incorrect number of scenarios
Good
Correct formula entered in correct cell to calculate profit margin and retail price
Scenario Manager created for (3) scenarios
Scenario Manager function works
PIE CHART
Poor
Incorrect Pie Style
Title missing
Percentages missing
Colors not enhanced
Fair
Correct pie style used
Incorrect title OR
Not new sheet OR
Colors not changed OR
Percentages not shown
Good
Correct pie style used
Correct title included
Created as a New Sheet
Colors are changed to enhance
Percentages are shown
PIVOT TABLE
Poor
PivotTable unsuccessful
Fair
PivotTable is executed correctly, but not summarized by SUM
Good
PivotTable is executed correctly
PivotTable is summarized by SUM, not AVERAGE
PIVOT CHART
Poor
PivotChart not executed correctly; not display lists and not color change
Fair
PivotChart does not display lists
Colors are changed and enhanced
Good
PivotChart displays field lists accurately
PivotChart colors are changed and enhanced
Keywords:
PivotTables
Subjects:
Computers
Types:
Assignment
Discuss this rubric
You may also be interested in:
More rubrics by this author
More Computers rubrics
More Assignment 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.