SLO Assigment

Handout and Rubric for Final Exam SLO Assignment – Excel Skills Demonstration

This assignment will demonstrate that the student is capable of using Excel to perform a variety of statistical, probabilistic and graphic functions. Excel is a powerful program that enables statistical analysis through the use of data entry, data manipulation, sorting and the use of functions that cover the gamut of probabilistic and statistical methods.

EXEMPLARY

(150)

PROFICIENT

(120)

DEVELOPING

(105)

EMERGING

(<104)

Excel

worksheets

130 The worksheets

are complete and

Excel functions

have been used to

sort and perform

regression.

Conclusions for

future

performance are

complete and

logical

105

The worksheets

are complete and

Excel functions

have been mostly

used to sort and

perform

regression.

Conclusions for

future

performance are

complete and

mostly logical

95

The worksheets are

somewhat complete

and Excel functions

have been mostly

used to sort and

perform regression.

Conclusions for

future performance

are complete but do

not flow from data

<94

The worksheets

are inconsistent

and Excel

functions have

rarely been used

to sort and

perform

regression.

Conclusions for

future

performance are

inconsistent and

illogical

Use of

Excel

20 Uses Excel

proficiently

15

Uses Excel, but

with some errors.

10

Uses Excel, but

with several errors.

<10

Does not use

Excel but uses

another program