Month: March 2023

Project Video Presentation

Due: Wednesday, 4/26

Form to opt-in for comments/feedback on report/video

General Directions

The project video presentation is intended to provide a high-level overview of your project to an audience of your peers (that is, individuals who have a reasonable knowledge of data science but are not experts in your particular project topic). Presentation recordings will be made available to the entire class (through Sakai, so not available outside of the class). The presentation should demonstrate your ability to communicate the significance and interpret the findings of your research project. The presentation should stand on its own so that it makes sense to someone who has not read your proposal or prototype.

Your group should create a video recording of your presentation in which every group member speaks and in which you use a visual aid such as presentation slides. The easiest way to do this is to simply hold a zoom call with all members of your project group, share your screen with your presentation slides, and record either locally or to the cloud (see Zoom recording help information). If this is not possible, you can also record portions individually and combine the recordings (though this will require additional editing work). In the end, we will ask for a URL to your complete recording, so you can either provide a share link to a zoom cloud recording or you can record locally and then upload your recording to Duke Box, Warpwire, or any other cloud platform that we can access such that we can view your recording directly online (we should not need to download to view the recording). Ensure that anyone with the link can view the recording.

In terms of length, the presentation should be between 8 and 12 minutes. You can have as many slides as are necessary, but a typical pace has 1-2 slides per minute, so 8-24 slides total would be reasonable. Your slides should prioritize well-labeled figures or visualizations and use text sparingly to emphasize important points. The text should also be large enough that it is reasonably easy to read. When you are finished, you will submit a pdf of your slides to Gradescope under the assignment “Project Video Presentation.” Be sure to include your names and NetIDs in your final document and use the group submission feature on Gradescope.  Your first slide should include the URL where we can view the recording of your presentation.

Grading

  • E (Exemplary, 10pts) – Video presentation is between 8 and 12 minutes.
  • S (Satisfactory, 9 pts) – Video presentation is over 12 minutes.
  • N (Not yet, 6pts) – Video presentation does not reach 8 minutes.
  • U (Unassessable, 2pts) –  Video presentation is missing or does not demonstrate meaningful effort.

Part 0: Title Slide

The very first slide of your presentation should be a title slide containing at least the below information. It does not need to be in the actual video recording.

  • A descriptive title of your project/presentation, not “CS216 Presentation Video”
  • Names of all group members
  • URL to the video recording of your presentation

Grading

  • E (Exemplary, 10pts) – Work that meets all requirements.
  • N (Not yet, 6pts) – Does not meet all requirements.

Part 1: Introduction and Research Questions

Your presentation should begin by introducing your topic generally and posing your research questions. Provide some explanation of the relevance or motivation of your research questions.

Grading

  • E (Exemplary, 20pts) – General introduction to topic and clearly defined research questions and their motivations.
  • S (Satisfactory, 19pts) – General introduction to topic and clearly defined research questions. Discussion of motivations may be missing.
  • N (Not yet, 12pts) – General introduction to topic. Research questions and motivations are not clearly defined.
  • U (Unassessable, 4pts) – Introduction and research questions are missing or do not demonstrate meaningful effort.

Part 2: Data Sources

Discuss the data you collected and used to answer your research questions. Be specific: name the datasets you are using, the information they contain, and where they were collected from/how they were prepared.

Grading

  • E (Exemplary, 20pts) – Origins of data are properly specified, cited, and include discussion of what information they contain. Any relevant data wrangling, cleaning, or other data preparation is explained.
  • S (Satisfactory, 19pts) – Origins of data are properly specified, cited, and include discussion of what information they contain. Any relevant data wrangling, cleaning, or other data preparation may be missing or could be improved.
  • N (Not yet, 12pts) – Poorly specified data sources and lack of discussion of preparing the dataset.
  • U (Unassessable, 4pts) – Discussion of data sources and data preparation are missing or do not demonstrate meaningful effort.

Part 3: Results

Describe your results. Where possible, provide well-labeled and legible charts/figures in your slides to summarize results instead of verbose text. Interpret the results in the context of your research questions. It may not be possible to describe every individual result from your project in a brief amount of time. Focus on the most important and essential results for addressing your research questions. Please note that a screenshot of your dataset does not count as a table or figure and should not be included in your video presentation.

