Week 5 Major Project BUSN 420

Basic Filter Possible Points Actual Points

Show all information for only customers who

live in the North region. 5

Show all information for only customers who

(a) live in the North region, (b) own their

homes, and (c) have only one household

member.

10

Comments: 15

Custom Filter Possible Points Actual Points

Show all information for customers who have

at least 4 household members. 10

Show all information for customers who (a)

have spent less than $20 or (b) more than

$100.

15

Comments: 25

Conditional Formatting Possible Points Actual Points

Show all information for all customers

highlighting those customers who have spent

more than $100. 10

Comments: 10

Pivot Tables Possible Points Actual Points

Provide a two-dimensional table that counts

the number of customers by the categories of

REGION and RENT vs. OWN. 15

Provide a two-dimensional table that both (a)

counts the number of customers and (b) sums

the TOTAL PURCHASES of customers by the

categories of REGION and RENT vs. OWN.

15

Provide a three-dimensional table that counts

the number of customers by the categories of

REGION, RENT vs. OWN, and NUM

HOUSEHOLD.

20

Comments: 50

Late Deductions

Total Score 100

Overall Comments

BUSN 420 Major Project Grading Rubric