BS/MIS Goal 1 Objective 1: 'Skills and Application'



Application of Business Technologies Rubric

| |3: Exceeds Standards |2: Meets Standards |1: Fails to Meet Standards |

|Spreadsheet/Database Interface Skills (Excel file) |

|Data Extraction |Creates an Excel file containing a worksheet |Creates an Excel file containing a worksheet |Fails to create Excel file/worksheet; or large |

| |comprising of columnar data imported through an|comprising of columnar data imported through an|amounts of data are missing/distorted; or data |

| |interface with the requisite Microsoft Access |interface with a Microsoft Access database |appear entered by means other than an interface|

| |database query. |query that is similar to, but other than, that |with a database query. |

| | |specified. | |

|Data Reorganization |Creates a functional PivotTable and a |Creates a functional PivotTable or a functional|Creates a new chart within the Excel file, |

| |functional PivotChart within the Excel file, |PivotChart within the Excel file, based on the |based on the imported columnar data, but does |

| |based on the imported columnar data. |imported columnar data, but not both. |not format it as a PivotChart, and does not |

| | | |create a PivotTable. |

|Data Integrity |All data items occupying the ROW, COLUMN, DATA,|The data item occupying the DATA field in the |The data item occupying the DATA field in the |

| |and PAGE fields in the PivotTable and |PivotTable/PivotChart is the one whose values |PivotTable/PivotChart is one whose values are |

| |PivotChart are exactly as specified. |are measurable via a "ratio" or "interval" |measurable only via a "nominal" or "ordinal" |

| | |scale. Only some of the other data items are in|scale, rather than a "ratio" or "interval" |

| | |their specified spots. |scale. |

|Application to Business Environment (Word processed report) |

|Information Extraction |Report contains comparative observations likely|Report contains some comparative observations |Report contains few or no observations that are|

| |obtained by interactive use of the |likely obtained by interactive use of the |comparative in nature. |

| |PivotTable/PivotChart, equal to or greater than|PivotTable/PivotChart, but fewer than the | |

| |the required number. |required number. | |

|Information Relevance |All observations are interpreted in the |Some observations are interpreted in the |Few or no observations are interpreted in the |

| |language of various business constructs, making|language of various business constructs, making|language of business constructs, and do not |

| |them meaningful for lower- and mid-level |them meaningful for lower- and mid-level |provide much meaning for lower- and mid-level |

| |managerial decision making. |managerial decision making. |managerial decision making. |

Scoring Key:

____ Exceeds standards 13 – 15

____ Meets standards 9 - 12

____ Fails to meet standards ≤ 8

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download