Unlike your final report, it is not generally possible to describe your methods in sufficient detail in a short presentation so that an informed audience member could reproduce your results. Instead, you should focus on your results and their interpretation, and only discuss methods at a high level such as may be necessary to interpret the results.

Example of Interpreting results

Do not: “When we conducted our hypothesis test, we found that p < 0.05, so our results are significant.”

Do: “Since our p-value is significant, we could determine that generation 1 pokemon have a different popularity than all other pokemon. And since the mean popularity of generation 1 is higher than the mean of all the other pokemon, we can conclude that generation 1 is on average more popular.” [The slide shows the p-value]

Grading

  • E (Exemplary, 20pts) – Most important and essential results are thoroughly discussed using labeled tables or figures followed by an interpretation of the results in the context of the research questions. 
  • S (Satisfactory, 19pts) – Results are thoroughly discussed using labeled tables or figures followed by an interpretation of the results in the context of the research questions. Maybe missing an important result that should have been included.
  • N (Not yet, 12pts) – Results are discussed using tables with missing labels or lacking interpretation in the context of the research questions.
  • U (Unassessable, 4pts) – Results are missing or do not demonstrate meaningful effort. 

Part 4: Limitations and Future Work

You should briefly discuss any important limitations or caveats to your results with respect to answering your research questions. For example, if you don’t have as much data as you would like or are unable to fairly evaluate the performance of a predictive model, explain and contextualize those limitations.

Finally, provide a brief discussion of future work. This could explain how future research might address the limitations you outline, or it could pose additional follow-up research questions based on your results so far. In short, explain how an informed audience member (such as a peer in the class) could improve on and extend your results.

Grading

  • E (Exemplary, 20pts) – Comprehensive and explicit discussion of important limitations and caveats to results. Brief discussion of future work and how results could be extended and improved upon.
  • S (Satisfactory, 19pts) – Comprehensive and explicit discussion of important limitations and caveats to results. Discussion of future work and how results could be extended and improved upon may lack some specification.
  • N (Not yet, 12pts) – Incomplete discussion of important limitations and caveats to results. Discussion of future work and how results could be extended and improved upon may lack some specification.
  • U (Unassessable, 4pts) – Limitations and future work are missing or do not demonstrate meaningful effort.

Checklist Before You Submit:

  1. Is your video presentation between 8 and 12 minutes in length?
  2. Does your first slide satisfy all requirements?
    1. A title of your project/presentation
    2. Names of all group members
    3. URL to the video recording of your presentation
  3. Do you have an Introduction and clearly stated Research Question(s)?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  4. Have you properly specified/cited one or more specific Data Sources and justified why they are relevant to the research Questions?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  5. Have you reported all of your important Results, including an interpretation of them in the context of the research questions?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  6. Have you defined clear Limitations to your results and Future Work?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?

 

Project Report

Due: Wednesday, 4/26

Form to opt-in for comments/feedback on report/video

General Directions

The final report is intended to provide a comprehensive account of your collaborative course project in data science. The report should demonstrate your ability to apply the data science skills you have learned to a real-world project in a holistic way from posing research questions and gathering data to analysis, visualization, interpretation, and communication. The report should stand on its own so that it makes sense to someone who has not read your proposal or prototype.

The report should contain at least the parts defined below. In terms of length, it should be 5-7 pages using standard margins (1 in.), font (11-12 pt), and line spacing (1-1.5). A typical submission is around 3-4 pages of text and 5-7 pages overall with tables and figures. It is important to stay within the page limit, practicing being succinct is an important skill. Your final report should also have a descriptive title, not “CS216 Project Report”. You should convert your written report to a pdf and upload it to Gradescope under the assignment “Project Final Report” by the due date. Be sure to include your names and NetIDs in your final document and use the group submission feature on Gradescope. You do not need to upload your accompanying data, code, or other supplemental resources demonstrating your work to Gradescope; instead, your report should contain instructions on how to access these resources (see the Results and Methods section below for more details).

In general, your approach to this report should be to write as if you had “planned this as your project all along.” A report is not a chronological story of your project. It is a summary of what you did where the “story” serves the reader’s comprehension.

Grading

  • E (Exemplary, 20pts) – Work that meets all requirements in terms of formatting and sections.
  • S (Satisfactory, 19 pts) – Work that meets all requirements but is over 7 pages.
  • N (Not yet, 12pts) – Does not meet all requirements.
  • U (Unassessable, 4pts) –  Missing at least one section.

