Spreadsheet Data Management and Analysis

Issued by Husson University

Earners of this badge have studied sophisticated techniques for handling and analyzing data in Excel and demonstrated the ability to: administer imports of large data sets and analyze and apply cleansing processes to data sets, create and use worksheet outlines and summarize worksheet data totals and subtotals, apply linking and consolidation of worksheets, apply data validation rules, create a what-if analysis and apply auditing options and settings.

Type Validation
Level Foundational
Time Weeks

Skills

Earning Criteria

Earners will create a spreadsheet of inventory logs, general ledgers, and checklists, which are some examples of data points used in inventory management. This real-world assessment models how a business could track how much inventory they have and when and what they need to order. The inventory spreadsheet should provide insights into top-selling items, which can be tracked by region or season. For this spreadsheet, a large data set will be provided.
Earners will complete a baseball related worksheet to apply sequences of formulas that can be used to input the fundamental game-by-game and player statistics that are crucial for fans to track in order to predict possible game results and calculate how defeats can affect standings. Earners design and implement a data validation rule to the data set and analyze how the rule works, create a what-if analysis to determine how outcomes could change, and audit changes to the data set that was change