Difference between revisions of "Data Preparation Procedures"

From Wikibase.slis.ua.edu
Jump to navigation Jump to search
Line 17: Line 17:
 
# Drive Data Preparation and Upload Procedures
 
# Drive Data Preparation and Upload Procedures
 
## Drive Creation Procedures
 
## Drive Creation Procedures
### '''[[Preparing Drive Creation Spreadsheets (2014 to Present)]]'''
+
### '''[[Preparing Drive Creation Spreadsheets for Games 2014 to Present]]'''
### '''[[Preparing Drive Creation Spreadsheets (2001 to 2013)]]'''
+
### '''[[Preparing Drive Creation Spreadsheets for Games 2001 to 2013]]'''
### '''[[Preparing Drive Creation Spreadsheets (Transcribed Games)]]'''
+
### '''[[Preparing Drive Creation Spreadsheets for Transcribed Games]]'''
### '''[[Preparing Drive Creation Spreadsheets (Historical Games)]]'''
+
### '''[[Preparing Drive Creation Spreadsheets for Historical Games]]'''
 
## Drive Data Preparation Procedures
 
## Drive Data Preparation Procedures
### '''[[Preparing Drive Data Spreadsheets (2014 to Present)]]'''
+
### '''[[Preparing Drive Data Spreadsheets for Games 2014 to Present]]'''
### '''[[Preparing Drive Data Spreadsheets (2001 to 2013)]]'''
+
### '''[[Preparing Drive Data Spreadsheets for Games 2001 to 2013]]'''
### '''[[Preparing Drive Data Spreadsheets (Transcribed Games)]]'''
+
### '''[[Preparing Drive Data Spreadsheets for Transcribed Games]]'''
### '''[[Preparing Drive Data Spreadsheets (Historical Games)]]'''
+
### '''[[Preparing Drive Data Spreadsheets for Historical Games]]'''
 
# Play-by-play Data Preparation and Upload Procedures
 
# Play-by-play Data Preparation and Upload Procedures
 
## Play Creation Procedures
 
## Play Creation Procedures
### '''[[Preparing Play Creation Spreadsheets (2014 to Present)]]'''
+
### '''[[Preparing Play Creation Spreadsheets for Games 2014 to Present]]'''
### '''[[Preparing Play Creation Spreadsheets (2001 to 2013)]]'''
+
### '''[[Preparing Play Creation Spreadsheets for Games 2001 to 2013]]'''
### '''[[Preparing Play Creation Spreadsheets (Transcribed Games)]]'''
+
### '''[[Preparing Play Creation Spreadsheets for Transcribed Games]]'''
### '''[[Preparing Play Creation Spreadsheets (Historical Games)]]'''
+
### '''[[Preparing Play Creation Spreadsheets for Historical Games]]'''
 
## Play-by-Play Data Preparation Procedures
 
## Play-by-Play Data Preparation Procedures
### '''[[Preparing Play-by-play Data Spreadsheets (2014 to Present)]]'''
+
### '''[[Preparing Play-by-play Data Spreadsheets for Games 2014 to Present]]'''
### '''[[Preparing Play-by-play Data Spreadsheets (2001 to 2013)]]'''
+
### '''[[Preparing Play-by-play Data Spreadsheets for Games 2001 to 2013]]'''
### '''[[Preparing Play-by-play Data Spreadsheets (Transcribed Games)]]'''
+
### '''[[Preparing Play-by-play Data Spreadsheets for Transcribed Games]]'''
### '''[[Preparing Play-by-play Data Spreadsheets (Historical Games)]]'''
+
### '''[[Preparing Play-by-play Data Spreadsheets for Historical Games]]'''
  
 
Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:
 
Data prep required for creating and populate each drive's item page using QuickStatements... two steps process:

Revision as of 04:06, 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. Initial spreadsheet preparation procedures - downloading/acquiring and then preparing spreadsheets based on time period within which each game occurred
    1. Preparing Spreadsheets (2014 to Present): For games occurring from 2014 to present
    2. Preparing Spreadsheets (2001 to 2013): For games occurring from 2001 to 2013
    3. Preparing Spreadsheets (Transcribed Games): For for games occurring prior to 2001 (transcribed spreadsheets)
    4. Preparing Spreadsheets (Historical Games): For historical games drawn from newspaper accounts (for games lacking extant play-by-play data)
  2. Drive Data Preparation and Upload Procedures
    1. Drive Creation Procedures
      1. Preparing Drive Creation Spreadsheets for Games 2014 to Present
      2. Preparing Drive Creation Spreadsheets for Games 2001 to 2013
      3. Preparing Drive Creation Spreadsheets for Transcribed Games
      4. Preparing Drive Creation Spreadsheets for Historical Games
    2. Drive Data Preparation Procedures
      1. Preparing Drive Data Spreadsheets for Games 2014 to Present
      2. Preparing Drive Data Spreadsheets for Games 2001 to 2013
      3. Preparing Drive Data Spreadsheets for Transcribed Games
      4. Preparing Drive Data Spreadsheets for Historical Games
  3. Play-by-play Data Preparation and Upload Procedures
    1. Play Creation Procedures
      1. Preparing Play Creation Spreadsheets for Games 2014 to Present
      2. Preparing Play Creation Spreadsheets for Games 2001 to 2013
      3. Preparing Play Creation Spreadsheets for Transcribed Games
      4. Preparing Play Creation Spreadsheets for Historical Games
    2. Play-by-Play Data Preparation Procedures
      1. Preparing Play-by-play Data Spreadsheets for Games 2014 to Present
      2. Preparing Play-by-play Data Spreadsheets for Games 2001 to 2013
      3. Preparing Play-by-play Data Spreadsheets for Transcribed Games
      4. Preparing Play-by-play Data Spreadsheets for Historical Games

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