Summary

[newellp88]

Rubric Score

Criteria 1: Report: Are conclusions clear and supported by evidence in all eight answers?

• Score Level: 1 (Does Not Meet Expectations)
• _Comment(s):_The purpose of this exercise is to create a report, for a non-user, describing the results from the queries; like a memo to a manager, for example. It was expected to be uploaded as a presentation of some kind: Google Slides, MS PPT, or comparable. More specifically, no text, rationale or context for the results are presented to support any answer.

Criteria 2: Query Accuracy: Do queries do what they were supposed to do?

• _Score Level:_4 (Exceeds Expectations)
• Comment(s): All queries retrieve the data intended. In question #3, SQL is capable of creating a new column from calculations performed on existing columns. So, there is a way to achieve this analysis completely with SQL queries, but it’s not mandatory.

Criteria 3: Query Formatting

• Score Level: 4 (Exceeds Expectations)
• _Comment(s):_Queries and subqueries are formatted according to the SQL style guide. Good job!

Criteria 4: Understanding underlying concepts and terminology

• _Score Level:_3 (Meets Expectations)

• Comment(s): Written queries demonstrate an understanding of the technical concepts and terminology that underpin this project. However, without adequate context or interpretation of the results, it is difficult to determine the level of understanding attained.

  Overall Score: 12/16

  You did a good job writing the specific queries to retrieve the desired data. A key part of any analyst’s job is to present and describe the results of a data inquiry or analysis to other stakeholders. This project is designed to combine technical skills (SQL queries) and analysis to mimic that reality. Unfortunately, while the code and query results look good they would be indecipherable to most external viewers.

[AshleyN2018]

Thank you for your review. I am not sure I understand how to rectify what I missed? Also, I thought I read that overall score would be 1-5 and anything 3 or below would have a chance to fix and resubmit?

[newellp88]

Hi Ashley, the project asks learners to produce a report with text summarizing the information provided by the queries. While you did really well with the actual queries, the presentation isn't very coherent. You can check the project definition, template and rubric again here.

There are four components in total for this project, scored on a scale from 1-4. You should be okay with the current score, but if not I'd be happy to review your re-submission. If you do decide to resubmit, I encourage you to use the proper document formats. There should be a PPT-like presentation and a .sql file, per the project definition.

[AshleyN2018]

Does my current score warrant a certificate?

On Wed, Oct 24, 2018, 8:56 AM Peter Newell notifications@github.com wrote:

Hi Ashley, the project asks learners to produce a report with text summarizing the information provided by the queries. While you did really well with the actual queries, the presentation isn't very coherent. You can check the project definition, template and rubric again here https://www.codecademy.com/articles/sql-scratch-capstone-funnels.

There are four components in total for this project, scored on a scale from 1-4. You should be okay with the current score, but if not I'd be happy to review your re-submission. If you do decide to resubmit, I encourage you to use the proper document formats. There should be a PPT-like presentation and a .sql file, per the project definition.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AshleyN2018/sql-scratch-capstone-turn-in/issues/1#issuecomment-432667465, or mute the thread https://github.com/notifications/unsubscribe-auth/Aor18Jn1Fhrl_DelCLfIKVsVqNkkxY0Rks5uoHGbgaJpZM4XyevA .

[newellp88]

Yes, you will still get a certificate with this score.