Using the questions you laid out in class, and the skills we learned for Sorting, Filtering and Grouping with Pivot Tables, answer the questions you wrote that belong to those categories.

By Thursday, July 17, you should hand in:

1. The spreadsheet you made in class listing out questions, their categories, and a new column listing the answer to each of the questions that fits in one of our three categories.

2. The data you are using, pertaining to your individual beat, with some sorting, filtering and Pivot Tables used to get to your answers.

3. A notes memo describing the process you went through (in bullet points) to get to those answers.

4. A paragraph-long pitch of what you are planning on covering for your final project.

Please also remember to add your Data Story Link to the spreadsheet by Wednesday at 6pm.