Part 1: Introduction and Research Questions (15 points)

Your final report should begin by reintroducing your topic and restating your research question(s) as in your proposal. As before, your research question(s) should be (1) substantial, (2) feasible, and (3) relevant. In contrast to the prior reports, the final report does not need to explicitly justify that the research questions are substantial and feasible in the text; your results should demonstrate both of these points. Therefore, you should remove that text to save space.

You should still explicitly justify how your research questions are relevant. In other words, be sure to explain the motivation of your research questions. Remember that relevant research questions address a subject of importance and interest within the scientific community or broader society. Additionally, we are looking for why your group believes this research project is worthwhile to your time in this course.

You can start with the text from your prototype, but you should update your introduction and research questions to reflect changes in or refinements of the project vision. Your introduction should be sufficient to provide context for the rest of your report.

Grading

  • E (Exemplary, 15pts) – Comprehensive introduction with clearly labeled, updated research questions and a justification for how the research questions are relevant. It is clear that the introduction and research questions have been refined from the prototype.
  • S (Satisfactory, 14pts) – Comprehensive introduction with clearly labeled, updated research questions and a justification for how the research questions are relevant. The introduction and research questions may have not been refined from the prototype (they have still kept reasoning for why their research questions are substantial and feasible).
  • N (Not yet, 9pts) – Incomplete introduction where the research questions or justification are missing pieces, but at least some of it is present. Or the justification is clearly not reasonable.
  • U (Unassessable, 3pts) – Incomplete introduction where it is entirely missing the research questions or justification or does not demonstrate meaningful effort.

Part 2: Data Sources (15 points)

Discuss the data you have collected and are using to answer your research questions. Be specific: name the datasets you are using, the information they contain, and where they were collected from / how they were prepared. You can begin with the text from your prototype but be sure to update it to fit the vision for your final project.

Grading

  • E (Exemplary, 15pts) – Origins of data are properly specified, cited, and relevant to answering the research question(s). If any significant data wrangling, cleaning, or other data preparation was done, these processes are explained.
  • S (Satisfactory, 14pts) – Origins of data are properly specified and cited. However, the justification is not clear why the data is relevant to the proposed research question(s). If any significant data wrangling, cleaning, or other data preparation was done, these processes are explained.
  • N (Not yet, 9pts) – Poorly specified data sources or the justification for using that data set or the methods to acquire the data is lacking. No discussion of preparing the dataset.
  • U (Unassessable, 3pts) – Data sources or methods to acquire data are missing or do not demonstrate meaningful effort.

Part 3: What Modules are You Using? (15 points)

Your project should utilize concepts from modules we have covered in this course to answer your research question(s). We will assume you will use modules 1 (Python), 2 (Numpy/Pandas), and 3 (Probability).  Your final report should state at least 3 more modules that you have utilized for your project. Each module should have a short description of how you used the knowledge in this module and a justification for that use. In addition, include what concepts from the module you used and at what stage of your project you mostly used this module. Potential stages include, but are not limited to: data gathering, data cleaning, data investigation, data analysis, and final report.

  • Module 4: Data Wrangling
  • Module 5: Statistical Inference
  • Module 6: Combining Data
  • Module 7: Databases and SQL
  • Module 8: Visualization
  • Module 9: Prediction & Supervised Machine Learning

Your overall report should clearly show that you used the modules discussed in this section. You should add any additional modules used and update the existing modules to be more specific to the different tasks and stages of your projects that changed since your prototype.

Grading

  • E (Exemplary, 15pts) – States at least 3 modules. For each module, they provide an updated (1) short description of how they used the module, (2) justification for using this module, (3) what concepts they used, (4) what stage they used it, and (5) clearly implemented it in the final report. 
  • S (Satisfactory, 14pts) – States at least 3 modules. For each module, they provide an updated (1) short description of how they used the module, (2) justification for using this module, (3) what concepts they used and (4) what stage they used it. Less than 3 modules are clearly implemented in the final report. 
  • N (Not yet, 9pts) – States at least 3 modules. For each module, they provide an updated (1) short description of how they used the module, (2) justification for using this module, (3) what concepts they used and (4) what stage they used it. Only one module is clearly implemented in the final report.
  • U (Unassessable, 3pts) – Does not meet the Not Yet criteria.

