Difference between revisions of "Data Preparation Procedures"

From Wikibase.slis.ua.edu
Jump to navigation Jump to search
Line 5: Line 5:
 
# Make sure a season page exists for each team participating in the game: [[Indexing a Football Team Season]]
 
# Make sure a season page exists for each team participating in the game: [[Indexing a Football Team Season]]
 
# Creating an item page for a game: [[Indexing a Football Game]]
 
# Creating an item page for a game: [[Indexing a Football Game]]
# [[Preparing Spreadsheets for Data Upload]]
+
# Preparing spreadsheets for data upload
 +
## For spreadsheets for games occurring from 2014 to present: Preparing Spreadsheets (2014 to present)
 +
## For spreadsheets for games occurring from 2001 to 2013: Preparing Spreadsheets (2001 to 2013)
 +
## For transcribed spreadsheets for games occurring prior to 2001: Preparing Spreadsheets (Transcribed Games)
 +
## For spreadsheets drawn from newspaper accounts of historical games: Preparing Spreadsheets (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:
 
## Create spreadsheet that will derive Q numbers for each drive and incorporating "instance of" statements: [[Drive Creation Procedure]]
 
## Create spreadsheet that will derive Q numbers for each drive and incorporating "instance of" statements: [[Drive Creation Procedure]]
 
## Create spreadsheet to populate data about each drive's (now) existing item page: [[Drive Data Preparation]]
 
## Create spreadsheet to populate data about each drive's (now) existing item page: [[Drive Data Preparation]]
 
# Next, create an item page for each play for a game ... two steps process:
 
# Next, create an item page for each play for a game ... two steps process:

Revision as of 21:57, 19 December 2018

This page provides information on data preparation for using QuickStatement

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

  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
  3. Preparing spreadsheets for data upload
    1. For spreadsheets for games occurring from 2014 to present: Preparing Spreadsheets (2014 to present)
    2. For spreadsheets for games occurring from 2001 to 2013: Preparing Spreadsheets (2001 to 2013)
    3. For transcribed spreadsheets for games occurring prior to 2001: Preparing Spreadsheets (Transcribed Games)
    4. For spreadsheets drawn from newspaper accounts of historical games: Preparing Spreadsheets (Historical Games)
  4. 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
  5. Next, create an item page for each play for a game ... two steps process: