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)]]'''
+
## '''[[Preparing Spreadsheets (2014 to Present)]]''': Spreadsheet preparation for games occurring from 2014 to present
## Spreadsheet preparation for games occurring from 2001 to 2013: '''[[Preparing Spreadsheets (2001 to 2013)]]'''
+
## '''[[Preparing Spreadsheets (2001 to 2013)]]''': Spreadsheet preparation for games occurring from 2001 to 2013
## Preparation for transcribed spreadsheets for games occurring prior to 2001: '''[[Preparing Spreadsheets (Transcribed Games)]]'''
+
## '''[[Preparing Spreadsheets (Transcribed Games)]]''': Preparation for transcribed spreadsheets for games occurring prior to 2001
## Spreadsheet preparation for historical games drawn from newspaper accounts: '''[[Preparing Spreadsheets (Historical Games)]]'''
+
## '''[[Preparing Spreadsheets (Historical Games)]]''': Spreadsheet preparation for historical games drawn from newspaper accounts
  
  

Revision as of 03:38, 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. Preparing Spreadsheets (2014 to Present): Spreadsheet preparation for games occurring from 2014 to present
    2. Preparing Spreadsheets (2001 to 2013): Spreadsheet preparation for games occurring from 2001 to 2013
    3. Preparing Spreadsheets (Transcribed Games): Preparation for transcribed spreadsheets for games occurring prior to 2001
    4. Preparing Spreadsheets (Historical Games): Spreadsheet preparation for historical games drawn from newspaper accounts


  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