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

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

p_path

the full page title

p_creator

the user_id of the editor who created the page.

pc_username

the username of the pattern creator

pc_date

the date the pattern was created

pc_rev

the rev_id that created the page

recent_editor

the user_id of the person who edited the page most recently

re_username

the username of the most recent editor

re_date

the date of the most recent edit

re_rev

the revision id of the most recent edit

endorsements

the number of times the pattern has been endorsed

eval_patterns_endorsements

eval_profiles

eval_questions