Homework Assignment 2

The goal of this assignment is to conduct data analytics for donorschoose.org platform, and suggest design improvement for the website, using MySQL and Python. In 10 minute presentation, you need to answer the following questions:

Remember that you are a business student - you are learning how to connect the use of the techniques of database management with the real business issues. Explain, explain, explain.

1. What is your goal?

• For example, do you want to increase total donations? Or, donations for a specific projects (e.g. geographical groups, socio-demographic groups)? Or, do you want to increase the success rate of the projects? Do you want increase equality across the platform? In what sense? (what's your definition/measurement of 'equality/inequality')? etc.

• More importantly, is the goal you set up important? If so, in what sense?

• How would you evaluate the current status of the website in light of your goal? (Use data to justify)

2. What is keeping you from achieving the goal?

• To achieve the goal, you need to find out the problems that keep you from achieving the goal.

  • What kind of problems do you think of? Why do you think that's hindering you from achieving the goal?

  • What kind of problems did you find? How did you find them? (Using data)

    • e.g. completion bias? selection bias? smaller projects get smaller donations? ...

3. What are your suggestions?

• Given the problems, how would you have to fix the problem? Make suggestions.

• Suggestions should be based on the empirical findings from answers to the questions above.

How to Present Your Work

• Have to answer the questions above step-by-step.

• You have to justify your answer with data analysis - explain your codes during the presentation.

• You are asked to run SQL codes within Python for your assignment.

  • https://www.kaggle.com/ambarish/eda-fe-xgb-glm-maps-donors-choose

  • https://www.kaggle.com/mahbubrob/text-analysis-donorschoose

  • https://www.kaggle.com/coronate/donorschoose-exploratory-analysis

• Use 10 pages or less of slides.

• 10 minutes maximum.

• Due to lack of accessibility to donorschoose.org in mainland China, please refer to Kickstarter or Indiegogo to get an understanding of UI of crowdfunding websites.

Final Notes

• Submit your presentation (no separate report required) on iSapce, one submission from one team, by anytime on May 17th.

• The order of presentation on May 18th and 20th will be posted on iSpace.