Part 4: Results and Methods (15 points)

This is likely to be the longest section of your paper at multiple pages. The results and methods section of your report should explain your detailed results and the methods used to obtain them. Where possible, results should be summarized using clearly labeled tables or figures and supplemented with written explanations of the significance of the results with respect to the research questions outlined previously. Please note that a screenshot of your dataset does not count as a table or figure and should not be included in your final report.

Your description of your methods should be specific. For example, if you scraped multiple web databases, merged them, and created a visualization, then you should explain how each step was conducted in enough detail that an informed reader could reasonably be expected to reproduce your results with time and effort. Just saying “we cleaned the data and dealt with missing values” or “we built a predictive model” is not sufficient detail.

Your report should also contain instructions on how to access your full implementation (that is, your code, data, and any other supplemental resources like additional charts or tables). The simplest way to do so is to include a link to the box folder, GitLab repo, or whatever other platforms your group is using to house your data and code.

Grading

  • E (Exemplary, 15pts) – Results are thoroughly discussed using labeled tables or figures followed by written descriptions. Specific explanation of how the results were generated and from what data. Link to code/data to create charts or visualizations is provided. 
  • S (Satisfactory, 14pts) – Results are thoroughly discussed using labeled tables or figures followed by written descriptions. Explanation of how the results were generated may lack some specification or it is somewhat unclear as to what data the results are from. Link provided.
  • N (Not yet, 9pts) – Results are discussed using tables with missing labels or lacking written descriptions. It is unclear how the results were generated and from what data.
  • U (Unassessable, 3pts) – Results are missing or do not demonstrate meaningful effort.

Part 5: Limitations and Future Work (10 points)

In this part, you should discuss any important limitations or caveats to your results with respect to answering your research questions. For example, if you don’t have as much data as you would like or are unable to fairly evaluate the performance of a predictive model, explain and contextualize those limitations.

Finally, provide a brief discussion of future work. This could explain how future research might address the limitations you outline, or it could pose additional follow-up research questions based on your results so far. In short, explain how an informed reader (such as a peer in the class) could improve on and extend your results.

Grading

  • E (Exemplary, 10pts) – Comprehensive and explicit discussion of important limitations and caveats to results. Brief discussion of future work and how results could be extended and improved upon.
  • S (Satisfactory, 9pts) – Discussion of important limitations and caveats to results could be improved or the discussion of future work and how results could be extended and improved upon lacks some specification.
  • N (Not yet, 6pts) –  Incomplete discussion of important limitations and caveats to results. Discussion of future work and how results could be extended and improved upon may lack some specification.
  • U (Unassessable, 2pts) – Limitations and future work are missing or do not demonstrate meaningful effort.

Part 6: Conclusion (5 points)

Provide a brief (one or two paragraphs) summary of your results. This summary of results should address all of your research questions.

Example

If one of your research questions was “Did COVID-19 result in bankruptcy in North Carolina during 2020?” then a possible (and purely hypothetical) summary of results might be:

We aggregate the public records disclosures of small businesses in North Carolina from January 2019 to December 2020 and find substantial evidence that COVID-19 did result in a moderate increase in bankruptcy during 2020. This increase is not geographically uniform and is concentrated during summer and fall 2020. We also examined the impact of federal stimulus but cannot provide an evaluation of its impact from the available data.

Grading

  • E (Exemplary, 10pts) – Research questions are clearly and completely addressed through a summary of results. 
  • S (Satisfactory, 9pts) – Research questions are clearly addressed through a summary of results. The results may be lacking in completely answering the research questions.
  • N (Not yet, 6pts) –  Research questions are somewhat addressed through a summary of results. The results are lacking in completely answering the research questions. Or the results of one of the research questions is missing.
  • U (Unassessable, 2pts) – Conclusion is missing or does not demonstrate meaningful effort.

(Optional) Part 7: Appendix of additional figures and tables

If you are struggling to keep your report within the 5-7 page limit, you may move some (not all) of your figures and tables to an optional appendix that will not count against your page limit. However, your report should stand on its own without the appendix. The appendix is for adding more nuance to your results, not to give you more space to talk about your results. Succinctness is an important skill to practice when doing data science. Your grader is not expected to look at the appendix when grading.

