BUSN 420 Major Project Assignment Instructions<\/p>\n
Technology plays an essential role in supporting decision-making. This major project
\nwill focus on supporting decision-making by exploring some of the features within
\nMicrosoft Excel, including the basic filter, custom filter, conditional formatting, as well as
\npivot tables. These tools allow for efficient data manipulation and analysis. Understanding their application is crucial for informed decision-making.<\/p>\n
Let\u2019s assume that you work for a small business and have been asked to perform the
\nfollowing tasks to aid in various decisions:<\/p>\n
Show all information for only customers who live in the North region. This task utilizes the basic filter functionality within Excel. It demonstrates how to isolate specific data based on a single criterion.
\nShow all information for only customers who (a) live in the North region, (b) own their homes, and (c) have only one household member. This exercise expands on basic filtering by incorporating multiple criteria. It showcases the power of combining conditions for more refined data retrieval.
\nShow all information for customers who have at least 4 household members. This task introduces the concept of filtering based on numerical values. It highlights the ability to select data based on comparative operators.
\nShow all information for customers who (a) have spent less than $20 or (b) more than $100. Here, the focus is on filtering with “OR” conditions. This allows for the selection of data that meets either of two specified criteria.
\nShow all information for all customers highlighting those customers who have spent more than $100. This task shifts from filtering to conditional formatting. It demonstrates how to visually highlight data based on specific conditions.
\nProvide a two-dimensional table that counts the number of customers by the categories of REGION and RENT VS. OWN. This introduces the concept of pivot tables for data summarization. It shows how to create a table that counts occurrences based on two categories.
\nProvide 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. This task builds upon the previous one by adding a summation component. It demonstrates how to calculate aggregate values within a pivot table.
\nProvide a three-dimensional table that counts the number of customers by the categories of REGION, RENT VS. OWN, and NUM HOUSEHOLD. Finally, this task explores the creation of multi-dimensional pivot tables. It showcases the ability to analyze data across three different categories. 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. The module provides valuable context and guidance for completing the tasks. It is essential to review it before proceeding. Microsoft Excel is available at no cost to Regent students via the Office 365 application. This accessibility ensures that all students have the necessary tools for the assignment. Familiarity with Excel is a valuable skill in today’s business environment. The XLMD_Customer.xlsx data file should be used to complete the assignment. This file contains the data required for each of the exercises. Careful analysis of this data is key to successful completion. Once you have completed each request, please submit one Excel document, including 8 worksheets illustrating each exercise. Each worksheet should clearly demonstrate the results of the corresponding task. Proper labeling and formatting are crucial for clarity.
\nBUSN 420 Major Project Grading Rubric
\nBasic Filter Possible Points Actual Points
\nShow all information for only
\ncustomers who live in the North
\nregion.
\n5
\nShow all information for only
\ncustomers who (a) live in the North
\nregion, (b) own their homes, and (c)
\nhave only one household member.
\n10
\nComments: 15
\nCustom Filter Possible Points Actual Points
\nShow all information for customers
\nwho have at least 4 household
\nmembers.
\n10
\nShow all information for customers
\nwho (a) have spent less than $20 or
\n(b) more than $100.
\n15
\nComments: 25
\nConditional Formatting Possible Points Actual Points
\nShow all information for all customers
\nhighlighting those customers who
\nhave spent more than $100.
\n10
\nComments: 10
\nPivot Tables Possible Points Actual Points
\nProvide a two-dimensional table that
\ncounts the number of customers by
\nthe categories of REGION and RENT
\nvs. OWN.
\n15
\nProvide a two-dimensional table that
\nboth (a) counts the number of
\ncustomers and (b) sums the TOTAL
\nPURCHASES of customers by the
\ncategories of REGION and RENT vs.
\nOWN.
\n15<\/p>\n
Data Analysis and Decision-Making with Microsoft Excel<\/p>\n","protected":false},"excerpt":{"rendered":"
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. These tools allow for efficient data manipulation and analysis. Understanding their […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7904,13079,13080,13081,13082,13083,11856,11095,11818,13084],"tags":[13085,13094,13087,13095,13092,13093,13091],"class_list":["post-139154","post","type-post","status-publish","format-standard","hentry","category-human-resource-management-assignment-help","category-business-finance-homework-help","category-business-and-management-homework","category-business-studies-assignment","category-management-assignment-help-uk","category-project-management-assignment-help","category-project-management-homework-help","category-research-project-writers","category-write-a-project-management-assignment","category-write-my-management-assignment","tag-busn-420","tag-conditional-formatting","tag-data-analysis","tag-data-analysis-and-decision-making-with-microsoft-excel","tag-excel","tag-filtering","tag-pivot-tables"],"_links":{"self":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/139154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/comments?post=139154"}],"version-history":[{"count":1,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/139154\/revisions"}],"predecessor-version":[{"id":139156,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/139154\/revisions\/139156"}],"wp:attachment":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/media?parent=139154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/categories?post=139154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/tags?post=139154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}