eggarcia28 / codecademy_capstone Goto Github PK

Rubric Score

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

• Score Level: 3/4
• Comment(s): Your presentation look really good! It was well put together and each of your conclusions included the necessary evidence in the form of data and queries. Here are a few notes and recommendations that I jotted down.

1. It looks like you may have forgotten to include the things that were asked in question 1 (e.g. the columns does the survey table have? Show a sample of data from the survey table? etc.)

2. You might want to take a look at some of your heading slides (e.g. slide 8 and 12). I'm not sure what happened but the headings do not display and a white box is shown instead.

3. I liked seeing your extra analysis on the last few slides, but in the future don't forget to provide actual data insights or conclusions that you have drawn based on this data. If you pretend this was a real life presentation, business leaders would be left wondering "so what" from the last 2 slides. You should take these facts and draw actual business conclusions that can be acted upon such as

• Black is the most populate color, so we should make sure that the most popular models include a black option.
• Users tend to purchase more of models that are in the $95 range, so we should introduce additional models at that price point.
• etc.

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

• Score Level: 4/4
• Comment(s): Nicely done! Each of your queries correctly manipulate the data to produce the desired piece of analysis.

In the future watch out for how you save and share your queries. It looks like you probably authored your code.sql file in wordpad (or similar app that creates a rich text formatted file...or rtf) but then changed the file extension to .sql. The result of this causes some unexpected results where aspects of the rtf raw format is included in your file. See below for an example.

Instead I would recommend using a text file to store your queries because it is then safe to change the file extensions to .sql

Criteria 3: Query Formatting

• Score Level: 4/4
• Comment(s): Once I downloaded your code.sql file and changed the extension back to .rtf and opened it in Word (or wordpad), your formatting looked great!

Criteria 4: Understanding underlying concepts and terminology

• Score Level: 4/4
• Comment(s): It is very clear that you have a great understanding of the underlying concepts and terminology at play here. Nice job!

Overall Score: 15/16

Overall you did a fantastic job on this project! Be sure to checkout the details above for more specific info and keep up the great work!