- Username
- Password
forgot?

iRubric: Data Analysis/PivotTables rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Data Analysis/PivotTables Data Analysis/PivotTables Advanced MS Excel FUNctions Rubric Code: YAB55W By aryanromo Ready to use Public Rubric Subject: Computers Type: Assignment Grade Levels: 9-12

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