Difference between revisions of "Data Preparation Procedures"

From Wikibase.slis.ua.edu
Jump to navigation Jump to search
Line 10: Line 10:
  
 
DATA PREPARATION PROCEDURES
 
DATA PREPARATION PROCEDURES
# '''[[Spreadsheet Preparation Procedures]]''': The download and initial preparation of spreadsheets by period
+
# '''Spreadsheet Preparation Procedures''': The download and initial preparation of spreadsheets by period
 
## Spreadsheet preparation for games occurring from 2014 to present: '''[[Preparing Spreadsheets (2014 to Present)]]'''
 
## Spreadsheet preparation for games occurring from 2014 to present: '''[[Preparing Spreadsheets (2014 to Present)]]'''
 
## Spreadsheet preparation for games occurring from 2001 to 2013: '''[[Preparing Spreadsheets (2001 to 2013)]]'''
 
## Spreadsheet preparation for games occurring from 2001 to 2013: '''[[Preparing Spreadsheets (2001 to 2013)]]'''

Revision as of 03:37, 21 December 2018

This page provides information on data preparation for using QuickStatement.

Procedures vary based on the year that a game occurred.

IMPORTANT: Before creating an Item page, be to to search to be sure it doesn't already exist!

PRELIMINARY STEPS

  1. Make sure a season page exists for each team participating in the game: Indexing a Football Team Season
  2. Creating an item page for a game: Indexing a Football Game

DATA PREPARATION PROCEDURES

  1. Spreadsheet Preparation Procedures: The download and initial preparation of spreadsheets by period
    1. Spreadsheet preparation for games occurring from 2014 to present: Preparing Spreadsheets (2014 to Present)
    2. Spreadsheet preparation for games occurring from 2001 to 2013: Preparing Spreadsheets (2001 to 2013)
    3. Preparation for transcribed spreadsheets for games occurring prior to 2001: Preparing Spreadsheets (Transcribed Games)
    4. Spreadsheet preparation for historical games drawn from newspaper accounts: Preparing Spreadsheets (Historical Games)


  1. Drive Data Preparation and Upload Procedures

Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:

    1. Create spreadsheet that will derive Q numbers for each drive and incorporating "instance of" statements: Drive Creation Procedure
    2. Create spreadsheet to populate data about each drive's (now) existing item page: Drive Data Preparation
  1. Play-by-play Data Preparation and Upload Procedures