Assignment 2: Data Analysis
Due: Monday, 9:00 am (eastern), Week 6 (Weight: 20%)
Overview
This assignment picks up where the last one left off. Having accurately framed the core problem/opportunity in Assignment 1, you will now turn your attention to collecting, organizing, and analyzing the data you are using to test your hypothesis. You are not yet ready to propose a specific action plan for your business. You will focus on evaluating what data you have and don’t have, and on identifying patterns, trends, and anomalies. Because you can never have complete data, your analysis must acknowledge what you know and what you don’t know. But, even with incomplete data, your actions must be reasonable given the time frame and resources you have. Those actions – your strategic plan – will be developed in Assignment 3.
Instructions
For this assignment, you will build on your first assignment by including an additional 3 to 4 pages to present your analysis of the data. Your submission must include the work you did in Assignment 1 and must provide relevant and quantifiable data, models, calculations, and analysis. Use the topics below to organize this section of your Board Brief:
1. Data Sources and Reliability
a. What data were the most critical to the analysis of the problem/opportunity you identified in Assignment 1? Explain.
b. What sources did you use to gather the data?
c. How reliable and complete are the data you are using? What steps did you take to validate this?
d. What data are unknown (or unknowable) at this stage? How does this impact your analysis?
2. Data Tools and Analysis
a. Drawing from the “Types of Analysis” guide and other resources from the course, what tools and techniques have you used in your analysis? Why did you select these?
b. Applying the analysis tools to your selected data, what patterns, trends, and anomalies did you uncover?
c. How do these patterns, trends, and anomalies shed light on the problem/opportunity you identified?
d. Leveraging your work in the Discussion Questions and the guidance from our course materials, include charts, tables, and/or other visual supports to ensure that your data tells a clear story that your reader can easily understand.
3. Conclusion and Action Items
a. What does your analysis tell you about where you should focus your efforts to drive meaningful improvement?
Formatting and Submission Requirements
• Submit your work in Word
• Include a cover page containing the title of the assignment, your name, your professor’s name, and the course title and date
• Include a references page with your sources
• The cover page and the references page are not included in the required page length
• Use professional font (Times New Roman or Arial), 10-12 font size, and double-space
• Headings are used to identify main topics and subtopics
• Paragraphs are separated by a single space
Rubric: Assignment 2
Criteria |
Unsatisfactory |
Low Pass |
Pass |
High Pass |
Honors |
1. Data Sources and Reliability
Weight:25%
|
Response was missing, |
Provided a |
Provided a |
Response treatment of all 4 |
Met HP criteria plus added data |
2. Data Tools and Analysis
Weight: |
Did not submit an adequate |
Submitted a complete and |
Submitted a complete and |
Submitted a complete and wellreasoned treatment of all 3 |
Met HP
|
3. Data Presentation
Weight: |
Data |
Data |
Data anomalies |
Data |
Met all HP |
4. Conclusions and Action Items
Weight: |
Conclusions |
Conclusions and action |
Conclusions and action |
Conclusions and action items and opportunities
|
Met all HP |