BUSN 420 Major Project Assignment Instructions

Technology plays an essential role in supporting decision-making. This major project will focus on supporting decision-making by exploring some of the features within Microsoft Excel, including the basic filter, custom filter, conditional formatting, as well as pivot tables. Let’s assume that you work for a small business and have been asked to perform the following tasks to aid in various decisions: 1. Show all information for only customers who live in the North region. 2. Show all information for only customers who (a) live in the North region, (b) own their homes, and (c) have only one household member. 3. Show all information for customers who have at least 4 household members. 4. Show all information for customers who (a) have spent less than $20 or (b) more than $100. 5. Show all information for all customers highlighting those customers who have spent more than $100. 6. Provide a two-dimensional table that counts the number of customers by the categories of REGION and RENT VS. OWN. 7. 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. 8. Provide a three-dimensional table that counts the number of customers by the categories of REGION, RENT VS. OWN, and NUM HOUSEHOLD. First, read the attached Extended Learning Module D: Decision Analysis with Spreadsheet Software document. Then, create the requested worksheet summaries listed above. You will need to use Microsoft Excel to complete this assignment. Microsoft Excel is available at no cost to Regent students via the Office 365 application listed in the Course Resources section of our Blackboard course. The attached XLMD_Customer.xlsx data file should be used to complete the assignment. Once you have completed each request, please submit one Excel document, including 8 worksheets illustrating each exercise.

BUSN 420 Major Project Grading Rubric

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

XLMD_Customer

CUST ID	REGION	RENT VS. OWN	NUM HOUSEHOLD	ANNUAL INCOME	TOTAL PURCHASES	NUM PURCHASES
1	North	Own	1	10K-25K	$ 38	1
2	South	Own	4	100K+	$ 30	4
3	North	Rent	3	25K-50K	$ 19	3
4	West	Own	5	25K-50K	$ 21	6
5	East	Own	6	50K-100K	$ 35	7
6	South	Own	2	10K-25K	$ 27	5
7	East	Own	3	100K+	$ 26	3
8	West	Rent	4	25K-50K	$ 25	6
9	North	Own	5	50K-100K	$ 30	8
10	West	Rent	7	25K-50K	$ 26	2
11	North	Own	1	50K-100K	$ 21	4
12	East	Own	2	100K+	$ 29	9
13	South	Own	5	10K-25K	$ 20	7
14	South	Own	4	25K-50K	$ 27	10
15	South	Rent	3	50K-100K	$ 19	2
16	West	Own	5	25K-50K	$ 19	6
17	North	Own	6	50K-100K	$ 129	5
18	East	Rent	2	10K-25K	$ 99	7
19	West	Own	3	25K-50K	$ 99	4
20	North	Rent	1	50K-100K	$ 119	3
21	East	Own	4	50K-100K	$ 149	2
22	South	Own	3	50K-100K	$ 165	8
23	West	Rent	5	25K-50K	$ 119	6
24	North	Rent	6	10K-25K	$ 129	7
25	East	Rent	7	100K+	$ 165	5
26	South	Own	3	10K-25K	$ 99	3
27	West	Rent	2	25K-50K	$ 155	6
28	North	Own	4	50K-100K	$ 115	8
29	East	Own	5	50K-100K	$ 129	1
30	South	Rent	4	50K-100K	$ 99	8
31	West	Own	2	25K-50K	$ 169	6
32	East	Rent	3	25K-50K	$ 40	4
33	East	Own	1	50K-100K	$ 36	7
34	North	Own	6	100K+	$ 45	3
35	North	Own	5	10K-25K	$ 29	1
36	West	Rent	4	100K+	$ 28	4
37	East	Rent	1	25K-50K	$ 46	1
38	South	Rent	5	50K-100K	$ 50	4
39	East	Rent	3	50K-100K	$ 22	6
40	West	Own	6	50K-100K	$ 20	9
41	North	Own	7	25K-50K	$ 19	3
42	East	Own	3	50K-100K	$ 31	1
43	South	Rent	2	50K-100K	$ 30	10
44	West	Rent	4	25K-50K	$ 18	3
45	East	Own	5	25K-50K	$ 31	7
46	South	Own	3	10K-25K	$ 35	6
47	West	Own	7	25K-50K	$ 28	5
48	East	Rent	3	100K+	$ 29	8
49	South	Rent	2	10K-25K	$ 35	6
50	North	Own	6	25K-50K	$ 30	4
51	South	Own	5	50K-100K	$ 38	7
52	West	Own	3	50K-100K	$ 20	3
53	North	Rent	1	25K-50K	$ 40	5
54	East	Rent	5	25K-50K	$ 30	4
55	South	Own	6	25K-50K	$ 40	8
56	West	Rent	3	10K-25K	$ 62	7
57	North	Rent	4	100K+	$ 22	9
58	East	Rent	5	100K+	$ 25	1
59	West	Rent	7	10K-25K	$ 27	4
60	East	Rent	2	25K-50K	$ 22	7
61	South	Own	3	25K-50K	$ 30	4
62	East	Own	1	25K-50K	$ 31	3
63	East	Own	4	50K-100K	$ 22	8
64	South	Rent	2	50K-100K	$ 25	9
65	West	Own	3	25K-50K	$ 24	3
66	East	Own	5	50K-100K	$ 36	2
67	North	Rent	4	50K-100K	$ 123	11
68	North	Rent	6	100K+	$ 19	2
69	North	Own	5	100K+	$ 23	6
70	South	Rent	7	100K+	$ 19	8
71	West	Rent	4	25K-50K	$ 25	6
72	West	Rent	5	50K-100K	$ 129	8
73	North	Own	3	50K-100K	$ 119	9
74	East	Own	6	100K+	$ 109	3
75	North	Own	5	10K-25K	$ 179	6
76	East	Rent	4	100K+	$ 145	5
77	South	Own	2	25K-50K	$ 119	7
78	North	Rent	3	50K-100K	$ 129	2
79	East	Own	4	10K-25K	$ 189	4
80	West	Own	6	50K-100K	$ 155	6
81	North	Rent	5	25K-50K	$ 78	4
82	East	Own	4	25K-50K	$ 61	5
83	South	Rent	3	25K-50K	$ 97	7
84	North	Rent	2	50K-100K	$ 63	2
85	West	Own	4	100K+	$ 39	3
86	East	Rent	6	50K-100K	$ 95	1
87	South	Rent	4	25K-50K	$ 86	Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax. Do you need an answer to this or any other questions? Order Plagiarism Free Answer Here About Wridemy We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers. How It Works To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline. Are there Discounts? All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure. Hire a tutor today CLICK HERE to make your first order Related Tags Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA