Learning and Evaluation/Archive/Boiler room/Contribution logging

In order to automate the maintenance of the evaluation portal, and to evaluate the effectiveness of the Evaluation portal itself, we are logging contributions to wiki pages within the scope of the evaluation portal. Metadata about edits made to these pages are stored in the publicly-viewable p50380g50729__grantsbot MySQL database on the metawiki_p database cluster on Wikimedia Labs. All data are pulled from the metawiki_p replica database, and everything in these tables is publicly-accessible data--no personally identifiable information (such as email addresses, IP addresses for logged-in users, etc) is logged.

Logging allows us to analyze the success of the Evaluation portal and makes it easier to figure out if there are things we need to improve to make it more useful and usable. We used a similar logging setup to evaluate the impact of the Teahouse during the pilot period. These data are not used to determine eligibility for grant funding.

eval_patterns edit

This table tracks how many pages there are in the category CategoryLearning patterns and/or its sub-categories, as well as to keep track of recent edits and endorsements to these patterns.

Fields edit

id edit

page_id edit

p_path edit

the full page title

p_namespace edit

p_creator edit

the user_id of the editor who created the page.

pc_username edit

the username of the pattern creator

pc_date edit

the date the pattern was created

pc_rev edit

the rev_id that created the page

recent_editor edit

the user_id of the person who edited the page most recently

re_username edit

the username of the most recent editor

re_date edit

the date of the most recent edit

re_rev edit

the revision id of the most recent edit

endorsements edit

the number of times the pattern has been endorsed

eval_patterns_endorsements edit

Fields edit

eval_profiles edit

Fields edit

eval_questions edit

Fields edit