Student’s Name: ______Evaluator’s Name ______
Date: ______Course: ______3/4/2008
Application of Business Technologies Rubric
3: Exceeds Standards / 2: Meets Standards / 1: Fails to Meet StandardsSpreadsheet/Database Interface Skills (Excel file)
Data Extraction / Creates an Excel file containing a worksheet comprising of columnar data imported through an interface with the requisite Microsoft Access database query. / Creates an Excel file containing a worksheet comprising of columnar data imported through an interface with a Microsoft Access database query that is similar to, but other than, that specified. / Fails to create Excel file/worksheet; or large amounts of data are missing/distorted; or data appear entered by means other than an interface with a database query.
Data Reorganization / Creates a functional PivotTable and a functional PivotChart within the Excel file, based on the imported columnar data. / Creates a functional PivotTable or a functional PivotChart within the Excel file, based on the imported columnar data, but not both. / Creates a new chart within the Excel file, based on the imported columnar data, but does not format it as a PivotChart, and does not create a PivotTable.
Data Integrity / All data items occupying the ROW, COLUMN, DATA, and PAGE fields in the PivotTable and PivotChart are exactly as specified. / The data item occupying the DATA field in the PivotTable/PivotChart is the one whose values are measurable via a "ratio" or "interval" scale. Only some of the other data items are in their specified spots. / The data item occupying the DATA field in the PivotTable/PivotChart is one whose values are measurable only via a "nominal" or "ordinal" scale, rather than a "ratio" or "interval" scale.
Application to Business Environment (Word processed report)
Information Extraction / Report contains comparative observations likely obtained by interactive use of the PivotTable/PivotChart, equal to or greater than the required number. / Report contains some comparative observations likely obtained by interactive use of the PivotTable/PivotChart, but fewer than the required number. / Report contains few or no observations that are comparative in nature.
Information Relevance / All observations are interpreted in the language of various business constructs, making them meaningful for lower- and mid-level managerial decision making. / Some observations are interpreted in the language of various business constructs, making them meaningful for lower- and mid-level managerial decision making. / Few or no observations are interpreted in the language of business constructs, and do not provide much meaning for lower- and mid-level managerial decision making.
Scoring Key:
____ Exceeds standards 13 – 15
____ Meets standards 9 - 12
____ Fails to meet standards ≤ 8