Week 3 Minor Project BUSN 420

Excellent/Good Fair/Poor Demonstrates knowledge of the

PivotTable wizard by accurately

placing the field buttons onto the

PivotTable grid. The PivotTable

represents the information presented

in Figure T3.17 with the magazine in

the page area, the month in the

column area, the sales rep field in the

row area, and the sale field in the data

area.

Demonstrates limited

knowledge of the PivotTable

wizard through inaccurately

placing the field buttons onto

the PivotTable grid. The

PivotTable has the information

presented in Figure T3.17,

however the information is not

in the same order.

10 10

The monthly totals and grand totals

exactly match the totals in Figure

T3.17.

The monthly totals and grand

totals are different from the

totals in Figure T3.17. 5 5

The Sales Rep field list is in

alphabetical order (A to Z).

The Sales Rep field list is not

in alphabetical order (A to Z). 5 5

The monthly sales total columns are

listed in order starting with January.

The monthly sales total

columns are not listed in order

and do not start in January. 5 5

25 25

Possible Points Actual Points

The PivotTable chart is in column

format as illustrated in Figure T3.18.

The PivotTable chart is not in

column format. 8 8

The sales rep columns are listed in

alphabetical order (A to Z).

The sales rep columns are not

listed in alphabetical order (A

to Z). 7 7

The chart legend is located on the

right side of the chart.

The chart legend is not located

on the right side of the chart. 5 5

20 20

Possible Points Actual Points

The pivot table and chart have been

properly constructed from the provided

data.

The pivot table and chart have

not been properly constructed

from the provided data. 10 10

The pivot table and chart clearly

identify the top four selling coffee

products.

The pivot table does not

clearly identify the top four

selling coffee products. 10 10

PivotTable

BUSN 420 Minor Project Grading Rubric (100 points)

Comments:

Using Pivot Tables to Solve a Problem

PivotTable Chart

Comments:

Possible Points Actual Points

The student has made a clear

recommendation that identifies the top

four selling coffee products.

The student has not made a

clear recommendation that

identifies the top four selling

coffee products.

5 5

25 25

Possible Points Actual Points

The student has provided robust

examples of the use of Pivot Tables.

The student has provided

minor examples of the use of

Pivot Tables. 10 10

The student has supported his or her

text with at least one peer-reviewed

scholarly journal references.

The student has not supported

his or her text with at least one

peer-reviewed scholarly

journal references.

5 5

The student has kept close to the 300-

500 word count requirement.

The student has strayed

significantly from the 300-500

word count requirement. 5 5

Spelling, punctuation, grammar, and

APA formatting are stellar.

Spelling, punctuation,

grammar, and APA formatting

are poor. 10 10

30 30

100 100Final Score:

Overall Comments:

Comments:

PivotTable Applications

Comments:

Late deductions (e.g., -10):