MSBAPM Research Project – Dr. Ramesh Shankar (Updated – 9/16/2018)On March 11th, 2011, StackOverflow made a significant change to their leaderboard. They now showusers with top reputation gained in the past week, rather than all-time high reputation users. Therationale from Jeff Atwood, senior StackOverflow executive, was (in this blog post:https://stackoverflow.blog/2011/03/01/redesigned-users-page/) that they wanted to make the users-leaderboard much more dynamic and more interesting as a destination. They also wanted to showcasethe efforts of any active users, not just the all-time top users. This shows that the company wanted toencourage regular users to contribute more.A causal question of interest to the company, and to designers of leaderboards, is: did this change causenewer users to put in more effort? After all, even before the change, people could see the weekly topusers, it was just not the default display. By converting this to a default, however, the website wasmaking it easier for regular users to gain visibility (there is one less link to click, to view them now).Some things we might expect to see, after the change compared to before the change:➢ Regular users might attract more viewers to their profile➢ Regular users might put in more effort, so that more regular users show up on the weeklyleaderboard consecutive weeks➢ Regular users might put in more effort the week after they show up on the weekly leaderboard– this may be true to some extent even if a regular user just showed up on the leaderboard –etc.What is the impact of recognition on effort? Does recognition lead to more or less effort in subsequentperiod? How does this vary with time?– Impact of showing up on leaderboard on subsequent performanceo Weekly leaderboardo Monthly leaderboard– How long does impact last?– Is the impact positive (more effort) or negative (less effort)?– Does it result in higher or lower quality?– Does the user become more risk averse (sticking to core areas) or more adventurous (venturingout to newer areas)?Your goal:Retrieve and analyze data from https://data.stackexchange.com/ to answer the above questions.Prepare a 10-minute presentation of your findings.*Updates* (also see next page)Data schema:https://meta.stackexchange.com/questions/2677/database-schema-documentation-for-the-public-data-dump-and-sedeYou may need to compute the reputation points earned by candidates in particular time periods (week,month or year). To compute points for a particular user, you can get (count of number of upvotes theirquestions or answers got) * (10 points per answer-upvote or 5 points for question-upvote) + (count ofnumber of downvotes their questions or answers got) * (-2 points per downvote – either for question oranswer).For a count of number of upvotes or downvotes, you need to join the following three tables:1. Users table with Posts table on Users.id = Posts.OwnerUserId2. Posts table with Votes table on Posts.id = Votes.PostId
GET AN ANSWER TO THIS ESSAY TODAY!
Save time and grade. Get a complete paper today.
Our leading custom writing service provides custom written papers in 80+ disciplines. Order essays, research papers, term papers, book reviews, assignments, dissertation, thesis or extensive dissertations & our expert ENL writers will easily prepare a paper according to your requirements.
Place this order today and get an amazing discount!!