Week 3 Minor Project BUSN 420

BUSN 420 Management Information Systems

Minor Project

The following exercises will introduce you to Microsoft Excel Pivot Tables. Having a good

understanding of Pivot Tables will give you an advantage in the business world. When your supervisor

asks you to analyze a large pile of data to solve a problem, you will be able to use a Pivot Table to slice

and dice data to gain information and create usable business intelligence to solve a real-world problem.

Please read the information provided and complete each exercise. Once you have completed all of the

exercises below, submit your Excel and Word documents using the assignment link in Canvas.

Please see the grading rubric at the end of these instructions for more information.

• First, read the attached Tech Plug-In T3: Problem Solving Using Excel document

• Then, review the “Using the PivotTable Feature” section on pages T3-10 through T3-14

• Create Figure T3.17 “Rearranged PivotTable Data” on page T3-13 and Figure T3.18 “PivotChart

Output” on page T3-14

SOLVE A PROBLEM USING A PIVOT TABLE

• Refer to the “Making Business Decision” section of the Tech Plug-In T3: Problem Solving Using

Excel document

• Complete Exercise 2: Coffee Trends

• Develop a PivotTable and PivotTable chart illustrating the top-selling coffee products

• Indicate the top 4 selling coffee products

PIVOT TABLE APPLICATIONS

How have you in the past, or could you in the future, use pivot tables in a business or ministry setting?

Considering the power of Pivot Tables to analyze data, what ethical issues might arise from the

improper usage of this tool to analyze business or ministry data. How should a Christian Worldview

inform these ethical dilemmas?

Please be brief and keep your response to around 300-500 words. Support your response with at

least one peer-reviewed scholarly journal reference.

All 4 sections of the Minor Project should be uploaded in Canvas, including:

1. A Pivot Table illustrating the monthly magazine sales by the sales representative as illustrated in Figure

T3.17 of the assignment instructions.

2. A Pivot Table Chart illustrating the monthly magazine sales by the sales representative as illustrated in

Figure T3.18 of the assignment instructions.

3. A Pivot Table and Chart illustrating the top 4 selling coffee products.

4. A 300 to 500-word essay describing the use of pivot tables and charts in a business or ministry setting.

The following rubric will be used to grade your submissions:

*

BUSN 420 Minor Project Grading Rubric (100 points)

PivotTable Possible

Points

Actual

Points 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

Comments: 25 25

PivotTable Chart 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

Comments: 20 20

Using Pivot Tables to Solve a Problem 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

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

Comments: 25 25

PivotTable Applications 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

reference.

The student has not

supported his or her text

with at least one peer-

reviewed scholarly

journal reference.

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

Comments: 30 30

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

Final Score: 100 100

Overall Comments:

*