is a great place to find real-world datasets.
In this project you will:
Explore Kaggle. Search for a dataset on a topic that interests you. Examine the dataset. Is it what you are looking for?
Once you have found a dataset that you are interested in, import it into XAMMP.
Make sure you understand whether:
Open/Copy the screenshot document and save it in a project location in Google drive so that you can easily find it.
Paste a screenshot of the structure of your database table where indicated.
Design at least 3 SQL queries which analyze the dataset and output a meaningful result.
See the SQL Rubric below to guide you.
Paste screenshots of your queries into the screenshot document where indicated.
Generate at least 1 meaningful chart which clearly visualizes some aspect of a query that you produced.
See the Chart Rubric below to guide you.
Paste screenshots of your charts into the screenshot document where indicated.
Write a report (500 words) based on your findings. The report should:
Tip: write the document first, format it later.
| Grade | Description |
|---|---|
| A | There are atleast 3 SQL query screenshots in the screenshot document. At least one of the queries is adequately complex using SELECT, COUNT, SUM/MIN/MAX/AVG etc, GROUP BY, ORDER BY and possibly wildcard(s) and/or calculated field(s). |
| B | There are atleast 3 SQL query screenshots in the screenshot document. None of the queries are as complex as described in A. |
| C | There are less than 3 SQL query screenshots in the screenshot document, regardless of complexity. |
| Grade | Description |
|---|---|
| A | There is at least 1 chart screenshot in the Screenshot document. A link to the Google Sheet hosting the chart was submitted by the deadline. The chart is appropriately titled. The axes are appropriately labeled. It is clear what the chart is telling the audience. |
| B | There is at least 1 chart screenshot in the Screenshot document. The chart may be missing a title or labels, making it unclear what the chart is telling the audience. |
| C | There is atleast one chart but there is no title and there are no labels. The chart is a complete mystery. |
| Grade | Description |
|---|---|
| A | The Google Document meets the requirement, fully matches the specification and meets the word limit (500 words). Note, the examiner will only read up to the word limit. The document is submitted by the deadline. |
| B | The Google Document may be missing aspects of the specification but still meets the word limit. It matches most of the requirements stated above and is submitted by the deadline. |
| C | The document misses the word limit by more than 20%, regardless of how accurately it follows the document specification, and regardless of how it matches the requirements stated above. The document was submitted by the deadline. |
| D | The document doesn't meet a C band and may not have been submitted. At the teacher's discretion a D can be awarded if it is clear that the student worked on the report during the project period. |
A This project was well thought out. The student took time to find an appropriate data set that he was interested in. This was motiviating.
The SQL queries are appropriately complex.
The chart is clearly labelled as per the requirement.
The report did not result in any warning once submitted into TurnItIn and another AI checker.
The report followed the specification accurately.
B The student found a basic dataset quite quickly, possibly regretting the restrictive nature of the dataset.
The SQL queries do not display any particular complexity and this could be due to the restrictive nature of the chosen dataset.
The chart is clearly labelled as per the requirement.
The report did not result in any warning once submitted into TurnItIn and another AI checker.
The report did not follow the specification accurately - a missed opportunity.