Checklist Before You Submit:

  1. Does your final report satisfy all general directions?
    1. 5-7 pages in length
    2. Standard margins (1 in.)
    3. Font size is 11-12 pt
    4. Line spacing is 1-1.5
    5. Final document is a pdf
  2. Do you have an Introduction and clearly stated Research Question(s)?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  3. Have you properly specified/cited one or more specific Data Sources and justified why they are relevant to the research Questions?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  4. Did you state at least 3 Modules to be used and how, as well as a justification of which concepts will be used at specific stages of the project?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  5. Have you reported all of your Results and Methods, including a specific explanation of how the results were generated?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  6. Have you defined clear Limitations to your results and Future Work?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  7. Have you written a comprehensive Conclusion?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?

 

Module 09: Prediction & Supervised Machine Learning

  1. Prepare (due Mon 4/3)
    1. Content below
    2. Sakai quizzes
  2. Peer Instructions – See on the class forum
  3. Homework (due Sun 4/9) [Link]
  4. Worked Examples [Link]

Content

9. A Predictive Modeling and Regression

  1. Ordinary Linear Regression and Intro Scikit-Learn (21 min.)
  2. Nonlinear Regression and Scikit-Learn Preprocessing (13 min.)
  3. Binary Classification with Logistic Regression (22 min.)

Note: sklearn.metrics.plot_confusion_matrix introduced in p.28-29 in the slides/video is deprecated; use sklearn.metrics.ConfusionMatrixDisplay instead. To see the updated slides, switch to the “slides” panel when viewing the 9.A.III video in Panopto.

9.B Machine Learning and Classification

  1. Naïve Bayes and Text Classification (20 min.) – The video has a type on slide 10, see the pdf of the slides in Box for the fix.
  2. K-Nearest Neighbors and Training/Testing (31 min.)

Optional Supplements

Chapter 5 Machine Learning from the Python Data Science Handbook provides a very nice treatment of many of the topics from the above videos and more. If you are new to machine learning, we highly recommend that you read sections 5.1 “What is Machine Learning” through 5.4 “Feature Engineering” after completing the videos. After that, you can optionally read any of the In-Depth sections about specific algorithms for prediction.

In addition, the scikit-learn documentation itself provides several resources for working with the library:

Module 08: Visualization

  1. Prepare (due M 3/27)
    1. Content below
    2. Sakai quizzes
  2. Peer Instructions – See on the class forum
  3. Homework (due Sun 4/2) [Link]
  4. Worked Examples [Link]

Content

08.A – Data Visualization and Design

  1. Why Visualize? (11 min.)
  2. Basic Plot Types (17 min.)
  3. Dos and Don’ts (10 min.)

08.B Visualization in Python

  1. Intro to Python Visualization Landscape (7 min.)
  2. Seaborn Introduction (17 min.)
  3. Seaborn Examples (17 min.)

Optional Supplements

Restart and Run All

Here is a guide on how to submit properly formatted .ipynb files for homework and exams.

This is important because a common way to detect bugs that the autograder might find is to first restart the kernel and run everything. Moreover, it is the equivalent of ensuring that you are submitting a polished notebook.

Steps to restart the kernel and run all

Go to the button labeled “Kernel” at the top of the page.

Click on the “Kernel” button to open this dropdown menu. Now click “Restart & Run All.”

This box will then appear. Click the red button labeled “Restart and Run All Cells.”

How to confirm it is correctly formatted

