Computer Science Question

DAD 220 Project Two Guidelines and Rubric

Competency

In this project, you will demonstrate your mastery of the following competency:

• Analyze the results of queries constructed to address data requirements

Scenario

The product manager of Quantigration has asked your data analytics team for a report summarizing your analysis of the return merchandise authorizations (RMAs) that have been received. These are the same data sets that you’ve already been working with. Your report should focus on summarizing the analysis and presenting your findings to the product manager.

Directions

RMA ReportIn your report, respond to the manager’s requests: to summarize the data you’ve been working with and to identify key information that will help the company streamline operations. Remember, not everyone who reviews this report will have a technical background.

Begin by writing SQL commands to capture usable data (which you’ve preloaded into Codio) for your analysis.

Specifically, the product manager wants you to analyze the following:Analyze the number of returns by state and describe your findings in your report.Analyze the percentage of returns by product type and describe your findings in your report.In your report, clearly summarize your analysis of the data for stakeholders. Include screenshots of the results of each query. When summarizing results, you may want to consider the following questions:How does the data provide the product manager with usable information?What are the potential flaws in the data that has been presented?Are there any limitations on your conclusions, or any other ways of looking at it that you haven’t considered? Clearly communicate your findings to stakeholders.

What to Submit

To complete this project, you must submit the following:

Data Analysis RMA ReportSubmit a report for the product manager summarizing the results of your analysis. Your report will address the analysis that you’ve conducted. Provide screenshots of your SQL queries and their resultant output following the same instructions for capturing screenshots that you were given in previous assignments. Lastly, provide a brief report that summarizes your analysis. Any references must be cited in APA format.

Project Two Rubric

Capture Usable Data

)

Analyze Returns by State and Product Type

Does not attempt criterion (0%)25

Summarize Data AnalysisExceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner (100%)

Does not attempt criterion (0%)25

Articulation of ResponseExceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner (100%)

25

100%

Criteria	Exemplary	Proficient	Needs Improvement	Not Evident	Value
N/A	Captures specific, usable data that can be analyzed by writing proper SQL commands (	100%	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include queries that do not address the identified trends in data (55%)			Does not attempt criterion (0%)				25
		Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner (100%)	Analyzes number of returns by state and percentage of returns by product type (85%)	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include inaccuracies or lack of detail in analysis of queries (55%)
Summarizes analysis of data for stakeholders (85%)	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include insufficient or unclear details to support the summary (55%)
Clearly conveys meaning with correct grammar, sentence structure, and spelling, demonstrating an understanding of audience and purpose (85%)	Shows progress toward proficiency, but with errors in grammar, sentence structure, and spelling, negatively impacting readability (55%)	Submission has critical errors in grammar, sentence structure, and spelling, preventing understanding of ideas (0%)
Total: