search

efird3fy / sql-scratch-capstone-turn-in

0 stars 0 forks source link

Summary #2

Open siyuan126 opened 5 years ago

siyuan126 commented 5 years ago

Criteria 1: Report Score Level: 2 (Approaches Expectations) Comment(s): Each slide has a huge Cool-tshirts, INC logo that takes too much space and overlap with the contents. Every answer is expected to have three components: 1) SQL queries, 2) output tables as evidence, 3) text interpreting the query results. However, for the first question: how many sources and campaigns, the respective query was put on the next slide, please keep the three components on the same slide, just as what you did to other questions. There are 8 questions for this project, the answers for two questions are missing: the user journey and the recommendation.

Criteria 2: Query Accuracy Score Level: 3 (Meets Expectations) Comment(s): All queries accurately retrieve the data intended.

Criteria 3: Query Formatting Score Level: 4 (Exceeds Expectations) Comment(s): Queries adhere to the rules of the style guide. Good work using aliases to rename the columns and using indentation to organize your subqueries, both make your queries more readable!

Criteria 4: Understanding underlying concepts and terminology Score Level: 2 (Approaches Expectations) Comment(s): Report demonstrates a partial understanding​ of connections between UTM parameters, marketing touchpoints, and touch attribution. Terms are used​ correctly. The user journey question needs you to investigate the purchase through different source and campaigns, and based on the findings to make recommendation. There is no purchase data shown in your report

Overall Score: 11/16 Here are some tips. Please think about how to answer the two questions, query the data you need, and try to explain the results. Remove the company logo from the slides or adjust their size.

efird3fy commented 5 years ago

Thanks, Yuan. Am I allowed to resubmit the content of the report for additional credit?

efird3fy commented 5 years ago

I have attached an amended PDF copy of the report.

I don't see anywhere in the rubric (see below) where the inclusion of logos are identified as grounds for reducing a grade. Furthermore, the rubric does not stipulate that a table must accompany each answer - only that the query results accompany each answer, which they do.

I haven't gone to any great lengths SQL+Capstone+Templates COOL TSHIRT - FIRDYIWEK.pdf to change the content of the report but will do so if you feel that I can receive a higher score on this project or if my current score puts me at risk of not receiving my certificate.

Thanks, Ephraim

https://s3.amazonaws.com/codecademy-content/programs/learn-sql-from-scratch/attribution-capstone-rubric-for-learners.pdf