After following the steps above, your notebook cells’ “In [#] ” labels will be in numerical order. Make sure to confirm that all code cells are run. This is a properly formatted .ipynb file. 

 

Example of an incorrectly formatted notebook

Although this .ipynb file below is in numerical order, the first cell in the file does not start with “In [1]” and is deemed an improperly formatted .ipynb file. 

Project Prototype

Due: Sunday, April 2nd

General Directions

The prototype deliverable is intended to demonstrate a proof of concept for your final project report. Large multi-week projects are challenging. This deliverable is intended to provide additional structure to ensure you are making progress and on a path toward success.

It consists of a written report detailed below, along with any accompanying data, code, or other supplementary resources that demonstrate your progress so far in the project. You can think of it as a rough draft for your final project. The report should stand on its own so that it makes sense to someone who has not read your proposal.

The report should contain at least five parts, which we define below. In terms of length, it should be 3-4 pages using standard margins (1 in.), font (11-12 pt), and line spacing (1-1.5). A typical submission is around 2-3 pages of text and 3-4 pages overall with tables and figures. You should convert your written report to a pdf and upload it to Gradescope under the assignment “Project Prototype” by the due date. Be sure to include your names and NetIDs in your final document and use the group submission feature on Gradescope. You do not need to upload your accompanying data, code, or other supplemental resources demonstrating your work to Gradescope; instead, your report should contain instructions on how to access these resources (see parts 2 and 4 below for more details).

  • E (Exemplary, 30pts) – Work that meets all requirements.
  • S (Satisfactory, 29 pts) – Work that meets all requirements but is over 4 pages.
  • N (Not yet, 18pts) – Does not meet all requirements.
  • U (Unassessable, 6pts) –  Missing at least one section.

Part 1: Introduction and Research Questions (15 points)

Your prototype report should begin by reintroducing your topic and restating your research question(s) as in your proposal. Your research question(s) should be (1) substantial, (2) feasible, and (3) relevant. Briefly justify each of these points as in the project proposal. You can start with the text from your proposal, but you should update your introduction and research questions to reflect changes in or refinements of the project vision. Specifically, point out what has changed since the proposal. Your introduction should be sufficient to provide context for the rest of your report.

Grading

  • E (Exemplary, 15pts) – Comprehensive introduction with clearly labeled, updated research questions and a justification for the research questions about whether they are substantial, feasible, and relevant. Any changes are specifically mentioned or they note there are no changes.
  • S (Satisfactory, 14pts) – Comprehensive introduction with clearly labeled research questions and a justification for the research questions about whether they are substantial, feasible, and relevant. Changes and updates may not be specifically mentioned.
  • N (Not yet, 9pts) – Incomplete introduction where the research questions or justification are missing pieces, but at least some of it is present. Or the justification is clearly not reasonable.
  • U (Unassessable, 3pts) – Incomplete introduction where it is entirely missing the research questions or justification or does not demonstrate meaningful effort.

Part 2: Data Sources (15 points)

After your introduction and research questions, your prototype should discuss the data you have collected and are using to answer your research questions. Be specific: name the datasets you are using and where they were collected from / how they were prepared. Briefly justify why your data are appropriate and sufficient to address your research questions. As in the introduction, you can begin with the text from your proposal but be sure to update it to fit your evolving project.

Grading

  • E (Exemplary, 15pts) – Origins of data are properly specified, cited, and relevant to answering the research question(s). If any data wrangling, cleaning, or other data preparation was done, these processes are explained.
  • S (Satisfactory, 14pts) – Origins of data are properly specified and cited. However, the justification is not clear why the data is relevant to the proposed research question(s). If any data wrangling, cleaning, or other data preparation was done, these processes are explained.
  • N (Not yet, 9pts) – Poorly specified data sources or the justification for using that data set or the methods to acquire the data is lacking. No discussion of preparing the dataset.
  • U (Unassessable, 3pts) – Data sources or methods to acquire data are missing or do not demonstrate meaningful effort.

Part 3: What Modules are You Using? (15 points)

Your project should utilize concepts from modules we have/will cover in this course to answer your research question(s). We will assume you will use modules 1 (Python), 2 (Numpy/Pandas), and 3 (Probability). This section should state at least 3 more modules that you will utilize for your project. Each module should have a short description of how you will use the knowledge in this module and a justification for that use. In addition, include what concepts from the module you will use and at what stage of your project you plan to mostly use this module. Potential stages include, but are not limited to: data gathering, data cleaning, data investigation, data analysis, and final report.

  • Module 4: Data Wrangling
  • Module 5: Statistical Inference
  • Module 6: Combining Data
  • Module 7: Databases and SQL
  • Module 8: Visualization
  • Module 9: Prediction & Supervised Machine Learning

As in Parts 1 and 2, you can begin with the text from your proposal but be sure to update it to fit with your evolving project. You should add any additional modules you will be using and update the existing modules to be more specific to the different tasks and stages of your projects.

Grading

  • E (Exemplary, 15pts) – States at least 3 modules. For each module, they provide an updated (1) short description of how they will use the module, (2) justification for using this module, (3) what concepts they will likely use, and (4) what stage they expect they will use it. 
  • S (Satisfactory, 14pts) – States at least 3 modules, but there are some weaknesses somewhere, such as one module as 3 or more parts not well fleshed out or across all 3 modules one part is weak.
  • N (Not yet, 9pts) – States at 3 modules, but 3 or more parts are entirely missing or basically non-existent out of 12 = 4 parts X 3 modules.
  • U (Unassessable, 3pts) – Does not meet the Not Yet criteria, such as having fewer than 3 modules or missing more than 3 parts across all 12 = 4 parts X 3 modules.

Example:

Here is an example justification for Module 3, assuming the project is about creating a prediction model that is classifying the data. Note the bolding, which will help you ensure you are meeting all requirements and your grader to find them.

Proposal

Module 3 Probability: We will use this module to calculate the accuracy of a baseline version of the model we will build. We will do this by considering the proportion of the label we are trying to predict, as well as taking into account some of the independent variables. Our justification is that we need a baseline accuracy to understand how good our model is. The concepts we will mainly use are the probability axioms and maybe some of Bayes or marginalization to calculate this baseline. We plan to use this module during the data analysis and final report stage.

Prototype

Module 3 Probability: We used this module to calculate the accuracy of a baseline version of a model we will build to predict the type of a Pokemon. We did this by considering the proportion of each type of a Pokemon in our data set and creating a baseline model that just predicted the most common pokemon in our data set. Our justification is that we need a baseline accuracy to understand how good our model is for predicting the type of a Pokemon based on other characteristics. The concepts we mainly used were the probability axioms and some of Bayes or marginalization to consider if there was a better baseline model we could use. We used this module during our data analysis and plan to use it in the final report stage.

Part 4: Preliminary Results and Methods (15 points)

The preliminary results section of your report should summarize the results obtained so far in the project. Where possible, results should be summarized using clearly labeled tables or figures and supplemented with a written explanation of the significance of the results with respect to the research questions outlined in the previous section. Please note that a screenshot of your dataset does not count as a table or figure and should not be included in your Prototype. Instead, if your primary progress is gathering and cleaning your data, provide a table with descriptive statistics about your data. Your results do not need to be final or conclusive for your entire project but should demonstrate substantial effort and progress and should provide concrete proof of concept or initial analysis with respect to your research questions.

Your results should be specific about exactly what data were used and how the results were generated. For example, if you scraped multiple web databases, merged them, and created a visualization, then you should explain how each step was conducted in enough detail that an informed reader could reasonably be expected to reproduce your results with time and effort. Just saying, “we cleaned the data and dealt with missing values,” is not sufficient detail, for example.

Your report itself should include an explanation of your methods, but it should also contain instructions on how to access your full implementation (that is, your code, data, and any other supplemental resources like additional charts or tables). The simplest way to do so is to include a link to the box folder, GitLab repo, or whatever other platform your group is using to house your data and code.

Grading

  • E (Exemplary, 15pts) – Preliminary results are thoroughly discussed using labeled tables or figures followed by written descriptions. Specific explanation of how the results were generated and from what data. Link to code/data to create charts or visualizations is provided. 
  • S (Satisfactory, 14pts) – Preliminary results are thoroughly discussed using labeled tables or figures followed by written descriptions. Explanation of how the results were generated may lack some specification or it is somewhat unclear as to what data the results are from. Link provided.
  • N (Not yet, 9pts) – Preliminary results are discussed using tables with missing labels or lacking written descriptions. It is unclear how the results were generated and from what data.
  • U (Unassessable, 3pts) – Preliminary results are missing or do demonstrate meaningful effort.

Part 5: Reflection and Next Steps (10 points)

In this part, you should answer the following sections in their own subsection (if space is limited, how you create the clear subsections is up to you):

  1. Successes/Mostly Complete – What has been successful in the project so far or what is essentially complete and ready for the final report?
  2. Challenges/Incomplete – What has been challenging in the project so far or what is incomplete in the prototype that needs to be finished for the final report?
  3. Collaboration plan reflection – How is the collaboration going? What is currently happening versus the original proposed plan? Is the group okay with what is happening? Does the group need to renegotiate what the plan should be? If yes, what is the new plan?
  4. Next Steps – What are your next steps? These should be concrete and specific actions that your group will take to address the challenges identified in order to complete a successful final project.

Grading

  • E (Exemplary, 10pts) – All four parts are present and the reflection is comprehensive on successes and challenges so far, a reflection on their collaboration plan, and a specific plan of action to address any concerns and future work.
  • S (Satisfactory, 9pts) – All four parts are present and the reflection is comprehensive on successes and challenges so far, but the collaboration plan is weak and there is only a loose plan of action to address any concerns and future work.
  • N (Not yet, 6pts) – A reflection/plan that does not entirely answer 1 or 2 of the questions above.
  • U (Unassessable, 2pts) – A reflection/plan that does not entirely answer 3 of the questions above.

Checklist Before You Submit:

  1. Does your prototype satisfy all general directions?
    1. 3-4 pages in length
    2. Standard margins (1 in.)
    3. Font size is 11-12 pt
    4. Line spacing is 1-1.5
    5. Final document is a pdf
  2. Do you have an Introduction and clearly stated Research Question(s)?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  3. Have you properly specified/cited one or more specific Data Sources and justified why they are relevant to the research Questions?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  4. Did you state at least 3 Modules to be used and how, as well as a justification of which concepts will be used at specific stages of the project?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  5. Have you reported all of your Preliminary Results and Methods, including a specific explanation of how the results were generated?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?
  6. Have you written a comprehensive reflection?
    1. Do you feel as if this part meets the requirements of E (Exemplary) or S (Satisfactory)?

Exam 2 and Exam 1 Retake

Exam 2 Logistics

  • Modules covered: 4, 5, and 6
    • Note: Even though it’s the same number of modules as Exam 1, that does not mean it is assessing the same amount of knowledge. Module 01 was a pre-amble module to remind you all of Python and as a warm-up for the weekly cadence of the class.
  • Practice Exam (Part1 – Link, Part2 – Link)
    • Note: This does not have a question about regular expressions, but the real exam will. One of the question’s solutions does use regular expressions it is just not required of the question.
  • Timeframe: It will open Thursday, 3/23, at 12:01 AM, and close Saturday, 3/25, at 11:59 PM.
    • The exam will close at 11:59 pm regardless of when you started.
  • The exam will be take-home. It is open book, open note, open internet, but closed to people.
    • This means you cannot receive help on this exam from anyone, including (but not limited to) communicating with a person while taking the exam, such as asking someone through the Internet (like stackoverflow) to receive help.
  • It consists of 2 parts that, like Exam 1 Part 2,  each have a time limit of 2 hours. Both parts will have data sets, and they will be different.
  • All other information is similar to Exam 1 Part 2. Such as getting the files, Gradescope, Sakai, asking for help, grading policy, etc.
    • Grading Clarification: A simple copy+paste and find+replace replacement from the practice exam is considered a Satisfactory answer. You must use your own words or elaborate beyond the practice exam text to show an Exemplary level of content mastery.

Exam 1 Retake Logistics

  • Timeframe:
    • Part 1: In-person during normal class time on Wednesday, 3/22.
      • Fill out the RSVP form by Sunday 3/19, so we know you are coming. Help us save trees and not waste paper.
      • If you change your mind last minute, we will print a few extras.
    • Part 2 (same as Exam 2): It will open Thursday, 3/23, at 12:01 AM, and close Saturday, 3/25, at 11:59 PM.
      • The exam will close at 11:59 pm regardless of when you started.
  • It assesses the same thing as Exam 1.
    • You may use things that you have learned that were not in the modules that this exam is testing (such as .groupby() or .apply()), but you can answer it without knowing any modules beyond what this exam is testing.
  • The data set and/or problems will be different.
  • You do not need to do both parts. You can do only one part if you wish. You must do ALL of the questions in that part, though. We will take the max score per part.
  • All other information is similar to Exam 1’s. Such as getting the files, Gradescope, Sakai, asking for help, grading policy, etc.
    • Grading Clarification: A simple copy+paste and find+replace replacement from the practice exam is considered a Satisfactory answer. You must use your own words or elaborate beyond the practice exam text to show an Exemplary level of content mastery.

Module 07: Databases & SQL

  1. Prepare (due Mon 3/6)
    1. Content below
    2. Sakai quizzes
  2. Peer Instructions – See on the class forum [Link TBD]
  3. Homework (due Mon 3/20) [LINK ]
  4. Worked Example [LINK]

Content

07.A – Relational Database (24 min.)

07.B

  1. SQL Querying (21 min.)
  2. SQL with Python and Pandas (12 min.)

Optional Supplements